APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_SESSION_GT

Line 1816: INSERT INTO PO_SESSION_GT(

1812: -- Put the stored data for these ids into the temp table.
1813: l_data_key := PO_CORE_S.get_session_gt_nextval();
1814:
1815: FORALL i IN 1 .. p_dist_id_tbl.COUNT
1816: INSERT INTO PO_SESSION_GT(
1817: KEY,
1818: index_num1,
1819: index_num2,
1820: num1,

Line 1858: PO_SESSION_GT GT

1854: GT.index_num1, -- po_distribution_id
1855: c_FUNDED_VALUE,
1856: PO_MESSAGE_S.PO_FUNDED_VAL_GT_REQ_FUNDS_RMN
1857: FROM
1858: PO_SESSION_GT GT
1859: WHERE
1860: GT.key = l_data_key
1861: AND EXISTS(
1862: SELECT NULL

Line 1863: FROM PO_SESSION_GT GT2,

1859: WHERE
1860: GT.key = l_data_key
1861: AND EXISTS(
1862: SELECT NULL
1863: FROM PO_SESSION_GT GT2,
1864: PO_CLMREQ_DIST_DETAILS_V PRD
1865: WHERE PRD.distribution_id = GT2.index_num2 -- JOIN
1866: AND GT2.key = l_data_key
1867: AND GT2.index_num2 = GT.index_num2 -- req_distribution_id

Line 2182: INSERT INTO PO_SESSION_GT(

2178: -- Put the stored data for these ids into the temp table.
2179: l_data_key := PO_CORE_S.get_session_gt_nextval();
2180:
2181: FORALL i IN 1 .. p_intf_dist_id_tbl.COUNT
2182: INSERT INTO PO_SESSION_GT(
2183: KEY,
2184: num1)
2185: SELECT
2186: l_data_key,

Line 2195: DELETE FROM po_session_gt

2191: AND pdi.interface_line_id = PLI.interface_line_id
2192: AND Nvl(PLI.clm_option_indicator,'*') = 'O'
2193: AND Nvl(PLI.clm_exercised_flag,'N') <> 'Y';
2194:
2195: DELETE FROM po_session_gt
2196: WHERE key = l_data_key
2197: RETURNING num1 BULK COLLECT INTO l_intf_dist_id_tbl;
2198:
2199: FOR i IN 1..l_intf_dist_id_tbl.Count