APPS.POR_AME_APPROVAL_LIST dependencies on PO_DOCUMENT_TYPES_ALL_B

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 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: