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 416: ameTransactionType po_document_types.ame_transaction_type%TYPE;

412: upperLimit number;
413: approverList ame_util.approversTable2;
414: hasAvailableOrder boolean := false;
415: E_NO_AVAILABLE_INSERTION EXCEPTION;
416: ameTransactionType po_document_types.ame_transaction_type%TYPE;
417: absolutePosition number;
418: availableInsertionList ame_util.insertionsTable2;
419: l_process_out VARCHAR2(10);
420: l_group_or_chain_id NUMBER := 0;

Line 802: ameTransactionType po_document_types.ame_transaction_type%TYPE;

798: ) IS
799:
800: l_api_name varchar2(50):= 'delete_approver';
801: tmpApprover ame_util.approverRecord2;
802: ameTransactionType po_document_types.ame_transaction_type%TYPE;
803:
804: approverList ame_util.approversTable2;
805: l_process_out VARCHAR2(10);
806: l_first_position_id NUMBER;

Line 1036: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1032: --approverList ame_util.approversTable;
1033: clearListForSavedCart varchar2(1) := 'N';
1034: authorizationStatus po_requisition_headers.authorization_status%TYPE;
1035: preparerId po_requisition_headers.preparer_id%TYPE;
1036: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1037:
1038: l_itemtype po_requisition_headers.wf_item_type%TYPE;
1039: l_itemkey po_requisition_headers.wf_item_key%TYPE;
1040:

Line 1393: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1389: l_api_name varchar2(50):= 'get_old_approval_list';
1390: hasApprovalAction varchar2(1);
1391: approverCount number;
1392: approverList ame_util.approversTable2;
1393: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1394: authorizationStatus po_requisition_headers_all.authorization_status%TYPE;
1395: isRcoApproval boolean := false;
1396: changeRequestExist number := 0;
1397: l_process_out VARCHAR2(10);

Line 1581: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1577: l_preparer_user_name varchar2(100);
1578:
1579: approverCount integer;
1580: approvers ame_util.approversTable2;
1581: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1582: l_process_out VARCHAR2(10);
1583:
1584: BEGIN
1585:

Line 1707: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1703:
1704: l_api_name varchar2(50):= 'get_first_authority_approver';
1705: approverCount number;
1706: approvers ame_util.approversTable2;
1707: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1708: l_process_out VARCHAR2(10);
1709:
1710: BEGIN
1711:

Line 1832: ameTransactionType po_document_types.ame_transaction_type%TYPE;

1828: l_api_name varchar2(50):= 'can_delete_oam_approvers';
1829: attributeValue1 VARCHAR2(10);
1830: attributeValue2 VARCHAR2(10);
1831: attributeValue3 VARCHAR2(10);
1832: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1833:
1834: BEGIN
1835:
1836: if g_fnd_debug = 'Y' then

Line 1903: docType po_document_types.document_type_code%TYPE;

1899: ) IS
1900:
1901: l_api_name varchar2(50):= 'getAmeTransactionType';
1902: changeRequestExist number := 0;
1903: docType po_document_types.document_type_code%TYPE;
1904: docSubType po_document_types.document_subtype%TYPE;
1905: lookupCode po_requisition_headers.type_lookup_code%TYPE;
1906: orgId NUMBER;
1907:

Line 1904: docSubType po_document_types.document_subtype%TYPE;

1900:
1901: l_api_name varchar2(50):= 'getAmeTransactionType';
1902: changeRequestExist number := 0;
1903: docType po_document_types.document_type_code%TYPE;
1904: docSubType po_document_types.document_subtype%TYPE;
1905: lookupCode po_requisition_headers.type_lookup_code%TYPE;
1906: orgId NUMBER;
1907:
1908: begin

Line 1981: x_ame_txn_type po_document_types_all_b.ame_transaction_type%TYPE;

1977: function getAmeTxnType (p_doc_type IN VARCHAR2,
1978: p_doc_subtype IN VARCHAR2,
1979: p_org_id IN NUMBER)
1980: return VARCHAR2 is
1981: x_ame_txn_type po_document_types_all_b.ame_transaction_type%TYPE;
1982: BEGIN
1983:
1984: SELECT ame_transaction_type
1985: INTO x_ame_txn_type

Line 1986: FROM po_document_types_all_b

1982: BEGIN
1983:
1984: SELECT ame_transaction_type
1985: INTO x_ame_txn_type
1986: FROM po_document_types_all_b
1987: WHERE document_type_code = p_doc_type
1988: and document_subtype = p_doc_subtype
1989: and org_id = p_org_id;
1990:

Line 2749: ameTransactionType po_document_types.ame_transaction_type%TYPE;

