eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AME_WF_PVT dependencies on WF_ITEMS

Line 706: l_item_key wf_items.item_key%TYPE;

702: resultout OUT NOCOPY VARCHAR2)
703: IS
704: l_progress VARCHAR2(3) DEFAULT '000';
705: l_document_id NUMBER;
706: l_item_key wf_items.item_key%TYPE;
707: l_next_approver_id NUMBER;
708: l_next_approver_name per_employees_current_x.full_name%TYPE;
709: l_next_approver_user_name VARCHAR2(100);
710: l_next_approver_disp_name VARCHAR2(240);

Line 1183: l_parent_item_type wf_items.parent_item_type%TYPE;

1179: l_current_approver ame_util.approverRecord2;
1180: l_forwardee ame_util.approverRecord2;
1181: l_approver_posoition_id NUMBER;
1182: l_approver_type VARCHAR2(10);
1183: l_parent_item_type wf_items.parent_item_type%TYPE;
1184: l_parent_item_key wf_items.parent_item_key%TYPE;
1185: l_document_type po_document_types.document_type_code%TYPE;
1186: l_ame_transaction_id NUMBER;
1187: l_error_message ame_util.longestStringType;

Line 1184: l_parent_item_key wf_items.parent_item_key%TYPE;

1180: l_forwardee ame_util.approverRecord2;
1181: l_approver_posoition_id NUMBER;
1182: l_approver_type VARCHAR2(10);
1183: l_parent_item_type wf_items.parent_item_type%TYPE;
1184: l_parent_item_key wf_items.parent_item_key%TYPE;
1185: l_document_type po_document_types.document_type_code%TYPE;
1186: l_ame_transaction_id NUMBER;
1187: l_error_message ame_util.longestStringType;
1188: wf_role_not_found EXCEPTION;

Line 1344: FROM wf_items

1340: l_error_message := SQLERRM;
1341:
1342: SELECT parent_item_type, parent_item_key
1343: INTO l_parent_item_type, l_parent_item_key
1344: FROM wf_items
1345: WHERE item_type = itemtype
1346: AND item_key = itemkey;
1347:
1348: po_wf_util_pkg.SetItemAttrText(

Line 1388: l_parent_item_type wf_items.parent_item_type%TYPE;

1384: funcmode IN VARCHAR2,
1385: resultout OUT NOCOPY VARCHAR2 )
1386: IS
1387: l_progress VARCHAR2(3) := '000';
1388: l_parent_item_type wf_items.parent_item_type%TYPE;
1389: l_parent_item_key wf_items.parent_item_key%TYPE;
1390: l_child_approver_empid NUMBER;
1391: l_child_approver_user_name wf_users.name%TYPE;
1392: l_child_approver_display_name wf_users.display_name%TYPE;

Line 1389: l_parent_item_key wf_items.parent_item_key%TYPE;

1385: resultout OUT NOCOPY VARCHAR2 )
1386: IS
1387: l_progress VARCHAR2(3) := '000';
1388: l_parent_item_type wf_items.parent_item_type%TYPE;
1389: l_parent_item_key wf_items.parent_item_key%TYPE;
1390: l_child_approver_empid NUMBER;
1391: l_child_approver_user_name wf_users.name%TYPE;
1392: l_child_approver_display_name wf_users.display_name%TYPE;
1393: l_api_name VARCHAR2(500) := 'process_response_exception';

Line 1413: FROM wf_items

1409: END IF;
1410:
1411: SELECT parent_item_type, parent_item_key
1412: INTO l_parent_item_type, l_parent_item_key
1413: FROM wf_items
1414: WHERE item_type = itemtype
1415: AND item_key = itemkey;
1416:
1417: -- Call process_response_internal with 'EXCEPTION'

Line 2131: l_parent_item_type wf_items.parent_item_type%TYPE;

2127: funcmode IN VARCHAR2,
2128: resultout OUT NOCOPY VARCHAR2)
2129: IS
2130: l_progress VARCHAR2(3) := '000';
2131: l_parent_item_type wf_items.parent_item_type%TYPE;
2132: l_parent_item_key wf_items.parent_item_key%TYPE;
2133: l_child_approver_empid NUMBER;
2134: l_child_approver_user_name wf_users.name%TYPE;
2135: l_child_approver_display_name wf_users.display_name%TYPE;

Line 2132: l_parent_item_key wf_items.parent_item_key%TYPE;

2128: resultout OUT NOCOPY VARCHAR2)
2129: IS
2130: l_progress VARCHAR2(3) := '000';
2131: l_parent_item_type wf_items.parent_item_type%TYPE;
2132: l_parent_item_key wf_items.parent_item_key%TYPE;
2133: l_child_approver_empid NUMBER;
2134: l_child_approver_user_name wf_users.name%TYPE;
2135: l_child_approver_display_name wf_users.display_name%TYPE;
2136: l_api_name VARCHAR2(500) := 'process_response_app_forward';

