1: PACKAGE BODY jtf_rs_groups_pub AS
2: /* $Header: jtfrspgb.pls 120.0.12010000.3 2009/08/05 07:59:56 rgokavar ship $ */
3:
4: /*****************************************************************************************
5: This package body defines the procedures for managing resource groups.
12: ******************************************************************************************/
13:
14: /* Package variables. */
15:
16: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_GROUPS_PUB';
17:
18:
19: /* Procedure to create the resource group and the members
20: based on input values passed by calling routines. */
275: ) IS
276:
277: BEGIN
278:
279: JTF_RS_GROUPS_PUB.G_RS_GRP_ID_PUB_FLAG := 'N';
280: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
281: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
282: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
283: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
276:
277: BEGIN
278:
279: JTF_RS_GROUPS_PUB.G_RS_GRP_ID_PUB_FLAG := 'N';
280: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
281: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
282: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
283: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
284: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
277: BEGIN
278:
279: JTF_RS_GROUPS_PUB.G_RS_GRP_ID_PUB_FLAG := 'N';
280: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
281: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
282: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
283: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
284: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
285: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
278:
279: JTF_RS_GROUPS_PUB.G_RS_GRP_ID_PUB_FLAG := 'N';
280: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
281: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
282: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
283: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
284: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
285: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
286: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
279: JTF_RS_GROUPS_PUB.G_RS_GRP_ID_PUB_FLAG := 'N';
280: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
281: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
282: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
283: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
284: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
285: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
286: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
287: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
280: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
281: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
282: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
283: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
284: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
285: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
286: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
287: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
288: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
281: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
282: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
283: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
284: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
285: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
286: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
287: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
288: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
289: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
282: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
283: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
284: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
285: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
286: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
287: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
288: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
289: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
290: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
283: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
284: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
285: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
286: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
287: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
288: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
289: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
290: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
291: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
284: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
285: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
286: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
287: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
288: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
289: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
290: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
291: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
292: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
285: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
286: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
287: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
288: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
289: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
290: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
291: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
292: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
293: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
286: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
287: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
288: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
289: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
290: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
291: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
292: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
293: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
294: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
287: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
288: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
289: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
290: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
291: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
292: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
293: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
294: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
295: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
288: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
289: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
290: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
291: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
292: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
293: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
294: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
295: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
296: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
289: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
290: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
291: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
292: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
293: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
294: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
295: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
296: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
297:
290: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
291: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
292: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
293: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
294: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
295: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
296: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
297:
298: jtf_rs_groups_pub.create_resource_group (
291: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
292: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
293: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
294: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
295: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
296: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
297:
298: jtf_rs_groups_pub.create_resource_group (
299: P_API_VERSION => P_API_VERSION,
292: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
293: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
294: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
295: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
296: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
297:
298: jtf_rs_groups_pub.create_resource_group (
299: P_API_VERSION => P_API_VERSION,
300: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
294: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
295: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
296: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
297:
298: jtf_rs_groups_pub.create_resource_group (
299: P_API_VERSION => P_API_VERSION,
300: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
301: P_COMMIT => P_COMMIT,
302: P_GROUP_NAME => P_GROUP_NAME,
473:
474: END update_resource_group;
475:
476:
477: END jtf_rs_groups_pub;