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

Price List Query for Item

 SELECT qph.list_header_id,        qph.name,        qph.description,        qphh.start_date_active,        qphh.currency_code,        q...