APPS.CSM_PROFILE_EVENT_PKG dependencies on FND_RESPONSIBILITY

Line 87: l_resp_id fnd_responsibility.responsibility_id%TYPE;

83: l_pub_item varchar2(30) := 'CSF_M_PROFILES';
84: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
85: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
86: l_user_id fnd_user.user_id%TYPE;
87: l_resp_id fnd_responsibility.responsibility_id%TYPE;
88: l_app_id fnd_application.application_id%TYPE;
89: l_markdirty boolean;
90: l_all_omfs_palm_user_list asg_download.user_list;
91: l_null_user_list asg_download.user_list;

Line 184: p_csm_resp_id fnd_responsibility.responsibility_id%TYPE)

180: );
181: -- get the profiles with values to be inserted
182: CURSOR l_profiles_ins_csr(p_last_upd_date date,
183: p_csm_appl_id fnd_application.application_id%TYPE,
184: p_csm_resp_id fnd_responsibility.responsibility_id%TYPE)
185: IS
186: SELECT val.application_id, val.profile_option_id, val.level_id, val.level_value,
187: val.level_value_application_id, val.profile_option_value, opt.profile_option_name
188: FROM fnd_profile_options opt,

Line 268: fnd_responsibility resp

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
272: AND acc.level_value = val.level_value

Line 380: fnd_responsibility resp

376: AND val.level_id <> 10003
377: UNION
378: SELECT 1
379: FROM fnd_profile_option_values val,
380: fnd_responsibility resp
381: WHERE val.application_id = acc.application_id
382: AND val.profile_option_id = acc.profile_option_id
383: AND val.level_id = acc.level_id
384: AND val.level_value = acc.level_value

Line 568: l_csm_resp_id fnd_responsibility.responsibility_id%TYPE;

564: SELECT csm_profiles_acc_s.NEXTVAL
565: FROM dual;
566:
567: l_csm_appl_id fnd_application.application_id%TYPE;
568: l_csm_resp_id fnd_responsibility.responsibility_id%TYPE;
569: l_old_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
570: l_old_level_id fnd_profile_option_values.level_id%TYPE;
571: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
572: l_level_id fnd_profile_option_values.level_id%TYPE;

Line 854: p_csm_resp_id fnd_responsibility.responsibility_id%TYPE

850:
851: -- get the profiles to be inserted for the new user
852: CURSOR l_profiles_ins_csr(p_user_id IN number,
853: p_csm_appl_id fnd_application.application_id%TYPE,
854: p_csm_resp_id fnd_responsibility.responsibility_id%TYPE
855: )
856: IS
857: SELECT val.application_id, val.profile_option_id, val.level_id, val.level_value,
858: val.level_value_application_id, val.profile_option_value, opt.profile_option_name

Line 941: fnd_responsibility resp

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
945: AND acc.level_value = val.level_value

Line 982: l_csm_resp_id fnd_responsibility.responsibility_id%TYPE;

978: SELECT csm_profiles_acc_s.NEXTVAL
979: FROM dual;
980:
981: l_csm_appl_id fnd_application.application_id%TYPE;
982: l_csm_resp_id fnd_responsibility.responsibility_id%TYPE;
983:
984: BEGIN
985: l_run_date := SYSDATE;
986: