APPS.POR_AME_APPROVAL_LIST dependencies on PO_DOCUMENT_TYPES_ALL_B

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