APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on CSM_MTL_ONHAND_QTY_ACC_S

Line 626: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL

622: l_sqlerrno varchar2(20);
623: l_sqlerrmsg varchar2(2000);
624:
625: CURSOR l_onhand_acc_seq IS
626: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL
627: FROM dual;
628:
629: -- post deletes to onhand
630: CURSOR l_onhand_delete_csr IS

Line 743: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;

739:
740:
741: TYPE inv_idTab IS TABLE OF csm_mtl_onhand_qty_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
742: TYPE org_idTab IS TABLE OF csm_mtl_onhand_qty_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
743: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
744: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
746: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
747: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;

Line 950: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;

946: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || 'inserted records',
947: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
948:
949: FOR i IN inv_id.FIRST..inv_id.LAST LOOP
950: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;
951: END LOOP;
952:
953: FORALL i IN inv_id.FIRST..inv_id.LAST
954: INSERT INTO CSM_MTL_ONHAND_QTY_ACC (ACCESS_ID, user_id, INVENTORY_ITEM_ID,ORGANIZATION_ID,