2745: pFieldDelimiter OUT NOCOPY VARCHAR2
2746: ) IS
2747:
2748: l_api_name varchar2(50):= 'get_ame_approval_list_history';
2749: ameTransactionType po_document_types.ame_transaction_type%TYPE;
2750:
2751: l_itemtype po_requisition_headers.wf_item_type%TYPE;
2752: l_itemkey po_requisition_headers.wf_item_key%TYPE;
2753:

Line 2771: p_doc_type po_document_types_all_b.document_type_code%type;

2767: l_preparer_id NUMBER;
2768: l_first_approver_id NUMBER;
2769: l_first_position_id NUMBER;
2770: l_org_id NUMBER;
2771: p_doc_type po_document_types_all_b.document_type_code%type;
2772: p_doc_subtype po_document_types_all_b.document_subtype%type;
2773: l_authorizationStatus po_requisition_headers_all.AUTHORIZATION_STATUS%type;
2774: l_change_pending_flag po_requisition_headers_all.CHANGE_PENDING_FLAG%type;
2775: l_approval_reqd_flag PO_CHANGE_REQUESTS.APPROVAL_REQUIRED_FLAG%type;

Line 2772: p_doc_subtype po_document_types_all_b.document_subtype%type;

2768: l_first_approver_id NUMBER;
2769: l_first_position_id NUMBER;
2770: l_org_id NUMBER;
2771: p_doc_type po_document_types_all_b.document_type_code%type;
2772: p_doc_subtype po_document_types_all_b.document_subtype%type;
2773: l_authorizationStatus po_requisition_headers_all.AUTHORIZATION_STATUS%type;
2774: l_change_pending_flag po_requisition_headers_all.CHANGE_PENDING_FLAG%type;
2775: l_approval_reqd_flag PO_CHANGE_REQUESTS.APPROVAL_REQUIRED_FLAG%type;
2776:

Line 3207: l_ameTransactionType po_document_types.ame_transaction_type%TYPE;

3203: ) IS
3204:
3205: l_itemtype po_requisition_headers.wf_item_type%TYPE;
3206: l_itemkey po_requisition_headers.wf_item_key%TYPE;
3207: l_ameTransactionType po_document_types.ame_transaction_type%TYPE;
3208: l_completeYNO varchar2(100);
3209:
3210: l_approversList ame_util.approversTable2;
3211: l_approver_index NUMBER;

Line 3457: ameTransactionType po_document_types.ame_transaction_type%TYPE;

3453: FUNCTION is_req_forward_valid( pReqHeaderId IN NUMBER) RETURN VARCHAR2 IS
3454:
3455: l_api_name varchar2(50):= 'is_req_forward_valid';
3456: tmpApprover ame_util.approverRecord2;
3457: ameTransactionType po_document_types.ame_transaction_type%TYPE;
3458:
3459: approverList ame_util.approversTable2;
3460: l_process_out VARCHAR2(10);
3461: currentFirstApprover ame_util.approverRecord2;

Line 3568: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

3564: actid in number,
3565: funcmode in varchar2,
3566: resultout out NOCOPY varchar2) IS
3567:
3568: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
3569: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
3570: l_document_id NUMBER;
3571: l_ame_Transaction_Type PO_DOCUMENT_TYPES_ALL.ame_transaction_type%TYPE;
3572: l_progress VARCHAR2(300) := '000';

Line 3569: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

3565: funcmode in varchar2,
3566: resultout out NOCOPY varchar2) IS
3567:
3568: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
3569: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
3570: l_document_id NUMBER;
3571: l_ame_Transaction_Type PO_DOCUMENT_TYPES_ALL.ame_transaction_type%TYPE;
3572: l_progress VARCHAR2(300) := '000';
3573: l_doc_string varchar2(200);

Line 3571: l_ame_Transaction_Type PO_DOCUMENT_TYPES_ALL.ame_transaction_type%TYPE;

3567:
3568: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
3569: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
3570: l_document_id NUMBER;
3571: l_ame_Transaction_Type PO_DOCUMENT_TYPES_ALL.ame_transaction_type%TYPE;
3572: l_progress VARCHAR2(300) := '000';
3573: l_doc_string varchar2(200);
3574: l_preparer_user_name varchar2(100);
3575: l_orgid number;

Line 3646: FROM po_document_types

3642: BEGIN
3643:
3644: SELECT ame_transaction_type
3645: INTO l_ame_Transaction_Type
3646: FROM po_document_types
3647: WHERE document_type_code = l_document_type
3648: and document_subtype = l_document_subtype;
3649:
3650: EXCEPTION