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 637: FROM po_headers_all pha,

633: WHERE
634: draft_id = To_number(dist.reference4))
635: WHEN reference1 = 'PO'
636: AND EXISTS (SELECT 1
637: FROM po_headers_all pha,
638: po_doc_style_headers pdsh
639: WHERE pdsh.style_id = pha.style_id
640: AND pdsh.clm_flag = 'Y'
641: AND segment1 = dist.reference4) THEN

Line 644: po_headers_all

640: AND pdsh.clm_flag = 'Y'
641: AND segment1 = dist.reference4) THEN
642: (SELECT clm_document_number
643: FROM
644: po_headers_all
645: WHERE
646: segment1 = dist.reference4)
647: ELSE dist.reference4
648: END ) reference_number,

Line 3025: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

3021: l_insert_action_code_tbl po_tbl_varchar30;
3022: l_insert_rev_num_tbl po_tbl_number;
3023:
3024: l_doc_id NUMBER;
3025: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
3026: l_rev_num NUMBER;
3027:
3028: l_index NUMBER;
3029: l_update_count NUMBER;

Line 3113: PO_HEADERS_ALL POH

3109: POH.revision_num
3110: , POH.authorization_status
3111: , POH.type_lookup_code
3112: FROM
3113: PO_HEADERS_ALL POH
3114: WHERE POH.po_header_id = SCRATCH.num1
3115: )
3116: WHERE SCRATCH.key = l_gt_key
3117: ;

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 3520: UPDATE PO_HEADERS_ALL POH

3516: -- is unreserved.
3517:
3518: l_progress := '030';
3519:
3520: UPDATE PO_HEADERS_ALL POH
3521: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3522: POH.approved_flag = 'R',
3523: POH.last_update_date = sysdate,
3524: POH.last_updated_by = fnd_global.user_id,

Line 3558: UPDATE PO_HEADERS_ALL POH

3554: -- is unreserved.
3555:
3556: l_progress := '040';
3557:
3558: UPDATE PO_HEADERS_ALL POH
3559: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3560: POH.approved_flag = 'R',
3561: POH.last_update_date = sysdate,
3562: POH.last_updated_by = fnd_global.user_id,

Line 4205: from psa_xla_accounting_errors pba,po_headers_all poh

4201: , g_result_TRANSACTION -- message type
4202: , pba.ENCODED_MSG
4203: , 'Y' --
4204: , poh.segment1
4205: from psa_xla_accounting_errors pba,po_headers_all poh
4206: where pba.event_id = PO_ENCUMBRANCE_POSTPROCESSING.g_event_id
4207: and pba.source_id_int_1 = poh.po_header_id
4208:
4209: UNION ALL