Monday, July 24, 2017

Package for calling Bursting Program for Data template & reports

create or replace PACKAGE      XXJML_ASN_DOLLARS_20170724 AS
   CUST_NO  VARCHAR2(10);
   SHIPPING_DATE  DATE;
 function AfterReport(p_request_id number) return boolean;
END XXJML_ASN_DOLLARS_20170724;



PACKAGE BODY
==============
create or replace PACKAGE BODY      XXJML_ASN_DOLLARS_20170724 AS
function AfterReport(p_request_id number) return boolean
   is
     l_req_id number;
   begin
     l_req_id := fnd_request.submit_request('XDO', 'XDOBURSTREP', '','', FALSE, 'Y', p_request_id, 'Y', CHR(0));
     commit;
     if l_req_id =0
     then
       return false;
     else
       return true;
     end if ;
   exception
     when others
     then
       return FALSE;
   end AfterReport;
END XXJML_ASN_DOLLARS_20170724;

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...