APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_HEADERS_ALL

Line 87: PO_HEADERS_ALL.type_lookup_code%TYPE

83:
84: -- doc subtypes
85:
86: g_doc_subtype_STANDARD CONSTANT
87: PO_HEADERS_ALL.type_lookup_code%TYPE
88: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD;
89:
90: g_doc_subtype_PLANNED CONSTANT
91: PO_HEADERS_ALL.type_lookup_code%TYPE

Line 91: PO_HEADERS_ALL.type_lookup_code%TYPE

87: PO_HEADERS_ALL.type_lookup_code%TYPE
88: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD;
89:
90: g_doc_subtype_PLANNED CONSTANT
91: PO_HEADERS_ALL.type_lookup_code%TYPE
92: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED;
93:
94: g_doc_subtype_BLANKET CONSTANT
95: PO_RELEASES_ALL.release_type%TYPE

Line 103: PO_HEADERS_ALL.type_lookup_code%TYPE

99: PO_RELEASES_ALL.release_type%TYPE
100: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_SCHEDULED;
101:
102: g_doc_subtype_MIXED_PO_RELEASE CONSTANT
103: PO_HEADERS_ALL.type_lookup_code%TYPE
104: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_MIXED_PO_RELEASE;
105:
106: -- doc levels
107:

Line 2696: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

2692: l_insert_action_code_tbl po_tbl_varchar30;
2693: l_insert_rev_num_tbl po_tbl_number;
2694:
2695: l_doc_id NUMBER;
2696: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2697: l_rev_num NUMBER;
2698:
2699: l_index NUMBER;
2700: l_update_count NUMBER;

Line 2784: PO_HEADERS_ALL POH

2780: POH.revision_num
2781: , POH.authorization_status
2782: , POH.type_lookup_code
2783: FROM
2784: PO_HEADERS_ALL POH
2785: WHERE POH.po_header_id = SCRATCH.num1
2786: )
2787: WHERE SCRATCH.key = l_gt_key
2788: ;

Line 3070: -- PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINE_LOCATIONS_ALL

3066: --Name: set_status_requires_reapproval
3067: --Pre-reqs:
3068: -- Unreserve action completed successfully.
3069: --Modifies:
3070: -- PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINE_LOCATIONS_ALL
3071: --Locks:
3072: -- None.
3073: --Function:
3074: -- This procedure updates the 'Approved' Shipments to 'REQUIRES REAPPROVAL'

Line 3190: UPDATE PO_HEADERS_ALL POH

3186: -- is unreserved.
3187:
3188: l_progress := '030';
3189:
3190: UPDATE PO_HEADERS_ALL POH
3191: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3192: POH.approved_flag = 'R',
3193: POH.last_update_date = sysdate,
3194: POH.last_updated_by = fnd_global.user_id,

Line 3228: UPDATE PO_HEADERS_ALL POH

3224: -- is unreserved.
3225:
3226: l_progress := '040';
3227:
3228: UPDATE PO_HEADERS_ALL POH
3229: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3230: POH.approved_flag = 'R',
3231: POH.last_update_date = sysdate,
3232: POH.last_updated_by = fnd_global.user_id,