526: AND m.process_enabled_flag = 'Y';
527:
528: CURSOR get_application_id IS /* 4576699 */
529: SELECT application_id
530: FROM fnd_application
531: WHERE application_short_name = 'GMD';
532:
533: CURSOR get_user_name(x_user_id NUMBER) IS /* 4576699 */
534: SELECT user_name FROM fnd_user WHERE user_id = x_user_id;
1750: return;
1751: END IF;
1752:
1753: /* Get First Approver */
1754: /* Get application_id from FND_APPLICATION */
1755: -- Bug 4576699: Added cursor instead of 'select' statement here
1756: OPEN get_application_id; /* xxx4576699 */
1757:
1758: FETCH get_application_id
2081:
2082:
2083:
2084: /* Get Next Approver */
2085: /* Get application_id from FND_APPLICATION */
2086: select application_id
2087: into l_application_id
2088: from fnd_application
2089: where application_short_name = 'GMD';
2084: /* Get Next Approver */
2085: /* Get application_id from FND_APPLICATION */
2086: select application_id
2087: into l_application_id
2088: from fnd_application
2089: where application_short_name = 'GMD';
2090:
2091: AME_API.GETNEXTAPPROVER(applicationIdIn => l_application_id,
2092: transactionIdIn => l_event_key,
2477: into l_from_role;
2478: CLOSE get_from_role;
2479:
2480: IF P_FUNCMODE = 'RUN' THEN
2481: /* Get application_id from FND_APPLICATION */
2482: SELECT application_id
2483: INTO l_application_id
2484: FROM fnd_application
2485: WHERE application_short_name = 'GMD';
2480: IF P_FUNCMODE = 'RUN' THEN
2481: /* Get application_id from FND_APPLICATION */
2482: SELECT application_id
2483: INTO l_application_id
2484: FROM fnd_application
2485: WHERE application_short_name = 'GMD';
2486:
2487: /*************************************/
2488: /* Check which event has been raised */