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 38: INSERT INTO csm_profile_option_values_acc(access_id,

34: p_level_value IN number, p_level_value_application_id IN number,
35: p_profile_option_value IN varchar2, p_creation_date IN date)
36: IS
37: BEGIN
38: INSERT INTO csm_profile_option_values_acc(access_id,
39: user_id,
40: application_id,
41: profile_option_id,
42: level_id,

Line 176: FROM csm_profile_option_values_acc acc

172: AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
173: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE
174: AND NOT EXISTS
175: (SELECT 1
176: FROM csm_profile_option_values_acc acc
177: WHERE acc.profile_option_id = opt.profile_option_id
178: AND acc.application_id = opt.application_id
179: AND acc.user_id = au.user_id
180: );

Line 259: FROM csm_profile_option_values_acc acc

255: OR (val.level_id = 10003 AND val.level_value = p_csm_resp_id)
256: )
257: AND NOT EXISTS
258: (SELECT 1
259: FROM csm_profile_option_values_acc acc
260: WHERE acc.profile_option_id = val.profile_option_id
261: AND acc.application_id = val.application_id
262: AND acc.level_id = val.level_id
263: AND acc.level_value = val.level_value

Line 267: FROM csm_profile_option_values_acc acc,

263: AND acc.level_value = val.level_value
264: AND acc.level_id <> 10003
265: UNION
266: SELECT 1
267: FROM csm_profile_option_values_acc acc,
268: fnd_responsibility resp
269: WHERE acc.profile_option_id = val.profile_option_id
270: AND acc.application_id = val.application_id
271: AND acc.level_id = val.level_id

Line 292: csm_profile_option_values_acc acc

288: val.profile_option_value,
289: acc.user_id,
290: acc.access_id
291: FROM fnd_profile_option_values val,
292: csm_profile_option_values_acc acc
293: WHERE val.profile_option_id = acc.profile_option_id
294: AND val.application_id = acc.application_id
295: AND acc.level_id = val.level_id
296: AND acc.level_value = val.level_value

Line 305: FROM csm_profile_option_values_acc acc,

301: IS
302: SELECT acc.access_id, acc.application_id, acc.profile_option_id, acc.level_id, acc.level_value,
303: acc.level_value_application_id, acc.profile_option_value, opt.profile_option_name,
304: acc.user_id
305: FROM csm_profile_option_values_acc acc,
306: fnd_profile_options opt
307: WHERE acc.profile_option_id = opt.profile_option_id
308: AND acc.application_id = opt.application_id
309: AND acc.level_id IS NOT NULL

Line 399: FROM csm_profile_option_values_acc ACC

395: CURSOR c_purge IS
396: SELECT /*+ index(ACC CSM_PROFILE_VALUES_ACC_N1) */
397: ACC.APPLICATION_ID,
398: ACC.PROFILE_OPTION_ID
399: FROM csm_profile_option_values_acc ACC
400: WHERE NOT EXISTS( SELECT 1
401: FROM FND_PROFILE_OPTIONS OPT
402: WHERE OPT.PROFILE_OPTION_ID = ACC.PROFILE_OPTION_ID
403: AND OPT.APPLICATION_ID = ACC.APPLICATION_ID

Line 472: FROM csm_profile_option_values_acc ACC

468: --Bug 5257429
469: CURSOR c_get_accessID(b_app_id NUMBER, b_prfopt_id NUMBER)
470: IS
471: SELECT ACC.ACCESS_ID,ACC.USER_ID
472: FROM csm_profile_option_values_acc ACC
473: WHERE ACC.APPLICATION_ID= b_app_id
474: AND ACC.PROFILE_OPTION_ID= b_prfopt_id;
475:
476:

Line 480: FROM csm_profile_option_values_acc

476:
477: CURSOR l_get_old_profile_csr (p_profile_option_id IN number, p_user_id IN number)
478: IS
479: SELECT access_id, profile_option_value, level_id
480: FROM csm_profile_option_values_acc
481: WHERE profile_option_id = p_profile_option_id
482: AND user_id = p_user_id
483: ORDER BY level_id desc
484: FOR UPDATE OF profile_option_value, level_id, level_value, last_update_date nowait;

Line 616: DELETE FROM csm_profile_option_values_acc WHERE ACCESS_ID=l_acc_tab(J);

612: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,l_acc_tab(J) ,l_user_tab(J), 'D', sysdate );
613: END LOOP;
614:
615: FORALL J IN 1..l_acc_tab.COUNT
616: DELETE FROM csm_profile_option_values_acc WHERE ACCESS_ID=l_acc_tab(J);
617:
618: END LOOP;
619:
620: COMMIT;

Line 625: -- insert into csm_profile_option_values_acc

621:
622: --- process profile wovalue inserts
623: FOR r_profiles_ins_rec IN l_profiles_wovalue_ins_csr LOOP
624:
625: -- insert into csm_profile_option_values_acc
626: insert_profiles_acc(r_profiles_ins_rec.access_id,r_profiles_ins_rec.user_id,r_profiles_ins_rec.application_id,
627: r_profiles_ins_rec.profile_option_id, 10001,
628: 0, NULL,
629: NULL,l_run_date);

Line 682: UPDATE csm_profile_option_values_acc

678: r_profiles_rec.level_id := 10001;
679: r_profiles_rec.level_value := 0;
680: END IF;
681:
682: UPDATE csm_profile_option_values_acc
683: SET profile_option_value = r_profiles_rec.profile_option_value,
684: level_id = r_profiles_rec.level_id,
685: level_value = r_profiles_rec.level_value,
686: level_value_application_id = r_profiles_rec.level_value_application_id,

Line 695: UPDATE csm_profile_option_values_acc

691: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
692: r_profiles_del_rec.access_id, l_user_id, ASG_DOWNLOAD.UPD, SYSDATE);
693: ELSE
694: --No value set for this profile at any level and hence set back to site level with value null
695: UPDATE csm_profile_option_values_acc
696: SET profile_option_value = NULL,
697: level_id = 10001,
698: level_value = 0,
699: level_value_application_id = NULL,

