APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PO_SESSION_GT

Line 459: l_key po_session_gt.key%TYPE;

455: d_mod CONSTANT VARCHAR2(100) := d_destination_type_code;
456: d_position NUMBER;
457:
458: -- key of temp table used to identify the derived result
459: l_key po_session_gt.key%TYPE;
460: l_num_list_tbl DBMS_SQL.NUMBER_TABLE;
461:
462: -- tables to store the derived result
463: l_index_tbl PO_TBL_NUMBER;

Line 537: INSERT INTO po_session_gt(key, num1, char1)

533:
534: d_position := 40;
535:
536: FORALL i IN 1..l_num_list_tbl.COUNT
537: INSERT INTO po_session_gt(key, num1, char1)
538: SELECT l_key,
539: l_num_list_tbl(i),
540: decode(msi.outside_operation_flag,'Y','O', decode(msi.stock_enabled_flag,'Y','E','D'))
541: FROM mtl_system_items msi

Line 548: DELETE FROM po_session_gt

544: AND msi.inventory_item_id = p_item_id_tbl(i);
545:
546: d_position := 50;
547:
548: DELETE FROM po_session_gt
549: WHERE key = l_key
550: RETURNING num1, char1
551: BULK COLLECT INTO l_index_tbl, l_result_tbl;
552: