DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_CORE_S

Line 241: l_key := PO_CORE_S.get_session_gt_nextval;

237:
238: d_position := 10;
239:
240: -- pick a new key for temp table
241: l_key := PO_CORE_S.get_session_gt_nextval;
242:
243: -- search in txn table
244: FORALL i IN INDICES OF l_processing_row_tbl
245: INSERT INTO po_session_gt(key, num1, num2)

Line 492: l_key := PO_CORE_S.get_session_gt_nextval;

488: x_line_num_unique_tbl := PO_TBL_VARCHAR1();
489: x_line_num_unique_tbl.EXTEND(p_line_num_tbl.COUNT);
490:
491: -- pick a new key for temp table
492: l_key := PO_CORE_S.get_session_gt_nextval;
493:
494: -- initialize index table
495: PO_PDOI_UTL.generate_ordered_num_list
496: (

Line 647: l_key := PO_CORE_S.get_session_gt_nextval;

643: END IF;
644: END LOOP;
645:
646: -- pick a new key for temp table
647: l_key := PO_CORE_S.get_session_gt_nextval;
648:
649: -- bug 4642348:
650: -- if document type is QUOTATION, there is no need to
651: -- search the txn table since existing price breaks

Line 920: l_key := PO_CORE_S.get_session_gt_nextval;

916: x_shipment_num_unique_tbl := PO_TBL_VARCHAR1();
917: x_shipment_num_unique_tbl.EXTEND(p_shipment_num_tbl.COUNT);
918:
919: -- pick a new key for temp table
920: l_key := PO_CORE_S.get_session_gt_nextval;
921:
922: -- initialize index table
923: PO_PDOI_UTL.generate_ordered_num_list
924: (

Line 1073: l_key := PO_CORE_S.get_session_gt_nextval;

1069: END IF;
1070: END LOOP;
1071:
1072: -- pick a new key for temp table
1073: l_key := PO_CORE_S.get_session_gt_nextval;
1074:
1075: d_position := 10;
1076:
1077: -- search in draft table

Line 1328: l_key := PO_CORE_S.get_session_gt_nextval;

1324: x_dist_num_unique_tbl := PO_TBL_VARCHAR1();
1325: x_dist_num_unique_tbl.EXTEND(p_dist_num_tbl.COUNT);
1326:
1327: -- pick a new key from temp table
1328: l_key := PO_CORE_S.get_session_gt_nextval;
1329:
1330: -- initialize index table
1331: PO_PDOI_UTL.generate_ordered_num_list
1332: (

Line 1459: l_key := PO_CORE_S.get_session_gt_nextval;

1455: PO_LOG.proc_begin(d_module, 'p_draft_id_tbl', p_draft_id_tbl);
1456: END IF;
1457:
1458: -- pick a new key for temp table
1459: l_key := PO_CORE_S.get_session_gt_nextval;
1460:
1461: d_position := 10;
1462:
1463: -- first, search in draft table for max price diff num

Line 1702: l_key := PO_CORE_S.get_session_gt_nextval;

1698: x_price_diff_num_unique_tbl := PO_TBL_VARCHAR1();
1699: x_price_diff_num_unique_tbl.EXTEND(p_price_diff_num_tbl.COUNT);
1700:
1701: -- pick a new key from temp table
1702: l_key := PO_CORE_S.get_session_gt_nextval;
1703:
1704: -- initialize index table
1705: PO_PDOI_UTL.generate_ordered_num_list
1706: (