11 Replies Latest reply on Apr 5, 2018 7:03 AM by John_K

    How to run a concurrent program using API when there is an update/correction in Job/location field in an assignments screen

    3173025

      Hi All,

       

      When there is an update/correction in job/location in assignments screen then a concurrent program should run.

       

      I think this we can do using triggers like when there is update/correction in particular fields then program should run using api.

       

      I am using AFTER INSERT OR UPDATE TRIGGER, but im not sure whether i have written correct logic or not.

       

      Also, i have seen dynamic triggers in the oracle forms. im not sure we can do by that or not.

       

      Could some on help on this.

       

      Trigger code is as below:

       

      create OR REPLACE TRIGGER XXSY_GRADE_POPULATE_TRG

        AFTER INSERT OR UPDATE of JOB_ID, LOCATION_ID

        ON PER_ALL_ASSIGNMENTS_F

        FOR EACH ROW

       

        DECLARE

        vl_request_id    NUMBER;

        BEGIN

        

         vl_request_id := fnd_request.submit_request ( application => 'XXSY',

                                                       program => 'XXSY_GRADES_UPDATE_PRC',

                                                       description => NULL,

                                                       start_time => NULL,

                                                       sub_request => FALSE,

                                                       argument1 => NULL);

      END;