DBA Data[Home] [Help]

APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_CORE_S

Line 434: l_key := PO_CORE_S.get_session_gt_nextval;

430:
431: d_position := 20;
432:
433: -- get existing values for all updatable attributes
434: l_key := PO_CORE_S.get_session_gt_nextval;
435: FORALL i IN 1..l_po_line_id_tbl.COUNT
436: INSERT INTO po_session_gt
437: (
438: key,

Line 1332: l_key := PO_CORE_S.get_session_gt_nextval;

1328: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1329: d_position := 10;
1330:
1331: -- get existing line_location_ids
1332: l_key := PO_CORE_S.get_session_gt_nextval;
1333: FORALL i IN 1..p_line_locs.rec_count
1334: INSERT INTO po_session_gt(key, num1, num2, char1)
1335: SELECT DISTINCT l_key,
1336: line_location_id,

Line 1568: l_key := PO_CORE_S.get_session_gt_nextval;

1564:
1565: d_position := 10;
1566:
1567: -- save id attr values into po_session_gt for MERGE query
1568: l_key := PO_CORE_S.get_session_gt_nextval;
1569: FORALL i IN INDICES OF p_processing_row_tbl
1570: INSERT INTO po_session_gt
1571: (
1572: key,

Line 1686: l_key := PO_CORE_S.get_session_gt_nextval;

1682:
1683: d_position := 10;
1684:
1685: -- save id attr values tlp into po_session_gt for MERGE query
1686: l_key := PO_CORE_S.get_session_gt_nextval;
1687: FORALL i IN INDICES OF p_processing_row_tbl
1688: INSERT INTO po_session_gt
1689: (
1690: key,

Line 5344: l_key := PO_CORE_S.get_session_gt_nextval;

5340: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
5341: PO_LOG.proc_begin(d_module, 'p_draft_id_tbl', p_draft_id_tbl);
5342: END IF;
5343:
5344: l_key := PO_CORE_S.get_session_gt_nextval;
5345:
5346: -- get attribute_values_id we need to sync from txn tables
5347: FORALL i IN INDICES OF p_index_tbl
5348: INSERT INTO po_session_gt