1 PACKAGE jtf_rs_group_usages_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrspas.pls 120.0 2005/05/11 08:21:04 appldev ship $ */
3 /*#
4 * Package containing procedures to maintain information
5 * about Group Usages
6 * @rep:scope internal
7 * @rep:product JTF
8 * @rep:displayname Group Usages Package
9 * @rep:category BUSINESS_ENTITY JTF_RS_GROUP_USAGE
10 */
11
12
13 /*****************************************************************************************
14 This is a public API that caller will invoke.
15 It provides PROCEDUREs for managing resource group usages.
16 Its main PROCEDUREs are as following:
17 Create Resource Group Usage
18 Delete Resource Group Usage
19 Calls to these PROCEDUREs will invoke PROCEDUREs from jtf_rs_group_usages_pvt
20 to do business validations and to do actual inserts and updates into tables.
21 ******************************************************************************************/
22
23
24
25 /*#
26 * PROCEDURE to create the resource group usage
27 * based on input values passed by calling routines.
28 * @param P_API_VERSION API version number
29 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
30 * @param P_COMMIT Flag to commit at the end of the procedure
31 * @param P_GROUP_ID Internal Unique Id of the group
32 * @param P_GROUP_NUMBER Group Number
33 * @param P_USAGE Usage Code
34 * @param X_RETURN_STATUS Output parameter for return status
35 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
36 * @param X_MSG_DATA Output parameter containing last user message from this procedure
37 * @param X_GROUP_USAGE_ID Output parameter containing the unique internal id of newly created group usage.
38 * @rep:scope internal
39 * @rep:displayname Create Group Usage
40 */
41 PROCEDURE create_group_usage
42 (P_API_VERSION IN NUMBER,
43 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45 P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
46 P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
47 P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
48 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49 X_MSG_COUNT OUT NOCOPY NUMBER,
50 X_MSG_DATA OUT NOCOPY VARCHAR2,
51 X_GROUP_USAGE_ID OUT NOCOPY JTF_RS_GROUP_USAGES.GROUP_USAGE_ID%TYPE
52 );
53
54
55
56 /*#
57 * PROCEDURE to delete the resource group usage
58 * based on input values passed by calling routines.
59 * @param P_API_VERSION API version number
60 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
61 * @param P_COMMIT Flag to commit at the end of the procedure
62 * @param P_GROUP_ID Internal Unique ID of the group
63 * @param P_GROUP_NUMBER Group Number
64 * @param P_USAGE Usage Code
65 * @param P_OBJECT_VERSION_NUM Object Version Number of the group usage
66 * @param X_RETURN_STATUS Output parameter for return status
67 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
68 * @param X_MSG_DATA Output parameter containing last user message from this procedure
69 * @rep:scope internal
70 * @rep:displayname Delete Group Usage
71 */
72 PROCEDURE delete_group_usage
73 (P_API_VERSION IN NUMBER,
74 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76 P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
77 P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
78 P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
79 P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,
80 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
81 X_MSG_COUNT OUT NOCOPY NUMBER,
82 X_MSG_DATA OUT NOCOPY VARCHAR2
83 );
84
85
86 END jtf_rs_group_usages_pub;