DBA Data[Home] [Help]

APPS.CSM_USER_EVENT_PKG dependencies on CSM_MTL_MATERIAL_TXN_ACC

Line 857: DELETE FROM csm_mtl_material_txn_acc WHERE user_id = p_user_id;

853: DELETE FROM CSM_NEW_MESSAGES_ACC WHERE user_id = p_user_id;
854: DELETE FROM CSM_STATE_TRANSITIONS_ACC WHERE user_id = p_user_id;
855: DELETE FROM csm_mtl_system_items_acc WHERE user_id = p_user_id;
856: DELETE FROM csm_mtl_serial_numbers_acc WHERE user_id = p_user_id;
857: DELETE FROM csm_mtl_material_txn_acc WHERE user_id = p_user_id;
858:
859: DELETE FROM csm_mtl_txn_lot_num_acc WHERE user_id = p_user_id;
860: DELETE FROM csm_mtl_unit_txn_acc WHERE user_id = p_user_id;
861: DELETE FROM csm_inv_loc_ass_acc WHERE user_id = p_user_id;

Line 929: CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn(p_user_id);

925: BEGIN
926: CSM_UTIL_PKG.LOG('Entering spawn_mat_txn for user_id: ' || p_user_id,
927: 'CSM_USER_EVENT_PKG.spawn_mat_txn',FND_LOG.LEVEL_PROCEDURE);
928:
929: CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn(p_user_id);
930:
931: CSM_UTIL_PKG.LOG('Leaving spawn_mat_txn for user_id: ' || p_user_id,
932: 'CSM_USER_EVENT_PKG.spawn_mat_txn',FND_LOG.LEVEL_PROCEDURE);
933: EXCEPTION