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_SYSTEM_ITEM_EVENT_PKG dependencies on CSM_SYSTEM_ITEMS_ACC

Line 15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC';

11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_SYSTEM_ITEMS_B';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_SYSTEM_ITEMS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';

Line 16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC_S';

12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_SYSTEM_ITEMS_B';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_SYSTEM_ITEMS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 53: l_stmt := 'UPDATE csm_system_items_acc acc';

49: l_run_date := SYSDATE;
50:
51: l_tab_access_id.DELETE;
52:
53: l_stmt := 'UPDATE csm_system_items_acc acc';
54: l_stmt := l_stmt || ' SET COUNTER = COUNTER - 1';
55: l_stmt := l_stmt || ' , LAST_UPDATE_DATE = SYSDATE';
56: l_stmt := l_stmt || ' , last_updated_by = nvl(fnd_global.user_id, 1)';
57: l_stmt := l_stmt || ' WHERE USER_ID = :1';

Line 68: FROM csm_system_items_acc acc

64: l_tab_user_id.DELETE;
65:
66: SELECT access_id, user_id
67: BULK COLLECT INTO l_tab_access_id, l_tab_user_id
68: FROM csm_system_items_acc acc
69: WHERE acc.counter = 0;
70:
71: IF l_tab_access_id.COUNT > 0 THEN
72: -- do bulk makedirty

Line 82: DELETE FROM csm_system_items_acc WHERE access_id = l_tab_access_id(i);

78: , P_TIMESTAMP => l_run_date
79: );
80:
81: FORALL i IN 1..l_tab_access_id.COUNT
82: DELETE FROM csm_system_items_acc WHERE access_id = l_tab_access_id(i);
83: END IF;
84:
85: CSM_UTIL_PKG.LOG('Leaving DELETE_SYSTEM_ITEMS ',
86: 'CSM_SYSTEM_ITEM_EVENT_PKG.DELETE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

Line 110: --SELECT /*+ index (acc CSM_SYSTEM_ITEMS_ACC_U2) acc.user_id,

106: l_sqlerrmsg varchar2(2000);
107:
108: CURSOR l_old_system_items_csr(p_old_organization_id IN number, p_user_id IN number)
109: IS
110: --SELECT /*+ index (acc CSM_SYSTEM_ITEMS_ACC_U2) acc.user_id,
111: acc.access_id
112: FROM csm_system_items_acc acc
113: WHERE acc.user_id = p_user_id
114: AND acc.organization_id = p_old_organization_id;

Line 112: FROM csm_system_items_acc acc

108: CURSOR l_old_system_items_csr(p_old_organization_id IN number, p_user_id IN number)
109: IS
110: --SELECT /*+ index (acc CSM_SYSTEM_ITEMS_ACC_U2) acc.user_id,
111: acc.access_id
112: FROM csm_system_items_acc acc
113: WHERE acc.user_id = p_user_id
114: AND acc.organization_id = p_old_organization_id;
115:
116: l_dummy BOOLEAN;

Line 168: DELETE CSM_SYSTEM_ITEMS_ACC WHERE ACCESS_ID = l_acc_id_lst(i);

164: );
165:
166: -- do a bulk delete
167: FORALL i IN l_acc_id_lst.FIRST..l_acc_id_lst.LAST
168: DELETE CSM_SYSTEM_ITEMS_ACC WHERE ACCESS_ID = l_acc_id_lst(i);
169: END IF;
170:
171: x_result := 'System Item purge complete';
172: END IF;

Line 203: --SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,

199: l_sqlerrmsg varchar2(2000);
200:
201: CURSOR l_systemitems_ins_csr(p_new_organization_id IN number, p_user_id IN number)
202: IS
203: --SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
204: au.user_id,
205: msi.inventory_item_id,
206: msi.organization_id
207: FROM asg_user au,

Line 222: FROM csm_system_items_acc acc

218: AND cbtc.billing_category IN ('L', 'E')
219: AND SYSDATE BETWEEN nvl(cbtc.start_date_active, SYSDATE) AND nvl(cbtc.end_date_active, SYSDATE)
220: AND NOT EXISTS
221: (SELECT 1
222: FROM csm_system_items_acc acc
223: WHERE acc.user_id = au.user_id
224: AND acc.inventory_item_id = msi.inventory_item_id
225: AND acc.organization_id = msi.organization_id
226: );

Line 228: TYPE inv_idTab IS TABLE OF csm_system_items_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

224: AND acc.inventory_item_id = msi.inventory_item_id
225: AND acc.organization_id = msi.organization_id
226: );
227:
228: TYPE inv_idTab IS TABLE OF csm_system_items_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
229: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
230:
231: l_inv_id inv_idTab;
232: l_org_id org_idTab;

Line 229: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;

225: AND acc.organization_id = msi.organization_id
226: );
227:
228: TYPE inv_idTab IS TABLE OF csm_system_items_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
229: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
230:
231: l_inv_id inv_idTab;
232: l_org_id org_idTab;
233: l_user_id_lst asg_download.user_list;

Line 288: INSERT INTO CSM_SYSTEM_ITEMS_ACC (ACCESS_ID, USER_ID, INVENTORY_ITEM_ID,ORGANIZATION_ID,

284: CLOSE l_systemitems_ins_csr;
285:
286: IF l_acc_id_lst.COUNT > 0 THEN
287: FORALL i IN l_acc_id_lst.FIRST..l_acc_id_lst.LAST
288: INSERT INTO CSM_SYSTEM_ITEMS_ACC (ACCESS_ID, USER_ID, INVENTORY_ITEM_ID,ORGANIZATION_ID,
289: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
290: VALUES (l_acc_id_lst(i), l_user_id_lst(i), l_inv_id(i), l_org_id(i), 1, 1, l_current_run_date,1,l_current_run_date,1);
291:
292: -- do bulk makedirty

Line 331: TYPE inv_idTab IS TABLE OF csm_system_items_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

327: l_max_last_update_date_b DATE;
328: l_max_last_update_date_tl DATE;
329: g_pub_item_name1 VARCHAR2(30) := 'CSF_M_SYSTEM_ITEMS';
330:
331: TYPE inv_idTab IS TABLE OF csm_system_items_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
332: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
333:
334: l_inv_id inv_idTab;
335: l_org_id org_idTab;

Line 332: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;

328: l_max_last_update_date_tl DATE;
329: g_pub_item_name1 VARCHAR2(30) := 'CSF_M_SYSTEM_ITEMS';
330:
331: TYPE inv_idTab IS TABLE OF csm_system_items_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
332: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
333:
334: l_inv_id inv_idTab;
335: l_org_id org_idTab;
336: l_user_id asg_download.user_list;

Line 359: SELECT /+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) / CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,

355:
356: -- insert
357: CURSOR l_systemitems_ins_csr
358: IS
359: SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) */ CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
360: au.user_id,
361: msi.inventory_item_id,
362: msi.organization_id
363: FROM asg_user au,

Line 380: FROM csm_system_items_acc acc

376: AND cbtc.billing_category IN ('L', 'E')
377: AND SYSDATE BETWEEN nvl(cbtc.start_date_active, SYSDATE) AND nvl(cbtc.end_date_active, SYSDATE)
378: AND NOT EXISTS
379: (SELECT 1
380: FROM csm_system_items_acc acc
381: WHERE acc.user_id = au.user_id
382: AND acc.inventory_item_id = msi.inventory_item_id
383: AND acc.organization_id = msi.organization_id
384: );

Line 389: SELECT /+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi MTL_SYSTEM_ITEMS_B_U1) / acc.access_id,

