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

Item - Category Query

      SELECT      msi.segment1 AS Item_Code,       msi.DESCRIPTION AS Item_Desc,       mcs.CATEGORY_SET_NAME,       mck.CONCATENATED_SEGMEN...