DBA Data[Home] [Help]

APPS.PO_VAL_PRICE_DIFFS2 dependencies on PO_SESSION_GT

Line 124: INSERT INTO po_session_gt

120:
121: l_gt_key := PO_CORE_S.get_session_gt_nextval();
122: -- insert the data in current group into temp table for comparason
123: FORALL i IN 1..p_id_tbl.COUNT
124: INSERT INTO po_session_gt
125: (key,
126: num1,
127: index_num1,
128: char1,

Line 179: FROM po_session_gt

175: AND entity_type = p_entity_type_tbl(i)
176: AND price_type = p_price_type_tbl(i))
177: OR
178: EXISTS(SELECT 1
179: FROM po_session_gt
180: WHERE key = l_gt_key
181: AND num1 < p_id_tbl(i)
182: AND index_num1 = p_entity_id_tbl(i)
183: AND char1 = p_entity_type_tbl(i)

Line 187: DELETE FROM po_session_gt

183: AND char1 = p_entity_type_tbl(i)
184: AND char2 = p_price_type_tbl(i)));
185:
186: -- remove the records from temp table
187: DELETE FROM po_session_gt
188: WHERE key = l_gt_key;
189:
190: IF (SQL%ROWCOUNT > 0) THEN
191: x_result_type := po_validations.c_result_type_failure;