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_PARAMETERS_EVENT_PKG dependencies on CSM_INTERORG_PARAMETERS_ACC

Line 23: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_INTERORG_PARAMETERS_ACC';

19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS';
21:
22: g_table_name2 CONSTANT VARCHAR2(30) := 'MTL_INTERORG_PARAMETERS';
23: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_INTERORG_PARAMETERS_ACC';
24: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
25: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_INTERORG_PARAMS');
26: g_pk1_name2 CONSTANT VARCHAR2(30) := 'FROM_ORGANIZATION_ID';
27: g_pk2_name2 CONSTANT VARCHAR2(30) := 'TO_ORGANIZATION_ID';

Line 246: AND NOT EXISTS (SELECT 1 FROM CSM_INTERORG_PARAMETERS_ACC acc

242: FROM ( SELECT distinct mtsn.from_organization_id,mtsn.to_organization_id
243: FROM MTL_INTERORG_PARAMETERS mtsn,csp_inv_loc_assignments inv
244: WHERE b_res_id =inv.resource_id
245: AND inv.organization_id in (mtsn.from_organization_id,mtsn.to_organization_id)
246: AND NOT EXISTS (SELECT 1 FROM CSM_INTERORG_PARAMETERS_ACC acc
247: WHERE acc.from_organization_id = mtsn.from_organization_id
248: AND acc.to_organization_id = mtsn.to_organization_id
249: AND acc.user_id=b_user_id ));
250:

Line 255: FROM CSM_INTERORG_PARAMETERS_ACC acc,MTL_INTERORG_PARAMETERS mtsn

251: -- updates cur
252: CURSOR c_mtl_parameters_upd_csr(p_lrd date)
253: IS
254: SELECT acc.access_id,acc.user_id
255: FROM CSM_INTERORG_PARAMETERS_ACC acc,MTL_INTERORG_PARAMETERS mtsn
256: WHERE acc.from_organization_id = mtsn.from_organization_id
257: AND acc.to_organization_id = mtsn.to_organization_id
258: AND p_lrd < mtsn.last_update_date ;
259:

Line 264: FROM CSM_INTERORG_PARAMETERS_ACC acc

260: -- deletes cur
261: CURSOR c_mtl_parameters_del_csr
262: IS
263: SELECT acc.access_id,acc.user_id
264: FROM CSM_INTERORG_PARAMETERS_ACC acc
265: WHERE NOT EXISTS
266: (SELECT 1 FROM MTL_INTERORG_PARAMETERS mtsn
267: WHERE mtsn.from_organization_id = acc.from_organization_id
268: AND mtsn.to_organization_id = acc.to_organization_id

Line 271: SELECT acc.access_id,acc.user_id FROM CSM_INTERORG_PARAMETERS_ACC acc

267: WHERE mtsn.from_organization_id = acc.from_organization_id
268: AND mtsn.to_organization_id = acc.to_organization_id
269: )
270: UNION
271: SELECT acc.access_id,acc.user_id FROM CSM_INTERORG_PARAMETERS_ACC acc
272: WHERE NOT EXISTS
273: (SELECT 1 FROM csp_inv_loc_assignments inv,asg_user au
274: WHERE au.resource_id =inv.resource_id AND au.user_id=acc.user_id AND inv.organization_id in (acc.from_organization_id,acc.to_organization_id));
275:

Line 297: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_INTERORG_PARAMETERS_ACC' ,

293:
294: FETCH c_mtl_parameters_del_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
295: EXIT WHEN l_tab_access_id.COUNT = 0;
296:
297: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_INTERORG_PARAMETERS_ACC' ,
298: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);
299:
300: l_markdirty := asg_download.mark_dirty(
301: P_PUB_ITEM => 'CSM_MTL_INTERORG_PARAMS'

Line 309: DELETE FROM CSM_INTERORG_PARAMETERS_ACC WHERE access_id = l_tab_access_id(i);

305: , P_TIMESTAMP => sysdate
306: );
307:
308: FORALL i IN 1..l_tab_access_id.COUNT
309: DELETE FROM CSM_INTERORG_PARAMETERS_ACC WHERE access_id = l_tab_access_id(i);
310:
311: COMMIT;
312: END LOOP;
313: CLOSE c_mtl_parameters_del_csr;

Line 327: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in CSM_INTERORG_PARAMETERS_ACC' ,

323:
324: FETCH c_mtl_parameters_upd_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
325: EXIT WHEN l_tab_access_id.COUNT = 0;
326:
327: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in CSM_INTERORG_PARAMETERS_ACC' ,
328: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);
329:
330: l_markdirty := asg_download.mark_dirty(
331: P_PUB_ITEM => 'CSM_MTL_INTERORG_PARAMS'

Line 357: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into CSM_INTERORG_PARAMETERS_ACC for user:'||rec.USER_ID ,

353:
354: FETCH c_mtl_parameters_ins_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id,l_tab_from_org,l_tab_to_org LIMIT 1000;
355: EXIT WHEN l_tab_access_id.COUNT = 0;
356:
357: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into CSM_INTERORG_PARAMETERS_ACC for user:'||rec.USER_ID ,
358: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);
359:
360: FORALL i IN 1..l_tab_access_id.COUNT
361: INSERT INTO CSM_INTERORG_PARAMETERS_ACC (access_id, user_id,from_organization_id, to_organization_id,

Line 361: INSERT INTO CSM_INTERORG_PARAMETERS_ACC (access_id, user_id,from_organization_id, to_organization_id,

357: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into CSM_INTERORG_PARAMETERS_ACC for user:'||rec.USER_ID ,
358: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);
359:
360: FORALL i IN 1..l_tab_access_id.COUNT
361: INSERT INTO CSM_INTERORG_PARAMETERS_ACC (access_id, user_id,from_organization_id, to_organization_id,
362: counter, created_by, creation_date, last_updated_by, last_update_date )
363: VALUES (l_tab_access_id(i), l_tab_user_id(i),l_tab_from_org(i),l_tab_to_org(i),
364: 1,fnd_global.user_id, sysdate, fnd_global.user_id, sysdate);
365: