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_ROLE_RELATE_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 59: from jtf_rs_role_relations rlt,

55: is
56: select rlt.role_relate_id,
57: rlt.start_date_active,
58: rlt.end_date_active
59: from jtf_rs_role_relations rlt,
60: jtf_rs_group_members mem
61: where mem.resource_id = p_resource_id
62: and nvl(mem.delete_flag, 'N') <> 'Y'
63: and rlt.role_resource_id = mem.group_member_id

Line 77: from jtf_rs_role_relations rlt,

73: is
74: select rlt.role_relate_id,
75: rlt.start_date_active,
76: rlt.end_date_active
77: from jtf_rs_role_relations rlt,
78: jtf_rs_team_members mem
79: where mem.team_resource_id = p_resource_id
80: and mem.resource_type = 'INDIVIDUAL'
81: and nvl(mem.delete_flag, 'N') <> 'Y'

Line 222: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,

218: PROCEDURE create_resource_role_relate
219: (P_API_VERSION IN NUMBER,
220: P_INIT_MSG_LIST IN VARCHAR2,
221: P_COMMIT IN VARCHAR2,
222: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
223: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
224: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,

Line 223: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

219: (P_API_VERSION IN NUMBER,
220: P_INIT_MSG_LIST IN VARCHAR2,
221: P_COMMIT IN VARCHAR2,
222: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
223: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
224: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,

Line 224: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

220: P_INIT_MSG_LIST IN VARCHAR2,
221: P_COMMIT IN VARCHAR2,
222: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
223: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
224: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,

Line 225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

221: P_COMMIT IN VARCHAR2,
222: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
223: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
224: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,

Line 226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,

222: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
223: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
224: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
230: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,

Line 227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,

223: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
224: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
230: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
231: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,

Line 228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,

224: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
230: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
231: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
232: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,

Line 229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,

225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
230: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
231: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
232: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
233: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,

Line 230: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,

226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
230: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
231: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
232: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
233: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
234: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,

Line 231: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,

227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
230: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
231: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
232: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
233: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
234: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
235: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,

Line 232: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,

228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
230: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
231: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
232: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
233: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
234: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
235: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
236: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,

Line 233: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,

229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
230: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
231: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
232: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
233: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
234: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
235: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
236: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
237: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,

Line 234: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,

230: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
231: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
232: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
233: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
234: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
235: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
236: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
237: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
238: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,

Line 235: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,

231: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
232: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
233: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
234: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
235: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
236: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
237: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
238: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
239: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,

Line 236: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,

232: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
233: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
234: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
235: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
236: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
237: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
238: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
239: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
240: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,

Line 237: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,

233: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
234: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
235: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
236: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
237: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
238: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
239: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
240: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
241: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,

Line 238: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,

234: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
235: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
236: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
237: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
238: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
239: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
240: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
241: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
242: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,

Line 239: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,

235: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
236: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
237: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
238: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
239: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
240: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
241: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
242: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
243: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 240: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,

236: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
237: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
238: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
239: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
240: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
241: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
242: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
243: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
244: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 241: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,

237: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
238: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
239: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
240: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
241: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
242: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
243: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
244: X_MSG_COUNT OUT NOCOPY NUMBER,
245: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 242: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,

238: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
239: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
240: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
241: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
242: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
243: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
244: X_MSG_COUNT OUT NOCOPY NUMBER,
245: X_MSG_DATA OUT NOCOPY VARCHAR2,
246: X_ROLE_RELATE_ID OUT NOCOPY JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE

Line 246: X_ROLE_RELATE_ID OUT NOCOPY JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE

242: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
243: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
244: X_MSG_COUNT OUT NOCOPY NUMBER,
245: X_MSG_DATA OUT NOCOPY VARCHAR2,
246: X_ROLE_RELATE_ID OUT NOCOPY JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE
247: )IS
248:
249: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_ROLE_RELATE';
250: l_api_version CONSTANT NUMBER := 1.0;

Line 254: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE;

250: l_api_version CONSTANT NUMBER := 1.0;
251: l_bind_data_id NUMBER;
252:
253: /* Moved the initial assignment of below variables to inside begin */
254: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE;
255: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE;
256: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE;
257: -- added truncate on 12 feb 2002
258: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

Line 255: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE;

251: l_bind_data_id NUMBER;
252:
253: /* Moved the initial assignment of below variables to inside begin */
254: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE;
255: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE;
256: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE;
257: -- added truncate on 12 feb 2002
258: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
259: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

Line 256: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE;

252:
253: /* Moved the initial assignment of below variables to inside begin */
254: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE;
255: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE;
256: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE;
257: -- added truncate on 12 feb 2002
258: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
259: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
260:

Line 258: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

254: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE;
255: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE;
256: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE;
257: -- added truncate on 12 feb 2002
258: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
259: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
260:
261: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
262: l_return_code VARCHAR2(100);

Line 259: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

255: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE;
256: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE;
257: -- added truncate on 12 feb 2002
258: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
259: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
260:
261: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
262: l_return_code VARCHAR2(100);
263: l_count NUMBER;

Line 261: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

257: -- added truncate on 12 feb 2002
258: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
259: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
260:
261: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
262: l_return_code VARCHAR2(100);
263: l_count NUMBER;
264: l_data VARCHAR2(200);
265:

Line 292: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

288: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
289: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;
290:
291: --changed the date comparison in the cursor 07/07/00
292: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
293: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
294: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
295: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
296: IS

Line 294: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

290:
291: --changed the date comparison in the cursor 07/07/00
292: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
293: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
294: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
295: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
296: IS
297: SELECT 'X'
298: FROM jtf_rs_role_relations

Line 295: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )

291: --changed the date comparison in the cursor 07/07/00
292: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
293: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
294: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
295: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
296: IS
297: SELECT 'X'
298: FROM jtf_rs_role_relations
299: WHERE role_resource_type = 'RS_INDIVIDUAL'

Line 298: FROM jtf_rs_role_relations

294: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
295: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
296: IS
297: SELECT 'X'
298: FROM jtf_rs_role_relations
299: WHERE role_resource_type = 'RS_INDIVIDUAL'
300: AND role_resource_id = ll_role_resource_id
301: AND role_id = ll_role_id
302: AND nvl(delete_flag, '0') <> 'Y'

Line 313: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

309: AND nvl(delete_flag, '0') <> 'Y';
310:
311: res_role_rec res_role_cur%rowtype;
312:
313: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
314: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
315: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
316: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
317: IS

Line 315: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

311: res_role_rec res_role_cur%rowtype;
312:
313: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
314: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
315: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
316: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
317: IS
318: SELECT 'X'
319: FROM jtf_rs_role_relations

Line 316: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )

312:
313: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
314: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
315: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
316: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
317: IS
318: SELECT 'X'
319: FROM jtf_rs_role_relations
320: WHERE role_resource_type = 'RS_GROUP'

Line 319: FROM jtf_rs_role_relations

315: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
316: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
317: IS
318: SELECT 'X'
319: FROM jtf_rs_role_relations
320: WHERE role_resource_type = 'RS_GROUP'
321: AND role_resource_id = ll_role_resource_id
322: AND role_id = ll_role_id
323: AND start_date_active <= ll_start_date_active

Line 334: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,

330: grp_role_rec grp_role_cur%rowtype;
331:
332: l_role_valid boolean := FALSE;
333:
334: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
335: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
336: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE)
337: IS
338: SELECT start_date_active,

Line 335: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

331:
332: l_role_valid boolean := FALSE;
333:
334: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
335: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
336: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE)
337: IS
338: SELECT start_date_active,
339: end_date_active

Line 336: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE)

332: l_role_valid boolean := FALSE;
333:
334: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
335: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
336: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE)
337: IS
338: SELECT start_date_active,
339: end_date_active
340: FROM jtf_rs_role_relations

Line 340: FROM jtf_rs_role_relations

336: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE)
337: IS
338: SELECT start_date_active,
339: end_date_active
340: FROM jtf_rs_role_relations
341: WHERE role_resource_type = ll_role_resource_type
342: AND role_resource_id = ll_role_resource_id
343: AND role_id = ll_role_id
344: AND nvl(delete_flag, 'N') <> 'Y';

Line 414: jtf_rs_role_relations RR1

410: jtf_rs_group_members GM1,
411: jtf_rs_group_members GM2,
412: jtf_rs_group_usages GU1,
413: jtf_rs_group_usages GU2,
414: jtf_rs_role_relations RR1
415: /* commented the below line to improve the performance. We are not using this table in the select statement. */
416: -- jtf_rs_role_relations RR2
417: WHERE GM2.group_member_id = l_member_id
418: AND G1.group_id = GM1.group_id

Line 416: -- jtf_rs_role_relations RR2

412: jtf_rs_group_usages GU1,
413: jtf_rs_group_usages GU2,
414: jtf_rs_role_relations RR1
415: /* commented the below line to improve the performance. We are not using this table in the select statement. */
416: -- jtf_rs_role_relations RR2
417: WHERE GM2.group_member_id = l_member_id
418: AND G1.group_id = GM1.group_id
419: AND G2.group_id = GM2.group_id
420: AND nvl(GM1.delete_flag, 'N') <> 'Y'

Line 449: jtf_rs_role_relations rel

445: cursor get_group_cur(l_role_relate_id number)
446: is
447: select mem.group_id
448: from jtf_rs_group_members mem,
449: jtf_rs_role_relations rel
450: where rel.role_relate_id = l_role_relate_id
451: and rel.role_resource_id = mem.group_member_id;
452:
453: l_group_id number;

Line 878: select jtf_rs_role_relations_s.nextval

874:
875: --dbms_output.put_line ('Debug Message 19');
876:
877: --get the primary key sequence value
878: select jtf_rs_role_relations_s.nextval
879: into l_role_relate_id
880: from dual;
881:
882:

Line 920: jtf_rs_role_relations_pkg.insert_row(X_ROWID => l_rowid,

916: */
917: --dbms_output.put_line ('l_start_date_active' || to_char(l_start_date_active, 'DD-MM-YYYY HH24:MI:SS'));
918:
919: --call table handler to insert record in role relations
920: jtf_rs_role_relations_pkg.insert_row(X_ROWID => l_rowid,
921: X_ROLE_RELATE_ID => l_role_relate_id,
922: X_ATTRIBUTE9 => p_attribute9,
923: X_ATTRIBUTE10 => p_attribute10,
924: X_ATTRIBUTE11 => p_attribute11,

Line 1268: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

1264: PROCEDURE update_resource_role_relate
1265: (P_API_VERSION IN NUMBER,
1266: P_INIT_MSG_LIST IN VARCHAR2,
1267: P_COMMIT IN VARCHAR2,
1268: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1269: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1270: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1271: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1272: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,

Line 1269: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

1265: (P_API_VERSION IN NUMBER,
1266: P_INIT_MSG_LIST IN VARCHAR2,
1267: P_COMMIT IN VARCHAR2,
1268: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1269: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1270: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1271: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1272: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1273: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,

Line 1270: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,

1266: P_INIT_MSG_LIST IN VARCHAR2,
1267: P_COMMIT IN VARCHAR2,
1268: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1269: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1270: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1271: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1272: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1273: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1274: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,

Line 1271: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

1267: P_COMMIT IN VARCHAR2,
1268: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1269: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1270: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1271: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1272: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1273: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1274: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1275: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,

Line 1272: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,

1268: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1269: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1270: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1271: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1272: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1273: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1274: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1275: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1276: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,

Line 1273: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,

1269: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1270: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1271: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1272: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1273: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1274: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1275: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1276: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1277: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,

Line 1274: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,

1270: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1271: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1272: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1273: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1274: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1275: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1276: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1277: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1278: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,

Line 1275: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,

1271: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1272: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1273: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1274: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1275: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1276: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1277: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1278: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1279: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,

Line 1276: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,

1272: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1273: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1274: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1275: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1276: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1277: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1278: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1279: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1280: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,

Line 1277: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,

1273: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1274: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1275: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1276: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1277: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1278: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1279: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1280: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1281: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,

Line 1278: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,

1274: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1275: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1276: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1277: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1278: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1279: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1280: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1281: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1282: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,

Line 1279: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,

1275: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1276: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1277: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1278: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1279: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1280: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1281: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1282: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1283: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,

Line 1280: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,

1276: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1277: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1278: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1279: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1280: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1281: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1282: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1283: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1284: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,

Line 1281: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,

1277: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1278: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1279: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1280: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1281: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1282: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1283: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1284: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1285: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,

Line 1282: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,

1278: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1279: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1280: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1281: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1282: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1283: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1284: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1285: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1286: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,

Line 1283: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,

1279: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1280: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1281: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1282: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1283: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1284: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1285: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1286: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
1287: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,

Line 1284: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,

1280: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1281: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1282: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1283: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1284: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1285: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1286: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
1287: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
1288: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1285: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,

1281: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1282: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1283: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1284: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1285: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1286: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
1287: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
1288: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1289: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1286: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,

1282: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1283: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1284: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1285: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1286: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
1287: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
1288: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1289: X_MSG_COUNT OUT NOCOPY NUMBER,
1290: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1287: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,

1283: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1284: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1285: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1286: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
1287: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
1288: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1289: X_MSG_COUNT OUT NOCOPY NUMBER,
1290: X_MSG_DATA OUT NOCOPY VARCHAR2
1291: )IS

Line 1301: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;

1297: l_count NUMBER;
1298: l_data VARCHAR2(200);
1299:
1300:
1301: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
1302: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1303: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1304: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1305: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;

Line 1302: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;

1298: l_data VARCHAR2(200);
1299:
1300:
1301: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
1302: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1303: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1304: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1305: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1306: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;

Line 1303: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;

1299:
1300:
1301: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
1302: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1303: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1304: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1305: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1306: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1307: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;

Line 1304: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;

1300:
1301: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
1302: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1303: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1304: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1305: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1306: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1307: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1308: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;

Line 1305: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;

1301: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
1302: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1303: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1304: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1305: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1306: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1307: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1308: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1309: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;

Line 1306: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;

1302: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1303: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1304: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1305: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1306: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1307: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1308: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1309: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1310: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;

Line 1307: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;

1303: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1304: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1305: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1306: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1307: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1308: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1309: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1310: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1311: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;

Line 1308: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;

1304: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1305: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1306: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1307: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1308: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1309: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1310: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1311: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1312: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;

Line 1309: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;

1305: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1306: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1307: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1308: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1309: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1310: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1311: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1312: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1313: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;

Line 1310: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;

1306: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1307: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1308: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1309: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1310: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1311: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1312: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1313: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1314: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;

Line 1311: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;

1307: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1308: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1309: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1310: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1311: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1312: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1313: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1314: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1315: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;

Line 1312: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;

1308: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1309: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1310: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1311: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1312: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1313: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1314: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1315: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1316: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 1313: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;

1309: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1310: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1311: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1312: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1313: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1314: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1315: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1316: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
1317:

Line 1314: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;

1310: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1311: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1312: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1313: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1314: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1315: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1316: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
1317:
1318:

Line 1315: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;

1311: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1312: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1313: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1314: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1315: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1316: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
1317:
1318:
1319: CURSOR role_relate_cur(ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

Line 1316: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;

1312: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1313: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1314: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1315: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1316: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
1317:
1318:
1319: CURSOR role_relate_cur(ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1320: IS

Line 1319: CURSOR role_relate_cur(ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

1315: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1316: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
1317:
1318:
1319: CURSOR role_relate_cur(ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1320: IS
1321: SELECT role_resource_type,
1322: role_resource_id,
1323: role_id,

Line 1344: FROM jtf_rs_role_relations

1340: attribute13,
1341: attribute14,
1342: attribute15,
1343: attribute_category
1344: FROM jtf_rs_role_relations
1345: WHERE role_relate_id = ll_role_relate_id
1346: AND nvl(delete_flag, '0') <> 'Y';
1347:
1348: role_relate_rec role_relate_cur%rowtype;

Line 1350: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ;

1346: AND nvl(delete_flag, '0') <> 'Y';
1347:
1348: role_relate_rec role_relate_cur%rowtype;
1349:
1350: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ;
1351: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;
1352: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1353: -- added trunc on 12th feb 2002
1354: /* Moved the initial assignment of below variables to inside begin */

Line 1351: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;

1347:
1348: role_relate_rec role_relate_cur%rowtype;
1349:
1350: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ;
1351: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;
1352: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1353: -- added trunc on 12th feb 2002
1354: /* Moved the initial assignment of below variables to inside begin */
1355: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

Line 1352: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;

1348: role_relate_rec role_relate_cur%rowtype;
1349:
1350: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ;
1351: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;
1352: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1353: -- added trunc on 12th feb 2002
1354: /* Moved the initial assignment of below variables to inside begin */
1355: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1356: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

Line 1355: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

1351: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;
1352: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1353: -- added trunc on 12th feb 2002
1354: /* Moved the initial assignment of below variables to inside begin */
1355: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1356: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1357: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1358: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1359: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;

Line 1356: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

1352: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1353: -- added trunc on 12th feb 2002
1354: /* Moved the initial assignment of below variables to inside begin */
1355: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1356: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1357: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1358: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1359: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;
1360:

Line 1357: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

1353: -- added trunc on 12th feb 2002
1354: /* Moved the initial assignment of below variables to inside begin */
1355: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1356: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1357: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1358: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1359: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;
1360:
1361: l_return_status VARCHAR2(200);

Line 1358: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;

1354: /* Moved the initial assignment of below variables to inside begin */
1355: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1356: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1357: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1358: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1359: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;
1360:
1361: l_return_status VARCHAR2(200);
1362: l_msg_count NUMBER;

Line 1359: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;

1355: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1356: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1357: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1358: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1359: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;
1360:
1361: l_return_status VARCHAR2(200);
1362: l_msg_count NUMBER;
1363: l_msg_data VARCHAR2(200);

Line 1397: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

1393: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1394: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;
1395:
1396: --changed the date comparison in the cursor 07/07/00
1397: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1398: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1399: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1400: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1401: IS

Line 1399: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

1395:
1396: --changed the date comparison in the cursor 07/07/00
1397: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1398: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1399: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1400: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1401: IS
1402: SELECT 'X'
1403: FROM jtf_rs_role_relations

Line 1400: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )

1396: --changed the date comparison in the cursor 07/07/00
1397: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1398: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1399: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1400: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1401: IS
1402: SELECT 'X'
1403: FROM jtf_rs_role_relations
1404: WHERE role_resource_type = 'RS_INDIVIDUAL'

Line 1403: FROM jtf_rs_role_relations

1399: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1400: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1401: IS
1402: SELECT 'X'
1403: FROM jtf_rs_role_relations
1404: WHERE role_resource_type = 'RS_INDIVIDUAL'
1405: AND role_resource_id = ll_role_resource_id
1406: AND role_id = ll_role_id
1407: AND to_date(to_char(start_date_active , 'dd-MM-yyyy'),'dd-MM-yyyy') <=

Line 1417: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

1413: AND nvl(delete_flag, '0') <> 'Y';
1414:
1415: res_role_rec res_role_cur%rowtype;
1416:
1417: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1418: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1419: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1420: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1421: IS

Line 1419: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

1415: res_role_rec res_role_cur%rowtype;
1416:
1417: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1418: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1419: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1420: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1421: IS
1422: SELECT 'X'
1423: FROM jtf_rs_role_relations

Line 1420: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )

1416:
1417: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1418: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1419: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1420: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1421: IS
1422: SELECT 'X'
1423: FROM jtf_rs_role_relations
1424: WHERE role_resource_type = 'RS_GROUP'

Line 1423: FROM jtf_rs_role_relations

1419: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1420: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1421: IS
1422: SELECT 'X'
1423: FROM jtf_rs_role_relations
1424: WHERE role_resource_type = 'RS_GROUP'
1425: AND role_resource_id = ll_role_resource_id
1426: AND role_id = ll_role_id
1427: AND start_date_active <= ll_start_date_active

Line 1436: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,

1432:
1433: grp_role_rec grp_role_cur%rowtype;
1434:
1435:
1436: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
1437: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1438: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
1439: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1440: IS

Line 1437: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

1433: grp_role_rec grp_role_cur%rowtype;
1434:
1435:
1436: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
1437: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1438: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
1439: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1440: IS
1441: SELECT start_date_active,

Line 1438: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

1434:
1435:
1436: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
1437: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1438: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
1439: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1440: IS
1441: SELECT start_date_active,
1442: end_date_active

Line 1439: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

1435:
1436: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
1437: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1438: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
1439: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1440: IS
1441: SELECT start_date_active,
1442: end_date_active
1443: FROM jtf_rs_role_relations

Line 1443: FROM jtf_rs_role_relations

1439: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1440: IS
1441: SELECT start_date_active,
1442: end_date_active
1443: FROM jtf_rs_role_relations
1444: WHERE role_relate_id <> ll_role_relate_id
1445: AND role_resource_type = ll_role_resource_type
1446: AND role_resource_id = ll_role_resource_id
1447: AND role_id = ll_role_id

Line 1518: jtf_rs_role_relations RR1

1514: jtf_rs_group_members GM1,
1515: jtf_rs_group_members GM2,
1516: jtf_rs_group_usages GU1,
1517: jtf_rs_group_usages GU2,
1518: jtf_rs_role_relations RR1
1519: /* commented the below line to improve the performance. We are not using this table in the select statement. */
1520: -- jtf_rs_role_relations RR2
1521: WHERE GM2.group_member_id = l_member_id
1522: AND G1.group_id = GM1.group_id

Line 1520: -- jtf_rs_role_relations RR2

1516: jtf_rs_group_usages GU1,
1517: jtf_rs_group_usages GU2,
1518: jtf_rs_role_relations RR1
1519: /* commented the below line to improve the performance. We are not using this table in the select statement. */
1520: -- jtf_rs_role_relations RR2
1521: WHERE GM2.group_member_id = l_member_id
1522: AND G1.group_id = GM1.group_id
1523: AND G2.group_id = GM2.group_id
1524: AND nvl(GM1.delete_flag, 'N') <> 'Y'

Line 1547: CURSOR res_team_cur(l_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

1543: c_exclusive_group_check_rec c_exclusive_group_check_cur%rowtype;
1544:
1545: /*changed + 1 logic */
1546: --cursor to check for team member dates for resource
1547: CURSOR res_team_cur(l_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1548: l_start_date_active DATE,
1549: L_end_date_active DATE ,
1550: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE )
1551: IS

Line 1554: jtf_rs_role_relations rlt

1550: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE )
1551: IS
1552: SELECT 'X'
1553: FROM jtf_rs_team_members mem,
1554: jtf_rs_role_relations rlt
1555: WHERE mem.team_resource_id = l_resource_id
1556: AND mem.resource_type = 'INDIVIDUAL'
1557: AND nvl(mem.delete_flag, 'N') <> 'Y'
1558: AND mem.team_member_id = rlt.role_resource_id

Line 1571: CURSOR res_group_cur(l_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

1567: res_team_rec res_team_cur%rowtype;
1568:
1569: /*changed + 1 logic */
1570: --cursor to check for group member dates for resource
1571: CURSOR res_group_cur(l_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1572: l_start_date_active DATE,
1573: L_end_date_active DATE ,
1574: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE)
1575: IS

Line 1578: jtf_rs_role_relations rlt

1574: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE)
1575: IS
1576: SELECT rlt.role_relate_id
1577: FROM jtf_rs_group_members mem,
1578: jtf_rs_role_relations rlt
1579: WHERE mem.resource_id = l_resource_id
1580: AND nvl(mem.delete_flag, 'N') <> 'Y'
1581: AND mem.group_member_id = rlt.role_resource_id
1582: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 1598: jtf_rs_role_relations rel

1594: cursor get_group_cur(l_role_relate_id number)
1595: is
1596: select mem.group_id
1597: from jtf_rs_group_members mem,
1598: jtf_rs_role_relations rel
1599: where rel.role_relate_id = l_role_relate_id
1600: and rel.role_resource_id = mem.group_member_id;
1601:
1602:

Line 2204: jtf_rs_role_relations_pkg.lock_row(

2200:
2201: --call update table handler
2202: BEGIN
2203:
2204: jtf_rs_role_relations_pkg.lock_row(
2205: x_role_relate_id => l_role_relate_id,
2206: x_object_version_number => p_object_version_num
2207: );
2208:

Line 2273: jtf_rs_role_relations_pkg.update_row(X_ROLE_RELATE_ID => l_role_relate_id,

2269: end;
2270:
2271: /* End of publish API call */
2272:
2273: jtf_rs_role_relations_pkg.update_row(X_ROLE_RELATE_ID => l_role_relate_id,
2274: X_ATTRIBUTE9 => l_attribute9,
2275: X_ATTRIBUTE10 => l_attribute10,
2276: X_ATTRIBUTE11 => l_attribute11,
2277: X_ATTRIBUTE12 => l_attribute12,

Line 2599: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

2595: PROCEDURE delete_resource_role_relate
2596: (P_API_VERSION IN NUMBER,
2597: P_INIT_MSG_LIST IN VARCHAR2,
2598: P_COMMIT IN VARCHAR2,
2599: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
2600: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
2601: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2602: X_MSG_COUNT OUT NOCOPY NUMBER,
2603: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 2600: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

2596: (P_API_VERSION IN NUMBER,
2597: P_INIT_MSG_LIST IN VARCHAR2,
2598: P_COMMIT IN VARCHAR2,
2599: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
2600: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
2601: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2602: X_MSG_COUNT OUT NOCOPY NUMBER,
2603: X_MSG_DATA OUT NOCOPY VARCHAR2
2604: )IS

Line 2607: CURSOR chk_type_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

2603: X_MSG_DATA OUT NOCOPY VARCHAR2
2604: )IS
2605:
2606:
2607: CURSOR chk_type_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
2608: IS
2609: SELECT role_resource_type,
2610: role_resource_id,
2611: role_id,

Line 2631: FROM jtf_rs_role_relations

2627: attribute13,
2628: attribute14,
2629: attribute15,
2630: attribute_category
2631: FROM jtf_rs_role_relations
2632: WHERE role_relate_id = l_role_relate_id;
2633:
2634:
2635: chk_type_rec chk_type_cur%rowtype;

Line 2639: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

2635: chk_type_rec chk_type_cur%rowtype;
2636:
2637: CURSOR chk_grp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2638: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2639: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2640: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2641: IS
2642: SELECT 'x'
2643: FROM jtf_rs_role_relations rlt,

Line 2640: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)

2636:
2637: CURSOR chk_grp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2638: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2639: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2640: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2641: IS
2642: SELECT 'x'
2643: FROM jtf_rs_role_relations rlt,
2644: jtf_rs_group_members mem

Line 2643: FROM jtf_rs_role_relations rlt,

2639: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2640: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2641: IS
2642: SELECT 'x'
2643: FROM jtf_rs_role_relations rlt,
2644: jtf_rs_group_members mem
2645: WHERE mem.resource_id = l_resource_id
2646: AND rlt.role_resource_id = mem.group_member_id
2647: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 2658: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

2654: chk_grp_rec chk_grp_cur%rowtype;
2655:
2656: CURSOR chk_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2657: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2658: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2659: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2660: IS
2661: SELECT 'x'
2662: FROM jtf_rs_role_relations rlt,

Line 2659: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)

2655:
2656: CURSOR chk_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2657: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2658: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2659: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2660: IS
2661: SELECT 'x'
2662: FROM jtf_rs_role_relations rlt,
2663: jtf_rs_team_members mem

Line 2662: FROM jtf_rs_role_relations rlt,

2658: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2659: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2660: IS
2661: SELECT 'x'
2662: FROM jtf_rs_role_relations rlt,
2663: jtf_rs_team_members mem
2664: WHERE mem.team_resource_id = l_resource_id
2665: AND mem.resource_type <> 'GROUP'
2666: AND rlt.role_resource_id = mem.team_member_id

Line 2679: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

2675: chk_team_rec chk_team_cur%rowtype;
2676:
2677:
2678: /* Moved the initial assignment of below variable to inside begin */
2679: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
2680:
2681: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_ROLE_RELATE';
2682: l_api_version CONSTANT NUMBER :=1.0;
2683: l_bind_data_id number;

Line 2695: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;

2691: l_return_code VARCHAR2(100);
2692: l_count NUMBER;
2693: l_data VARCHAR2(200);
2694:
2695: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
2696: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2697: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2698: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2699: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;

Line 2696: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;

2692: l_count NUMBER;
2693: l_data VARCHAR2(200);
2694:
2695: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
2696: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2697: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2698: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2699: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2700: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;

Line 2697: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;

2693: l_data VARCHAR2(200);
2694:
2695: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
2696: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2697: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2698: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2699: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2700: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2701: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;

Line 2698: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;

2694:
2695: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
2696: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2697: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2698: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2699: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2700: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2701: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2702: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;

Line 2699: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;

2695: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
2696: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2697: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2698: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2699: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2700: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2701: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2702: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2703: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;

Line 2700: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;

2696: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2697: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2698: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2699: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2700: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2701: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2702: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2703: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2704: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;

Line 2701: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;

2697: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2698: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2699: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2700: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2701: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2702: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2703: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2704: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2705: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;

Line 2702: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;

2698: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2699: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2700: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2701: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2702: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2703: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2704: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2705: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2706: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;

Line 2703: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;

2699: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2700: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2701: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2702: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2703: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2704: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2705: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2706: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2707: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;

Line 2704: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;

2700: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2701: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2702: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2703: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2704: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2705: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2706: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2707: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2708: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;

Line 2705: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;

2701: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2702: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2703: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2704: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2705: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2706: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2707: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2708: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2709: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;

Line 2706: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;

2702: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2703: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2704: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2705: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2706: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2707: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2708: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2709: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
2710: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 2707: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;

2703: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2704: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2705: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2706: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2707: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2708: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2709: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
2710: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
2711:

Line 2708: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;

2704: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2705: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2706: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2707: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2708: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2709: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
2710: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
2711:
2712: l_return_status VARCHAR2(200);

Line 2709: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;

2705: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2706: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2707: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2708: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2709: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
2710: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
2711:
2712: l_return_status VARCHAR2(200);
2713: l_msg_count NUMBER;

Line 2710: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;

2706: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2707: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2708: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2709: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
2710: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
2711:
2712: l_return_status VARCHAR2(200);
2713: l_msg_count NUMBER;
2714: l_msg_data VARCHAR2(200);

Line 2720: jtf_rs_role_relations rel

2716: cursor get_group_cur(l_role_relate_id number)
2717: is
2718: select mem.group_id
2719: from jtf_rs_group_members mem,
2720: jtf_rs_role_relations rel
2721: where rel.role_relate_id = l_role_relate_id
2722: and rel.role_resource_id = mem.group_member_id;
2723:
2724: l_group_id number;

Line 2938: jtf_rs_role_relations_pkg.update_row(

2934: END IF;
2935:
2936:
2937: --call update api to set the delete flag to 'Y'
2938: jtf_rs_role_relations_pkg.update_row(
2939: X_ROLE_RELATE_ID => l_role_relate_id,
2940: X_ATTRIBUTE9 => l_attribute9,
2941: X_ATTRIBUTE10 => l_attribute10,
2942: X_ATTRIBUTE11 => l_attribute11,