APPS.PO_LINE_LOCATIONS_DRAFT_PVT dependencies on PO_SESSION_GT

Line 90: INSERT INTO po_session_gt

86:
87: d_position := 20;
88:
89: FORALL i IN 1..p_draft_id_tbl.COUNT
90: INSERT INTO po_session_gt
91: ( key,
92: num1
93: )
94: SELECT l_key,

Line 109: DELETE FROM po_session_gt

105: d_position := 30;
106:
107: -- All the num1 returned from this DELETE statement are indexes for
108: -- records that contain draft changes
109: DELETE FROM po_session_gt
110: WHERE key = l_key
111: RETURNING num1
112: BULK COLLECT INTO l_dft_exists_index_tbl;
113:

Line 377: INSERT INTO po_session_gt

373:
374: l_key := PO_CORE_S.get_session_gt_nextval;
375:
376: -- New price break or deleted price break trigger retroactive pricing
377: INSERT INTO po_session_gt
378: ( key,
379: num1
380: )
381: SELECT l_key,

Line 395: INSERT INTO po_session_gt

391: d_position := 20;
392:
393: -- If one of the pricing attributes get modified, it triggers
394: -- retroactive pricing event as well
395: INSERT INTO po_session_gt
396: ( key,
397: num1
398: )
399: SELECT l_key,

Line 425: DELETE FROM po_session_gt

421:
422: d_position := 30;
423:
424: -- get all the lines that need to retroactively re-price
425: DELETE FROM po_session_gt
426: WHERE key = l_key
427: RETURNING num1, p_draft_info.draft_id, NULL
428: BULK COLLECT
429: INTO l_po_line_id_tbl, l_draft_id_tbl, l_delete_flag_tbl;