DBA Data[Home] [Help]

APPS.PA_PROJECT_REQUEST_PVT dependencies on PA_PRM_WF_ITEM_KEY_S

Line 2357: SELECT PA_PRM_WF_ITEM_KEY_S.nextval

2353: --debug('In LOOP, i =' || i);
2354:
2355: IF (l_recipient_tab(i) <> l_last_recipient AND l_last_recipient <> TEXT_DUMMY) THEN
2356:
2357: SELECT PA_PRM_WF_ITEM_KEY_S.nextval
2358: INTO l_item_key
2359: FROM DUAL;
2360:
2361: debug('l_item_key(inside loop) = ' || l_item_key);

Line 2439: SELECT PA_PRM_WF_ITEM_KEY_S.nextval

2435: debug('Exit Notification Loop');
2436:
2437: IF l_recipient_tab.count <> 0 THEN
2438: -- Sent notification for the last recipient.
2439: SELECT PA_PRM_WF_ITEM_KEY_S.nextval
2440: INTO l_item_key
2441: FROM DUAL;
2442: debug('l_item_key(outside loop) = ' || l_item_key);
2443: