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_PVT dependencies on JTF_RS_ROLES_VL

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

56: IS
57:
58: l_api_version CONSTANT NUMBER := 1.0;
59: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_RESOURCE_ROLES';
60: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
61: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
62: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
63: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
64: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;

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

57:
58: l_api_version CONSTANT NUMBER := 1.0;
59: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_RESOURCE_ROLES';
60: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
61: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
62: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
63: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
64: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
65: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;

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

58: l_api_version CONSTANT NUMBER := 1.0;
59: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_RESOURCE_ROLES';
60: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
61: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
62: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
63: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
64: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
65: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
66: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;

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

59: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_RESOURCE_ROLES';
60: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
61: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
62: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
63: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
64: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
65: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
66: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
67: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;

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

60: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
61: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
62: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
63: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
64: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
65: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
66: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
67: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
68: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;

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

61: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
62: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
63: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
64: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
65: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
66: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
67: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
68: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
69: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;

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

62: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
63: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
64: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
65: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
66: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
67: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
68: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
69: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
70: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;

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

63: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
64: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
65: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
66: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
67: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
68: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
69: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
70: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
71: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;

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

64: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
65: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
66: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
67: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
68: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
69: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
70: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
71: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
72: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;

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

65: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
66: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
67: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
68: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
69: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
70: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
71: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
72: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
73: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;

Line 70: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;

66: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
67: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
68: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
69: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
70: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
71: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
72: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
73: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
74: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;

Line 71: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;

67: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
68: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
69: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
70: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
71: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
72: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
73: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
74: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
75: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;

Line 72: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;

68: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
69: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
70: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
71: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
72: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
73: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
74: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
75: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
76: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;

Line 73: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;

69: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
70: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
71: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
72: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
73: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
74: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
75: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
76: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
77: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;

Line 74: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;

70: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
71: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
72: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
73: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
74: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
75: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
76: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
77: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
78: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;

Line 75: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;

71: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
72: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
73: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
74: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
75: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
76: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
77: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
78: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
79: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;

Line 76: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;

72: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
73: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
74: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
75: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
76: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
77: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
78: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
79: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
80: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;

Line 77: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;

73: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
74: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
75: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
76: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
77: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
78: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
79: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
80: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
81: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;

Line 78: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;

74: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
75: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
76: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
77: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
78: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
79: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
80: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
81: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
82: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;

Line 79: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;

75: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
76: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
77: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
78: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
79: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
80: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
81: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
82: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
83: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;

Line 80: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;

76: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
77: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
78: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
79: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
80: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
81: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
82: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
83: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
84: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;

Line 81: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;

77: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
78: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
79: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
80: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
81: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
82: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
83: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
84: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
85: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;

Line 82: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;

78: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
79: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
80: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
81: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
82: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
83: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
84: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
85: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;
86: l_rowid ROWID;

Line 83: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;

79: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
80: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
81: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
82: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
83: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
84: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
85: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;
86: l_rowid ROWID;
87: l_role_id jtf_rs_roles_vl.role_id%type;

Line 84: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;

80: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
81: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
82: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
83: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
84: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
85: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;
86: l_rowid ROWID;
87: l_role_id jtf_rs_roles_vl.role_id%type;
88: i number;

Line 85: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;

81: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
82: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
83: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
84: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
85: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;
86: l_rowid ROWID;
87: l_role_id jtf_rs_roles_vl.role_id%type;
88: i number;
89: l_check_char varchar2(1);

Line 87: l_role_id jtf_rs_roles_vl.role_id%type;

83: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
84: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
85: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;
86: l_rowid ROWID;
87: l_role_id jtf_rs_roles_vl.role_id%type;
88: i number;
89: l_check_char varchar2(1);
90: l_bind_data_id number;
91:

Line 96: CURSOR c_jtf_rs_roles( l_role_id IN jtf_rs_roles_vl.role_id%type ) IS

92: l_return_status VARCHAR2(2000);
93: l_msg_count NUMBER;
94: l_msg_data VARCHAR2(2000);
95:
96: CURSOR c_jtf_rs_roles( l_role_id IN jtf_rs_roles_vl.role_id%type ) IS
97: SELECT 'Y'
98: FROM jtf_rs_roles_vl
99: WHERE role_id = l_role_id;
100:

Line 98: FROM jtf_rs_roles_vl

94: l_msg_data VARCHAR2(2000);
95:
96: CURSOR c_jtf_rs_roles( l_role_id IN jtf_rs_roles_vl.role_id%type ) IS
97: SELECT 'Y'
98: FROM jtf_rs_roles_vl
99: WHERE role_id = l_role_id;
100:
101: CURSOR c_role_code (l_role_code IN jtf_rs_roles_vl.role_code%type) IS
102: SELECT role_code

Line 101: CURSOR c_role_code (l_role_code IN jtf_rs_roles_vl.role_code%type) IS

97: SELECT 'Y'
98: FROM jtf_rs_roles_vl
99: WHERE role_id = l_role_id;
100:
101: CURSOR c_role_code (l_role_code IN jtf_rs_roles_vl.role_code%type) IS
102: SELECT role_code
103: FROM jtf_rs_roles_vl
104: WHERE role_code = l_role_code;
105:

Line 103: FROM jtf_rs_roles_vl

99: WHERE role_id = l_role_id;
100:
101: CURSOR c_role_code (l_role_code IN jtf_rs_roles_vl.role_code%type) IS
102: SELECT role_code
103: FROM jtf_rs_roles_vl
104: WHERE role_code = l_role_code;
105:
106: CURSOR c_role_type_code ( l_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS
107: SELECT lookup_code from fnd_lookups

Line 106: CURSOR c_role_type_code ( l_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS

102: SELECT role_code
103: FROM jtf_rs_roles_vl
104: WHERE role_code = l_role_code;
105:
106: CURSOR c_role_type_code ( l_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS
107: SELECT lookup_code from fnd_lookups
108: WHERE LOOKUP_TYPE = 'JTF_RS_ROLE_TYPE'
109: AND lookup_code = l_role_type_code
110: AND enabled_flag = 'Y'

Line 115: CURSOR c_role_name_check(c_role_name IN jtf_rs_roles_vl.role_name%type, c_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS

111: AND trunc(sysdate) <= trunc(nvl(end_date_active,sysdate));
112:
113: Dummy_char varchar2(1);
114:
115: CURSOR c_role_name_check(c_role_name IN jtf_rs_roles_vl.role_name%type, c_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS
116: SELECT 'x'
117: FROM jtf_rs_roles_vl
118: WHERE upper(ROLE_NAME) = c_role_name
119: AND ROLE_TYPE_CODE = c_role_type_code;

Line 117: FROM jtf_rs_roles_vl

113: Dummy_char varchar2(1);
114:
115: CURSOR c_role_name_check(c_role_name IN jtf_rs_roles_vl.role_name%type, c_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS
116: SELECT 'x'
117: FROM jtf_rs_roles_vl
118: WHERE upper(ROLE_NAME) = c_role_name
119: AND ROLE_TYPE_CODE = c_role_type_code;
120:
121: BEGIN

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

645: )
646: IS
647: l_api_version CONSTANT NUMBER := 1.0;
648: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RS_RESOURCE_ROLES';
649: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
650: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
651: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
652: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
653: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;

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

646: IS
647: l_api_version CONSTANT NUMBER := 1.0;
648: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RS_RESOURCE_ROLES';
649: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
650: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
651: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
652: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
653: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
654: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;

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

647: l_api_version CONSTANT NUMBER := 1.0;
648: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RS_RESOURCE_ROLES';
649: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
650: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
651: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
652: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
653: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
654: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
655: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;

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

648: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RS_RESOURCE_ROLES';
649: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
650: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
651: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
652: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
653: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
654: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
655: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
656: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;

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

649: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
650: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
651: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
652: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
653: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
654: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
655: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
656: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
657: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;

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

650: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
651: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
652: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
653: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
654: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
655: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
656: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
657: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
658: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;

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

651: l_role_name jtf_rs_roles_vl.role_name%type := p_role_name;
652: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
653: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
654: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
655: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
656: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
657: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
658: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
659: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;

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

652: l_role_desc jtf_rs_roles_vl.role_desc%type := p_role_desc;
653: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
654: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
655: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
656: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
657: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
658: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
659: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
660: l_object_version_number jtf_rs_roles_vl.object_version_number%type :=p_object_version_number;

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

653: l_role_type_code jtf_rs_roles_vl.role_type_code%type := p_role_type_code;
654: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
655: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
656: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
657: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
658: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
659: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
660: l_object_version_number jtf_rs_roles_vl.object_version_number%type :=p_object_version_number;
661: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;

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

654: l_seeded_flag jtf_rs_roles_vl.seeded_flag%type := p_seeded_flag;
655: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
656: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
657: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
658: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
659: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
660: l_object_version_number jtf_rs_roles_vl.object_version_number%type :=p_object_version_number;
661: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
662: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;

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

655: l_active_flag jtf_rs_roles_vl.active_flag%type := p_active_flag;
656: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
657: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
658: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
659: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
660: l_object_version_number jtf_rs_roles_vl.object_version_number%type :=p_object_version_number;
661: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
662: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
663: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;

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

656: l_member_flag jtf_rs_roles_vl.member_flag%type := p_member_flag;
657: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
658: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
659: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
660: l_object_version_number jtf_rs_roles_vl.object_version_number%type :=p_object_version_number;
661: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
662: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
663: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
664: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;

Line 661: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;

657: l_admin_flag jtf_rs_roles_vl.admin_flag%type := p_admin_flag;
658: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
659: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
660: l_object_version_number jtf_rs_roles_vl.object_version_number%type :=p_object_version_number;
661: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
662: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
663: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
664: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
665: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;

Line 662: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;

658: l_lead_flag jtf_rs_roles_vl.lead_flag%type := p_lead_flag;
659: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
660: l_object_version_number jtf_rs_roles_vl.object_version_number%type :=p_object_version_number;
661: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
662: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
663: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
664: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
665: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
666: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;

Line 663: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;

659: l_manager_flag jtf_rs_roles_vl.manager_flag%type := p_manager_flag;
660: l_object_version_number jtf_rs_roles_vl.object_version_number%type :=p_object_version_number;
661: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
662: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
663: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
664: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
665: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
666: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
667: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;

Line 664: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;

660: l_object_version_number jtf_rs_roles_vl.object_version_number%type :=p_object_version_number;
661: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
662: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
663: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
664: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
665: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
666: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
667: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
668: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;

Line 665: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;

661: l_attribute1 jtf_rs_roles_vl.attribute1%type := p_attribute1;
662: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
663: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
664: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
665: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
666: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
667: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
668: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
669: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;

Line 666: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;

662: l_attribute2 jtf_rs_roles_vl.attribute2%type := p_attribute2;
663: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
664: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
665: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
666: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
667: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
668: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
669: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
670: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;

Line 667: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;

663: l_attribute3 jtf_rs_roles_vl.attribute3%type := p_attribute3;
664: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
665: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
666: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
667: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
668: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
669: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
670: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
671: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;

Line 668: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;

664: l_attribute4 jtf_rs_roles_vl.attribute4%type := p_attribute4;
665: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
666: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
667: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
668: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
669: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
670: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
671: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
672: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;

Line 669: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;

665: l_attribute5 jtf_rs_roles_vl.attribute5%type := p_attribute5;
666: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
667: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
668: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
669: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
670: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
671: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
672: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
673: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;

Line 670: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;

666: l_attribute6 jtf_rs_roles_vl.attribute6%type := p_attribute6;
667: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
668: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
669: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
670: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
671: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
672: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
673: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
674: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;

Line 671: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;

667: l_attribute7 jtf_rs_roles_vl.attribute7%type := p_attribute7;
668: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
669: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
670: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
671: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
672: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
673: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
674: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
675: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;

Line 672: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;

668: l_attribute8 jtf_rs_roles_vl.attribute8%type := p_attribute8;
669: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
670: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
671: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
672: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
673: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
674: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
675: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
676: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;

Line 673: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;

669: l_attribute9 jtf_rs_roles_vl.attribute9%type := p_attribute9;
670: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
671: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
672: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
673: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
674: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
675: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
676: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;
677: L_BIND_DATA_ID NUMBER;

Line 674: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;

670: l_attribute10 jtf_rs_roles_vl.attribute10%type := p_attribute10;
671: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
672: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
673: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
674: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
675: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
676: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;
677: L_BIND_DATA_ID NUMBER;
678:

Line 675: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;

671: l_attribute11 jtf_rs_roles_vl.attribute11%type := p_attribute11;
672: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
673: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
674: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
675: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
676: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;
677: L_BIND_DATA_ID NUMBER;
678:
679:

Line 676: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;

672: l_attribute12 jtf_rs_roles_vl.attribute12%type := p_attribute12;
673: l_attribute13 jtf_rs_roles_vl.attribute13%type := p_attribute13;
674: l_attribute14 jtf_rs_roles_vl.attribute14%type := p_attribute14;
675: l_attribute15 jtf_rs_roles_vl.attribute15%type := p_attribute15;
676: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;
677: L_BIND_DATA_ID NUMBER;
678:
679:
680: CURSOR c_role_code (l_role_code IN jtf_rs_roles_vl.role_code%type) IS

Line 680: CURSOR c_role_code (l_role_code IN jtf_rs_roles_vl.role_code%type) IS

676: l_attribute_category jtf_rs_roles_vl.attribute_category%type := p_attribute_category;
677: L_BIND_DATA_ID NUMBER;
678:
679:
680: CURSOR c_role_code (l_role_code IN jtf_rs_roles_vl.role_code%type) IS
681: SELECT role_code
682: FROM jtf_rs_roles_vl
683: WHERE role_code = l_role_code;
684:

Line 682: FROM jtf_rs_roles_vl

678:
679:
680: CURSOR c_role_code (l_role_code IN jtf_rs_roles_vl.role_code%type) IS
681: SELECT role_code
682: FROM jtf_rs_roles_vl
683: WHERE role_code = l_role_code;
684:
685: CURSOR c_role_type_code ( l_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS
686: SELECT lookup_code from fnd_lookups

Line 685: CURSOR c_role_type_code ( l_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS

681: SELECT role_code
682: FROM jtf_rs_roles_vl
683: WHERE role_code = l_role_code;
684:
685: CURSOR c_role_type_code ( l_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS
686: SELECT lookup_code from fnd_lookups
687: WHERE LOOKUP_TYPE = 'JTF_RS_ROLE_TYPE'
688: AND lookup_code = l_role_type_code
689: AND enabled_flag = 'Y'

Line 694: CURSOR c_role_name_check(c_role_name IN jtf_rs_roles_vl.role_name%type, c_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS

690: AND trunc(sysdate) <= trunc(nvl(end_date_active,sysdate));
691:
692: Dummy_char varchar2(1);
693:
694: CURSOR c_role_name_check(c_role_name IN jtf_rs_roles_vl.role_name%type, c_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS
695: SELECT 'x'
696: FROM jtf_rs_roles_vl
697: WHERE upper(role_name) = c_role_name
698: AND role_type_code = c_role_type_code

Line 696: FROM jtf_rs_roles_vl

692: Dummy_char varchar2(1);
693:
694: CURSOR c_role_name_check(c_role_name IN jtf_rs_roles_vl.role_name%type, c_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS
695: SELECT 'x'
696: FROM jtf_rs_roles_vl
697: WHERE upper(role_name) = c_role_name
698: AND role_type_code = c_role_type_code
699: AND role_id <> p_role_id;
700:

Line 730: FROM jtf_rs_roles_vl

726: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
727: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
728: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
729: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute1, p_attribute_category) l_attribute_category
730: FROM jtf_rs_roles_vl
731: WHERE role_id = l_role_id;
732:
733: rs_role_rec c_rs_role_update%ROWTYPE;
734:

Line 882: -- FROM jtf_rs_roles_vl

878: --End of Resource Role Validation
879:
880: --Validate if the Seeded Flag is Checked
881: -- SELECT seeded_flag INTO l_seeded_flag
882: -- FROM jtf_rs_roles_vl
883: -- WHERE role_id = l_role_id;
884:
885: -- IF l_seeded_flag = 'Y' THEN
886: -- --dbms_output.put_line ('Seeded Data Cannot be Updated');

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

1305: ) IS
1306:
1307: l_api_version CONSTANT NUMBER := 1.0;
1308: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_ROLES';
1309: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
1310: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
1311: L_BIND_DATA_ID NUMBER;
1312: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
1313: -- added for NOCOPY handle in JTF_RESOURCE_UTL

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

1306:
1307: l_api_version CONSTANT NUMBER := 1.0;
1308: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_ROLES';
1309: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
1310: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
1311: L_BIND_DATA_ID NUMBER;
1312: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
1313: -- added for NOCOPY handle in JTF_RESOURCE_UTL
1314: l_role_id_out jtf_rs_roles_vl.role_id%type;

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

1308: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_ROLES';
1309: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
1310: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
1311: L_BIND_DATA_ID NUMBER;
1312: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
1313: -- added for NOCOPY handle in JTF_RESOURCE_UTL
1314: l_role_id_out jtf_rs_roles_vl.role_id%type;
1315:
1316: l_return_status VARCHAR2(2000);

Line 1314: l_role_id_out jtf_rs_roles_vl.role_id%type;

1310: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
1311: L_BIND_DATA_ID NUMBER;
1312: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
1313: -- added for NOCOPY handle in JTF_RESOURCE_UTL
1314: l_role_id_out jtf_rs_roles_vl.role_id%type;
1315:
1316: l_return_status VARCHAR2(2000);
1317: l_msg_count NUMBER;
1318: l_msg_data VARCHAR2(2000);

Line 1339: SELECT role_name from jtf_rs_roles_vl

1335:
1336: FUNCTION get_role_name(p_role_id IN NUMBER) return VARCHAR2 IS
1337: role_name jtf_Rs_roles_tl.role_name%type;
1338: cursor c_role_name is
1339: SELECT role_name from jtf_rs_roles_vl
1340: WHERE role_id = p_role_id;
1341: BEGIN
1342: OPEN c_role_name;
1343: FETCH c_role_name into role_name;