APPS.JTF_RS_IMPORT_USER_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 24: l_first_name jtf_rs_resource_extns.source_first_name%type ;

20: l_msg_data varchar2(2000);
21: l_msg_data1 varchar2(2000);
22: l_msg_index_out varchar2(2000);
23:
24: l_first_name jtf_rs_resource_extns.source_first_name%type ;
25: l_last_name jtf_rs_resource_extns.source_last_name%type ;
26: l_user_name jtf_rs_resource_extns.user_name%type ;
27: l_email jtf_rs_resource_extns.source_email%type ;
28: l_mgr_user_name jtf_rs_resource_extns.user_name%type ;

Line 25: l_last_name jtf_rs_resource_extns.source_last_name%type ;

21: l_msg_data1 varchar2(2000);
22: l_msg_index_out varchar2(2000);
23:
24: l_first_name jtf_rs_resource_extns.source_first_name%type ;
25: l_last_name jtf_rs_resource_extns.source_last_name%type ;
26: l_user_name jtf_rs_resource_extns.user_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:

Line 26: l_user_name jtf_rs_resource_extns.user_name%type ;

22: l_msg_index_out varchar2(2000);
23:
24: l_first_name jtf_rs_resource_extns.source_first_name%type ;
25: l_last_name jtf_rs_resource_extns.source_last_name%type ;
26: l_user_name jtf_rs_resource_extns.user_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;

Line 27: l_email jtf_rs_resource_extns.source_email%type ;

23:
24: l_first_name jtf_rs_resource_extns.source_first_name%type ;
25: l_last_name jtf_rs_resource_extns.source_last_name%type ;
26: l_user_name jtf_rs_resource_extns.user_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;

Line 28: l_mgr_user_name jtf_rs_resource_extns.user_name%type ;

24: l_first_name jtf_rs_resource_extns.source_first_name%type ;
25: l_last_name jtf_rs_resource_extns.source_last_name%type ;
26: l_user_name jtf_rs_resource_extns.user_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;

Line 64: cursor c_mgr_resource_id (l_mgr_user_id jtf_rs_resource_extns.user_id%type) is

60: cursor c_mgr_user_name (l_mgr_user_name fnd_user.user_name%type) is
61: select user_id from fnd_user
62: where user_name = l_mgr_user_name;
63:
64: cursor c_mgr_resource_id (l_mgr_user_id jtf_rs_resource_extns.user_id%type) is
65: select resource_id
66: from jtf_rs_resource_extns
67: where user_id = l_mgr_user_id;
68:

Line 66: from jtf_rs_resource_extns

62: where user_name = l_mgr_user_name;
63:
64: cursor c_mgr_resource_id (l_mgr_user_id jtf_rs_resource_extns.user_id%type) is
65: select resource_id
66: from jtf_rs_resource_extns
67: where user_id = l_mgr_user_id;
68:
69: cursor c_nav_group (l_nav_group jtf_iapp_families_vl.app_family_display_name%type) is
70: select app_family_id

Line 103: cursor c_get_user_id (l_user_name jtf_rs_resource_extns.user_name%type) is

99: select role_id, role_code
100: from jtf_rs_roles_vl
101: where role_name = l_role_name;
102:
103: cursor c_get_user_id (l_user_name jtf_rs_resource_extns.user_name%type) is
104: select user_id
105: from fnd_user
106: where user_name = l_user_name;
107:

Line 114: l_mgr_user_id jtf_rs_resource_extns.user_id%type;

110: l_user_password fnd_user.encrypted_user_password%type := NULL;
111: l_group_member_id number;
112: l_role_relate_id number;
113:
114: l_mgr_user_id jtf_rs_resource_extns.user_id%type;
115: l_mgr_resource_id jtf_rs_resource_extns.resource_id%type;
116: l_group_id jtf_rs_groups_b.group_id%type;
117: l_role_id1 jtf_rs_roles_b.role_id%type;
118: l_role_id2 jtf_rs_roles_b.role_id%type;

Line 115: l_mgr_resource_id jtf_rs_resource_extns.resource_id%type;

111: l_group_member_id number;
112: l_role_relate_id number;
113:
114: l_mgr_user_id jtf_rs_resource_extns.user_id%type;
115: l_mgr_resource_id jtf_rs_resource_extns.resource_id%type;
116: l_group_id jtf_rs_groups_b.group_id%type;
117: l_role_id1 jtf_rs_roles_b.role_id%type;
118: l_role_id2 jtf_rs_roles_b.role_id%type;
119: l_role_code1 jtf_rs_roles_b.role_code%type;