APPS.JTF_RS_IMPORT_USER_PUB dependencies on FND_RESPONSIBILITY

Line 31: l_resp_group1 fnd_responsibility_vl.responsibility_name%type;

27: l_email jtf_rs_resource_extns.source_email%type ;
28: l_mgr_user_name jtf_rs_resource_extns.user_name%type ;
29:
30: l_nav_group1 jtf_iapp_families_vl.app_family_display_name%type;
31: l_resp_group1 fnd_responsibility_vl.responsibility_name%type;
32: l_res_role1 jtf_rs_roles_vl.role_name%type;
33:
34: l_nav_group2 jtf_iapp_families_vl.app_family_display_name%type;
35: l_resp_group2 fnd_responsibility_vl.responsibility_name%type;

Line 35: l_resp_group2 fnd_responsibility_vl.responsibility_name%type;

31: l_resp_group1 fnd_responsibility_vl.responsibility_name%type;
32: l_res_role1 jtf_rs_roles_vl.role_name%type;
33:
34: l_nav_group2 jtf_iapp_families_vl.app_family_display_name%type;
35: l_resp_group2 fnd_responsibility_vl.responsibility_name%type;
36: l_res_role2 jtf_rs_roles_vl.role_name%type;
37:
38: l_employee_number per_all_people_f.employee_number%type ;
39: l_resource_group jtf_rs_groups_vl.group_name%type ;

Line 40: l_default_resp fnd_responsibility_vl.responsibility_name%type ;

36: l_res_role2 jtf_rs_roles_vl.role_name%type;
37:
38: l_employee_number per_all_people_f.employee_number%type ;
39: l_resource_group jtf_rs_groups_vl.group_name%type ;
40: l_default_resp fnd_responsibility_vl.responsibility_name%type ;
41:
42: l_business_group_id per_all_people_f.business_group_id%type;
43: l_mgr_employee_id fnd_user.employee_id%type;
44:

Line 74: cursor c_resp_group (l_resp_group fnd_responsibility_vl.responsibility_name%type) is

70: select app_family_id
71: from jtf_iapp_families_vl
72: where app_family_display_name = l_nav_group;
73:
74: cursor c_resp_group (l_resp_group fnd_responsibility_vl.responsibility_name%type) is
75: select responsibility_id
76: from fnd_responsibility_vl
77: where responsibility_name = l_resp_group;
78:

Line 76: from fnd_responsibility_vl

72: where app_family_display_name = l_nav_group;
73:
74: cursor c_resp_group (l_resp_group fnd_responsibility_vl.responsibility_name%type) is
75: select responsibility_id
76: from fnd_responsibility_vl
77: where responsibility_name = l_resp_group;
78:
79: cursor c_nav_resp_group (l_app_family_id jtf_iapp_families_b.app_family_id%type,
80: l_responsibility_id fnd_responsibility.responsibility_id%type) is

Line 80: l_responsibility_id fnd_responsibility.responsibility_id%type) is

76: from fnd_responsibility_vl
77: where responsibility_name = l_resp_group;
78:
79: cursor c_nav_resp_group (l_app_family_id jtf_iapp_families_b.app_family_id%type,
80: l_responsibility_id fnd_responsibility.responsibility_id%type) is
81: select 1 from jtf_iapp_families_b jif, fnd_responsibility fr,
82: jtf_iapp_family_app_map jpm
83: where jif.app_family_id = jpm.app_family_id
84: and jpm.application_id = fr.application_id

Line 81: select 1 from jtf_iapp_families_b jif, fnd_responsibility fr,

77: where responsibility_name = l_resp_group;
78:
79: cursor c_nav_resp_group (l_app_family_id jtf_iapp_families_b.app_family_id%type,
80: l_responsibility_id fnd_responsibility.responsibility_id%type) is
81: select 1 from jtf_iapp_families_b jif, fnd_responsibility fr,
82: jtf_iapp_family_app_map jpm
83: where jif.app_family_id = jpm.app_family_id
84: and jpm.application_id = fr.application_id
85: and fr.responsibility_id = l_responsibility_id

Line 124: l_responsibility_id1 fnd_responsibility.responsibility_id%type;

120: l_role_code2 jtf_rs_roles_b.role_code%type;
121:
122: l_app_family_id1 jtf_iapp_families_b.app_family_id%type;
123: l_app_family_id2 jtf_iapp_families_b.app_family_id%type;
124: l_responsibility_id1 fnd_responsibility.responsibility_id%type;
125: l_responsibility_id2 fnd_responsibility.responsibility_id%type;
126:
127: l_num number;
128: l_method_emp_gen varchar2(150);

Line 125: l_responsibility_id2 fnd_responsibility.responsibility_id%type;

121:
122: l_app_family_id1 jtf_iapp_families_b.app_family_id%type;
123: l_app_family_id2 jtf_iapp_families_b.app_family_id%type;
124: l_responsibility_id1 fnd_responsibility.responsibility_id%type;
125: l_responsibility_id2 fnd_responsibility.responsibility_id%type;
126:
127: l_num number;
128: l_method_emp_gen varchar2(150);
129: l_assign_def_resp boolean;