1 PACKAGE jtf_rs_groups_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrspgs.pls 120.0.12010000.2 2009/05/11 07:36:14 rgokavar ship $ */
3 /*#
4 * Group create and update API
5 * This API contains the procedures to insert and update Group record.
6 * @rep:scope public
7 * @rep:product JTF
8 * @rep:displayname Groups API
9 * @rep:category BUSINESS_ENTITY JTF_RS_GROUP
10 */
11 /*****************************************************************************************
12 This is a public API that caller will invoke.
13 It provides procedures for managing resource groups.
14 Its main procedures are as following:
18 to do business validations and to do actual inserts and updates into tables.
15 Create Resource Group
16 Update Resource Group
17 Calls to these procedures will invoke procedures from jtf_rs_groups_pvt
19 This package uses variables of type record and pl/sql table .
20 ******************************************************************************************/
21
22
23 /* Procedure to create the resource group and the members
24 based on input values passed by calling routines. */
25 /*#
26 * Create Group API
27 * This procedure allows the user to create a group record.
28 * @param p_api_version API version
29 * @param p_init_msg_list Initialization of the message list
30 * @param p_commit Commit
31 * @param p_group_name The name of the resource group
32 * @param p_group_desc A description of the resource group
33 * @param p_exclusive_flag Exclusive Flag
34 * @param p_email_address The email address of the group owner
35 * @param p_start_date_active Date on which the resource group becomes active. This value can not be NULL, and the start date must be less than the end date.
36 * @param p_end_date_active Date on which the resource group is no longer active. If no end date is provided, the group is active indefinitely.
37 * @param p_accounting_code Account code
38 * @param x_return_status Output parameter for return status
39 * @param x_msg_count Output parameter for number of user messages from this procedure
40 * @param x_msg_data Output parameter containing last user message from this procedure
41 * @param x_group_id Out parameter for Group Identifier
42 * @param x_group_number Out parameter for Group Number
43 * @param p_time_zone Time Zone information
44 * @rep:scope public
45 * @rep:lifecycle active
46 * @rep:displayname Create Group API
47 */
48 PROCEDURE create_resource_group
49 (P_API_VERSION IN NUMBER,
50 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52 P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
53 P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
54 P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
55 P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
56 P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
57 P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
58 P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
59 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60 X_MSG_COUNT OUT NOCOPY NUMBER,
61 X_MSG_DATA OUT NOCOPY VARCHAR2,
62 X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
63 X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
64 P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
65 );
66
67
68 --Create Resource Group Migration API, used for one-time migration of resource group data
69 --The API includes GROUP_ID as one of its Input Parameters
70 /*#
71 * Create Group Migration API
72 * This procedure is used for one-time migration of resource group data
73 * The API includes group_id as one of its Input Parameters
74 * @param p_api_version API version
75 * @param p_init_msg_list Initialization of the message list
76 * @param p_commit Commit
77 * @param p_group_id Group Identifier
78 * @param p_group_name The name of the resource group
79 * @param p_group_desc A description of the resource group
80 * @param p_exclusive_flag Exclusive Flag
81 * @param p_email_address The email address of the group owner
82 * @param p_start_date_active Date on which the resource group becomes active. This value can not be NULL, and the start date must be less than the end date.
83 * @param p_end_date_active Date on which the resource group is no longer active. If no end date is provided, the group is active indefinitely.
84 * @param p_accounting_code Account code
85 * @param p_attribute1 Descriptive flexfield Segment 1
86 * @param p_attribute2 Descriptive flexfield Segment 2
87 * @param p_attribute3 Descriptive flexfield Segment 3
88 * @param p_attribute4 Descriptive flexfield Segment 4
89 * @param p_attribute5 Descriptive flexfield Segment 5
90 * @param p_attribute6 Descriptive flexfield Segment 6
91 * @param p_attribute7 Descriptive flexfield Segment 7
92 * @param p_attribute8 Descriptive flexfield Segment 8
93 * @param p_attribute9 Descriptive flexfield Segment 9
94 * @param p_attribute10 Descriptive flexfield Segment 10
95 * @param p_attribute11 Descriptive flexfield Segment 11
96 * @param p_attribute12 Descriptive flexfield Segment 12
97 * @param p_attribute13 Descriptive flexfield Segment 13
98 * @param p_attribute14 Descriptive flexfield Segment 14
99 * @param p_attribute15 Descriptive flexfield Segment 15
100 * @param p_attribute_category Descriptive flexfield structure definition column
101 * @param x_return_status Output parameter for return status
102 * @param x_msg_count Output parameter for number of user messages from this procedure
103 * @param x_msg_data Output parameter containing last user message from this procedure
104 * @param x_group_id Out parameter for Group Identifier
105 * @param x_group_number Out parameter for Group Number
106 * @param p_time_zone Time Zone information
107 * @rep:scope internal
108 * @rep:lifecycle obsolete
109 * @rep:displayname Create Group Migration API
110 */
111 PROCEDURE create_resource_group_migrate
112 (P_API_VERSION IN NUMBER,
113 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115 P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
119 P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
116 P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
117 P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
118 P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
120 P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
121 P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
122 P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
123 P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
124 P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
125 P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
126 P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
127 P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
128 P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
129 P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
130 P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
131 P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
132 P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
133 P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
134 P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
135 P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
136 P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
137 P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
138 P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
139 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
140 X_MSG_COUNT OUT NOCOPY NUMBER,
141 X_MSG_DATA OUT NOCOPY VARCHAR2,
142 X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
143 X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
144 P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
145 );
146
147 --Creating a Global Variable to be used for setting the flag,
148 --when the create_resource_group_migrate gets called
149
150 G_RS_GRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
151 G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
152 G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
153 G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
154 G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
155 G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
156 G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
157 G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
158 G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
159 G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
160 G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
161 G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
162 G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
163 G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
164 G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
165 G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
166 G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
167 G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;
168
169 /* Procedure to update the resource group based on input values
170 passed by calling routines. */
171 /*#
172 * Update Group API
173 * This procedure allows the user to update a group record.
174 * @param p_api_version API version
175 * @param p_init_msg_list Initialization of the message list
176 * @param p_commit Commit
177 * @param p_group_id Group Identifier
178 * @param p_group_number Group Number
179 * @param p_group_name The name of the resource group
180 * @param p_group_desc A description of the resource group
181 * @param p_exclusive_flag Exclusive Flag
182 * @param p_email_address The email address of the group owner
183 * @param p_start_date_active Date on which the resource group becomes active. This value can not be NULL, and the start date must be less than the end date.
184 * @param p_end_date_active Date on which the resource group is no longer active. If no end date is provided, the group is active indefinitely.
185 * @param p_accounting_code Account code
186 * @param p_object_version_num The object version number of the group derives from the jtf_rs_groups table.
187 * @param x_return_status Output parameter for return status
188 * @param x_msg_count Output parameter for number of user messages from this procedure
189 * @param x_msg_data Output parameter containing last user message from this procedure,
190 * @param p_time_zone Time Zone information
191 * @rep:scope public
192 * @rep:lifecycle active
193 * @rep:displayname Update Group API
194 */
195 PROCEDURE update_resource_group
196 (P_API_VERSION IN NUMBER,
197 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199 P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
200 P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
201 P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
202 P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
203 P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
204 P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
205 P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
206 P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
207 P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
208 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
209 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
210 X_MSG_COUNT OUT NOCOPY NUMBER,
211 X_MSG_DATA OUT NOCOPY VARCHAR2,
212 P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM
213 );
214
215
216 END jtf_rs_groups_pub;
[Home] [Help]