DBA Data[Home] [Help]

APPS.GMD_SS_TIMEPOINT_WF_PKG dependencies on FND_APPLICATION

Line 151: /* Get application_id from FND_APPLICATION */

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 */

Line 153: from fnd_application where application_short_name='GMD';

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:

Line 374: /* Get application_id from FND_APPLICATION */

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 */

Line 376: from fnd_application where application_short_name='GMD';

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'