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 PO_DOCUMENT_TYPES

Line 229: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

225: funcmode IN VARCHAR2,
226: resultout OUT NOCOPY VARCHAR2)
227: IS
228: l_document_id NUMBER;
229: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
230: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
231: l_next_approver_id NUMBER;
232: l_next_approver_user_name FND_USER.USER_NAME%TYPE;
233: l_next_approver_disp_name WF_USERS.DISPLAY_NAME%TYPE;

Line 230: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

226: resultout OUT NOCOPY VARCHAR2)
227: IS
228: l_document_id NUMBER;
229: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
230: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
231: l_next_approver_id NUMBER;
232: l_next_approver_user_name FND_USER.USER_NAME%TYPE;
233: l_next_approver_disp_name WF_USERS.DISPLAY_NAME%TYPE;
234: l_orig_system WF_USERS.ORIG_SYSTEM%TYPE := ame_util.perOrigSystem;

Line 242: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

238: l_preparer_user_name FND_USER.USER_NAME%TYPE;
239: l_org_id NUMBER;
240: l_insertion_type VARCHAR2(30);
241: l_authority_type VARCHAR2(30);
242: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
243: l_completeYNO VARCHAR2(1);
244: l_position_has_valid_approvers VARCHAR2(10);
245: l_need_to_get_next_approver BOOLEAN;
246: l_ame_exception ame_util.longestStringType;

Line 714: l_transaction_type po_document_types.ame_transaction_type%TYPE;

710: l_next_approver_disp_name VARCHAR2(240);
711: l_orig_system VARCHAR2(48);
712: l_org_id NUMBER;
713: l_functional_currency VARCHAR2(30);
714: l_transaction_type po_document_types.ame_transaction_type%TYPE;
715: n_varname wf_engine.nametabtyp;
716: n_varval wf_engine.numtabtyp;
717: t_po_varname wf_engine.nametabtyp;
718: t_po_varval wf_engine.texttabtyp;

Line 728: l_document_type po_document_types.document_type_code%TYPE;

724: l_approver_index NUMBER;
725: l_first_position_id NUMBER DEFAULT NULL;
726: l_first_approver_id NUMBER DEFAULT NULL;
727: l_ame_transaction_id NUMBER;
728: l_document_type po_document_types.document_type_code%TYPE;
729: l_esigner_exists VARCHAR2(1);
730: l_api_name VARCHAR2(500) := 'launch_parallel_approval';
731: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
732: l_owner_user_name fnd_user.user_name%TYPE;

Line 1178: l_transaction_type po_document_types.ame_transaction_type%TYPE;

1174: p_response IN VARCHAR2 )
1175: IS
1176: l_progress VARCHAR2(3) := '000';
1177: l_document_id NUMBER;
1178: l_transaction_type po_document_types.ame_transaction_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);

Line 1185: l_document_type po_document_types.document_type_code%TYPE;

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;
1189: l_api_name VARCHAR2(500) := 'process_response_internal';

Line 1459: l_document_type po_document_types.document_type_code%TYPE;

1455: l_draft_id NUMBER;
1456: l_revision_num NUMBER;
1457: l_action VARCHAR2(30) := NULL;
1458: l_next_approver_id NUMBER :='';
1459: l_document_type po_document_types.document_type_code%TYPE;
1460: l_document_subtype po_document_types_all_b.document_subtype%TYPE;
1461: l_approval_group_id NUMBER:='';
1462: l_doc_string VARCHAR2(200);
1463: l_preparer_user_name VARCHAR2(100);

Line 1460: l_document_subtype po_document_types_all_b.document_subtype%TYPE;

1456: l_revision_num NUMBER;
1457: l_action VARCHAR2(30) := NULL;
1458: l_next_approver_id NUMBER :='';
1459: l_document_type po_document_types.document_type_code%TYPE;
1460: l_document_subtype po_document_types_all_b.document_subtype%TYPE;
1461: l_approval_group_id NUMBER:='';
1462: l_doc_string VARCHAR2(200);
1463: l_preparer_user_name VARCHAR2(100);
1464: l_org_id NUMBER;

Line 2703: l_document_type po_document_types.document_type_code%TYPE;

2699: l_document_id NUMBER;
2700: l_revision_num NUMBER;
2701: l_draft_id NUMBER;
2702: l_org_id NUMBER;
2703: l_document_type po_document_types.document_type_code%TYPE;
2704: l_document_subtype po_document_types_all_b.document_subtype%TYPE;
2705: l_approval_group_id NUMBER:='';
2706: l_original_recipient wf_notifications.original_recipient%TYPE;
2707: l_current_recipient_role wf_notifications.recipient_role%TYPE;

