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.POR_AME_REQ_WF_PVT dependencies on PO_DOCUMENT_TYPES

Line 67: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

63: funcmode in varchar2,
64: resultout out NOCOPY varchar2) IS
65: l_progress VARCHAR2(3500) := '000';
66: l_document_id NUMBER;
67: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
68: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
69: l_next_approver_id NUMBER;
70: l_next_approver_user_name fnd_user.user_name%TYPE;
71: l_next_approver_disp_name wf_users.display_name%TYPE;

Line 68: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

64: resultout out NOCOPY varchar2) IS
65: l_progress VARCHAR2(3500) := '000';
66: l_document_id NUMBER;
67: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
68: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
69: l_next_approver_id NUMBER;
70: l_next_approver_user_name fnd_user.user_name%TYPE;
71: l_next_approver_disp_name wf_users.display_name%TYPE;
72: l_orig_system wf_users.orig_system%TYPE := ame_util.perOrigSystem;

Line 83: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

79:
80: l_next_approver ame_util.approverRecord;
81: l_insertion_type VARCHAR2(30);
82: l_authority_type VARCHAR2(30);
83: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
84:
85: l_completeYNO varchar2(100);
86: l_position_has_valid_approvers varchar2(10);
87: l_need_to_get_next_approver boolean;

Line 304: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

300: l_next_approver_disp_name VARCHAR2(240);
301: l_orig_system VARCHAR2(48);
302: l_org_id number;
303: l_functional_currency VARCHAR2(30);
304: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
305:
306: n_varname Wf_Engine.NameTabTyp;
307: n_varval Wf_Engine.NumTabTyp;
308:

Line 325: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

321:
322: l_first_position_id NUMBER := null;
323: l_first_approver_id NUMBER := null;
324: l_ame_transaction_id PO_HEADERS_ALL.ame_approval_id%TYPE;
325: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
326:
327: begin
328: IF (funcmode='RUN') THEN
329:

Line 994: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

990: p_response in varchar2 ) IS
991:
992: l_progress VARCHAR2(500) := '000';
993: l_document_id number;
994: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
995: l_current_approver ame_util.approverRecord2;
996: l_forwardee ame_util.approverRecord2; -- CLM Apprvl
997: l_approver_posoition_id number;
998: l_approver_type varchar2(10);

Line 1003: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE; --

999: l_error_code NUMBER;
1000: l_error_message ame_util.longestStringType;
1001: l_parent_item_type wf_items.parent_item_type%TYPE;
1002: l_parent_item_key wf_items.parent_item_key%TYPE;
1003: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE; --
1004: l_ame_transaction_id PO_HEADERS_ALL.ame_approval_id%TYPE; --
1005: begin
1006:
1007: l_progress := 'Process_Response_Internal: 001';

Line 1211: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1207: l_approver_group_id NUMBER;
1208: l_req_header_id NUMBER;
1209: l_process_out VARCHAR2(10);
1210: approverList ame_util.approversTable2;
1211: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1212: l_response_action VARCHAR2(20);
1213: l_note VARCHAR2(4000);
1214: l_person_id NUMBER;
1215: l_orig_system VARCHAR2(3);

Line 1224: l_transaction_type po_document_types.ame_transaction_type%TYPE; --

1220: l_preparer_user_name fnd_user.user_name%TYPE;
1221: l_doc_string VARCHAR2(200);
1222: l_ame_exception ame_util.longestStringType;
1223: l_approver_response varchar2(20);
1224: l_transaction_type po_document_types.ame_transaction_type%TYPE; --
1225: l_ame_transaction_id NUMBER; --
1226: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE; --
1227:
1228: CURSOR l_child_wf (itemtype IN wf_items.parent_item_type%TYPE,itemkey IN wf_items.parent_item_key%TYPE) IS

Line 1226: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE; --

1222: l_ame_exception ame_util.longestStringType;
1223: l_approver_response varchar2(20);
1224: l_transaction_type po_document_types.ame_transaction_type%TYPE; --
1225: l_ame_transaction_id NUMBER; --
1226: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE; --
1227:
1228: CURSOR l_child_wf (itemtype IN wf_items.parent_item_type%TYPE,itemkey IN wf_items.parent_item_key%TYPE) IS
1229: SELECT wfi.item_type, wfi.item_key,wfn.recipient_role, wfn.original_recipient
1230: FROM wf_items wfi,wf_item_activity_statuses wfias,wf_notifications wfn

Line 1241: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE; --Bug 13444730

1237: AND wfias.notification_id = wfn.notification_id;
1238: l_child_wf_cur l_child_wf%ROWTYPE;
1239:
1240: l_draft_id NUMBER; --Bug 12944203
1241: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE; --Bug 13444730
1242: l_approver_disp_name VARCHAR2(200) := null;
1243: begin
1244:
1245: l_progress := 'Process_Beat_By_First: 001';

Line 2275: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

2271:
2272: l_org_id number;
2273: l_document_id NUMBER;
2274: l_draft_id NUMBER;
2275: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
2276: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
2277: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.DOCUMENT_SUBTYPE%TYPE;
2278:
2279: BEGIN

Line 2276: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

2272: l_org_id number;
2273: l_document_id NUMBER;
2274: l_draft_id NUMBER;
2275: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
2276: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
2277: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.DOCUMENT_SUBTYPE%TYPE;
2278:
2279: BEGIN
2280:

Line 2277: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.DOCUMENT_SUBTYPE%TYPE;

2273: l_document_id NUMBER;
2274: l_draft_id NUMBER;
2275: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
2276: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
2277: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.DOCUMENT_SUBTYPE%TYPE;
2278:
2279: BEGIN
2280:
2281: l_progress := 'Insert_Action_History: 001';

Line 2433: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

2429:
2430: l_org_id number;
2431: l_current_approver number;
2432: -- CLM Apprvl --
2433: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
2434: l_draft_id NUMBER;
2435:
2436: BEGIN
2437:

Line 2585: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

2581:
2582: l_org_id number;
2583: l_current_approver number;
2584: -- --
2585: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
2586: l_draft_id NUMBER;
2587:
2588: BEGIN
2589:

Line 2735: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

2731:
2732: l_org_id number;
2733: l_current_approver number;
2734: -- --
2735: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
2736: l_draft_id NUMBER;
2737:
2738: BEGIN
2739:

Line 2877: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

2873:
2874: l_org_id number;
2875: l_current_approver number;
2876: -- --
2877: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
2878: l_draft_id NUMBER;
2879:
2880: BEGIN
2881: