APPS.CSL_MTL_ITEM_LOCATIONS_ACC_PKG dependencies on CSL_ACC_SEQUENCE

Line 106: SELECT CSL_ACC_SEQUENCE.NEXTVAL, SEC.RESOURCE_ID, LOC.INVENTORY_LOCATION_ID, LOC.ORGANIZATION_ID, SEC.COUNTER

102: */
103: PROCEDURE INSERT_ACC_REC_MARKDIRTY( p_last_run_date IN DATE )
104: IS
105: CURSOR c_inserted( b_last_date DATE ) IS
106: SELECT CSL_ACC_SEQUENCE.NEXTVAL, SEC.RESOURCE_ID, LOC.INVENTORY_LOCATION_ID, LOC.ORGANIZATION_ID, SEC.COUNTER
107: FROM JTM_MTL_SEC_INV_ACC SEC, MTL_ITEM_LOCATIONS LOC
108: WHERE SEC.SECONDARY_INVENTORY_NAME = LOC.SUBINVENTORY_CODE
109: AND SEC.ORGANIZATION_ID = LOC.ORGANIZATION_ID
110: AND LOC.CREATION_DATE >= NVL(b_last_date, LOC.CREATION_DATE)

Line 127: -- CSL.CSL_ACC_SEQUENCE

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

Line 436: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, A.RESOURCE_ID, L.INVENTORY_LOCATION_ID, L.ORGANIZATION_ID, A.COUNTER

432: PROCEDURE POPULATE_ITEM_LOCATIONS_ACC
433: IS
434: PRAGMA AUTONOMOUS_TRANSACTION;
435: CURSOR c_inserted
436: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, A.RESOURCE_ID, L.INVENTORY_LOCATION_ID, L.ORGANIZATION_ID, A.COUNTER
437: FROM MTL_ITEM_LOCATIONS L, JTM_MTL_SEC_INV_ACC A
438: WHERE L.SUBINVENTORY_CODE = A.SECONDARY_INVENTORY_NAME
439: AND L.ORGANIZATION_ID = A.ORGANIZATION_ID;
440: