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.JTF_RS_ROLES_PUB dependencies on JTF_RS_ROLES_VL

Line 44: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;

40: IS
41:
42: l_api_version CONSTANT NUMBER := 1.0;
43: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_RESOURCE_ROLES';
44: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
45: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
46: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
47: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
48: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;

Line 45: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;

41:
42: l_api_version CONSTANT NUMBER := 1.0;
43: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_RESOURCE_ROLES';
44: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
45: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
46: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
47: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
48: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
49: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;

Line 46: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;

42: l_api_version CONSTANT NUMBER := 1.0;
43: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_RESOURCE_ROLES';
44: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
45: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
46: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
47: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
48: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
49: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
50: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;

Line 47: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;

43: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_RESOURCE_ROLES';
44: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
45: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
46: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
47: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
48: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
49: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
50: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
51: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;

Line 48: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;

44: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
45: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
46: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
47: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
48: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
49: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
50: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
51: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
52: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;

Line 49: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;

45: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
46: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
47: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
48: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
49: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
50: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
51: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
52: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
53: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;

Line 50: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;

46: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
47: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
48: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
49: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
50: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
51: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
52: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
53: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
54:

Line 51: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;

47: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
48: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
49: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
50: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
51: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
52: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
53: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
54:
55: BEGIN

Line 52: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;

48: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
49: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
50: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
51: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
52: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
53: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
54:
55: BEGIN
56:

Line 53: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;

49: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
50: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
51: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
52: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
53: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
54:
55: BEGIN
56:
57: SAVEPOINT create_rs_resource_roles_pub;

Line 146: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;

142: )
143: IS
144: l_api_version CONSTANT NUMBER := 1.0;
145: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RS_RESOURCE_ROLES';
146: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
147: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
148: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
149: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
150: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;

Line 147: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;

143: IS
144: l_api_version CONSTANT NUMBER := 1.0;
145: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RS_RESOURCE_ROLES';
146: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
147: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
148: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
149: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
150: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
151: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;

Line 148: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;

144: l_api_version CONSTANT NUMBER := 1.0;
145: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RS_RESOURCE_ROLES';
146: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
147: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
148: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
149: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
150: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
151: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
152: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;

Line 149: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;

145: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RS_RESOURCE_ROLES';
146: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
147: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
148: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
149: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
150: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
151: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
152: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
153: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;

Line 150: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;

146: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
147: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
148: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
149: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
150: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
151: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
152: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
153: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
154: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;

Line 151: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;

147: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
148: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
149: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
150: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
151: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
152: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
153: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
154: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
155: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;

Line 152: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;

148: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
149: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
150: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
151: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
152: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
153: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
154: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
155: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
156: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;

Line 153: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;

149: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
150: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
151: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
152: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
153: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
154: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
155: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
156: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
157: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;

Line 154: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;

150: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
151: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
152: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
153: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
154: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
155: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
156: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
157: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
158:

Line 155: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;

151: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
152: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
153: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
154: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
155: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
156: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
157: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
158:
159: BEGIN

Line 156: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;

152: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
153: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
154: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
155: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
156: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
157: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
158:
159: BEGIN
160: SAVEPOINT update_rs_resource_roles_pub;

Line 157: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;

153: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
154: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
155: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
156: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
157: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
158:
159: BEGIN
160: SAVEPOINT update_rs_resource_roles_pub;
161: x_return_status := fnd_api.g_ret_sts_success;

Line 240: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;

236: ) IS
237:
238: l_api_version CONSTANT NUMBER := 1.0;
239: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RS_RESOURCE_ROLES';
240: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
241: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
242: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
243:
244: BEGIN

Line 241: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;

237:
238: l_api_version CONSTANT NUMBER := 1.0;
239: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RS_RESOURCE_ROLES';
240: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
241: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
242: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
243:
244: BEGIN
245: SAVEPOINT delete_rs_resource_roles_pub;

Line 242: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;

238: l_api_version CONSTANT NUMBER := 1.0;
239: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RS_RESOURCE_ROLES';
240: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
241: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
242: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
243:
244: BEGIN
245: SAVEPOINT delete_rs_resource_roles_pub;
246: x_return_status := fnd_api.g_ret_sts_success;