DBA Data[Home] [Help]

APPS.CSM_USER_EVENT_PKG dependencies on CSM_MTL_MATERIAL_TXN_ACC

Line 897: DELETE FROM csm_mtl_material_txn_acc WHERE user_id = p_user_id;

893: DELETE FROM CSM_NEW_MESSAGES_ACC WHERE user_id = p_user_id;
894: DELETE FROM CSM_STATE_TRANSITIONS_ACC WHERE user_id = p_user_id;
895: DELETE FROM csm_mtl_system_items_acc WHERE user_id = p_user_id;
896: DELETE FROM csm_mtl_serial_numbers_acc WHERE user_id = p_user_id;
897: DELETE FROM csm_mtl_material_txn_acc WHERE user_id = p_user_id;
898:
899: DELETE FROM csm_mtl_txn_lot_num_acc WHERE user_id = p_user_id;
900: DELETE FROM csm_mtl_unit_txn_acc WHERE user_id = p_user_id;
901: DELETE FROM csm_inv_loc_ass_acc WHERE user_id = p_user_id;

Line 986: CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn(p_user_id);

982: BEGIN
983: CSM_UTIL_PKG.LOG('Entering spawn_mat_txn for user_id: ' || p_user_id,
984: 'CSM_USER_EVENT_PKG.spawn_mat_txn',FND_LOG.LEVEL_PROCEDURE);
985:
986: CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn(p_user_id);
987:
988: CSM_UTIL_PKG.LOG('Leaving spawn_mat_txn for user_id: ' || p_user_id,
989: 'CSM_USER_EVENT_PKG.spawn_mat_txn',FND_LOG.LEVEL_PROCEDURE);
990: EXCEPTION