1: PACKAGE BODY jtf_rs_groups_pub AS
2: /* $Header: jtfrspgb.pls 120.0 2005/05/11 08:21:09 appldev 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. */
246: ) IS
247:
248: BEGIN
249:
250: JTF_RS_GROUPS_PUB.G_RS_GRP_ID_PUB_FLAG := 'N';
251: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
252: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
253: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
254: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
247:
248: BEGIN
249:
250: JTF_RS_GROUPS_PUB.G_RS_GRP_ID_PUB_FLAG := 'N';
251: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
252: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
253: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
254: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
255: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
248: BEGIN
249:
250: JTF_RS_GROUPS_PUB.G_RS_GRP_ID_PUB_FLAG := 'N';
251: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
252: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
253: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
254: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
255: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
256: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
249:
250: JTF_RS_GROUPS_PUB.G_RS_GRP_ID_PUB_FLAG := 'N';
251: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
252: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
253: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
254: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
255: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
256: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
257: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
250: JTF_RS_GROUPS_PUB.G_RS_GRP_ID_PUB_FLAG := 'N';
251: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
252: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
253: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
254: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
255: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
256: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
257: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
258: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
251: JTF_RS_GROUPS_PUB.G_GROUP_ID := P_GROUP_ID;
252: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
253: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
254: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
255: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
256: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
257: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
258: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
259: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
252: JTF_RS_GROUPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
253: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
254: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
255: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
256: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
257: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
258: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
259: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
260: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
253: JTF_RS_GROUPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
254: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
255: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
256: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
257: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
258: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
259: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
260: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
261: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
254: JTF_RS_GROUPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
255: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
256: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
257: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
258: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
259: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
260: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
261: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
262: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
255: JTF_RS_GROUPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
256: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
257: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
258: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
259: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
260: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
261: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
262: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
263: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
256: JTF_RS_GROUPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
257: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
258: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
259: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
260: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
261: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
262: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
263: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
264: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
257: JTF_RS_GROUPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
258: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
259: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
260: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
261: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
262: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
263: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
264: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
265: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
258: JTF_RS_GROUPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
259: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
260: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
261: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
262: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
263: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
264: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
265: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
266: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
259: JTF_RS_GROUPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
260: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
261: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
262: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
263: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
264: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
265: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
266: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
267: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
260: JTF_RS_GROUPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
261: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
262: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
263: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
264: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
265: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
266: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
267: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
268:
261: JTF_RS_GROUPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
262: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
263: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
264: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
265: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
266: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
267: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
268:
269: jtf_rs_groups_pub.create_resource_group (
262: JTF_RS_GROUPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
263: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
264: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
265: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
266: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
267: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
268:
269: jtf_rs_groups_pub.create_resource_group (
270: P_API_VERSION => P_API_VERSION,
263: JTF_RS_GROUPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
264: JTF_RS_GROUPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
265: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
266: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
267: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
268:
269: jtf_rs_groups_pub.create_resource_group (
270: P_API_VERSION => P_API_VERSION,
271: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
265: JTF_RS_GROUPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
266: JTF_RS_GROUPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
267: JTF_RS_GROUPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
268:
269: jtf_rs_groups_pub.create_resource_group (
270: P_API_VERSION => P_API_VERSION,
271: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
272: P_COMMIT => P_COMMIT,
273: P_GROUP_NAME => P_GROUP_NAME,
435:
436: END update_resource_group;
437:
438:
439: END jtf_rs_groups_pub;