385:
386: -- update
387: CURSOR l_systemitems_upd_b_csr(p_last_run_date DATE)
388: IS
389: SELECT /*+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi MTL_SYSTEM_ITEMS_B_U1) */ acc.access_id,
390: acc.user_id,
391: msi.inventory_item_id,
392: msi.organization_id
393: FROM csm_system_items_acc acc,

Line 393: FROM csm_system_items_acc acc,

389: SELECT /*+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi MTL_SYSTEM_ITEMS_B_U1) */ acc.access_id,
390: acc.user_id,
391: msi.inventory_item_id,
392: msi.organization_id
393: FROM csm_system_items_acc acc,
394: mtl_system_items_b msi
395: WHERE acc.inventory_item_id = msi.inventory_item_id
396: AND acc.organization_id = msi.organization_id
397: AND msi.last_update_date >= p_last_run_date

Line 402: SELECT /+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi_tl MTL_SYSTEM_ITEMS_TL_U1) / acc.access_id,

398: ;
399:
400: CURSOR l_systemitems_upd_tl_csr(p_last_run_date DATE)
401: IS
402: SELECT /*+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi_tl MTL_SYSTEM_ITEMS_TL_U1) */ acc.access_id,
403: acc.user_id,
404: msi_tl.inventory_item_id,
405: msi_tl.organization_id
406: FROM csm_system_items_acc acc,

Line 406: FROM csm_system_items_acc acc,

402: SELECT /*+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi_tl MTL_SYSTEM_ITEMS_TL_U1) */ acc.access_id,
403: acc.user_id,
404: msi_tl.inventory_item_id,
405: msi_tl.organization_id
406: FROM csm_system_items_acc acc,
407: asg_user au,
408: mtl_system_items_tl msi_tl
409: WHERE acc.user_id = au.user_id
410: AND acc.inventory_item_id = msi_tl.inventory_item_id

Line 418: SELECT /+ index (acc csm_system_items_acc_u1)/ acc.access_id,

414:
415: -- delete
416: CURSOR l_systemitems_del_csr
417: IS
418: SELECT /*+ index (acc csm_system_items_acc_u1)*/ acc.access_id,
419: acc.user_id,
420: acc.inventory_item_id,
421: acc.organization_id
422: FROM csm_system_items_acc acc

Line 422: FROM csm_system_items_acc acc

