How to create Concurrent Program based on PLSQL Procedure
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|
Category: EBS