Line 2165: FROM wf_items

2161: -- APPROVER_EMPID, APPROVER_USER_NAME, APPROVER_DISPLAY_NAME with child approver attributes.
2162:
2163: SELECT parent_item_type, parent_item_key
2164: INTO l_parent_item_type, l_parent_item_key
2165: FROM wf_items
2166: WHERE item_type = itemtype
2167: AND item_key = itemkey;
2168:
2169: l_progress := '020';

Line 2229: l_parent_item_type wf_items.parent_item_type%TYPE;

2225: funcmode IN VARCHAR2,
2226: resultout OUT NOCOPY VARCHAR2)
2227: IS
2228: l_progress VARCHAR2(3) := '000';
2229: l_parent_item_type wf_items.parent_item_type%TYPE;
2230: l_parent_item_key wf_items.parent_item_key%TYPE;
2231: l_child_approver_empid NUMBER;
2232: l_child_approver_user_name wf_users.name%TYPE;
2233: l_child_approver_display_name wf_users.display_name%TYPE;

Line 2230: l_parent_item_key wf_items.parent_item_key%TYPE;

2226: resultout OUT NOCOPY VARCHAR2)
2227: IS
2228: l_progress VARCHAR2(3) := '000';
2229: l_parent_item_type wf_items.parent_item_type%TYPE;
2230: l_parent_item_key wf_items.parent_item_key%TYPE;
2231: l_child_approver_empid NUMBER;
2232: l_child_approver_user_name wf_users.name%TYPE;
2233: l_child_approver_display_name wf_users.display_name%TYPE;
2234: l_api_name VARCHAR2(500) := 'process_response_approve';

Line 2263: FROM wf_items

2259: -- APPROVER_EMPID, APPROVER_USER_NAME, APPROVER_DISPLAY_NAME with child approver attributes.
2260:
2261: SELECT parent_item_type, parent_item_key
2262: INTO l_parent_item_type, l_parent_item_key
2263: FROM wf_items
2264: WHERE item_type = itemtype
2265: AND item_key = itemkey;
2266:
2267: l_progress := '020';

Line 2324: l_parent_item_type wf_items.parent_item_type%TYPE;

2320: funcmode IN VARCHAR2,
2321: resultout OUT NOCOPY VARCHAR2)
2322: IS
2323: l_progress VARCHAR2(3) := '000';
2324: l_parent_item_type wf_items.parent_item_type%TYPE;
2325: l_parent_item_key wf_items.parent_item_key%TYPE;
2326: l_child_approver_empid NUMBER;
2327: l_child_approver_user_name wf_users.name%TYPE;
2328: l_child_approver_display_name wf_users.display_name%TYPE;

Line 2325: l_parent_item_key wf_items.parent_item_key%TYPE;

2321: resultout OUT NOCOPY VARCHAR2)
2322: IS
2323: l_progress VARCHAR2(3) := '000';
2324: l_parent_item_type wf_items.parent_item_type%TYPE;
2325: l_parent_item_key wf_items.parent_item_key%TYPE;
2326: l_child_approver_empid NUMBER;
2327: l_child_approver_user_name wf_users.name%TYPE;
2328: l_child_approver_display_name wf_users.display_name%TYPE;
2329: l_api_name VARCHAR2(500) := 'process_response_reject';

Line 2362: FROM wf_items

2358: l_progress := '030';
2359:
2360: SELECT parent_item_type, parent_item_key
2361: INTO l_parent_item_type, l_parent_item_key
2362: FROM wf_items
2363: WHERE item_type = itemtype
2364: AND item_key = itemkey;
2365:
2366: l_progress := '040';

Line 2421: l_parent_item_type wf_items.parent_item_type%TYPE;

2417: funcmode IN VARCHAR2,
2418: resultout OUT NOCOPY VARCHAR2)
2419: IS
2420: l_progress VARCHAR2(3) := '000';
2421: l_parent_item_type wf_items.parent_item_type%TYPE;
2422: l_parent_item_key wf_items.parent_item_key%TYPE;
2423: l_child_approver_empid NUMBER;
2424: l_child_approver_user_name wf_users.name%TYPE;
2425: l_child_approver_display_name wf_users.display_name%TYPE;

Line 2422: l_parent_item_key wf_items.parent_item_key%TYPE;

