eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_MTL_SEC_LOCATORS_ACC_PKG dependencies on MTL_SECONDARY_LOCATORS

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 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_SECONDARY_LOCATORS');

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';
10: g_pk2_name CONSTANT VARCHAR2(30) := 'SECONDARY_LOCATOR';
11: g_pk3_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_SECONDARY_LOCATORS';

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';
10: g_pk2_name CONSTANT VARCHAR2(30) := 'SECONDARY_LOCATOR';
11: g_pk3_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
12: g_debug_level NUMBER; -- debug level

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 24: , MTL_SECONDARY_LOCATORS b

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
28: AND b.INVENTORY_ITEM_ID = acc.INVENTORY_ITEM_ID

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 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 119: TYPE item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

115: );
116:
117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
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;

Line 120: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;

116:
117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
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;

Line 121: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
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;

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 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 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 214: This procedure will trigger the insert of the corresponding MTL_SECONDARY_LOCATORS record as well.

210: RAISE;
211: END INSERT_ACC_REC_MARKDIRTY;
212:
213: /*
214: This procedure will trigger the insert of the corresponding MTL_SECONDARY_LOCATORS record as well.
215: This will be called from CSL_MTL_SYSTEM_ITEMS_ACC_PKG insertion procedures except in the CON_REQUEST_SYSTEM_ITEMS calls.
216: */
217: PROCEDURE Insert_Secondary_Locators
218: ( p_inventory_item_id IN NUMBER

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 295: This procedure will trigger the delete of the corresponding MTL_SECONDARY_LOCATORS record as well.

291: NULL;
292: END Update_Secondary_Locators;
293:
294: /*
295: This procedure will trigger the delete of the corresponding MTL_SECONDARY_LOCATORS record as well.
296: This will be called from CSL_MTL_SYSTEM_ITEMS_ACC_PKG deletion procedures except in the CON_REQUEST_SYSTEM_ITEMS calls.
297: */
298: PROCEDURE Delete_Secondary_Locators
299: ( p_inventory_item_id IN NUMBER

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 363: This procedure is used to populate the MTL_SECONDARY_LOCATORS records upon patching

359: END IF;
360: END Delete_Secondary_Locators;
361:
362: /*
363: This procedure is used to populate the MTL_SECONDARY_LOCATORS records upon patching
364: (upgrading with JTM_MTL_SYSTEM_ITEMS_ACC already filled).
365: It's also called from CSL_MTL_SYSTEM_ITEMS_ACC_PKG.INSERT_ALL_ACC_RECORDS
366: */
367: PROCEDURE POPULATE_SEC_LOCATORS_ACC IS

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

Line 381: TYPE inventory_item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

377: AND A.RESOURCE_ID = I.RESOURCE_ID
378: AND A.RESOURCE_ID = U.RESOURCE_ID;
379: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
380: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
381: TYPE inventory_item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
382: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
383: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
384: TYPE counter_Tab IS TABLE OF JTM_MTL_SYSTEM_ITEMS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;
385: items inventory_item_Tab;

Line 382: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;

378: AND A.RESOURCE_ID = U.RESOURCE_ID;
379: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
380: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
381: TYPE inventory_item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
382: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
383: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
384: TYPE counter_Tab IS TABLE OF JTM_MTL_SYSTEM_ITEMS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;
385: items inventory_item_Tab;
386: locations location_Tab;

Line 383: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

379: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
380: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
381: TYPE inventory_item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
382: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
383: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
384: TYPE counter_Tab IS TABLE OF JTM_MTL_SYSTEM_ITEMS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;
385: items inventory_item_Tab;
386: locations location_Tab;
387: organizations org_Tab;

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));

Line 450: MTL_SECONDARY_LOCATORS table.

446: END POPULATE_SEC_LOCATORS_ACC;
447:
448: /*
449: Concurrent program run to periodically pick up the changes on
450: MTL_SECONDARY_LOCATORS table.
451: */
452: PROCEDURE CON_REQUEST_SECONDARY_LOCATORS
453: IS
454: PRAGMA AUTONOMOUS_TRANSACTION;