418: SELECT /*+ index (acc csm_system_items_acc_u1)*/ acc.access_id,
419: acc.user_id,
420: acc.inventory_item_id,
421: acc.organization_id
422: FROM csm_system_items_acc acc
423: WHERE NOT EXISTS
424: (SELECT 1
425: FROM mtl_system_items_b msi,
426: CS_BILLING_TYPE_CATEGORIES cbtc

Line 477: DELETE CSM_SYSTEM_ITEMS_ACC WHERE ACCESS_ID = l_acc_id(i);

473: );
474:
475: -- do a bulk delete
476: FORALL i IN l_acc_id.FIRST..l_acc_id.LAST
477: DELETE CSM_SYSTEM_ITEMS_ACC WHERE ACCESS_ID = l_acc_id(i);
478: END IF;
479: END LOOP;
480: CLOSE l_systemitems_del_csr;
481:

Line 577: INSERT INTO CSM_SYSTEM_ITEMS_ACC (ACCESS_ID, USER_ID, INVENTORY_ITEM_ID,ORGANIZATION_ID,

573: EXIT WHEN l_acc_id.COUNT = 0;
574:
575: IF l_acc_id.COUNT > 0 THEN
576: FORALL i IN l_acc_id.FIRST..l_acc_id.LAST
577: INSERT INTO CSM_SYSTEM_ITEMS_ACC (ACCESS_ID, USER_ID, INVENTORY_ITEM_ID,ORGANIZATION_ID,
578: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
579: VALUES (l_acc_id(i), l_user_id(i), l_inv_id(i), l_org_id(i), 1, 1, l_current_run_date,1,l_current_run_date,1);
580:
581: -- do bulk makedirty

Line 1007: SELECT /+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) / CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,

1003: l_sqlerrmsg varchar2(2000);
1004:
1005: CURSOR l_systemitems_ins_csr(p_organization_id IN NUMBER, p_user_id IN NUMBER)
1006: IS
1007: SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) */ CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
1008: au.user_id,
1009: msi.inventory_item_id,
1010: msi.organization_id
1011: FROM asg_user au,

Line 1026: FROM csm_system_items_acc acc

1022: AND cbtc.billing_category IN ('L', 'E')
1023: AND SYSDATE BETWEEN nvl(cbtc.start_date_active, SYSDATE) AND nvl(cbtc.end_date_active, SYSDATE)
1024: AND NOT EXISTS
1025: (SELECT 1
1026: FROM csm_system_items_acc acc
1027: WHERE acc.user_id = au.user_id
1028: AND acc.inventory_item_id = msi.inventory_item_id
1029: AND acc.organization_id = msi.organization_id
1030: );

Line 1032: TYPE inv_idTab IS TABLE OF csm_system_items_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

1028: AND acc.inventory_item_id = msi.inventory_item_id
1029: AND acc.organization_id = msi.organization_id
1030: );
1031:
1032: TYPE inv_idTab IS TABLE OF csm_system_items_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1033: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
1034:
1035: l_inv_id inv_idTab;
1036: l_org_id org_idTab;

Line 1033: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;

1029: AND acc.organization_id = msi.organization_id
1030: );
1031:
1032: TYPE inv_idTab IS TABLE OF csm_system_items_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1033: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
1034:
1035: l_inv_id inv_idTab;
1036: l_org_id org_idTab;
1037: l_user_id_lst asg_download.user_list;

Line 1064: INSERT INTO CSM_SYSTEM_ITEMS_ACC (ACCESS_ID, USER_ID, INVENTORY_ITEM_ID,ORGANIZATION_ID,

1060: EXIT WHEN l_acc_id_lst.COUNT = 0;
1061:
1062: IF l_acc_id_lst.COUNT > 0 THEN
1063: FORALL i IN l_acc_id_lst.FIRST..l_acc_id_lst.LAST
1064: INSERT INTO CSM_SYSTEM_ITEMS_ACC (ACCESS_ID, USER_ID, INVENTORY_ITEM_ID,ORGANIZATION_ID,
1065: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
1066: VALUES (l_acc_id_lst(i), l_user_id_lst(i), l_inv_id(i), l_org_id(i), 1, 1, l_current_run_date,1,l_current_run_date,1);
1067:
1068: -- do bulk makedirty

Line 1105: -- insert into csm_system_items_acc

1101: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,
1102: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
1103:
1104: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1105: -- insert into csm_system_items_acc
1106: CSM_ACC_PKG.Insert_Acc
1107: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1108: ,P_ACC_TABLE_NAME => g_acc_table_name1
1109: ,P_SEQ_NAME => g_acc_sequence_name1

Line 1144: -- delete from csm_system_items_acc

1140: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,
1141: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
1142:
1143: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1144: -- delete from csm_system_items_acc
1145: CSM_ACC_PKG.Delete_Acc
1146: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1147: ,P_ACC_TABLE_NAME => g_acc_table_name1
1148: ,P_PK1_NAME => g_pk1_name1