APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_SESSION_GT

Line 3070: -- PO_SESSION_GT mapping

3066:
3067: --
3068: -- Load the data into the temp table for bulk processing.
3069: --
3070: -- PO_SESSION_GT mapping
3071: --
3072: -- num1 document header_id
3073: -- num2 revision_num
3074: -- char1 authorization_status

Line 3084: INSERT INTO PO_SESSION_GT

3080:
3081: l_progress := '060';
3082:
3083: FORALL i IN 1 .. p_doc_id_tbl.COUNT
3084: INSERT INTO PO_SESSION_GT
3085: ( key
3086: , num1
3087: )
3088: VALUES

Line 3101: UPDATE PO_SESSION_GT SCRATCH

3097: IF (p_doc_type IN (g_doc_type_PO, g_doc_type_PA)) THEN
3098:
3099: l_progress := '110';
3100:
3101: UPDATE PO_SESSION_GT SCRATCH
3102: SET
3103: ( num2
3104: , char1
3105: , char2

Line 3125: UPDATE PO_SESSION_GT SCRATCH

3121: ELSIF (p_doc_type = g_doc_type_RELEASE) THEN
3122:
3123: l_progress := '120';
3124:
3125: UPDATE PO_SESSION_GT SCRATCH
3126: SET
3127: ( num2
3128: , char1
3129: , char2

Line 3151: UPDATE PO_SESSION_GT SCRATCH

3147: l_progress := '130';
3148:
3149: -- no revision_num for Reqs.
3150:
3151: UPDATE PO_SESSION_GT SCRATCH
3152: SET
3153: ( char1
3154: , char2
3155: )

Line 3175: UPDATE PO_SESSION_GT SCRATCH

3171: -- Determine if a NULL action already exists for the doc.
3172:
3173: l_progress := '150';
3174:
3175: UPDATE PO_SESSION_GT SCRATCH
3176: SET char3 =
3177: ( SELECT 'Y'
3178: FROM PO_ACTION_HISTORY POAH
3179: WHERE POAH.object_type_code = p_doc_type

Line 3219: PO_SESSION_GT SCRATCH

3215: , l_orig_auth_status_tbl
3216: , l_orig_doc_subtype_tbl
3217: , l_orig_null_flag_tbl
3218: FROM
3219: PO_SESSION_GT SCRATCH
3220: WHERE SCRATCH.key = l_gt_key
3221: ;
3222:
3223: l_progress := '210';