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 Standard Package for Order Totals

  Purpose: Sometimes we need to show line-wise or complete order totals (Basic / Tax / Tax+Basic) in reports. Oracle provides a standard...