APPS.PO_VAL_HEADERS dependencies on PO_SESSION_GT

Line 955: INSERT INTO PO_SESSION_GT

951:
952: l_data_key := PO_CORE_S.get_session_gt_nextval();
953:
954: FORALL i IN 1 .. p_header_id_tbl.COUNT
955: INSERT INTO PO_SESSION_GT
956: ( key
957: , num1
958: , num2
959: , char1

Line 977: PO_SESSION_GT SES

973: BULK COLLECT INTO
974: l_header_id_tbl
975: , l_segment1_tbl
976: FROM
977: PO_SESSION_GT SES
978: , PO_SYSTEM_PARAMETERS_ALL PARAMS
979: WHERE
980: SES.key = l_data_key
981: AND SES.num2 = PARAMS.org_id

Line 1068: -- The following mapping is used for PO_SESSION_GT in this

1064: l_results_count := x_results.result_type.COUNT;
1065:
1066: ----------------------------------------------------------
1067: --
1068: -- The following mapping is used for PO_SESSION_GT in this
1069: -- procedure:
1070: --
1071: -- num1 - po_header_id
1072: -- num2 - org_id

Line 1085: INSERT INTO PO_SESSION_GT

1081:
1082: -- Only check unsaved headers with manually entered document numbers.
1083:
1084: FORALL i IN 1 .. p_header_id_tbl.COUNT
1085: INSERT INTO PO_SESSION_GT
1086: ( key
1087: , num1
1088: , num2
1089: , index_char1

Line 1117: UPDATE PO_SESSION_GT SES

1113: IF (SQL%ROWCOUNT > 0) THEN
1114:
1115: d_position := 110;
1116:
1117: UPDATE PO_SESSION_GT SES
1118: SET index_char2 = 'X'
1119: WHERE
1120: SES.key = l_data_key
1121: AND

Line 1147: FROM PO_SESSION_GT UNSAVED_DATA

1143: OR
1144: -- Check for other in-memory documents.
1145: EXISTS
1146: ( SELECT NULL
1147: FROM PO_SESSION_GT UNSAVED_DATA
1148: WHERE
1149: UNSAVED_DATA.key = l_data_key
1150: AND UNSAVED_DATA.num2 = SES.num2 -- org_id
1151: AND UNSAVED_DATA.index_char1 = SES.index_char1 -- segment1

Line 1180: PO_SESSION_GT SES

1176: , l_org_id_tbl
1177: , l_segment1_tbl
1178: , l_nonunique_tbl
1179: FROM
1180: PO_SESSION_GT SES
1181: WHERE
1182: SES.key = l_data_key
1183: AND
1184: ( SES.index_char2 = 'X'