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.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on CSM_MTL_SYSTEM_ITEMS_ACC

Line 17: g_mtl_sys_items_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_SYSTEM_ITEMS_ACC';

13:
14: g_pub_item varchar2(30) := 'CSM_MTL_SYSTEM_ITEMS';
15:
16: /*** Globals ***/
17: g_mtl_sys_items_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_SYSTEM_ITEMS_ACC';
18: g_mtl_sys_items_table_name CONSTANT VARCHAR2(30) := 'CS_MTL_SYSTEM_ITEMS';
19: g_mtl_sys_items_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_SYSTEM_ITEMS_ACC_S' ;
20: g_mtl_sys_items_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
21: g_mtl_sys_items_pk2_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 19: g_mtl_sys_items_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_SYSTEM_ITEMS_ACC_S' ;

15:
16: /*** Globals ***/
17: g_mtl_sys_items_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_SYSTEM_ITEMS_ACC';
18: g_mtl_sys_items_table_name CONSTANT VARCHAR2(30) := 'CS_MTL_SYSTEM_ITEMS';
19: g_mtl_sys_items_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_SYSTEM_ITEMS_ACC_S' ;
20: g_mtl_sys_items_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
21: g_mtl_sys_items_pk2_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
22: g_mtl_sys_items_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
23: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SYSTEM_ITEMS');

Line 54: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id

50: -- Both category and cat set are null
51: CURSOR c_items (b_user_id NUMBER, b_organization_id NUMBER,
52: b_changed VARCHAR2, b_last_run_date DATE)
53: IS
54: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
55: FROM MTL_SYSTEM_ITEMS_B msi
56: WHERE msi.organization_id = b_organization_id
57: AND (b_changed = 'Y'
58: OR msi.creation_date >= NVL(b_last_run_date, msi.creation_date))

Line 61: FROM csm_mtl_system_items_acc acc

57: AND (b_changed = 'Y'
58: OR msi.creation_date >= NVL(b_last_run_date, msi.creation_date))
59: AND NOT EXISTS
60: ( SELECT 1
61: FROM csm_mtl_system_items_acc acc
62: WHERE user_id = b_user_id
63: AND acc.inventory_item_id = msi.inventory_item_id
64: AND acc.organization_id = msi.organization_id);
65:

Line 70: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id

