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 293: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

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

Line 295: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

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

Line 296: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )

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

Line 299: FROM jtf_rs_role_relations

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

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

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

Line 316: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

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

Line 317: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )

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

Line 320: FROM jtf_rs_role_relations

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

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

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

Line 336: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

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

Line 337: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE)

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

Line 341: FROM jtf_rs_role_relations

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

Line 416: jtf_rs_role_relations RR1

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

Line 418: -- jtf_rs_role_relations RR2

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

Line 451: jtf_rs_role_relations rel

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

Line 892: select jtf_rs_role_relations_s.nextval

888:
889: --dbms_output.put_line ('Debug Message 19');
890:
891: --get the primary key sequence value
892: select jtf_rs_role_relations_s.nextval
893: into l_role_relate_id
894: from dual;
895:
896:

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

930: */
931: --dbms_output.put_line ('l_start_date_active' || to_char(l_start_date_active, 'DD-MM-YYYY HH24:MI:SS'));
932:
933: --call table handler to insert record in role relations
934: jtf_rs_role_relations_pkg.insert_row(X_ROWID => l_rowid,
935: X_ROLE_RELATE_ID => l_role_relate_id,
936: X_ATTRIBUTE9 => p_attribute9,
937: X_ATTRIBUTE10 => p_attribute10,
938: X_ATTRIBUTE11 => p_attribute11,

Line 1282: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

1278: PROCEDURE update_resource_role_relate
1279: (P_API_VERSION IN NUMBER,
1280: P_INIT_MSG_LIST IN VARCHAR2,
1281: P_COMMIT IN VARCHAR2,
1282: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1283: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1284: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1285: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,

Line 1283: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

1279: (P_API_VERSION IN NUMBER,
1280: P_INIT_MSG_LIST IN VARCHAR2,
1281: P_COMMIT IN VARCHAR2,
1282: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1283: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1284: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1285: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,

Line 1284: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,

1280: P_INIT_MSG_LIST IN VARCHAR2,
1281: P_COMMIT IN VARCHAR2,
1282: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1283: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1284: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1285: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1288: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,

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

1281: P_COMMIT IN VARCHAR2,
1282: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1283: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1284: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1285: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1288: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1289: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,

Line 1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,

1282: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1283: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1284: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1285: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1288: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1289: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1290: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,

Line 1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,

1283: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1284: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1285: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1288: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1289: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1290: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1291: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,

Line 1288: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,

1284: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1285: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1288: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1289: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1290: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1291: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1292: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,

Line 1289: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,

1285: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1288: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1289: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1290: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1291: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1292: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1293: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,

Line 1290: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,

1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1288: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1289: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1290: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1291: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1292: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1293: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1294: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,

Line 1291: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,

1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
1288: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1289: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1290: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1291: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1292: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1293: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1294: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1295: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,

Line 1292: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,

1288: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
1289: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1290: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1291: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1292: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1293: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1294: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1295: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1296: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,

Line 1293: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,

1289: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,
1290: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1291: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1292: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1293: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1294: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1295: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1296: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1297: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,

Line 1294: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,

1290: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE,
1291: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1292: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1293: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1294: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1295: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1296: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1297: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1298: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,

Line 1295: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,

1291: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE,
1292: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1293: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1294: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1295: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1296: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1297: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1298: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1299: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,

Line 1296: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,

1292: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE,
1293: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1294: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1295: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1296: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1297: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1298: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1299: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1300: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,

Line 1297: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,

1293: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE,
1294: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1295: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1296: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1297: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1298: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1299: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1300: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
1301: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,

Line 1298: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,

1294: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE,
1295: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1296: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1297: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1298: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1299: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1300: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
1301: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
1302: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1299: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,

1295: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE,
1296: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1297: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1298: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1299: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1300: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
1301: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
1302: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1303: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1300: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,

1296: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE,
1297: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1298: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1299: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1300: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
1301: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
1302: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1303: X_MSG_COUNT OUT NOCOPY NUMBER,
1304: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1301: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,

1297: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE,
1298: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE,
1299: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE,
1300: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE,
1301: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
1302: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1303: X_MSG_COUNT OUT NOCOPY NUMBER,
1304: X_MSG_DATA OUT NOCOPY VARCHAR2
1305: )IS

Line 1315: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;

1311: l_count NUMBER;
1312: l_data VARCHAR2(200);
1313:
1314:
1315: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
1316: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1317: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1318: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1319: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;

Line 1316: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;

1312: l_data VARCHAR2(200);
1313:
1314:
1315: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
1316: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1317: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1318: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1319: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1320: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;

Line 1317: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;

1313:
1314:
1315: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
1316: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1317: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1318: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1319: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1320: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1321: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;

Line 1318: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;

1314:
1315: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
1316: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1317: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1318: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1319: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1320: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1321: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1322: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;

Line 1319: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;

1315: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
1316: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1317: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1318: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1319: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1320: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1321: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1322: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1323: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;

Line 1320: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;

1316: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
1317: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1318: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1319: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1320: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1321: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1322: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1323: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1324: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;

Line 1321: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;

1317: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
1318: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1319: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1320: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1321: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1322: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1323: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1324: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1325: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;

Line 1322: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;

1318: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
1319: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1320: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1321: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1322: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1323: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1324: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1325: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1326: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;

Line 1323: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;

1319: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
1320: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1321: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1322: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1323: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1324: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1325: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1326: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1327: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;

Line 1324: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;

1320: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
1321: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1322: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1323: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1324: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1325: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1326: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1327: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1328: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;

Line 1325: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;

1321: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
1322: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1323: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1324: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1325: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1326: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1327: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1328: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1329: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;

Line 1326: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;

1322: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
1323: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1324: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1325: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1326: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1327: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1328: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1329: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1330: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 1327: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;

1323: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
1324: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1325: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1326: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1327: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1328: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1329: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1330: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
1331:

Line 1328: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;

1324: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
1325: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1326: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1327: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1328: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1329: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1330: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
1331:
1332:

Line 1329: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;

1325: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
1326: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1327: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1328: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1329: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1330: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
1331:
1332:
1333: CURSOR role_relate_cur(ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

Line 1330: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;

1326: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
1327: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
1328: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
1329: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1330: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
1331:
1332:
1333: CURSOR role_relate_cur(ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1334: IS

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

1329: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
1330: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
1331:
1332:
1333: CURSOR role_relate_cur(ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1334: IS
1335: SELECT role_resource_type,
1336: role_resource_id,
1337: role_id,

Line 1358: FROM jtf_rs_role_relations

1354: attribute13,
1355: attribute14,
1356: attribute15,
1357: attribute_category
1358: FROM jtf_rs_role_relations
1359: WHERE role_relate_id = ll_role_relate_id
1360: AND nvl(delete_flag, '0') <> 'Y';
1361:
1362: role_relate_rec role_relate_cur%rowtype;

Line 1364: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ;

1360: AND nvl(delete_flag, '0') <> 'Y';
1361:
1362: role_relate_rec role_relate_cur%rowtype;
1363:
1364: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ;
1365: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;
1366: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1367: -- added trunc on 12th feb 2002
1368: /* Moved the initial assignment of below variables to inside begin */

Line 1365: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;

1361:
1362: role_relate_rec role_relate_cur%rowtype;
1363:
1364: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ;
1365: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;
1366: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1367: -- added trunc on 12th feb 2002
1368: /* Moved the initial assignment of below variables to inside begin */
1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

Line 1366: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;

1362: role_relate_rec role_relate_cur%rowtype;
1363:
1364: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ;
1365: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;
1366: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1367: -- added trunc on 12th feb 2002
1368: /* Moved the initial assignment of below variables to inside begin */
1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1370: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

Line 1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

1365: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;
1366: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1367: -- added trunc on 12th feb 2002
1368: /* Moved the initial assignment of below variables to inside begin */
1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1370: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1371: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1372: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1373: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;

Line 1370: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

1366: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1367: -- added trunc on 12th feb 2002
1368: /* Moved the initial assignment of below variables to inside begin */
1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1370: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1371: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1372: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1373: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;
1374:

Line 1371: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

1367: -- added trunc on 12th feb 2002
1368: /* Moved the initial assignment of below variables to inside begin */
1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1370: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1371: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1372: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1373: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;
1374:
1375: l_return_status VARCHAR2(200);

Line 1372: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;

1368: /* Moved the initial assignment of below variables to inside begin */
1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1370: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1371: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1372: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1373: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;
1374:
1375: l_return_status VARCHAR2(200);
1376: l_msg_count NUMBER;

Line 1373: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;

1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1370: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1371: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1372: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1373: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;
1374:
1375: l_return_status VARCHAR2(200);
1376: l_msg_count NUMBER;
1377: l_msg_data VARCHAR2(200);

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

1407: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1408: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;
1409:
1410: --changed the date comparison in the cursor 07/07/00
1411: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1412: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1413: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1414: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1415: IS

Line 1413: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

1409:
1410: --changed the date comparison in the cursor 07/07/00
1411: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1412: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1413: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1414: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1415: IS
1416: SELECT 'X'
1417: FROM jtf_rs_role_relations

Line 1414: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )

1410: --changed the date comparison in the cursor 07/07/00
1411: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1412: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1413: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1414: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1415: IS
1416: SELECT 'X'
1417: FROM jtf_rs_role_relations
1418: WHERE role_resource_type = 'RS_INDIVIDUAL'

Line 1417: FROM jtf_rs_role_relations

1413: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1414: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1415: IS
1416: SELECT 'X'
1417: FROM jtf_rs_role_relations
1418: WHERE role_resource_type = 'RS_INDIVIDUAL'
1419: AND role_resource_id = ll_role_resource_id
1420: AND role_id = ll_role_id
1421: AND to_date(to_char(start_date_active , 'dd-MM-yyyy'),'dd-MM-yyyy') <=

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

1427: AND nvl(delete_flag, '0') <> 'Y';
1428:
1429: res_role_rec res_role_cur%rowtype;
1430:
1431: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1432: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1433: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1434: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1435: IS

Line 1433: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

1429: res_role_rec res_role_cur%rowtype;
1430:
1431: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1432: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1433: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1434: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1435: IS
1436: SELECT 'X'
1437: FROM jtf_rs_role_relations

Line 1434: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )

1430:
1431: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1432: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1433: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1434: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1435: IS
1436: SELECT 'X'
1437: FROM jtf_rs_role_relations
1438: WHERE role_resource_type = 'RS_GROUP'

Line 1437: FROM jtf_rs_role_relations

1433: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1434: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1435: IS
1436: SELECT 'X'
1437: FROM jtf_rs_role_relations
1438: WHERE role_resource_type = 'RS_GROUP'
1439: AND role_resource_id = ll_role_resource_id
1440: AND role_id = ll_role_id
1441: AND start_date_active <= ll_start_date_active

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

1446:
1447: grp_role_rec grp_role_cur%rowtype;
1448:
1449:
1450: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
1451: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1452: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
1453: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1454: IS

Line 1451: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

1447: grp_role_rec grp_role_cur%rowtype;
1448:
1449:
1450: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
1451: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1452: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
1453: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1454: IS
1455: SELECT start_date_active,

Line 1452: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

1448:
1449:
1450: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
1451: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1452: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
1453: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1454: IS
1455: SELECT start_date_active,
1456: end_date_active

Line 1453: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

1449:
1450: CURSOR check_date_cur(ll_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE ,
1451: ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1452: ll_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
1453: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1454: IS
1455: SELECT start_date_active,
1456: end_date_active
1457: FROM jtf_rs_role_relations

Line 1457: FROM jtf_rs_role_relations

1453: ll_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1454: IS
1455: SELECT start_date_active,
1456: end_date_active
1457: FROM jtf_rs_role_relations
1458: WHERE role_relate_id <> ll_role_relate_id
1459: AND role_resource_type = ll_role_resource_type
1460: AND role_resource_id = ll_role_resource_id
1461: AND role_id = ll_role_id

Line 1532: jtf_rs_role_relations RR1

1528: jtf_rs_group_members GM1,
1529: jtf_rs_group_members GM2,
1530: jtf_rs_group_usages GU1,
1531: jtf_rs_group_usages GU2,
1532: jtf_rs_role_relations RR1
1533: /* commented the below line to improve the performance. We are not using this table in the select statement. */
1534: -- jtf_rs_role_relations RR2
1535: WHERE GM2.group_member_id = l_member_id
1536: AND G1.group_id = GM1.group_id

Line 1534: -- jtf_rs_role_relations RR2

1530: jtf_rs_group_usages GU1,
1531: jtf_rs_group_usages GU2,
1532: jtf_rs_role_relations RR1
1533: /* commented the below line to improve the performance. We are not using this table in the select statement. */
1534: -- jtf_rs_role_relations RR2
1535: WHERE GM2.group_member_id = l_member_id
1536: AND G1.group_id = GM1.group_id
1537: AND G2.group_id = GM2.group_id
1538: AND nvl(GM1.delete_flag, 'N') <> 'Y'

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

1557: c_exclusive_group_check_rec c_exclusive_group_check_cur%rowtype;
1558:
1559: /*changed + 1 logic */
1560: --cursor to check for team member dates for resource
1561: CURSOR res_team_cur(l_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1562: l_start_date_active DATE,
1563: L_end_date_active DATE ,
1564: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE )
1565: IS

Line 1568: jtf_rs_role_relations rlt

1564: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE )
1565: IS
1566: SELECT 'X'
1567: FROM jtf_rs_team_members mem,
1568: jtf_rs_role_relations rlt
1569: WHERE mem.team_resource_id = l_resource_id
1570: AND mem.resource_type = 'INDIVIDUAL'
1571: AND nvl(mem.delete_flag, 'N') <> 'Y'
1572: AND mem.team_member_id = rlt.role_resource_id

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

1581: res_team_rec res_team_cur%rowtype;
1582:
1583: /*changed + 1 logic */
1584: --cursor to check for group member dates for resource
1585: CURSOR res_group_cur(l_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1586: l_start_date_active DATE,
1587: L_end_date_active DATE ,
1588: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE)
1589: IS

Line 1592: jtf_rs_role_relations rlt

1588: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE)
1589: IS
1590: SELECT rlt.role_relate_id
1591: FROM jtf_rs_group_members mem,
1592: jtf_rs_role_relations rlt
1593: WHERE mem.resource_id = l_resource_id
1594: AND nvl(mem.delete_flag, 'N') <> 'Y'
1595: AND mem.group_member_id = rlt.role_resource_id
1596: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 1612: jtf_rs_role_relations rel

1608: cursor get_group_cur(l_role_relate_id number)
1609: is
1610: select mem.group_id
1611: from jtf_rs_group_members mem,
1612: jtf_rs_role_relations rel
1613: where rel.role_relate_id = l_role_relate_id
1614: and rel.role_resource_id = mem.group_member_id;
1615:
1616:

Line 2230: jtf_rs_role_relations_pkg.lock_row(

2226:
2227: --call update table handler
2228: BEGIN
2229:
2230: jtf_rs_role_relations_pkg.lock_row(
2231: x_role_relate_id => l_role_relate_id,
2232: x_object_version_number => p_object_version_num
2233: );
2234:

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

2295: end;
2296:
2297: /* End of publish API call */
2298:
2299: jtf_rs_role_relations_pkg.update_row(X_ROLE_RELATE_ID => l_role_relate_id,
2300: X_ATTRIBUTE9 => l_attribute9,
2301: X_ATTRIBUTE10 => l_attribute10,
2302: X_ATTRIBUTE11 => l_attribute11,
2303: X_ATTRIBUTE12 => l_attribute12,

Line 2625: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

2621: PROCEDURE delete_resource_role_relate
2622: (P_API_VERSION IN NUMBER,
2623: P_INIT_MSG_LIST IN VARCHAR2,
2624: P_COMMIT IN VARCHAR2,
2625: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
2626: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
2627: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2628: X_MSG_COUNT OUT NOCOPY NUMBER,
2629: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 2626: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

2622: (P_API_VERSION IN NUMBER,
2623: P_INIT_MSG_LIST IN VARCHAR2,
2624: P_COMMIT IN VARCHAR2,
2625: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
2626: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
2627: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2628: X_MSG_COUNT OUT NOCOPY NUMBER,
2629: X_MSG_DATA OUT NOCOPY VARCHAR2
2630: )IS

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

2629: X_MSG_DATA OUT NOCOPY VARCHAR2
2630: )IS
2631:
2632:
2633: CURSOR chk_type_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
2634: IS
2635: SELECT role_resource_type,
2636: role_resource_id,
2637: role_id,

Line 2657: FROM jtf_rs_role_relations

2653: attribute13,
2654: attribute14,
2655: attribute15,
2656: attribute_category
2657: FROM jtf_rs_role_relations
2658: WHERE role_relate_id = l_role_relate_id;
2659:
2660:
2661: chk_type_rec chk_type_cur%rowtype;

Line 2665: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

2661: chk_type_rec chk_type_cur%rowtype;
2662:
2663: CURSOR chk_grp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2664: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2665: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2666: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2667: IS
2668: SELECT 'x'
2669: FROM jtf_rs_role_relations rlt,

Line 2666: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)

2662:
2663: CURSOR chk_grp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2664: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2665: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2666: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2667: IS
2668: SELECT 'x'
2669: FROM jtf_rs_role_relations rlt,
2670: jtf_rs_group_members mem

Line 2669: FROM jtf_rs_role_relations rlt,

2665: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2666: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2667: IS
2668: SELECT 'x'
2669: FROM jtf_rs_role_relations rlt,
2670: jtf_rs_group_members mem
2671: WHERE mem.resource_id = l_resource_id
2672: AND rlt.role_resource_id = mem.group_member_id
2673: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 2684: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

2680: chk_grp_rec chk_grp_cur%rowtype;
2681:
2682: CURSOR chk_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2683: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2684: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2685: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2686: IS
2687: SELECT 'x'
2688: FROM jtf_rs_role_relations rlt,

Line 2685: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)

2681:
2682: CURSOR chk_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2683: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2684: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2685: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2686: IS
2687: SELECT 'x'
2688: FROM jtf_rs_role_relations rlt,
2689: jtf_rs_team_members mem

Line 2688: FROM jtf_rs_role_relations rlt,

2684: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2685: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2686: IS
2687: SELECT 'x'
2688: FROM jtf_rs_role_relations rlt,
2689: jtf_rs_team_members mem
2690: WHERE mem.team_resource_id = l_resource_id
2691: AND mem.resource_type <> 'GROUP'
2692: AND rlt.role_resource_id = mem.team_member_id

Line 2705: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

2701: chk_team_rec chk_team_cur%rowtype;
2702:
2703:
2704: /* Moved the initial assignment of below variable to inside begin */
2705: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
2706:
2707: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_ROLE_RELATE';
2708: l_api_version CONSTANT NUMBER :=1.0;
2709: l_bind_data_id number;

Line 2721: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;

2717: l_return_code VARCHAR2(100);
2718: l_count NUMBER;
2719: l_data VARCHAR2(200);
2720:
2721: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
2722: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2723: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2724: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2725: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;

Line 2722: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;

2718: l_count NUMBER;
2719: l_data VARCHAR2(200);
2720:
2721: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
2722: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2723: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2724: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2725: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2726: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;

Line 2723: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;

2719: l_data VARCHAR2(200);
2720:
2721: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
2722: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2723: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2724: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2725: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2726: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2727: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;

Line 2724: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;

2720:
2721: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
2722: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2723: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2724: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2725: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2726: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2727: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2728: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;

Line 2725: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;

2721: L_ATTRIBUTE1 JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE;
2722: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2723: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2724: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2725: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2726: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2727: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2728: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2729: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;

Line 2726: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;

2722: L_ATTRIBUTE2 JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE;
2723: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2724: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2725: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2726: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2727: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2728: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2729: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2730: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;

Line 2727: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;

2723: L_ATTRIBUTE3 JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE;
2724: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2725: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2726: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2727: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2728: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2729: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2730: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2731: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;

Line 2728: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;

2724: L_ATTRIBUTE4 JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE;
2725: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2726: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2727: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2728: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2729: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2730: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2731: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2732: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;

Line 2729: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;

2725: L_ATTRIBUTE5 JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE;
2726: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2727: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2728: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2729: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2730: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2731: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2732: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2733: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;

Line 2730: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;

2726: L_ATTRIBUTE6 JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE;
2727: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2728: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2729: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2730: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2731: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2732: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2733: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2734: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;

Line 2731: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;

2727: L_ATTRIBUTE7 JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE;
2728: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2729: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2730: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2731: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2732: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2733: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2734: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2735: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;

Line 2732: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;

2728: L_ATTRIBUTE8 JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE;
2729: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2730: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2731: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2732: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2733: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2734: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2735: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
2736: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 2733: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;

2729: L_ATTRIBUTE9 JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE;
2730: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2731: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2732: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2733: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2734: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2735: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
2736: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
2737:

Line 2734: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;

2730: L_ATTRIBUTE10 JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE;
2731: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2732: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2733: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2734: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2735: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
2736: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
2737:
2738: l_return_status VARCHAR2(200);

Line 2735: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;

2731: L_ATTRIBUTE11 JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE;
2732: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2733: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2734: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2735: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
2736: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
2737:
2738: l_return_status VARCHAR2(200);
2739: l_msg_count NUMBER;

Line 2736: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;

2732: L_ATTRIBUTE12 JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE;
2733: L_ATTRIBUTE13 JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE;
2734: L_ATTRIBUTE14 JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE;
2735: L_ATTRIBUTE15 JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE;
2736: L_ATTRIBUTE_CATEGORY JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
2737:
2738: l_return_status VARCHAR2(200);
2739: l_msg_count NUMBER;
2740: l_msg_data VARCHAR2(200);

Line 2746: jtf_rs_role_relations rel

2742: cursor get_group_cur(l_role_relate_id number)
2743: is
2744: select mem.group_id
2745: from jtf_rs_group_members mem,
2746: jtf_rs_role_relations rel
2747: where rel.role_relate_id = l_role_relate_id
2748: and rel.role_resource_id = mem.group_member_id;
2749:
2750: l_group_id number;

Line 2964: jtf_rs_role_relations_pkg.update_row(

2960: END IF;
2961:
2962:
2963: --call update api to set the delete flag to 'Y'
2964: jtf_rs_role_relations_pkg.update_row(
2965: X_ROLE_RELATE_ID => l_role_relate_id,
2966: X_ATTRIBUTE9 => l_attribute9,
2967: X_ATTRIBUTE10 => l_attribute10,
2968: X_ATTRIBUTE11 => l_attribute11,