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 336: INSERT INTO po_session_gt

332:
333: l_key := PO_CORE_S.get_session_gt_nextval;
334:
335: -- New price break or deleted price break trigger retroactive pricing
336: INSERT INTO po_session_gt
337: ( key,
338: num1
339: )
340: SELECT l_key,

Line 354: INSERT INTO po_session_gt

350: d_position := 20;
351:
352: -- If one of the pricing attributes get modified, it triggers
353: -- retroactive pricing event as well
354: INSERT INTO po_session_gt
355: ( key,
356: num1
357: )
358: SELECT l_key,

Line 384: DELETE FROM po_session_gt

380:
381: d_position := 30;
382:
383: -- get all the lines that need to retroactively re-price
384: DELETE FROM po_session_gt
385: WHERE key = l_key
386: RETURNING num1, p_draft_info.draft_id, NULL
387: BULK COLLECT
388: INTO l_po_line_id_tbl, l_draft_id_tbl, l_delete_flag_tbl;