APPS.CSL_MTL_SEC_LOCATORS_ACC_PKG dependencies on CSL_MTL_SECONDARY_LOCATORS_ACC

Line 5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_MTL_SECONDARY_LOCATORS_ACC';

1: PACKAGE BODY CSL_MTL_SEC_LOCATORS_ACC_PKG AS
2: /* $Header: cslslacb.pls 120.1 2005/06/01 23:39:40 appldev $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_MTL_SECONDARY_LOCATORS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_SECONDARY_LOCATORS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_SECONDARY_LOCATORS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';

Line 23: FROM CSL_MTL_SECONDARY_LOCATORS_ACC acc

19: PROCEDURE UPDATE_ACC_REC_MARKDIRTY( p_last_run_date IN DATE )
20: IS
21: CURSOR c_changed( b_last_date DATE ) IS
22: SELECT acc.ACCESS_ID, acc.RESOURCE_ID
23: FROM CSL_MTL_SECONDARY_LOCATORS_ACC acc
24: , MTL_SECONDARY_LOCATORS b
25: , ASG_USER au
26: WHERE b.SECONDARY_LOCATOR = acc.SECONDARY_LOCATOR
27: AND b.ORGANIZATION_ID = acc.ORGANIZATION_ID

Line 114: FROM CSL_MTL_SECONDARY_LOCATORS_ACC

110: )
111: AND (I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID)
112: NOT IN
113: ( SELECT RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID
114: FROM CSL_MTL_SECONDARY_LOCATORS_ACC
115: );
116:
117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
118: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

Line 122: TYPE counter_Tab IS TABLE OF CSL_MTL_SECONDARY_LOCATORS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;

118: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
119: TYPE item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
120: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
121: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
122: TYPE counter_Tab IS TABLE OF CSL_MTL_SECONDARY_LOCATORS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;
123: locations location_Tab;
124: items item_Tab;
125: organizations org_Tab;
126: counters counter_Tab;

Line 141: UPDATE CSL_MTL_SECONDARY_LOCATORS_ACC

137: );
138: END IF;
139:
140: /*Increment count if the record already exists */
141: UPDATE CSL_MTL_SECONDARY_LOCATORS_ACC
142: SET COUNTER = COUNTER + 1
143: , LAST_UPDATE_DATE = SYSDATE
144: , LAST_UPDATED_BY = 1
145: WHERE ( RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID ) IN

Line 178: INSERT INTO CSL_MTL_SECONDARY_LOCATORS_ACC(

174: );
175: END IF;
176:
177: FORALL i IN l_tab_access_id.FIRST..l_tab_access_id.LAST
178: INSERT INTO CSL_MTL_SECONDARY_LOCATORS_ACC(
179: ACCESS_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY
180: , COUNTER, RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID ) VALUES (
181: l_tab_access_id(i), sysdate, 1, sysdate, 1, counters(i), l_tab_resource_id(i), items(i), locations(i), organizations(i));
182:

Line 305: FROM CSL_MTL_SECONDARY_LOCATORS_ACC

301: , p_resource_id IN NUMBER
302: ) IS
303: CURSOR c_sec_locator (b_inventory_item_id NUMBER, b_org_id NUMBER, b_resource_id NUMBER)
304: IS SELECT SECONDARY_LOCATOR, ACCESS_ID
305: FROM CSL_MTL_SECONDARY_LOCATORS_ACC
306: WHERE INVENTORY_ITEM_ID = b_inventory_item_id
307: AND ORGANIZATION_ID = b_org_id
308: AND RESOURCE_ID = b_resource_id;
309: r_sec_locator c_sec_locator%ROWTYPE;

Line 393: DELETE FROM CSL_MTL_SECONDARY_LOCATORS_ACC;

389:
390: l_dummy BOOLEAN;
391:
392: BEGIN
393: DELETE FROM CSL_MTL_SECONDARY_LOCATORS_ACC;
394:
395: OPEN c_inserted;
396: FETCH c_inserted BULK COLLECT
397: INTO l_tab_access_id, l_tab_resource_id, items, locations, organizations, counters;

Line 411: INSERT INTO CSL_MTL_SECONDARY_LOCATORS_ACC(

407: );
408: END IF;
409:
410: FORALL i IN l_tab_access_id.FIRST..l_tab_access_id.LAST
411: INSERT INTO CSL_MTL_SECONDARY_LOCATORS_ACC(
412: ACCESS_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY
413: , COUNTER, RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID ) VALUES (
414: l_tab_access_id(i), sysdate, 1, sysdate, 1,
415: counters(i), l_tab_resource_id(i), items(i), locations(i), organizations(i));