1 PACKAGE jtf_rs_resource_pub AS
2 /* $Header: jtfrsprs.pls 120.0 2005/05/11 08:21:20 appldev ship $ */
3 /*#
4 * Resource create/update/delete API
5 * This API contains the procedures to insert, update and delete Resource record.
6 * @rep:scope public
7 * @rep:product JTF
8 * @rep:displayname Resource API
9 * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE
10 * @rep:businessevent oracle.apps.jtf.jres.resource.create
11 * @rep:businessevent oracle.apps.jtf.jres.resource.update.user
12 * @rep:businessevent oracle.apps.jtf.jres.resource.update.effectivedate
13 * @rep:businessevent oracle.apps.jtf.jres.resource.update.attributes
14 * @rep:businessevent oracle.apps.jtf.jres.resource.delete
15 */
16 /*****************************************************************************************
17 This is a public API that caller will invoke.
18 It provides procedures for managing resources.
19 Its main procedures are as following:
20 Create Resource
21 Update Resource
22 Calls to these procedures will invoke procedures from jtf_resource_pvt
23 to do business validations and to do actual inserts and updates into tables.
24 ******************************************************************************************/
25
26
27 /*G_MISS_LOCATION MDSYS.SDO_GEOMETRY := mdsys.sdo_geometry(fnd_api.g_miss_num, null, null,
28
29 mdsys.sdo_elem_info_array(null),
30
31
32 mdsys.sdo_ordinate_array(null));*/
33
34
35 /* Procedure to create the resource based on input values passed by calling routines. */
36
37 /*#
38 * Get workflow role for a given resouurce
39 * This function returns the workflow role for a given resource.
40 * @param resource_id Resource Id
41 * @return Workflow Role
42 * @rep:scope internal
43 * @rep:displayname Get Workflow Role for a Resource
44 */
45 Function get_wf_role ( resource_id in number )
46 RETURN varchar2 ;
47
48 /*#
49 * Create Resource API
50 * This procedure allows the user to create a resource record.
51 * @param p_api_version API version
52 * @param p_init_msg_list Initialization of the message list
53 * @param p_commit Commit
54 * @param p_category Category of the Resource
55 * @param p_source_id Source identifier of the Resource
56 * @param p_address_id Resource address
57 * @param p_contact_id Resource contact identifier
58 * @param p_managing_emp_id Identifier for the manager of the resource
59 * @param p_managing_emp_num Employee number of the resources manager
60 * @param p_start_date_active Date on which the resource becomes active. This value can not be NULL, and the start date must be less than the end date.
61 * @param p_end_date_active Date on which the resource is no longer active.
62 * @param p_time_zone Time zone, this value must be a valid time zone as defined in table HZ_TIMEZONES.
63 * @param p_cost_per_hr The salary cost per hour for this resource. This value is used in conjunction with the p_comp_currency_code parameter.
64 * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
65 * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
66 * @param p_support_site_id Value used by the Service applications.
67 * @param p_ies_agent_login Value used by Interaction Center applications (if using Oracle Scripting).
68 * @param p_server_group_id Value used by Interaction Center applications
69 * @param p_interaction_center_name Value used by Interaction Center applications
70 * @param p_assigned_to_group_id The group to which this resource is assigned
71 * @param p_cost_center The cost center to which this resource is assigned
72 * @param p_charge_to_cost_center Cost center to charge against, this may be different than the resource's current cost center.
73 * @param p_comp_currency_code Compensation currency type. This value must be a valid currency code as listed in table FND_CURRENCIES.
74 * @param p_commissionable_flag Whether this resource is eligible for a commission or not.
75 * @param p_hold_reason_code The reason that compensation is being withheld
76 * @param p_hold_payment Whether Withhold compensation or not
77 * @param p_comp_service_team_id The identifier for the team to which this resource belongs
78 * @param p_user_id User Id of the Resource
79 * @param p_transaction_number Transaction identifier
80 * @param x_return_status Output parameter for return status
81 * @param x_msg_count Output parameter for number of user messages from this procedure
82 * @param x_msg_data Output parameter containing last user message from this procedure
83 * @param x_resource_id Out parameter for Resource Identifier
84 * @param x_resource_number Out parameter for Resource Number
85 * @rep:scope internal
86 * @rep:lifecycle obsolete
87 * @rep:displayname Create Resource API
88 */
89 PROCEDURE create_resource
90 (P_API_VERSION IN NUMBER,
91 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93 P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
94 P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
95 P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
96 P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
97 P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
98 P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
99 P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
100 P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
101 P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
102 P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
103 P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
104 P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
105 P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
106 P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
107 P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
108 P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
109 P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
110 P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
111 P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
112 P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
113 P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
114 P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
115 P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
116 P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
117 P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
118 P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
119 --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
120 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
121 X_MSG_COUNT OUT NOCOPY NUMBER,
122 X_MSG_DATA OUT NOCOPY VARCHAR2,
123 X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
124 X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE
125 );
126
127 --Create Resource Migration API, used for one-time migration of resource data
128 --The API includes RESOURCE_ID as one of its Input Parameters
129
130 /*#
131 * Create Resource Migration API
132 * This procedure used for one-time migration of resource data
133 * The API includes RESOURCE_ID as one of its Input Parameters
134 * @param p_api_version API version
135 * @param p_init_msg_list Initialization of the message list
136 * @param p_commit Commit
137 * @param p_resource_id Resource identifier
138 * @param p_category Category of the Resource
139 * @param p_source_id Source identifier of the Resource
140 * @param p_address_id Resource address
141 * @param p_contact_id Resource contact identifier
142 * @param p_managing_emp_id Identifier for the manager of the resource
143 * @param p_managing_emp_num Employee number of the resources manager
144 * @param p_start_date_active Date on which the resource becomes active. This value can not be NULL, and the start date must be less than the end date.
145 * @param p_end_date_active Date on which the resource is no longer active.
146 * @param p_time_zone Time zone, this value must be a valid time zone as defined in table HZ_TIMEZONES.
147 * @param p_cost_per_hr The salary cost per hour for this resource. This value is used in conjunction with the p_comp_currency_code parameter.
148 * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
149 * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
150 * @param p_support_site_id Value used by the Service applications.
151 * @param p_ies_agent_login Value used by Interaction Center applications (if using Oracle Scripting).
152 * @param p_server_group_id Value used by Interaction Center applications
153 * @param p_interaction_center_name Value used by Interaction Center applications
154 * @param p_assigned_to_group_id The group to which this resource is assigned
155 * @param p_cost_center The cost center to which this resource is assigned
156 * @param p_charge_to_cost_center Cost center to charge against, this may be different than the resource's current cost center.
157 * @param p_comp_currency_code Compensation currency type. This value must be a valid currency code as listed in table FND_CURRENCIES.
158 * @param p_commissionable_flag Whether this resource is eligible for a commission or not.
159 * @param p_hold_reason_code The reason that compensation is being withheld
160 * @param p_hold_payment Whether Withhold compensation or not
161 * @param p_comp_service_team_id The identifier for the team to which this resource belongs
162 * @param p_user_id User Id of the Resource
163 * @param p_transaction_number Transaction identifier
164 * @param p_attribute1 Descriptive flexfield Segment 1
165 * @param p_attribute2 Descriptive flexfield Segment 2
166 * @param p_attribute3 Descriptive flexfield Segment 3
167 * @param p_attribute4 Descriptive flexfield Segment 4
168 * @param p_attribute5 Descriptive flexfield Segment 5
169 * @param p_attribute6 Descriptive flexfield Segment 6
170 * @param p_attribute7 Descriptive flexfield Segment 7
171 * @param p_attribute8 Descriptive flexfield Segment 8
172 * @param p_attribute9 Descriptive flexfield Segment 9
173 * @param p_attribute10 Descriptive flexfield Segment 10
174 * @param p_attribute11 Descriptive flexfield Segment 11
175 * @param p_attribute12 Descriptive flexfield Segment 12
176 * @param p_attribute13 Descriptive flexfield Segment 13
177 * @param p_attribute14 Descriptive flexfield Segment 14
178 * @param p_attribute15 Descriptive flexfield Segment 15
179 * @param p_attribute_category Descriptive flexfield structure definition column
180 * @param x_return_status Output parameter for return status
181 * @param x_msg_count Output parameter for number of user messages from this procedure
182 * @param x_msg_data Output parameter containing last user message from this procedure
183 * @param x_resource_id Out parameter for Resource Identifier
184 * @param x_resource_number Out parameter for Resource Number
185 * @rep:scope internal
186 * @rep:lifecycle obsolete
187 * @rep:displayname Create Resource Migration API
191 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
188 */
189 PROCEDURE create_resource_migrate
190 (P_API_VERSION IN NUMBER,
192 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193 P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
194 P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
195 P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
196 P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
197 P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
198 P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
199 P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
200 P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
201 P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
202 P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
203 P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
204 P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
205 P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
206 P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
207 P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
208 P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
209 P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
210 P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
211 P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
212 P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
213 P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
214 P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
215 P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
216 P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
217 P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
218 P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
219 --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
220 P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE DEFAULT NULL,
221 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
222 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
223 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
224 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
225 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
226 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
227 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
228 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
229 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
230 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
231 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
232 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
233 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
234 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
235 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
236 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
237 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
238 X_MSG_COUNT OUT NOCOPY NUMBER,
239 X_MSG_DATA OUT NOCOPY VARCHAR2,
240 X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
241 X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE
242 );
243
244 --Creating a Global Variable to be used for setting the flag,
245 --when the create_resource_migrate gets called
246
247 G_RS_ID_PUB_FLAG VARCHAR2(1) := 'Y';
248 G_RESOURCE_ID JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE := NULL;
249 G_ATTRIBUTE1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE := NULL;
253 G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE := NULL;
250 G_ATTRIBUTE2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE := NULL;
251 G_ATTRIBUTE3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE := NULL;
252 G_ATTRIBUTE4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE := NULL;
254 G_ATTRIBUTE6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE := NULL;
255 G_ATTRIBUTE7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE := NULL;
256 G_ATTRIBUTE8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE := NULL;
257 G_ATTRIBUTE9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE := NULL;
258 G_ATTRIBUTE10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE := NULL;
259 G_ATTRIBUTE11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE := NULL;
260 G_ATTRIBUTE12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE := NULL;
261 G_ATTRIBUTE13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE := NULL;
262 G_ATTRIBUTE14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE := NULL;
263 G_ATTRIBUTE15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE := NULL;
264 G_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE := NULL;
265
266 /* Procedure to update the resource based on input values passed by calling routines. */
267
268 /*#
269 * Update Resource API
270 * This procedure allows the user to update a resource record
271 * @param p_api_version API version
272 * @param p_init_msg_list Initialization of the message list
273 * @param p_commit Commit
274 * @param p_resource_id Resource Identifier
275 * @param p_resource_number Resource Number
276 * @param p_managing_emp_id Identifier for the manager of the resource
277 * @param p_start_date_active Date on which the resource becomes active. This value can not be NULL, and the start date must be less than the end date.
278 * @param p_end_date_active Date on which the resource is no longer active.
279 * @param p_time_zone Time zone, this value must be a valid time zone as defined in table HZ_TIMEZONES.
280 * @param p_cost_per_hr The salary cost per hour for this resource. This value is used in conjunction with the p_comp_currency_code parameter.
281 * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
282 * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
283 * @param p_support_site_id Value used by the Service applications.
284 * @param p_ies_agent_login Value used by Interaction Center applications (if using Oracle Scripting).
285 * @param p_server_group_id Value used by Interaction Center applications
286 * @param p_assigned_to_group_id The group to which this resource is assigned
287 * @param p_cost_center The cost center to which this resource is assigned
288 * @param p_charge_to_cost_center Cost center to charge against, this may be different than the resource's current cost center.
289 * @param p_comp_currency_code Compensation currency type. This value must be a valid currency code as listed in table FND_CURRENCIES.
290 * @param p_commissionable_flag Whether this resource is eligible for a commission or not.
291 * @param p_hold_reason_code The reason that compensation is being withheld
292 * @param p_hold_payment Whether Withhold compensation or not
293 * @param p_comp_service_team_id The identifier for the team to which this resource belongs
294 * @param p_user_id User Id of the Resource
295 * @param p_object_version_num The object version number of the resource derives from the jtf_rs_resource_extns table.
296 * @param x_return_status Output parameter for return status
297 * @param x_msg_count Output parameter for number of user messages from this procedure
298 * @param x_msg_data Output parameter containing last user message from this procedure
299 * @rep:scope internal
300 * @rep:lifecycle obsolete
301 * @rep:displayname Update Resource API
302 */
303 PROCEDURE update_resource
304 (P_API_VERSION IN NUMBER,
305 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
306 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
307 P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
308 P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
309 P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
310 P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
311 P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
312 P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
313 P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
314 P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
315 P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
316 P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
317 P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
318 P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
319 P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
323 P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
320 P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
321 P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
322 P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
324 P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
325 P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
326 P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
327 P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
328 --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
329 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
330 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
331 X_MSG_COUNT OUT NOCOPY NUMBER,
332 X_MSG_DATA OUT NOCOPY VARCHAR2
333 );
334
335
336 /* Procedure to delete the resource based on input values passed by calling routines. */
337
338 /*#
339 * Delete Resource API
340 * This is the main Resource delete API
341 * This procedure allows the user to delete a TBH resource record
342 * @param p_api_version API version
343 * @param p_init_msg_list Initialization of the message list
344 * @param p_commit Commit
345 * @param p_resource_id Resource identifier
346 * @param x_return_status Output parameter for return status
347 * @param x_msg_count Output parameter for number of user messages from this procedure
348 * @param x_msg_data Output parameter containing last user message from this procedure
349 * @rep:scope public
350 * @rep:lifecycle active
351 * @rep:displayname Delete Resource API
352 * @rep:businessevent oracle.apps.jtf.jres.resource.delete
353 */
354 PROCEDURE delete_resource
355 (P_API_VERSION IN NUMBER,
356 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
357 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
358 P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
359 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
360 X_MSG_COUNT OUT NOCOPY NUMBER,
361 X_MSG_DATA OUT NOCOPY VARCHAR2
362 );
363
364
365 /* Procedure to create the resource with the resource synchronizing parameters. */
366 /*#
367 * Create Resource API
368 * This is the main Resource create API
369 * This procedure allows the user to create a resource record with the resource synchronizing parameters
370 * @param p_api_version API version
371 * @param p_init_msg_list Initialization of the message list
372 * @param p_commit Commit
373 * @param p_category Category of the Resource
374 * @param p_source_id Source identifier of the Resource
375 * @param p_address_id Resource address
376 * @param p_contact_id Resource contact identifier
377 * @param p_managing_emp_id Identifier for the manager of the resource
378 * @param p_managing_emp_num Employee number of the resources manager
379 * @param p_start_date_active Date on which the resource becomes active. This value can not be NULL, and the start date must be less than the end date.
380 * @param p_end_date_active Date on which the resource is no longer active.
381 * @param p_time_zone Time zone, this value must be a valid time zone as defined in table HZ_TIMEZONES.
385 * @param p_support_site_id Value used by the Service applications.
382 * @param p_cost_per_hr The salary cost per hour for this resource. This value is used in conjunction with the p_comp_currency_code parameter.
383 * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
384 * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
386 * @param p_ies_agent_login Value used by Interaction Center applications (if using Oracle Scripting).
387 * @param p_server_group_id Value used by Interaction Center applications
388 * @param p_interaction_center_name Value used by Interaction Center applications
389 * @param p_assigned_to_group_id The group to which this resource is assigned
390 * @param p_cost_center The cost center to which this resource is assigned
391 * @param p_charge_to_cost_center Cost center to charge against, this may be different than the resource's current cost center.
392 * @param p_comp_currency_code Compensation currency type. This value must be a valid currency code as listed in table FND_CURRENCIES.
393 * @param p_commissionable_flag Whether this resource is eligible for a commission or not.
394 * @param p_hold_reason_code The reason that compensation is being withheld
395 * @param p_hold_payment Whether Withhold compensation or not
396 * @param p_comp_service_team_id The identifier for the team to which this resource belongs
397 * @param p_user_id User Id of the Resource
398 * @param p_transaction_number Transaction identifier
399 * @param p_resource_name Name of the Resource
400 * @param p_source_name Name of the source
401 * @param p_source_number Source Number
402 * @param p_source_job_title Source job title
403 * @param p_source_email Source Email
404 * @param p_source_phone Source Phone
405 * @param p_source_org_id Source Organization Identifier
406 * @param p_source_org_name Source Organization Name
407 * @param p_source_address1 Source Address 1
408 * @param p_source_address2 Source Address 2
409 * @param p_source_address3 Source Address 3
410 * @param p_source_address4 Source Address 4
411 * @param p_source_city Source City
412 * @param p_source_postal_code Source postal code
413 * @param p_source_state Source state
414 * @param p_source_province Source province
415 * @param p_source_county Source County
416 * @param p_source_country Source Country
417 * @param p_source_mgr_id Source manager Identifier
418 * @param p_source_mgr_name Source manager Name
419 * @param p_source_business_grp_id Source Business Organization Identifier
420 * @param p_source_business_grp_name Source Business Organization Name
421 * @param p_source_first_name Source First Name
422 * @param p_source_last_name Source Last Name
423 * @param p_source_middle_name Source Middle Name
424 * @param p_source_category Source Category
425 * @param p_source_status Source Status
426 * @param p_source_office Source Office
427 * @param p_source_location Source Location
428 * @param p_source_mailstop Source Mailstop
429 * @param p_user_name User Name
430 * @param p_source_mobile_phone Source Mobile Phone
431 * @param p_source_pager Source Pager
432 * @param p_attribute1 Descriptive flexfield Segment 1
433 * @param p_attribute2 Descriptive flexfield Segment 2
434 * @param p_attribute3 Descriptive flexfield Segment 3
435 * @param p_attribute4 Descriptive flexfield Segment 4
436 * @param p_attribute5 Descriptive flexfield Segment 5
437 * @param p_attribute6 Descriptive flexfield Segment 6
438 * @param p_attribute7 Descriptive flexfield Segment 7
439 * @param p_attribute8 Descriptive flexfield Segment 8
440 * @param p_attribute9 Descriptive flexfield Segment 9
441 * @param p_attribute10 Descriptive flexfield Segment 10
442 * @param p_attribute11 Descriptive flexfield Segment 11
443 * @param p_attribute12 Descriptive flexfield Segment 12
444 * @param p_attribute13 Descriptive flexfield Segment 13
445 * @param p_attribute14 Descriptive flexfield Segment 14
446 * @param p_attribute15 Descriptive flexfield Segment 15
447 * @param p_attribute_category Descriptive flexfield structure definition column
448 * @param x_return_status Output parameter for return status
449 * @param x_msg_count Output parameter for number of user messages from this procedure
450 * @param x_msg_data Output parameter containing last user message from this procedure
451 * @param x_resource_id Out parameter for Resource Identifier
452 * @param x_resource_number Out parameter for Resource Number
453 * @rep:scope public
454 * @rep:lifecycle active
455 * @rep:primaryinstance
456 * @rep:displayname Create Resource API
457 * @rep:businessevent oracle.apps.jtf.jres.resource.create
458 */
459 PROCEDURE create_resource
460 (P_API_VERSION IN NUMBER,
461 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
462 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463 P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
464 P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
465 P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
466 P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
467 P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
468 P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
469 P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
470 P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
471 P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
475 P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
472 P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
473 P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
474 P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
476 P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
477 P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
478 P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
479 P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
480 P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
481 P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
482 P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
483 P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
484 P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
485 P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
486 P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
487 P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
488 P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
489 --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
490 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
491 X_MSG_COUNT OUT NOCOPY NUMBER,
492 X_MSG_DATA OUT NOCOPY VARCHAR2,
493 X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
494 X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
495 P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
496 P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
497 P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
498 P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
499 P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
500 P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
501 P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
502 P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
503 P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
504 P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
505 P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
506 P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
507 P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
508 P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
509 P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
510 P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
511 P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
512 P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
513 P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
514 P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
515 P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
516 P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
517 P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
518 P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
519 P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
520 P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
521 P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
522 P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
523 P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
524 P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
525 P_USER_NAME IN VARCHAR2 DEFAULT NULL,
526 P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
527 P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
528 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
529 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
530 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
531 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
532 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
533 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
534 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
535 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
536 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
540 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
537 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
538 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
539 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
541 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
542 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
543 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
544 );
545
546
547 /* Procedure to update the resource with the resource synchronizing parameters. */
548
549 /* Procedure to create the resource with the resource synchronizing parameters. */
550 /*#
551 * Update Resource API
552 * This is the main Resource update API
553 * This procedure allows the user to update a resource record with the resource synchronizing parameters
554 * @param p_api_version API version
555 * @param p_init_msg_list Initialization of the message list
556 * @param p_commit Commit
557 * @param p_resource_id Resource Identifier
558 * @param p_resource_number Resource Number
559 * @param p_managing_emp_id Identifier for the manager of the resource
560 * @param p_start_date_active Date on which the resource becomes active. This value can not be NULL, and the start date must be less than the end date.
561 * @param p_end_date_active Date on which the resource is no longer active.
562 * @param p_time_zone Time zone, this value must be a valid time zone as defined in table HZ_TIMEZONES.
563 * @param p_cost_per_hr The salary cost per hour for this resource. This value is used in conjunction with the p_comp_currency_code parameter.
564 * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
565 * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
566 * @param p_support_site_id Value used by the Service applications.
567 * @param p_ies_agent_login Value used by Interaction Center applications (if using Oracle Scripting).
568 * @param p_server_group_id Value used by Interaction Center applications
569 * @param p_assigned_to_group_id The group to which this resource is assigned
570 * @param p_cost_center The cost center to which this resource is assigned
571 * @param p_charge_to_cost_center Cost center to charge against, this may be different than the resource's current cost center.
572 * @param p_comp_currency_code Compensation currency type. This value must be a valid currency code as listed in table FND_CURRENCIES.
573 * @param p_commissionable_flag Whether this resource is eligible for a commission or not.
574 * @param p_hold_reason_code The reason that compensation is being withheld
575 * @param p_hold_payment Whether Withhold compensation or not
576 * @param p_comp_service_team_id The identifier for the team to which this resource belongs
577 * @param p_user_id User Id of the Resource
578 * @param p_resource_name Name of the Resource
579 * @param p_source_name Name of the source
580 * @param p_source_number Source Number
581 * @param p_source_job_title Source job title
582 * @param p_source_email Source Email
583 * @param p_source_phone Source Phone
584 * @param p_source_org_id Source Organization Identifier
585 * @param p_source_org_name Source Organization Name
586 * @param p_source_address1 Source Address 1
587 * @param p_source_address2 Source Address 2
588 * @param p_source_address3 Source Address 3
589 * @param p_source_address4 Source Address 4
590 * @param p_source_city Source City
591 * @param p_source_postal_code Source postal code
592 * @param p_source_state Source state
593 * @param p_source_province Source province
594 * @param p_source_county Source County
595 * @param p_source_country Source Country
596 * @param p_source_mgr_id Source manager Identifier
597 * @param p_source_mgr_name Source manager Name
598 * @param p_source_business_grp_id Source Business Organization Identifier
599 * @param p_source_business_grp_name Source Business Organization Name
600 * @param p_source_first_name Source First Name
601 * @param p_source_last_name Source Last Name
602 * @param p_source_middle_name Source Middle Name
603 * @param p_source_category Source Category
604 * @param p_source_status Source Status
605 * @param p_source_office Source Office
606 * @param p_source_location Source Location
607 * @param p_source_mailstop Source Mailstop
608 * @param p_address_id Resource address
609 * @param p_object_version_num The object version number of the resource derives from the jtf_rs_resource_extns table.
610 * @param p_user_name User Name
611 * @param p_source_mobile_phone Source Mobile Phone
612 * @param p_source_pager Source Pager
613 * @param p_attribute1 Descriptive flexfield Segment 1
614 * @param p_attribute2 Descriptive flexfield Segment 2
615 * @param p_attribute3 Descriptive flexfield Segment 3
616 * @param p_attribute4 Descriptive flexfield Segment 4
617 * @param p_attribute5 Descriptive flexfield Segment 5
618 * @param p_attribute6 Descriptive flexfield Segment 6
619 * @param p_attribute7 Descriptive flexfield Segment 7
620 * @param p_attribute8 Descriptive flexfield Segment 8
621 * @param p_attribute9 Descriptive flexfield Segment 9
625 * @param p_attribute13 Descriptive flexfield Segment 13
622 * @param p_attribute10 Descriptive flexfield Segment 10
623 * @param p_attribute11 Descriptive flexfield Segment 11
624 * @param p_attribute12 Descriptive flexfield Segment 12
626 * @param p_attribute14 Descriptive flexfield Segment 14
627 * @param p_attribute15 Descriptive flexfield Segment 15
628 * @param p_attribute_category Descriptive flexfield structure definition column
629 * @param x_return_status Output parameter for return status
630 * @param x_msg_count Output parameter for number of user messages from this procedure
631 * @param x_msg_data Output parameter containing last user message from this procedure
632 * @rep:scope public
633 * @rep:lifecycle active
634 * @rep:primaryinstance
635 * @rep:displayname Update Resource API
636 * @rep:businessevent oracle.apps.jtf.jres.resource.update.user
637 * @rep:businessevent oracle.apps.jtf.jres.resource.update.effectivedate
638 * @rep:businessevent oracle.apps.jtf.jres.resource.update.attributes
639 */
640 PROCEDURE update_resource
641 (P_API_VERSION IN NUMBER,
642 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
643 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
644 P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
645 P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
646 P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
647 P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
648 P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
649 P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
650 P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
651 P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
652 P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
653 P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
654 P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
655 P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
656 P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
657 P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
658 P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
659 P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
660 P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
661 P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
662 P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
663 P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
664 P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
665 --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
666 P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
667 P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
668 P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
669 P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT FND_API.G_MISS_CHAR,
670 P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
671 P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
672 P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
673 P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
674 P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
675 P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
676 P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
677 P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
678 P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
679 P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
680 P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
681 P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
682 P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
683 P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
684 P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
685 P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
689 P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
686 P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
687 P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
688 P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
690 P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
691 P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
692 P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
693 P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
694 P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
695 P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT FND_API.G_MISS_CHAR,
696 P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
697 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
698 P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
699 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
700 X_MSG_COUNT OUT NOCOPY NUMBER,
701 X_MSG_DATA OUT NOCOPY VARCHAR2,
702 P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
703 P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT FND_API.G_MISS_CHAR,
704 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
705 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
706 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
707 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
708 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
709 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
710 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
711 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
712 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
713 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
714 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
715 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
716 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
717 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
718 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
719 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR
720 );
721
722
723 END jtf_rs_resource_pub;