APPS.CSM_USER_EVENT_PKG dependencies on CSM_USER_INVENTORY_ORG

Line 412: DELETE FROM csm_user_inventory_org WHERE user_id = p_user_id;

408: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);
409: l_category_set_id := csm_profile_pkg.get_category_set_id(p_user_id);
410: l_category_id := csm_profile_pkg.get_category_id(p_user_id);
411:
412: DELETE FROM csm_user_inventory_org WHERE user_id = p_user_id;
413:
414: INSERT INTO csm_user_inventory_org (
415: user_id, organization_id, last_update_date, last_updated_by,
416: creation_date, created_by, category_set_id, category_id )

Line 414: INSERT INTO csm_user_inventory_org (

410: l_category_id := csm_profile_pkg.get_category_id(p_user_id);
411:
412: DELETE FROM csm_user_inventory_org WHERE user_id = p_user_id;
413:
414: INSERT INTO csm_user_inventory_org (
415: user_id, organization_id, last_update_date, last_updated_by,
416: creation_date, created_by, category_set_id, category_id )
417: VALUES (
418: p_user_id, l_organization_id, SYSDATE, 1, SYSDATE, 1,

Line 925: DELETE FROM csm_user_inventory_org WHERE user_id = p_user_id;

921: DELETE FROM csm_mtl_item_locations_acc WHERE user_id = p_user_id;
922: DELETE FROM csm_mtl_secondary_locators_acc WHERE user_id = p_user_id;
923: DELETE FROM csm_mtl_onhand_qty_acc WHERE user_id = p_user_id;
924:
925: DELETE FROM csm_user_inventory_org WHERE user_id = p_user_id;
926: DELETE FROM CSM_FND_LOBS_ACC WHERE user_id = p_user_id;--Bug 4938130
927: DELETE FROM CSM_HZ_CUST_ACCOUNTS_ACC WHERE user_id = p_user_id;--Bug 5213097
928: DELETE FROM CSM_SR_TYPE_MAPPING_ACC WHERE user_id = p_user_id;--Bug 5213097
929: DELETE FROM CSM_CSI_ITEM_ATTR_ACC WHERE user_id = p_user_id;--Bug 5213097