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_PROFILE_EVENT_PKG dependencies on CSM_PROFILE_OPTION_VALUES_ACC

Line 9: SELECT acc.access_id,acc.user_id FROM csm_profile_option_values_acc acc

5:
6: -- get the profiles to be deleted
7: CURSOR l_profiles_del_csr
8: IS
9: SELECT acc.access_id,acc.user_id FROM csm_profile_option_values_acc acc
10: WHERE NOT EXISTS (SELECT 1 FROM fnd_profile_option_values val
11: WHERE acc.profile_option_id = val.profile_option_id
12: AND acc.application_id = val.application_id
13: AND acc.level_id = val.level_id

Line 17: SELECT access_id,user_id FROM csm_profile_option_values_acc ACC

13: AND acc.level_id = val.level_id
14: AND acc.level_value = val.level_value
15: AND (acc.level_id <> 10003 OR acc.level_value_application_id=val.level_value_application_id))
16: UNION
17: SELECT access_id,user_id FROM csm_profile_option_values_acc ACC
18: WHERE NOT EXISTS( SELECT 1 FROM FND_PROFILE_OPTIONS OPT
19: WHERE OPT.PROFILE_OPTION_ID = ACC.PROFILE_OPTION_ID
20: AND OPT.APPLICATION_ID = ACC.APPLICATION_ID
21: AND NVL(OPT.start_date_active, SYSDATE) <= SYSDATE

Line 171: AND not exists(SELECT 1 FROM csm_profile_option_values_acc acc

167: AND au.enabled='Y'
168: group by opt.profile_option_name,val.application_id, val.profile_option_id,au.user_id,au.user_name
169: ) tab
170: WHERE au.USER_ID=tab.user_id
171: AND not exists(SELECT 1 FROM csm_profile_option_values_acc acc
172: WHERE acc.application_id = tab.application_id
173: AND acc.profile_option_id = tab.profile_option_id
174: AND acc.user_id = tab.user_id);
175:

Line 181: csm_profile_option_values_acc acc,asg_user au

177: CURSOR l_profiles_upd_csr
178: IS
179: SELECT acc.access_id,acc.user_id,val.level_id,val.level_value,val.LEVEL_VALUE_APPLICATION_ID,val.profile_option_value
180: FROM fnd_profile_option_values val,
181: csm_profile_option_values_acc acc,asg_user au
182: WHERE val.profile_option_id = acc.profile_option_id
183: AND val.application_id = acc.application_id
184: AND val.level_id in (10001,10002,10003,10004)
185: AND (val.level_id<> 10002 OR val.level_value=au.app_id)

Line 227: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_profile_option_values_acc' ,

223: l_tab_user_id.DELETE;
224: FETCH l_profiles_del_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
225: EXIT WHEN l_tab_access_id.COUNT = 0;
226:
227: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_profile_option_values_acc' ,
228: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
229:
230: l_markdirty := asg_download.mark_dirty(
231: P_PUB_ITEM => g_pub_item

Line 239: DELETE FROM csm_profile_option_values_acc WHERE access_id = l_tab_access_id(i);

235: , P_TIMESTAMP => sysdate
236: );
237:
238: FORALL i IN 1..l_tab_access_id.COUNT
239: DELETE FROM csm_profile_option_values_acc WHERE access_id = l_tab_access_id(i);
240:
241: COMMIT;
242: END LOOP;
243: CLOSE l_profiles_del_csr;

Line 262: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in csm_profile_option_values_acc' ,

258:
259: FETCH l_profiles_upd_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_l_id,l_tab_l_val,l_tab_lva_id,l_tab_pf_val LIMIT 1000;
260: EXIT WHEN l_tab_access_id.COUNT = 0;
261:
262: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in csm_profile_option_values_acc' ,
263: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
264:
265: l_markdirty := asg_download.mark_dirty(
266: P_PUB_ITEM => g_pub_item

Line 274: UPDATE csm_profile_option_values_acc

270: , P_TIMESTAMP => sysdate
271: );
272:
273: FORALL i IN 1..l_tab_access_id.COUNT
274: UPDATE csm_profile_option_values_acc
275: SET LEVEL_ID = l_tab_l_id(i)
276: ,LEVEL_VALUE = l_tab_l_val(i)
277: ,LEVEL_VALUE_APPLICATION_ID =l_tab_lva_id(i)
278: ,profile_option_value = l_tab_pf_val(i)

Line 307: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_profile_option_values_acc' ,

303: FETCH l_profiles_ins_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_app_id,l_tab_prf_id,
304: l_tab_l_id,l_tab_l_val,l_tab_lva_id,l_tab_pf_val,l_tab_prf_name LIMIT 1000;
305: EXIT WHEN l_tab_access_id.COUNT = 0;
306:
307: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_profile_option_values_acc' ,
308: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
309:
310:
311: FORALL i IN 1..l_tab_access_id.COUNT

Line 312: INSERT INTO csm_profile_option_values_acc(access_id, user_id, application_id, profile_option_id,

308: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
309:
310:
311: FORALL i IN 1..l_tab_access_id.COUNT
312: INSERT INTO csm_profile_option_values_acc(access_id, user_id, application_id, profile_option_id,
313: level_id, level_value, level_value_application_id, profile_option_value,profile_option_name,
314: created_by,creation_date, last_updated_by, last_update_date, last_update_login )
315: VALUES (l_tab_access_id(I),l_tab_user_id(I),l_tab_app_id(I),l_tab_prf_id(I),
316: l_tab_l_id(I),l_tab_l_val(I),l_tab_lva_id(I),l_tab_pf_val(I),l_tab_prf_name(I),

Line 417: AND not exists(SELECT 1 FROM csm_profile_option_values_acc acc

413: AND au.user_id=p_user_id
414: group by opt.profile_option_name,val.application_id, val.profile_option_id,au.user_id,au.user_name
415: ) tab
416: WHERE au.USER_ID=tab.user_id
417: AND not exists(SELECT 1 FROM csm_profile_option_values_acc acc
418: WHERE acc.application_id = tab.application_id
419: AND acc.profile_option_id = tab.profile_option_id
420: AND acc.user_id = tab.user_id);
421:

Line 456: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_profile_option_values_acc' ,

452: FETCH l_profiles_ins_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_app_id,l_tab_prf_id,
453: l_tab_l_id,l_tab_l_val,l_tab_lva_id,l_tab_pf_val,l_tab_prf_name LIMIT 1000;
454: EXIT WHEN l_tab_access_id.COUNT = 0;
455:
456: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_profile_option_values_acc' ,
457: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
458:
459:
460: FORALL i IN 1..l_tab_access_id.COUNT

Line 461: INSERT INTO csm_profile_option_values_acc(access_id, user_id, application_id, profile_option_id,

457: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
458:
459:
460: FORALL i IN 1..l_tab_access_id.COUNT
461: INSERT INTO csm_profile_option_values_acc(access_id, user_id, application_id, profile_option_id,
462: level_id, level_value, level_value_application_id, profile_option_value,profile_option_name,
463: created_by,creation_date, last_updated_by, last_update_date, last_update_login )
464: VALUES (l_tab_access_id(I),l_tab_user_id(I),l_tab_app_id(I),l_tab_prf_id(I),
465: l_tab_l_id(I),l_tab_l_val(I),l_tab_lva_id(I),l_tab_pf_val(I),l_tab_prf_name(I),

Line 561: AND NOT EXISTS(SELECT 1 FROM csm_profile_option_values_acc acc WHERE acc.application_id = opt.application_id AND acc.profile_option_id = opt.profile_option_id)

557: ,'JTF_NTS_NOTE_TYPE','CSF_DEBRIEF_RESTRICT_INSTANCE' ,'CSF_ENABLE_RETURN_ROUTING_DBF','CSP_PART_REQ_DEF_SHIP_TO'
558: ,'CSF_GOOGLE_MAP_KEY','CSF_GOOGLE_MAP_CLIENT_ID','CSF_GOOGLE_MAP_ADDENDUM','CSM_CUSTOMIZATION_KEY','CSM_DFLT_TASK_STATUS_SYNC_UPD')
559: AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
560: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE
561: AND NOT EXISTS(SELECT 1 FROM csm_profile_option_values_acc acc WHERE acc.application_id = opt.application_id AND acc.profile_option_id = opt.profile_option_id)
562: AND au.enabled='Y'
563: */
564:
565: END CSM_PROFILE_EVENT_PKG;