APPS.CSM_PROFILE_EVENT_PKG dependencies on FND_APPLICATION

Line 88: l_app_id fnd_application.application_id%TYPE;

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;
92: l_single_access_id_list asg_download.access_list;

Line 183: p_csm_appl_id fnd_application.application_id%TYPE,

179: AND acc.user_id = au.user_id
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

Line 555: FROM fnd_application

551: ORDER BY val.level_id DESC;
552:
553: cursor c_csm_appl is
554: SELECT APPLICATION_ID
555: FROM fnd_application
556: where application_short_name = 'CSM';
557:
558: cursor c_csm_resp(c_user_id NUMBER) is
559: select RESPONSIBILITY_ID

Line 567: l_csm_appl_id fnd_application.application_id%TYPE;

563: CURSOR c_profile_seq IS
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;

Line 853: p_csm_appl_id fnd_application.application_id%TYPE,

849: l_markdirty BOOLEAN;
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,

Line 969: FROM fnd_application

965: l_old_level_id fnd_profile_option_values.level_id%TYPE;
966:
967: CURSOR c_csm_appl IS
968: SELECT APPLICATION_ID
969: FROM fnd_application
970: WHERE application_short_name = 'CSM';
971:
972: CURSOR c_csm_resp (c_user_id NUMBER) IS
973: SELECT RESPONSIBILITY_ID

Line 981: l_csm_appl_id fnd_application.application_id%TYPE;

977: CURSOR c_profile_seq IS
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;