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_APPROVAL_LIST dependencies on PO_DOCUMENT_TYPES

Line 161: ameTransactionType po_document_types.ame_transaction_type%TYPE;

157: ) IS
158:
159: l_api_name varchar2(50):= 'change_first_approver';
160: tmpApprover ame_util.approverRecord2;
161: ameTransactionType po_document_types.ame_transaction_type%TYPE;
162:
163: approverList ame_util.approversTable2;
164: l_process_out VARCHAR2(10);
165: currentFirstApprover ame_util.approverRecord2;

Line 405: ameTransactionType po_document_types.ame_transaction_type%TYPE;

401: upperLimit number;
402: approverList ame_util.approversTable2;
403: hasAvailableOrder boolean := false;
404: E_NO_AVAILABLE_INSERTION EXCEPTION;
405: ameTransactionType po_document_types.ame_transaction_type%TYPE;
406: absolutePosition number;
407: availableInsertionList ame_util.insertionsTable2;
408: l_process_out VARCHAR2(10);
409: l_group_or_chain_id NUMBER := 0;

Line 771: ameTransactionType po_document_types.ame_transaction_type%TYPE;

767: ) IS
768:
769: l_api_name varchar2(50):= 'delete_approver';
770: tmpApprover ame_util.approverRecord2;
771: ameTransactionType po_document_types.ame_transaction_type%TYPE;
772:
773: approverList ame_util.approversTable2;
774: l_process_out VARCHAR2(10);
775: l_first_position_id NUMBER;

Line 1005: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1001: --approverList ame_util.approversTable;
1002: clearListForSavedCart varchar2(1) := 'N';
1003: authorizationStatus po_requisition_headers.authorization_status%TYPE;
1004: preparerId po_requisition_headers.preparer_id%TYPE;
1005: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1006:
1007: l_itemtype po_requisition_headers.wf_item_type%TYPE;
1008: l_itemkey po_requisition_headers.wf_item_key%TYPE;
1009:

Line 1334: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1330: l_api_name varchar2(50):= 'get_old_approval_list';
1331: hasApprovalAction varchar2(1);
1332: approverCount number;
1333: approverList ame_util.approversTable2;
1334: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1335: authorizationStatus po_requisition_headers_all.authorization_status%TYPE;
1336: isRcoApproval boolean := false;
1337: changeRequestExist number := 0;
1338: l_process_out VARCHAR2(10);

Line 1516: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1512: l_preparer_user_name varchar2(100);
1513:
1514: approverCount integer;
1515: approvers ame_util.approversTable2;
1516: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1517: l_process_out VARCHAR2(10);
1518:
1519: BEGIN
1520:

Line 1642: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1638:
1639: l_api_name varchar2(50):= 'get_first_authority_approver';
1640: approverCount number;
1641: approvers ame_util.approversTable2;
1642: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1643: l_process_out VARCHAR2(10);
1644:
1645: BEGIN
1646:

Line 1767: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1763: l_api_name varchar2(50):= 'can_delete_oam_approvers';
1764: attributeValue1 VARCHAR2(10);
1765: attributeValue2 VARCHAR2(10);
1766: attributeValue3 VARCHAR2(10);
1767: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1768:
1769: BEGIN
1770:
1771: if g_fnd_debug = 'Y' then

Line 1838: docType po_document_types.document_type_code%TYPE;

1834: ) IS
1835:
1836: l_api_name varchar2(50):= 'getAmeTransactionType';
1837: changeRequestExist number := 0;
1838: docType po_document_types.document_type_code%TYPE;
1839: docSubType po_document_types.document_subtype%TYPE;
1840: lookupCode po_requisition_headers.type_lookup_code%TYPE;
1841: orgId NUMBER;
1842:

Line 1839: docSubType po_document_types.document_subtype%TYPE;

1835:
1836: l_api_name varchar2(50):= 'getAmeTransactionType';
1837: changeRequestExist number := 0;
1838: docType po_document_types.document_type_code%TYPE;
1839: docSubType po_document_types.document_subtype%TYPE;
1840: lookupCode po_requisition_headers.type_lookup_code%TYPE;
1841: orgId NUMBER;
1842:
1843: begin

Line 1916: x_ame_txn_type po_document_types_all_b.ame_transaction_type%TYPE;

1912: function getAmeTxnType (p_doc_type IN VARCHAR2,
1913: p_doc_subtype IN VARCHAR2,
1914: p_org_id IN NUMBER)
1915: return VARCHAR2 is
1916: x_ame_txn_type po_document_types_all_b.ame_transaction_type%TYPE;
1917: BEGIN
1918:
1919: SELECT ame_transaction_type
1920: INTO x_ame_txn_type

Line 1921: FROM po_document_types_all_b

1917: BEGIN
1918:
1919: SELECT ame_transaction_type
1920: INTO x_ame_txn_type
1921: FROM po_document_types_all_b
1922: WHERE document_type_code = p_doc_type
1923: and document_subtype = p_doc_subtype
1924: and org_id = p_org_id;
1925:

Line 2679: ameTransactionType po_document_types.ame_transaction_type%TYPE;

2675: pFieldDelimiter OUT NOCOPY VARCHAR2
2676: ) IS
2677:
2678: l_api_name varchar2(50):= 'get_ame_approval_list_history';
2679: ameTransactionType po_document_types.ame_transaction_type%TYPE;
2680:
2681: l_itemtype po_requisition_headers.wf_item_type%TYPE;
2682: l_itemkey po_requisition_headers.wf_item_key%TYPE;
2683:

Line 2701: p_doc_type po_document_types_all_b.document_type_code%type;

2697: l_preparer_id NUMBER;
2698: l_first_approver_id NUMBER;
2699: l_first_position_id NUMBER;
2700: l_org_id NUMBER;
2701: p_doc_type po_document_types_all_b.document_type_code%type;
2702: p_doc_subtype po_document_types_all_b.document_subtype%type;
2703: l_authorizationStatus po_requisition_headers_all.AUTHORIZATION_STATUS%type;
2704: l_change_pending_flag po_requisition_headers_all.CHANGE_PENDING_FLAG%type;
2705: l_approval_reqd_flag PO_CHANGE_REQUESTS.APPROVAL_REQUIRED_FLAG%type;

Line 2702: p_doc_subtype po_document_types_all_b.document_subtype%type;

2698: l_first_approver_id NUMBER;
2699: l_first_position_id NUMBER;
2700: l_org_id NUMBER;
2701: p_doc_type po_document_types_all_b.document_type_code%type;
2702: p_doc_subtype po_document_types_all_b.document_subtype%type;
2703: l_authorizationStatus po_requisition_headers_all.AUTHORIZATION_STATUS%type;
2704: l_change_pending_flag po_requisition_headers_all.CHANGE_PENDING_FLAG%type;
2705: l_approval_reqd_flag PO_CHANGE_REQUESTS.APPROVAL_REQUIRED_FLAG%type;
2706:

Line 3131: l_ameTransactionType po_document_types.ame_transaction_type%TYPE;

3127: ) IS
3128:
3129: l_itemtype po_requisition_headers.wf_item_type%TYPE;
3130: l_itemkey po_requisition_headers.wf_item_key%TYPE;
3131: l_ameTransactionType po_document_types.ame_transaction_type%TYPE;
3132: l_completeYNO varchar2(100);
3133:
3134: l_approversList ame_util.approversTable2;
3135: l_approver_index NUMBER;