2418: resultout OUT NOCOPY VARCHAR2)
2419: IS
2420: l_progress VARCHAR2(3) := '000';
2421: l_parent_item_type wf_items.parent_item_type%TYPE;
2422: l_parent_item_key wf_items.parent_item_key%TYPE;
2423: l_child_approver_empid NUMBER;
2424: l_child_approver_user_name wf_users.name%TYPE;
2425: l_child_approver_display_name wf_users.display_name%TYPE;
2426: l_api_name VARCHAR2(500) := 'process_response_forward';

Line 2454: FROM wf_items

2450: -- APPROVER_EMPID, APPROVER_USER_NAME, APPROVER_DISPLAY_NAME with child approver attributes.
2451:
2452: SELECT parent_item_type, parent_item_key
2453: INTO l_parent_item_type, l_parent_item_key
2454: FROM wf_items
2455: WHERE item_type = itemtype
2456: AND item_key = itemkey;
2457:
2458: l_progress := '020';

Line 2515: l_parent_item_type wf_items.parent_item_type%TYPE;

2511: funcmode IN VARCHAR2,
2512: resultout OUT NOCOPY VARCHAR2)
2513: IS
2514: l_progress VARCHAR2(3) := '000';
2515: l_parent_item_type wf_items.parent_item_type%TYPE;
2516: l_parent_item_key wf_items.parent_item_key%TYPE;
2517: l_child_approver_empid NUMBER;
2518: l_child_approver_user_name wf_users.name%TYPE;
2519: l_child_approver_display_name wf_users.display_name%TYPE;

Line 2516: l_parent_item_key wf_items.parent_item_key%TYPE;

2512: resultout OUT NOCOPY VARCHAR2)
2513: IS
2514: l_progress VARCHAR2(3) := '000';
2515: l_parent_item_type wf_items.parent_item_type%TYPE;
2516: l_parent_item_key wf_items.parent_item_key%TYPE;
2517: l_child_approver_empid NUMBER;
2518: l_child_approver_user_name wf_users.name%TYPE;
2519: l_child_approver_display_name wf_users.display_name%TYPE;
2520: l_api_name VARCHAR2(500) := 'process_response_timeout';

Line 2552: FROM wf_items

2548: l_progress := '020';
2549:
2550: SELECT parent_item_type, parent_item_key
2551: INTO l_parent_item_type, l_parent_item_key
2552: FROM wf_items
2553: WHERE item_type = itemtype
2554: AND item_key = itemkey;
2555:
2556: l_progress := '030';

Line 3700: l_parent_item_type wf_items.parent_item_type%TYPE;

3696: funcmode IN VARCHAR2,
3697: resultout OUT NOCOPY VARCHAR2)
3698: IS
3699: l_progress VARCHAR2(3) := '000';
3700: l_parent_item_type wf_items.parent_item_type%TYPE;
3701: l_parent_item_key wf_items.parent_item_key%TYPE;
3702: l_child_approver_empid NUMBER;
3703: l_child_approver_groupid NUMBER;
3704: l_approver_group_id NUMBER;

Line 3701: l_parent_item_key wf_items.parent_item_key%TYPE;

3697: resultout OUT NOCOPY VARCHAR2)
3698: IS
3699: l_progress VARCHAR2(3) := '000';
3700: l_parent_item_type wf_items.parent_item_type%TYPE;
3701: l_parent_item_key wf_items.parent_item_key%TYPE;
3702: l_child_approver_empid NUMBER;
3703: l_child_approver_groupid NUMBER;
3704: l_approver_group_id NUMBER;
3705: l_po_header_id NUMBER;

Line 3727: CURSOR l_child_wf ( itemtype IN wf_items.parent_item_type%TYPE,

3723: l_api_name VARCHAR2(500) := 'process_beat_by_first';
3724: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
3725: l_approver_disp_name VARCHAR2(200);
3726:
3727: CURSOR l_child_wf ( itemtype IN wf_items.parent_item_type%TYPE,
3728: itemkey IN wf_items.parent_item_key%TYPE ) IS
3729: SELECT wfi.item_type,
3730: wfi.item_key,
3731: wfn.recipient_role,

Line 3728: itemkey IN wf_items.parent_item_key%TYPE ) IS

3724: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
3725: l_approver_disp_name VARCHAR2(200);
3726:
3727: CURSOR l_child_wf ( itemtype IN wf_items.parent_item_type%TYPE,
3728: itemkey IN wf_items.parent_item_key%TYPE ) IS
3729: SELECT wfi.item_type,
3730: wfi.item_key,
3731: wfn.recipient_role,
3732: wfn.original_recipient

Line 3733: FROM wf_items wfi,

