APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_SESSION_GT

Line 2741: -- PO_SESSION_GT mapping

2737:
2738: --
2739: -- Load the data into the temp table for bulk processing.
2740: --
2741: -- PO_SESSION_GT mapping
2742: --
2743: -- num1 document header_id
2744: -- num2 revision_num
2745: -- char1 authorization_status

Line 2755: INSERT INTO PO_SESSION_GT

2751:
2752: l_progress := '060';
2753:
2754: FORALL i IN 1 .. p_doc_id_tbl.COUNT
2755: INSERT INTO PO_SESSION_GT
2756: ( key
2757: , num1
2758: )
2759: VALUES

Line 2772: UPDATE PO_SESSION_GT SCRATCH

2768: IF (p_doc_type IN (g_doc_type_PO, g_doc_type_PA)) THEN
2769:
2770: l_progress := '110';
2771:
2772: UPDATE PO_SESSION_GT SCRATCH
2773: SET
2774: ( num2
2775: , char1
2776: , char2

Line 2796: UPDATE PO_SESSION_GT SCRATCH

2792: ELSIF (p_doc_type = g_doc_type_RELEASE) THEN
2793:
2794: l_progress := '120';
2795:
2796: UPDATE PO_SESSION_GT SCRATCH
2797: SET
2798: ( num2
2799: , char1
2800: , char2

Line 2822: UPDATE PO_SESSION_GT SCRATCH

2818: l_progress := '130';
2819:
2820: -- no revision_num for Reqs.
2821:
2822: UPDATE PO_SESSION_GT SCRATCH
2823: SET
2824: ( char1
2825: , char2
2826: )

Line 2846: UPDATE PO_SESSION_GT SCRATCH

2842: -- Determine if a NULL action already exists for the doc.
2843:
2844: l_progress := '150';
2845:
2846: UPDATE PO_SESSION_GT SCRATCH
2847: SET char3 =
2848: ( SELECT 'Y'
2849: FROM PO_ACTION_HISTORY POAH
2850: WHERE POAH.object_type_code = p_doc_type

Line 2889: PO_SESSION_GT SCRATCH

2885: , l_orig_auth_status_tbl
2886: , l_orig_doc_subtype_tbl
2887: , l_orig_null_flag_tbl
2888: FROM
2889: PO_SESSION_GT SCRATCH
2890: WHERE SCRATCH.key = l_gt_key
2891: ;
2892:
2893: l_progress := '210';