105: close get_from_role ;
106:
107:
108: IF P_FUNCMODE='RUN' THEN
109: /* Get application_id from FND_APPLICATION */
110: select application_id into l_application_id
111: from fnd_application where application_short_name='GMD';
112:
113: /* Check which event has been raised */
107:
108: IF P_FUNCMODE='RUN' THEN
109: /* Get application_id from FND_APPLICATION */
110: select application_id into l_application_id
111: from fnd_application where application_short_name='GMD';
112:
113: /* Check which event has been raised */
114: wf_log_pkg.string(6, 'Dummy','Entered Stability Study Batch Creation '||l_event_key);
115:
310: l_form varchar2(240);
311: BEGIN
312:
313: /* Get Next Approver */
314: /* Get application_id from FND_APPLICATION */
315: select application_id into l_application_id
316: from fnd_application where application_short_name='GMD';
317:
318: ame_api.getNextApprover(applicationIdIn => l_application_id,
312:
313: /* Get Next Approver */
314: /* Get application_id from FND_APPLICATION */
315: select application_id into l_application_id
316: from fnd_application where application_short_name='GMD';
317:
318: ame_api.getNextApprover(applicationIdIn => l_application_id,
319: transactionIdIn => l_event_key,
320: transactionTypeIn => l_transaction_type,