3729: SELECT wfi.item_type,
3730: wfi.item_key,
3731: wfn.recipient_role,
3732: wfn.original_recipient
3733: FROM wf_items wfi,
3734: wf_item_activity_statuses wfias,
3735: wf_notifications wfn
3736: WHERE wfi.parent_item_key = itemkey
3737: AND wfi.item_type = itemtype

Line 3765: FROM wf_items

3761: END IF;
3762:
3763: SELECT parent_item_type, parent_item_key
3764: INTO l_parent_item_type, l_parent_item_key
3765: FROM wf_items
3766: WHERE item_type = itemtype
3767: AND item_key = itemkey;
3768:
3769: --Check if there we have encountered any ame exception.

Line 4048: l_parent_item_type wf_items.parent_item_type%TYPE;

4044: funcmode IN VARCHAR2,
4045: resultout OUT NOCOPY VARCHAR2)
4046: IS
4047: l_progress VARCHAR2(3) := '000';
4048: l_parent_item_type wf_items.parent_item_type%TYPE;
4049: l_parent_item_key wf_items.parent_item_key%TYPE;
4050: l_api_name VARCHAR2(500) := 'update_resp_verf_failed';
4051: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4052:

Line 4049: l_parent_item_key wf_items.parent_item_key%TYPE;

4045: resultout OUT NOCOPY VARCHAR2)
4046: IS
4047: l_progress VARCHAR2(3) := '000';
4048: l_parent_item_type wf_items.parent_item_type%TYPE;
4049: l_parent_item_key wf_items.parent_item_key%TYPE;
4050: l_api_name VARCHAR2(500) := 'update_resp_verf_failed';
4051: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4052:
4053: BEGIN

Line 4071: FROM wf_items

4067: END IF;
4068:
4069: SELECT parent_item_type, parent_item_key
4070: INTO l_parent_item_type, l_parent_item_key
4071: FROM wf_items
4072: WHERE item_type = itemtype
4073: AND item_key = itemkey;
4074:
4075: l_progress := '020';

Line 4113: l_parent_item_type wf_items.parent_item_type%TYPE;

4109: funcmode IN VARCHAR2,
4110: resultout OUT NOCOPY VARCHAR2)
4111: IS
4112: l_progress VARCHAR2(3) := '000';
4113: l_parent_item_type wf_items.parent_item_type%TYPE;
4114: l_parent_item_key wf_items.parent_item_key%TYPE;
4115: l_api_name VARCHAR2(500) := 'update_resp_verf_failed_reject';
4116: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4117:

Line 4114: l_parent_item_key wf_items.parent_item_key%TYPE;

4110: resultout OUT NOCOPY VARCHAR2)
4111: IS
4112: l_progress VARCHAR2(3) := '000';
4113: l_parent_item_type wf_items.parent_item_type%TYPE;
4114: l_parent_item_key wf_items.parent_item_key%TYPE;
4115: l_api_name VARCHAR2(500) := 'update_resp_verf_failed_reject';
4116: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4117:
4118: BEGIN

Line 4136: FROM wf_items

4132: END IF;
4133:
4134: SELECT parent_item_type, parent_item_key
4135: INTO l_parent_item_type, l_parent_item_key
4136: FROM wf_items
4137: WHERE item_type = itemtype
4138: AND item_key = itemkey;
4139:
4140: l_progress := '020';

Line 4434: FROM wf_items

4430: SELECT LEVEL,
4431: item_type,
4432: item_key,
4433: end_date
4434: FROM wf_items
4435: START WITH item_type = t_item_type
4436: AND item_key = t_item_key
4437: CONNECT BY PRIOR item_type = parent_item_type
4438: AND PRIOR item_key = parent_item_key

Line 4865: l_item_type wf_items.item_type%TYPE;

4861: x_return_message OUT NOCOPY VARCHAR2) IS
4862:
4863: l_log_head VARCHAR2(50) := g_module_prefix || 'withdraw_document';
4864: l_progress VARCHAR2(10);
4865: l_item_type wf_items.item_type%TYPE;
4866: l_item_key wf_items.item_key%TYPE;
4867: l_note po_action_history.note%TYPE;
4868: l_current_user_name VARCHAR2(100);
4869: l_disp_name VARCHAR2(240);

Line 4866: l_item_key wf_items.item_key%TYPE;

4862:
4863: l_log_head VARCHAR2(50) := g_module_prefix || 'withdraw_document';
4864: l_progress VARCHAR2(10);
4865: l_item_type wf_items.item_type%TYPE;
4866: l_item_key wf_items.item_key%TYPE;
4867: l_note po_action_history.note%TYPE;
4868: l_current_user_name VARCHAR2(100);
4869: l_disp_name VARCHAR2(240);
4870: l_send_notf_flag VARCHAR2(1);