APPS.CSL_MTL_SEC_LOCATORS_ACC_PKG dependencies on CSL_ACC_SEQUENCE

Line 98: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID, I.COUNTER

94: */
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

Line 129: -- CSL.CSL_ACC_SEQUENCE

125: organizations org_Tab;
126: counters counter_Tab;
127:
128: l_dummy BOOLEAN;
129: -- CSL.CSL_ACC_SEQUENCE
130: BEGIN
131: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
132: jtm_message_log_pkg.Log_Msg
133: ( 0

Line 370: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID, I.COUNTER

366: */
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