APPS.PO_AME_WF_PVT dependencies on WF_ROLES

Line 1282: FROM wf_roles

1278: IF l_forwardee.name IS NULL THEN
1279: SELECT name
1280: INTO l_forwardee.name
1281: FROM ( SELECT name
1282: FROM wf_roles
1283: WHERE orig_system = l_forwardee.orig_system
1284: AND orig_system_id = l_forwardee.orig_system_id
1285: ORDER BY start_date )
1286: WHERE ROWNUM = 1;

Line 1295: FROM wf_roles

1291: IF l_current_approver.name IS NULL THEN
1292: SELECT name
1293: INTO l_current_approver.name
1294: FROM ( SELECT name
1295: FROM wf_roles
1296: WHERE orig_system = l_current_approver.orig_system
1297: AND orig_system_id = l_current_approver.orig_system_id
1298: ORDER BY start_date )
1299: WHERE ROWNUM = 1;

Line 2696: l_new_recipient_id wf_roles.orig_system_id%TYPE;

2692: l_preserved_ctx VARCHAR2(5);
2693: l_nid NUMBER;
2694: l_progress VARCHAR2(3);
2695: l_action po_action_history.action_code%TYPE := NULL;
2696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
2697: l_current_recipient_id wf_roles.orig_system_id%TYPE;
2698: l_origsys wf_roles.orig_system%TYPE;
2699: l_document_id NUMBER;
2700: l_revision_num NUMBER;

Line 2697: l_current_recipient_id wf_roles.orig_system_id%TYPE;

2693: l_nid NUMBER;
2694: l_progress VARCHAR2(3);
2695: l_action po_action_history.action_code%TYPE := NULL;
2696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
2697: l_current_recipient_id wf_roles.orig_system_id%TYPE;
2698: l_origsys wf_roles.orig_system%TYPE;
2699: l_document_id NUMBER;
2700: l_revision_num NUMBER;
2701: l_draft_id NUMBER;

Line 2698: l_origsys wf_roles.orig_system%TYPE;

2694: l_progress VARCHAR2(3);
2695: l_action po_action_history.action_code%TYPE := NULL;
2696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
2697: l_current_recipient_id wf_roles.orig_system_id%TYPE;
2698: l_origsys wf_roles.orig_system%TYPE;
2699: l_document_id NUMBER;
2700: l_revision_num NUMBER;
2701: l_draft_id NUMBER;
2702: l_org_id NUMBER;