147:
148:
149: IF P_FUNCMODE='RUN' THEN
150:
151: /* Get application_id from FND_APPLICATION */
152: select application_id into l_application_id
153: from fnd_application where application_short_name='GMD';
154:
155: /* Check which event has been raised */
149: IF P_FUNCMODE='RUN' THEN
150:
151: /* Get application_id from FND_APPLICATION */
152: select application_id into l_application_id
153: from fnd_application where application_short_name='GMD';
154:
155: /* Check which event has been raised */
156: wf_log_pkg.string(6, 'Dummy','Entered Stability Study Batch Creation '||l_event_key);
157:
370: l_form varchar2(240);
371: BEGIN
372:
373: /* Get Next Approver */
374: /* Get application_id from FND_APPLICATION */
375: select application_id into l_application_id
376: from fnd_application where application_short_name='GMD';
377:
378: /*Update the wf_sent column to show that a notification has been sent */
372:
373: /* Get Next Approver */
374: /* Get application_id from FND_APPLICATION */
375: select application_id into l_application_id
376: from fnd_application where application_short_name='GMD';
377:
378: /*Update the wf_sent column to show that a notification has been sent */
379: update gmd_ss_time_points
380: set wf_sent = 'Y'