Line 2704: l_document_subtype po_document_types_all_b.document_subtype%TYPE;

2700: l_revision_num NUMBER;
2701: l_draft_id NUMBER;
2702: l_org_id NUMBER;
2703: l_document_type po_document_types.document_type_code%TYPE;
2704: l_document_subtype po_document_types_all_b.document_subtype%TYPE;
2705: l_approval_group_id NUMBER:='';
2706: l_original_recipient wf_notifications.original_recipient%TYPE;
2707: l_current_recipient_role wf_notifications.recipient_role%TYPE;
2708: l_api_name VARCHAR2(500) := 'post_approval_notif';

Line 3708: ameTransactionType po_document_types.ame_transaction_type%TYPE;

3704: l_approver_group_id NUMBER;
3705: l_po_header_id NUMBER;
3706: l_process_out VARCHAR2(10);
3707: l_approver_list ame_util.approversTable2;
3708: ameTransactionType po_document_types.ame_transaction_type%TYPE;
3709: l_response_action VARCHAR2(20);
3710: l_note VARCHAR2(4000);
3711: l_person_id NUMBER;
3712: l_orig_system VARCHAR2(3);

Line 3718: l_transaction_type po_document_types.ame_transaction_type%TYPE;

3714: l_preparer_user_name fnd_user.user_name%TYPE;
3715: l_doc_string VARCHAR2(200);
3716: l_ame_exception ame_util.longestStringType;
3717: l_approver_response VARCHAR2(20);
3718: l_transaction_type po_document_types.ame_transaction_type%TYPE;
3719: l_ame_transaction_id NUMBER;
3720: l_document_type po_document_types.document_type_code%TYPE;
3721: l_document_subtype po_document_types.document_subtype%TYPE;
3722: l_approver_category VARCHAR2(20);

Line 3720: l_document_type po_document_types.document_type_code%TYPE;

3716: l_ame_exception ame_util.longestStringType;
3717: l_approver_response VARCHAR2(20);
3718: l_transaction_type po_document_types.ame_transaction_type%TYPE;
3719: l_ame_transaction_id NUMBER;
3720: l_document_type po_document_types.document_type_code%TYPE;
3721: l_document_subtype po_document_types.document_subtype%TYPE;
3722: l_approver_category VARCHAR2(20);
3723: l_api_name VARCHAR2(500) := 'process_beat_by_first';
3724: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;

Line 3721: l_document_subtype po_document_types.document_subtype%TYPE;

3717: l_approver_response VARCHAR2(20);
3718: l_transaction_type po_document_types.ame_transaction_type%TYPE;
3719: l_ame_transaction_id NUMBER;
3720: l_document_type po_document_types.document_type_code%TYPE;
3721: l_document_subtype po_document_types.document_subtype%TYPE;
3722: l_approver_category VARCHAR2(20);
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);

Line 5096: l_transaction_type po_document_types.ame_transaction_type%TYPE;

5092: RETURN VARCHAR2
5093: IS
5094: l_approver_index NUMBER;
5095: e_signer_flag VARCHAR2(1);
5096: l_transaction_type po_document_types.ame_transaction_type%TYPE;
5097: l_ame_transaction_id NUMBER;
5098: l_api_name VARCHAR2(500) := 'check_set_esigners';
5099: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
5100:

Line 6027: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

6023: funcmode IN VARCHAR2,
6024: resultout OUT NOCOPY VARCHAR2)
6025: IS
6026: l_document_id NUMBER;
6027: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
6028: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
6029: l_doc_string VARCHAR2(200);
6030: l_preparer_user_name FND_USER.USER_NAME%TYPE;
6031: l_revision_num NUMBER;

Line 6028: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

6024: resultout OUT NOCOPY VARCHAR2)
6025: IS
6026: l_document_id NUMBER;
6027: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
6028: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
6029: l_doc_string VARCHAR2(200);
6030: l_preparer_user_name FND_USER.USER_NAME%TYPE;
6031: l_revision_num NUMBER;
6032: l_api_name VARCHAR2(500) := 'update_pending_signature';

Line 6342: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

6338: l_api_name VARCHAR2(500) := 'supress_existing_approvers';
6339: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
6340: l_approver_list ame_util.approversTable2;
6341: xprocess_out VARCHAR2(1);
6342: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
6343: l_transaction_id NUMBER;
6344: l_approver_index NUMBER;
6345:
6346: BEGIN