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 3137: PO_RELEASES_ALL POR

3133: POR.revision_num
3134: , POR.authorization_status
3135: , POR.release_type
3136: FROM
3137: PO_RELEASES_ALL POR
3138: WHERE POR.po_release_id = SCRATCH.num1
3139: )
3140: WHERE SCRATCH.key = l_gt_key
3141: ;

Line 3400: -- PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINE_LOCATIONS_ALL

3396: --Name: set_status_requires_reapproval
3397: --Pre-reqs:
3398: -- Unreserve action completed successfully.
3399: --Modifies:
3400: -- PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINE_LOCATIONS_ALL
3401: --Locks:
3402: -- None.
3403: --Function:
3404: -- This procedure updates the 'Approved' Shipments to 'REQUIRES REAPPROVAL'

Line 3625: UPDATE PO_RELEASES_ALL POR

3621: -- succeeded in GL and PO is approved.
3622: --SQL Why: The PO should be unapproved if one of its distribution
3623: -- is unreserved.
3624:
3625: UPDATE PO_RELEASES_ALL POR
3626: SET POR.authorization_status = 'REQUIRES REAPPROVAL',
3627: POR.approved_flag = 'R',
3628: POR.last_update_date = sysdate,
3629: POR.last_updated_by = fnd_global.user_id,