APPS.PO_VAL_LINES dependencies on PO_SESSION_GT

Line 613: INSERT INTO PO_SESSION_GT

609:
610: d_progress := 30.0;
611:
612: FORALL i IN 1 .. p_line_id_tbl.COUNT
613: INSERT INTO PO_SESSION_GT
614: ( key
615: , index_num1 -- po_line_id
616: , char1 -- currency_code
617: , num1 -- minimum_accountable_unit

Line 719: , PO_SESSION_GT GTT

715: ELSE GREATEST(NVL(PLL.amount_billed, 0),
716: NVL(PLL.amount_financed, 0))
717: END)), 0) sum_amt_bill_actuals
718: FROM PO_LINE_LOCATIONS_ALL PLL
719: , PO_SESSION_GT GTT
720: WHERE PLL.po_line_id = p_line_id_tbl(i)
721: AND GTT.key = l_gt_key
722: AND GTT.index_num1(+) = PLL.po_line_id
723: )

Line 804: INSERT INTO PO_SESSION_GT

800:
801: l_data_key := PO_CORE_S.get_session_gt_nextval();
802:
803: FORALL i IN 1 .. p_line_id_tbl.COUNT
804: INSERT INTO PO_SESSION_GT
805: ( key
806: , num1
807: , num2
808: )

Line 823: PO_SESSION_GT SES

819: BULK COLLECT INTO
820: l_line_id_tbl
821: , l_amount_tbl
822: FROM
823: PO_SESSION_GT SES
824: , PO_LINES_ALL LINE
825: , PO_HEADERS_ALL HEADER
826: WHERE
827: SES.key = l_data_key

Line 1312: INSERT INTO PO_SESSION_GT

1308:
1309: l_data_key := PO_CORE_S.get_session_gt_nextval();
1310:
1311: FORALL i IN 1 .. p_line_id_tbl.COUNT
1312: INSERT INTO PO_SESSION_GT
1313: ( key
1314: , num1
1315: , num2
1316: , char1

Line 1334: PO_SESSION_GT SES

1330: BULK COLLECT INTO
1331: l_line_id_tbl
1332: , l_price_break_lookup_code_tbl
1333: FROM
1334: PO_SESSION_GT SES
1335: , PO_LINES_ALL SAVED_LINE
1336: WHERE
1337: SES.key = l_data_key
1338: AND SAVED_LINE.po_line_id = SES.num1