Thursday, September 14, 2017

Submit Concurrent program Using TRIGGER

CREATE OR REPLACE TRIGGER chidam
  AFTER UPDATE ON student
  FOR EACH ROW
  WHEN (1 = 1)
DECLARE
  l_result     BOOLEAN;
  l_request_id NUMBER := 0;

BEGIN
  l_result     := fnd_request.set_mode(TRUE);
  l_request_id :=
  fnd_request.submit_request(application => 'XXONT',
                           program     => 'XXX_CONCU_SHORT_NAME',
                           argument1   => null);


END;

No comments:

Post a Comment

Oracle EBS R12 – Query to View Consolidated Invoice Details with Individual Transactions

SELECT     hp.party_name                  AS customer_name,     aca.account_number             AS customer_account,     hci.cons_billing_num...