Line 709: DELETE FROM csm_profile_option_values_acc WHERE profile_option_id = r_profiles_del_rec.profile_option_id

705:
706: END IF;
707: CLOSE c_profiles_csr;
708: ELSE
709: DELETE FROM csm_profile_option_values_acc WHERE profile_option_id = r_profiles_del_rec.profile_option_id
710: AND user_id = l_user_id;
711: END IF; -- if valid omfs user
712:
713: END LOOP; --palm omfs user loop

Line 721: UPDATE csm_profile_option_values_acc

717:
718: --process updates STARTS
719: FOR r_profiles_upd_rec IN l_profiles_upd_csr LOOP
720:
721: UPDATE csm_profile_option_values_acc
722: SET profile_option_value = r_profiles_upd_rec.profile_option_value,
723: last_update_date = l_run_date
724: WHERE USER_ID = r_profiles_upd_rec.user_id
725: AND profile_option_id = r_profiles_upd_rec.profile_option_id

Line 769: UPDATE csm_profile_option_values_acc

765: IF l_get_old_profile_csr%FOUND THEN
766: -- only call the WF if a profile at a higher level is added; update the acc table with the new value
767: IF r_profiles_ins_rec.level_id > NVL(l_old_level_id,0) THEN
768:
769: UPDATE csm_profile_option_values_acc
770: SET profile_option_value = r_profiles_ins_rec.profile_option_value,
771: level_id = r_profiles_ins_rec.level_id,
772: level_value = r_profiles_ins_rec.level_value,
773: level_value_application_id = r_profiles_ins_rec.level_value_application_id,

Line 794: -- insert into csm_profile_option_values_acc

790: OPEN c_profile_seq;
791: FETCH c_profile_seq INTO l_access_id;
792: CLOSE c_profile_seq;
793:
794: -- insert into csm_profile_option_values_acc
795: insert_profiles_acc(l_access_id,l_user_id,r_profiles_ins_rec.application_id,
796: r_profiles_ins_rec.profile_option_id, r_profiles_ins_rec.level_id,
797: r_profiles_ins_rec.level_value, r_profiles_ins_rec.level_value_application_id,
798: r_profiles_ins_rec.profile_option_value,l_run_date);

Line 930: FROM csm_profile_option_values_acc acc

926: OR (val.level_id = 10003 AND val.level_value = p_csm_resp_id)
927: )
928: AND NOT EXISTS
929: (SELECT 1
930: FROM csm_profile_option_values_acc acc
931: WHERE acc.profile_option_id = val.profile_option_id
932: AND acc.application_id = val.application_id
933: AND acc.level_id = val.level_id
934: AND acc.level_value = val.level_value

Line 940: FROM csm_profile_option_values_acc acc,

936: -- AND NVl(acc.level_value_application_id, -1) = NVL(val.level_value_application_id, -1)
937: AND acc.user_id = p_user_id
938: UNION
939: SELECT 1
940: FROM csm_profile_option_values_acc acc,
941: fnd_responsibility resp
942: WHERE acc.profile_option_id = val.profile_option_id
943: AND acc.application_id = val.application_id
944: AND acc.level_id = val.level_id

Line 958: FROM csm_profile_option_values_acc

954:
955: CURSOR l_get_old_profile_csr (p_profile_option_id IN number, p_user_id IN number)
956: IS
957: SELECT access_id, profile_option_value, level_id
958: FROM csm_profile_option_values_acc
959: WHERE profile_option_id = p_profile_option_id
960: AND user_id = p_user_id
961: ORDER BY level_id desc
962: FOR UPDATE OF profile_option_value, level_id, level_value, last_update_date NOWAIT;

Line 1005: UPDATE csm_profile_option_values_acc

1001: FETCH l_get_old_profile_csr INTO l_access_id, l_old_profile_option_value, l_old_level_id;
1002: IF l_get_old_profile_csr%FOUND THEN
1003: -- only call the WF if a profile at a higher level is added; update the acc table with the new value
1004: IF r_profiles_ins_rec.level_id > NVL(l_old_level_id,0) THEN
1005: UPDATE csm_profile_option_values_acc
1006: SET profile_option_value = r_profiles_ins_rec.profile_option_value,
1007: level_id = r_profiles_ins_rec.level_id,
1008: level_value = r_profiles_ins_rec.level_value,
1009: level_value_application_id = r_profiles_ins_rec.level_value_application_id,

Line 1032: -- insert into csm_profile_option_values_acc

1028: OPEN c_profile_seq;
1029: FETCH c_profile_seq INTO l_access_id;
1030: CLOSE c_profile_seq;
1031:
1032: -- insert into csm_profile_option_values_acc
1033: insert_profiles_acc(l_access_id,p_user_id,r_profiles_ins_rec.application_id,
1034: r_profiles_ins_rec.profile_option_id, r_profiles_ins_rec.level_id,
1035: r_profiles_ins_rec.level_value, r_profiles_ins_rec.level_value_application_id,
1036: r_profiles_ins_rec.profile_option_value,l_run_date);