66: -- Category is not null and Cat set is null
67: CURSOR c_items_Cat (b_user_id NUMBER, b_organization_id NUMBER,
68: b_changed VARCHAR2, b_last_run_date DATE, b_category_id NUMBER)
69: IS
70: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
71: FROM mtl_system_items_b msi
72: WHERE NOT EXISTS
73: (SELECT 1
74: FROM csm_mtl_system_items_acc acc

Line 74: FROM csm_mtl_system_items_acc acc

70: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
71: FROM mtl_system_items_b msi
72: WHERE NOT EXISTS
73: (SELECT 1
74: FROM csm_mtl_system_items_acc acc
75: WHERE user_id = b_user_id
76: AND acc.inventory_item_id = msi.inventory_item_id
77: AND acc.organization_id = msi.organization_id
78: )

Line 94: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id

90: -- Category is null and Cat Set is not null
91: CURSOR c_items_Cat_Set (b_user_id NUMBER, b_organization_id NUMBER,
92: b_changed VARCHAR2, b_last_run_date DATE, b_category_set_id NUMBER)
93: IS
94: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
95: FROM mtl_system_items_b msi
96: WHERE NOT EXISTS
97: (SELECT 1
98: FROM csm_mtl_system_items_acc acc

Line 98: FROM csm_mtl_system_items_acc acc

94: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
95: FROM mtl_system_items_b msi
96: WHERE NOT EXISTS
97: (SELECT 1
98: FROM csm_mtl_system_items_acc acc
99: WHERE user_id = b_user_id
100: AND acc.inventory_item_id = msi.inventory_item_id
101: AND acc.organization_id = msi.organization_id
102: )

Line 118: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id

114: -- Both Category and Category set are not null
115: CURSOR c_items_Cat_Set_Cat (b_user_id NUMBER, b_organization_id NUMBER,
116: b_changed VARCHAR2, b_last_run_date DATE, b_category_id NUMBER, b_category_set_id NUMBER)
117: IS
118: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
119: FROM mtl_system_items_b msi
120: WHERE NOT EXISTS
121: (SELECT 1
122: FROM csm_mtl_system_items_acc acc

Line 122: FROM csm_mtl_system_items_acc acc

118: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
119: FROM mtl_system_items_b msi
120: WHERE NOT EXISTS
121: (SELECT 1
122: FROM csm_mtl_system_items_acc acc
123: WHERE user_id = b_user_id
124: AND acc.inventory_item_id = msi.inventory_item_id
125: AND acc.organization_id = msi.organization_id
126: )

Line 150: l_stmt := 'UPDATE csm_mtl_system_items_acc';

146: -- acc due to current SR's and increment counter
147: IF p_changed = 'Y' THEN
148:
149: -- changed to dynamic sql to support either category or category set
150: l_stmt := 'UPDATE csm_mtl_system_items_acc';
151: l_stmt := l_stmt || ' SET counter = counter + 1';
152: l_stmt := l_stmt || ' , last_update_date = SYSDATE';
153: l_stmt := l_stmt || ' , last_updated_by = 1';
154: l_stmt := l_stmt || ' WHERE user_id = :1';

Line 188: l_stmt := 'UPDATE csm_mtl_system_items_acc acc';

184:
185: ELSE -- if p_changed = 'N', delete items that are no longer assigned to the category/category set
186: -- changed to dynamic sql to support either category or category set
187: l_stmt := NULL;
188: l_stmt := 'UPDATE csm_mtl_system_items_acc acc';
189: l_stmt := l_stmt || ' SET counter = counter - 1';
190: l_stmt := l_stmt || ' , last_update_date = SYSDATE';
191: l_stmt := l_stmt || ' , last_updated_by = 1';
192: l_stmt := l_stmt || ' WHERE user_id = :1';

Line 231: FROM csm_mtl_system_items_acc acc

227: l_tab_user_id.DELETE;
228:
229: SELECT access_id, user_id
230: BULK COLLECT INTO l_tab_access_id, l_tab_user_id
231: FROM csm_mtl_system_items_acc acc
232: WHERE acc.counter = 0;
233:
234: IF l_tab_access_id.COUNT > 0 THEN
235: -- do bulk makedirty

Line 245: DELETE FROM csm_mtl_system_items_acc WHERE access_id = l_tab_access_id(i);

241: , P_TIMESTAMP => l_run_date
242: );
243:
244: FORALL i IN 1..l_tab_access_id.COUNT
245: DELETE FROM csm_mtl_system_items_acc WHERE access_id = l_tab_access_id(i);
246: END IF;
247: ELSE
248: -- do not decrement as category/category set profile is not changed
249: l_stmt := NULL;

Line 269: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,

265: EXIT WHEN l_tab_access_id.COUNT = 0;
266:
267: IF l_tab_access_id.COUNT > 0 THEN
268: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
269: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
270: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
271:
272: FORALL i IN 1..l_tab_access_id.COUNT
273: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,

Line 273: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,

269: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
270: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
271:
272: FORALL i IN 1..l_tab_access_id.COUNT
273: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
274: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
275: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
276: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
277:

Line 310: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,

306: EXIT WHEN l_tab_access_id.COUNT = 0;
307:
308: IF l_tab_access_id.COUNT > 0 THEN
309: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
310: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
311: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
312:
313: FORALL i IN 1..l_tab_access_id.COUNT
314: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,

Line 314: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,

310: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
311: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
312:
313: FORALL i IN 1..l_tab_access_id.COUNT
314: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
315: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
316: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
317: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
318:

Line 351: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,

347: EXIT WHEN l_tab_access_id.COUNT = 0;
348:
349: IF l_tab_access_id.COUNT > 0 THEN
350: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
351: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
352: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
353:
354: FORALL i IN 1..l_tab_access_id.COUNT
355: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,

Line 355: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,

351: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
352: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
353:
354: FORALL i IN 1..l_tab_access_id.COUNT
355: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
356: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
357: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
358: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
359:

Line 392: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,

388: EXIT WHEN l_tab_access_id.COUNT = 0;
389:
390: IF l_tab_access_id.COUNT > 0 THEN
391: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
392: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
393: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
394:
395: FORALL i IN 1..l_tab_access_id.COUNT
396: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,

Line 396: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,

392: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
393: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
394:
395: FORALL i IN 1..l_tab_access_id.COUNT
396: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
397: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
398: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
399: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
400:

Line 445: SELECT /+ INDEX (acc CSM_MTL_SYSTEM_ITEMS_ACC_U1) INDEX(msi MTL_SYSTEM_ITEMS_B_U1) /

441: l_max_last_update_date_tl DATE;
442:
443: CURSOR c_changed( b_last_date DATE)
444: IS
445: SELECT /*+ INDEX (acc CSM_MTL_SYSTEM_ITEMS_ACC_U1) INDEX(msi MTL_SYSTEM_ITEMS_B_U1) */
446: acc.access_id, acc.user_id
447: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi
448: WHERE msi.inventory_item_id = acc.inventory_item_id
449: AND msi.organization_id = acc.organization_id

Line 447: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi

443: CURSOR c_changed( b_last_date DATE)
444: IS
445: SELECT /*+ INDEX (acc CSM_MTL_SYSTEM_ITEMS_ACC_U1) INDEX(msi MTL_SYSTEM_ITEMS_B_U1) */
446: acc.access_id, acc.user_id
447: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi
448: WHERE msi.inventory_item_id = acc.inventory_item_id
449: AND msi.organization_id = acc.organization_id
450: AND (msi.last_update_date >= b_last_date);
451:

Line 532: l_stmt := 'UPDATE csm_mtl_system_items_acc acc';

528: l_run_date := SYSDATE;
529:
530: l_tab_access_id.DELETE;
531:
532: l_stmt := 'UPDATE csm_mtl_system_items_acc acc';
533: l_stmt := l_stmt || ' SET COUNTER = COUNTER - 1';
534: l_stmt := l_stmt || ' , LAST_UPDATE_DATE = SYSDATE';
535: l_stmt := l_stmt || ' , last_updated_by = nvl(fnd_global.user_id, 1)';
536: l_stmt := l_stmt || ' WHERE USER_ID = :1';

Line 573: FROM csm_mtl_system_items_acc acc

569: l_tab_user_id.DELETE;
570:
571: SELECT access_id, user_id
572: BULK COLLECT INTO l_tab_access_id, l_tab_user_id
573: FROM csm_mtl_system_items_acc acc
574: WHERE acc.counter = 0;
575:
576: IF l_tab_access_id.COUNT > 0 THEN
577: -- do bulk makedirty

Line 587: DELETE FROM csm_mtl_system_items_acc WHERE access_id = l_tab_access_id(i);

583: , P_TIMESTAMP => l_run_date
584: );
585:
586: FORALL i IN 1..l_tab_access_id.COUNT
587: DELETE FROM csm_mtl_system_items_acc WHERE access_id = l_tab_access_id(i);
588: END IF;
589:
590: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS ',
591: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);