APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_RELEASES_ALL

Line 95: PO_RELEASES_ALL.release_type%TYPE

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
96: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_BLANKET;
97:
98: g_doc_subtype_SCHEDULED CONSTANT
99: PO_RELEASES_ALL.release_type%TYPE

Line 99: PO_RELEASES_ALL.release_type%TYPE

95: PO_RELEASES_ALL.release_type%TYPE
96: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_BLANKET;
97:
98: g_doc_subtype_SCHEDULED CONSTANT
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

Line 2808: PO_RELEASES_ALL POR

2804: POR.revision_num
2805: , POR.authorization_status
2806: , POR.release_type
2807: FROM
2808: PO_RELEASES_ALL POR
2809: WHERE POR.po_release_id = SCRATCH.num1
2810: )
2811: WHERE SCRATCH.key = l_gt_key
2812: ;

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 3295: UPDATE PO_RELEASES_ALL POR

3291: -- succeeded in GL and PO is approved.
3292: --SQL Why: The PO should be unapproved if one of its distribution
3293: -- is unreserved.
3294:
3295: UPDATE PO_RELEASES_ALL POR
3296: SET POR.authorization_status = 'REQUIRES REAPPROVAL',
3297: POR.approved_flag = 'R',
3298: POR.last_update_date = sysdate,
3299: POR.last_updated_by = fnd_global.user_id,