Tech Trainings

How to create Concurrent Program based on PLSQL Procedure

June 22, 2024 by admin

Create PLSQL SPEC and Body as shown below

---package spec
CREATE OR REPLACE PACKAGE XXORA_PO_UTILS  IS 

PROCEDURE GEN_PO_DATA(
    errbuff OUT NOCOPY VARCHAR2,
    retcode OUT NOCOPY VARCHAR2);


END XXORA_PO_UTILS; 

---package body
CREATE OR REPLACE PACKAGE BODY XXORA_PO_UTILS  IS 

PROCEDURE GEN_PO_DATA(
    errbuff OUT NOCOPY VARCHAR2,
    retcode OUT NOCOPY VARCHAR2)
    IS 
    
     CURSOR C_PO_DATA IS 
      
      select pha.po_header_id, pha.type_lookup_code, pha.segment1 , pha.vendor_id
, asup.vendor_name 
from po_headers_all pha,  ap_suppliers asup
where 1=1
and pha.vendor_id = asup.vendor_id  ; 
    
    BEGIN
      
        for rec  in c_Po_data 
         loop
           
      fnd_file.put_line(fnd_file.log, rec.po_header_id  ||'----' || rec.segment1||'----' || 
      rec.type_lookup_code||'----' || rec.vendor_name); 
      
      fnd_file.put_line(fnd_file.output, rec.po_header_id  ||'----' || rec.segment1||'----' || 
      rec.type_lookup_code||'----' || rec.vendor_name);
      
         end loop; 
    
    END GEN_PO_DATA; 


END XXORA_PO_UTILS; 

Create Concurrent Executable

Create Concurrent Program

Assign the Concurrent Program to a request group (find the request group the responsibility)

Run the Concurrent Program

Comments |0|