APPS.CSL_MTL_SEC_LOCATORS_ACC_PKG dependencies on CSL_MTL_ITEM_LOCATIONS_ACC

Line 99: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,

95: PROCEDURE INSERT_ACC_REC_MARKDIRTY( p_last_run_date IN DATE )
96: IS
97: CURSOR c_inserted( b_last_date DATE )
98: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID, I.COUNTER
99: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,
100: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U
101: WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
102: AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
103: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID

Line 147: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,

143: , LAST_UPDATE_DATE = SYSDATE
144: , LAST_UPDATED_BY = 1
145: WHERE ( RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID ) IN
146: ( SELECT I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID
147: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,
148: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U
149: WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
150: AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
151: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID

Line 225: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A

221: )
222: IS
223: CURSOR c_sec_locator ( b_inventory_item_id NUMBER, b_org_id NUMBER, b_resource_id NUMBER)
224: IS SELECT S.SECONDARY_LOCATOR
225: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A
226: WHERE S.INVENTORY_ITEM_ID = b_inventory_item_id
227: AND S.ORGANIZATION_ID = b_org_id
228: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID
229: AND S.ORGANIZATION_ID = A.ORGANIZATION_ID

Line 254: /* comment this out, assuming that CSL_MTL_ITEM_LOCATIONS_ACC records already exist

250: || p_resource_id
251: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
252: END IF;
253:
254: /* comment this out, assuming that CSL_MTL_ITEM_LOCATIONS_ACC records already exist
255: CSL_MTL_ITEM_LOCATIONS_ACC_PKG.Insert_Item_Location
256: ( p_inventory_location_id => r_sec_locator.SECONDARY_LOCATOR
257: ,p_organization_id => p_organization_id
258: ,p_resource_id => p_resource_id

Line 255: CSL_MTL_ITEM_LOCATIONS_ACC_PKG.Insert_Item_Location

251: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
252: END IF;
253:
254: /* comment this out, assuming that CSL_MTL_ITEM_LOCATIONS_ACC records already exist
255: CSL_MTL_ITEM_LOCATIONS_ACC_PKG.Insert_Item_Location
256: ( p_inventory_location_id => r_sec_locator.SECONDARY_LOCATOR
257: ,p_organization_id => p_organization_id
258: ,p_resource_id => p_resource_id
259: );

Line 333: CSL_MTL_ITEM_LOCATIONS_ACC_PKG.Delete_Item_Location

329: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
330: END IF;
331:
332: /*
333: CSL_MTL_ITEM_LOCATIONS_ACC_PKG.Delete_Item_Location
334: ( p_inventory_location_id => r_sec_locator.SECONDARY_LOCATOR
335: ,p_organization_id => p_organization_id
336: ,p_resource_id => p_resource_id
337: );

Line 371: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,

367: PROCEDURE POPULATE_SEC_LOCATORS_ACC IS
368: PRAGMA AUTONOMOUS_TRANSACTION;
369: CURSOR c_inserted
370: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID, I.COUNTER
371: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,
372: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U
373: WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
374: AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
375: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID