1 PACKAGE jtf_rs_group_usages_pvt AS
2 /* $Header: jtfrsvas.pls 120.0 2005/05/11 08:22:53 appldev ship $ */
3
4 /*****************************************************************************************
5 This is a public API that caller will invoke.
6 It provides procedures for managing resource group usages.
7 Its main procedures are as following:
8 Create Resource Group Usage
9 Delete Resource Group Usage
10 Calls to these procedures will invoke calls to table handlers which
11 do actual inserts and deletes into tables.
12 ******************************************************************************************/
13
14
15 /* Procedure to create the resource group usage
16 based on input values passed by calling routines. */
17
18 PROCEDURE create_group_usage
19 (P_API_VERSION IN NUMBER,
20 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22 P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
23 P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
24 P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
25 P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
26 P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
27 P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
28 P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
29 P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
30 P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
31 P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
32 P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
33 P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
34 P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
35 P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
36 P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
37 P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
38 P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
39 P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
40 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
41 X_MSG_COUNT OUT NOCOPY NUMBER,
42 X_MSG_DATA OUT NOCOPY VARCHAR2,
43 X_GROUP_USAGE_ID OUT NOCOPY JTF_RS_GROUP_USAGES.GROUP_USAGE_ID%TYPE
44 );
45
46
47
48 /* Procedure to delete the resource group usage
49 based on input values passed by calling routines. */
50
51 PROCEDURE delete_group_usage
52 (P_API_VERSION IN NUMBER,
53 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55 P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
56 P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
57 P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,
58 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
59 X_MSG_COUNT OUT NOCOPY NUMBER,
60 X_MSG_DATA OUT NOCOPY VARCHAR2
61 );
62
63
64 END jtf_rs_group_usages_pvt;