1 PACKAGE jtf_rs_resource_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrsprs.pls 120.2 2010/08/30 06:18:11 rgokavar 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
188 */
189 PROCEDURE create_resource_migrate
190 (P_API_VERSION IN NUMBER,
191 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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;
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;
253 G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%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,
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,
323 P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%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 /* Procedure to delete the resource based on input values passed by calling routines. */
336
337 /*#
338 * Delete Resource API
339 * This is the main Resource delete API
340 * This procedure allows the user to delete a TBH resource record
341 * @param p_api_version API version
342 * @param p_init_msg_list Initialization of the message list
343 * @param p_commit Commit
344 * @param p_resource_id Resource identifier
345 * @param x_return_status Output parameter for return status
346 * @param x_msg_count Output parameter for number of user messages from this procedure
347 * @param x_msg_data Output parameter containing last user message from this procedure
348 * @rep:scope public
349 * @rep:lifecycle active
350 * @rep:displayname Delete Resource API
351 * @rep:businessevent oracle.apps.jtf.jres.resource.delete
352 */
353 PROCEDURE delete_resource
354 (P_API_VERSION IN NUMBER,
355 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
356 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
357 P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
358 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
359 X_MSG_COUNT OUT NOCOPY NUMBER,
360 X_MSG_DATA OUT NOCOPY VARCHAR2
361 );
362
363
364 /* Procedure to create the resource with the resource synchronizing parameters. */
365 /*#
366 * Create Resource API
367 * This is the main Resource create API
368 * This procedure allows the user to create a resource record with the resource synchronizing parameters
369 * @param p_api_version API version
370 * @param p_init_msg_list Initialization of the message list
371 * @param p_commit Commit
372 * @param p_category Category of the Resource
373 * @param p_source_id Source identifier of the Resource
374 * @param p_address_id Resource address
375 * @param p_contact_id Resource contact identifier
376 * @param p_managing_emp_id Identifier for the manager of the resource
377 * @param p_managing_emp_num Employee number of the resources manager
378 * @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.
379 * @param p_end_date_active Date on which the resource is no longer active.
380 * @param p_time_zone Time zone, this value must be a valid time zone as defined in table HZ_TIMEZONES.
381 * @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.
382 * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
383 * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
384 * @param p_support_site_id Value used by the Service applications.
385 * @param p_ies_agent_login Value used by Interaction Center applications (if using Oracle Scripting).
386 * @param p_server_group_id Value used by Interaction Center applications
387 * @param p_interaction_center_name Value used by Interaction Center applications
388 * @param p_assigned_to_group_id The group to which this resource is assigned
389 * @param p_cost_center The cost center to which this resource is assigned
390 * @param p_charge_to_cost_center Cost center to charge against, this may be different than the resource's current cost center.
391 * @param p_comp_currency_code Compensation currency type. This value must be a valid currency code as listed in table FND_CURRENCIES.
392 * @param p_commissionable_flag Whether this resource is eligible for a commission or not.
393 * @param p_hold_reason_code The reason that compensation is being withheld
394 * @param p_hold_payment Whether Withhold compensation or not
395 * @param p_comp_service_team_id The identifier for the team to which this resource belongs
396 * @param p_user_id User Id of the Resource
397 * @param p_transaction_number Transaction identifier
398 * @param p_resource_name Name of the Resource
399 * @param p_source_name Name of the source
400 * @param p_source_number Source Number
401 * @param p_source_job_title Source job title
402 * @param p_source_email Source Email
403 * @param p_source_phone Source Phone
404 * @param p_source_org_id Source Organization Identifier
405 * @param p_source_org_name Source Organization Name
406 * @param p_source_address1 Source Address 1
407 * @param p_source_address2 Source Address 2
408 * @param p_source_address3 Source Address 3
409 * @param p_source_address4 Source Address 4
410 * @param p_source_city Source City
411 * @param p_source_postal_code Source postal code
412 * @param p_source_state Source state
413 * @param p_source_province Source province
414 * @param p_source_county Source County
415 * @param p_source_country Source Country
416 * @param p_source_mgr_id Source manager Identifier
417 * @param p_source_mgr_name Source manager Name
418 * @param p_source_business_grp_id Source Business Organization Identifier
419 * @param p_source_business_grp_name Source Business Organization Name
420 * @param p_source_first_name Source First Name
421 * @param p_source_last_name Source Last Name
422 * @param p_source_middle_name Source Middle Name
423 * @param p_source_category Source Category
424 * @param p_source_status Source Status
425 * @param p_source_office Source Office
426 * @param p_source_location Source Location
427 * @param p_source_mailstop Source Mailstop
428 * @param p_user_name User Name
429 * @param p_source_mobile_phone Source Mobile Phone
430 * @param p_source_pager Source Pager
431 * @param p_attribute1 Descriptive flexfield Segment 1
432 * @param p_attribute2 Descriptive flexfield Segment 2
433 * @param p_attribute3 Descriptive flexfield Segment 3
434 * @param p_attribute4 Descriptive flexfield Segment 4
435 * @param p_attribute5 Descriptive flexfield Segment 5
436 * @param p_attribute6 Descriptive flexfield Segment 6
437 * @param p_attribute7 Descriptive flexfield Segment 7
438 * @param p_attribute8 Descriptive flexfield Segment 8
439 * @param p_attribute9 Descriptive flexfield Segment 9
440 * @param p_attribute10 Descriptive flexfield Segment 10
441 * @param p_attribute11 Descriptive flexfield Segment 11
442 * @param p_attribute12 Descriptive flexfield Segment 12
443 * @param p_attribute13 Descriptive flexfield Segment 13
444 * @param p_attribute14 Descriptive flexfield Segment 14
445 * @param p_attribute15 Descriptive flexfield Segment 15
446 * @param p_attribute_category Descriptive flexfield structure definition column
447 * @param x_return_status Output parameter for return status
448 * @param x_msg_count Output parameter for number of user messages from this procedure
449 * @param x_msg_data Output parameter containing last user message from this procedure
450 * @param x_resource_id Out parameter for Resource Identifier
451 * @param x_resource_number Out parameter for Resource Number
452 * @rep:scope public
453 * @rep:lifecycle active
454 * @rep:primaryinstance
455 * @rep:displayname Create Resource API
456 * @rep:businessevent oracle.apps.jtf.jres.resource.create
457 */
458 PROCEDURE create_resource
459 (P_API_VERSION IN NUMBER,
460 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
461 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
462 P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
463 P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
464 P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
465 P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
466 P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
467 P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
468 P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
469 P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
470 P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
471 P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
472 P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
473 P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
474 P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
475 P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
476 P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
477 P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
478 P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
479 P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
480 P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
481 P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
482 P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
483 P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
484 P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
485 P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
486 P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
487 P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
488 --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
489 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
490 X_MSG_COUNT OUT NOCOPY NUMBER,
491 X_MSG_DATA OUT NOCOPY VARCHAR2,
492 X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
493 X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
494 P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
495 P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
496 P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
497 P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
498 P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
499 P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
500 P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
501 P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
502 P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
503 P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
504 P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
505 P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
506 P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
507 P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
508 P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
509 P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
510 P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
511 P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
512 P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
513 P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
514 P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
515 P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
516 P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
517 P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
518 P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
519 P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
520 P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
521 P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
522 P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
523 P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
524 P_USER_NAME IN VARCHAR2 DEFAULT NULL,
525 P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
526 P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
527 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
528 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
529 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
530 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
531 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
532 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
533 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
534 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
535 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
536 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
537 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
538 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
539 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
540 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
541 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
542 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
543 );
544
545
546 /* Procedure to update the resource with the resource synchronizing parameters. */
547
548 /*#
549 * Update Resource API
550 * This is the main Resource update API
551 * This procedure allows the user to update a resource record with the resource synchronizing parameters
552 * @param p_api_version API version
553 * @param p_init_msg_list Initialization of the message list
554 * @param p_commit Commit
555 * @param p_resource_id Resource Identifier
556 * @param p_resource_number Resource Number
557 * @param p_managing_emp_id Identifier for the manager of the resource
558 * @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.
559 * @param p_end_date_active Date on which the resource is no longer active.
560 * @param p_time_zone Time zone, this value must be a valid time zone as defined in table HZ_TIMEZONES.
561 * @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.
562 * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
563 * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
564 * @param p_support_site_id Value used by the Service applications.
565 * @param p_ies_agent_login Value used by Interaction Center applications (if using Oracle Scripting).
566 * @param p_server_group_id Value used by Interaction Center applications
567 * @param p_assigned_to_group_id The group to which this resource is assigned
568 * @param p_cost_center The cost center to which this resource is assigned
569 * @param p_charge_to_cost_center Cost center to charge against, this may be different than the resource's current cost center.
570 * @param p_comp_currency_code Compensation currency type. This value must be a valid currency code as listed in table FND_CURRENCIES.
571 * @param p_commissionable_flag Whether this resource is eligible for a commission or not.
572 * @param p_hold_reason_code The reason that compensation is being withheld
573 * @param p_hold_payment Whether Withhold compensation or not
574 * @param p_comp_service_team_id The identifier for the team to which this resource belongs
575 * @param p_user_id User Id of the Resource
576 * @param p_resource_name Name of the Resource
577 * @param p_source_name Name of the source
578 * @param p_source_number Source Number
579 * @param p_source_job_title Source job title
580 * @param p_source_email Source Email
581 * @param p_source_phone Source Phone
582 * @param p_source_org_id Source Organization Identifier
583 * @param p_source_org_name Source Organization Name
584 * @param p_source_address1 Source Address 1
585 * @param p_source_address2 Source Address 2
586 * @param p_source_address3 Source Address 3
587 * @param p_source_address4 Source Address 4
588 * @param p_source_city Source City
589 * @param p_source_postal_code Source postal code
590 * @param p_source_state Source state
591 * @param p_source_province Source province
592 * @param p_source_county Source County
593 * @param p_source_country Source Country
594 * @param p_source_mgr_id Source manager Identifier
595 * @param p_source_mgr_name Source manager Name
596 * @param p_source_business_grp_id Source Business Organization Identifier
597 * @param p_source_business_grp_name Source Business Organization Name
598 * @param p_source_first_name Source First Name
599 * @param p_source_last_name Source Last Name
600 * @param p_source_middle_name Source Middle Name
601 * @param p_source_category Source Category
602 * @param p_source_status Source Status
603 * @param p_source_office Source Office
604 * @param p_source_location Source Location
605 * @param p_source_mailstop Source Mailstop
606 * @param p_address_id Resource address
607 * @param p_object_version_num The object version number of the resource derives from the jtf_rs_resource_extns table.
608 * @param p_user_name User Name
609 * @param p_source_mobile_phone Source Mobile Phone
610 * @param p_source_pager Source Pager
611 * @param p_attribute1 Descriptive flexfield Segment 1
612 * @param p_attribute2 Descriptive flexfield Segment 2
613 * @param p_attribute3 Descriptive flexfield Segment 3
614 * @param p_attribute4 Descriptive flexfield Segment 4
615 * @param p_attribute5 Descriptive flexfield Segment 5
616 * @param p_attribute6 Descriptive flexfield Segment 6
617 * @param p_attribute7 Descriptive flexfield Segment 7
618 * @param p_attribute8 Descriptive flexfield Segment 8
619 * @param p_attribute9 Descriptive flexfield Segment 9
620 * @param p_attribute10 Descriptive flexfield Segment 10
621 * @param p_attribute11 Descriptive flexfield Segment 11
622 * @param p_attribute12 Descriptive flexfield Segment 12
623 * @param p_attribute13 Descriptive flexfield Segment 13
624 * @param p_attribute14 Descriptive flexfield Segment 14
625 * @param p_attribute15 Descriptive flexfield Segment 15
626 * @param p_attribute_category Descriptive flexfield structure definition column
627 * @param x_return_status Output parameter for return status
628 * @param x_msg_count Output parameter for number of user messages from this procedure
629 * @param x_msg_data Output parameter containing last user message from this procedure
630 * @rep:scope public
631 * @rep:lifecycle active
632 * @rep:primaryinstance
633 * @rep:displayname Update Resource API
634 * @rep:businessevent oracle.apps.jtf.jres.resource.update.user
635 * @rep:businessevent oracle.apps.jtf.jres.resource.update.effectivedate
636 * @rep:businessevent oracle.apps.jtf.jres.resource.update.attributes
637 */
638 PROCEDURE update_resource
639 (P_API_VERSION IN NUMBER,
640 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
641 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
642 P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
643 P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
644 P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
645 P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
646 P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
647 P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
648 P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
649 P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
650 P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
651 P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
652 P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
653 P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
654 P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
655 P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
656 P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
657 P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
658 P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
659 P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
660 P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
661 P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
662 P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
663 --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
664 P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
665 P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
666 P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
667 P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT FND_API.G_MISS_CHAR,
668 P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
669 P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
670 P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
671 P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
672 P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
673 P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
674 P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
675 P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
676 P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
677 P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
678 P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
679 P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
680 P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
681 P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
682 P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
683 P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
684 P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
685 P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
686 P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
687 P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
688 P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
689 P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
690 P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
691 P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
692 P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
693 P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT FND_API.G_MISS_CHAR,
694 P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
695 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
696 P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
697 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
698 X_MSG_COUNT OUT NOCOPY NUMBER,
699 X_MSG_DATA OUT NOCOPY VARCHAR2,
700 P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
701 P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT FND_API.G_MISS_CHAR,
702 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
703 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
704 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
705 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
706 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
707 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
708 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
709 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
710 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
711 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
712 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
713 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
714 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
715 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
716 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
717 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR
718 );
719
720 /*
721 | Modification History :
722 |
723 | Sudhir Gokavarapu ER9864816 - New procedure Created, FS_SETUP_COMPLETE parameter is added to
724 | existing UPDATE_RESOURSE parameter list.
725 */
726
727 /* Procedure to update the resource with the resource synchronizing parameters along with FS Setup Complete Flag. */
728
729 /*#
730 * Update Resource API
731 * This is the main Resource update API
732 * This procedure allows the user to update a resource record with the resource synchronizing parameters
733 * @param p_api_version API version
734 * @param p_init_msg_list Initialization of the message list
735 * @param p_commit Commit
736 * @param p_resource_id Resource Identifier
737 * @param p_resource_number Resource Number
738 * @param p_managing_emp_id Identifier for the manager of the resource
739 * @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.
740 * @param p_end_date_active Date on which the resource is no longer active.
741 * @param p_time_zone Time zone, this value must be a valid time zone as defined in table HZ_TIMEZONES.
742 * @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.
743 * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
744 * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
745 * @param p_support_site_id Value used by the Service applications.
746 * @param p_ies_agent_login Value used by Interaction Center applications (if using Oracle Scripting).
747 * @param p_server_group_id Value used by Interaction Center applications
748 * @param p_assigned_to_group_id The group to which this resource is assigned
749 * @param p_cost_center The cost center to which this resource is assigned
750 * @param p_charge_to_cost_center Cost center to charge against, this may be different than the resource's current cost center.
751 * @param p_comp_currency_code Compensation currency type. This value must be a valid currency code as listed in table FND_CURRENCIES.
752 * @param p_commissionable_flag Whether this resource is eligible for a commission or not.
753 * @param p_hold_reason_code The reason that compensation is being withheld
754 * @param p_hold_payment Whether Withhold compensation or not
755 * @param p_comp_service_team_id The identifier for the team to which this resource belongs
756 * @param p_user_id User Id of the Resource
757 * @param p_resource_name Name of the Resource
758 * @param p_source_name Name of the source
759 * @param p_source_number Source Number
760 * @param p_source_job_title Source job title
761 * @param p_source_email Source Email
762 * @param p_source_phone Source Phone
763 * @param p_source_org_id Source Organization Identifier
764 * @param p_source_org_name Source Organization Name
765 * @param p_source_address1 Source Address 1
766 * @param p_source_address2 Source Address 2
767 * @param p_source_address3 Source Address 3
768 * @param p_source_address4 Source Address 4
769 * @param p_source_city Source City
770 * @param p_source_postal_code Source postal code
771 * @param p_source_state Source state
772 * @param p_source_province Source province
773 * @param p_source_county Source County
774 * @param p_source_country Source Country
775 * @param p_source_mgr_id Source manager Identifier
776 * @param p_source_mgr_name Source manager Name
777 * @param p_source_business_grp_id Source Business Organization Identifier
778 * @param p_source_business_grp_name Source Business Organization Name
779 * @param p_source_first_name Source First Name
780 * @param p_source_last_name Source Last Name
781 * @param p_source_middle_name Source Middle Name
782 * @param p_source_category Source Category
783 * @param p_source_status Source Status
784 * @param p_source_office Source Office
785 * @param p_source_location Source Location
786 * @param p_source_mailstop Source Mailstop
787 * @param p_address_id Resource address
788 * @param p_object_version_num The object version number of the resource derives from the jtf_rs_resource_extns table.
789 * @param p_user_name User Name
790 * @param p_source_mobile_phone Source Mobile Phone
791 * @param p_source_pager Source Pager
792 * @param p_attribute1 Descriptive flexfield Segment 1
793 * @param p_attribute2 Descriptive flexfield Segment 2
794 * @param p_attribute3 Descriptive flexfield Segment 3
795 * @param p_attribute4 Descriptive flexfield Segment 4
796 * @param p_attribute5 Descriptive flexfield Segment 5
797 * @param p_attribute6 Descriptive flexfield Segment 6
798 * @param p_attribute7 Descriptive flexfield Segment 7
799 * @param p_attribute8 Descriptive flexfield Segment 8
800 * @param p_attribute9 Descriptive flexfield Segment 9
801 * @param p_attribute10 Descriptive flexfield Segment 10
802 * @param p_attribute11 Descriptive flexfield Segment 11
803 * @param p_attribute12 Descriptive flexfield Segment 12
804 * @param p_attribute13 Descriptive flexfield Segment 13
805 * @param p_attribute14 Descriptive flexfield Segment 14
806 * @param p_attribute15 Descriptive flexfield Segment 15
807 * @param p_attribute_category Descriptive flexfield structure definition column
808 * @param p_fs_setup_complete The status on Field service Setup completion for a particular resource.
809 * @param x_return_status Output parameter for return status
810 * @param x_msg_count Output parameter for number of user messages from this procedure
811 * @param x_msg_data Output parameter containing last user message from this procedure
812 * @rep:scope public
813 * @rep:lifecycle active
814 * @rep:primaryinstance
815 * @rep:displayname Update Resource API
816 * @rep:businessevent oracle.apps.jtf.jres.resource.update.user
817 * @rep:businessevent oracle.apps.jtf.jres.resource.update.effectivedate
818 * @rep:businessevent oracle.apps.jtf.jres.resource.update.attributes
819 */
820 PROCEDURE update_resource
821 (P_API_VERSION IN NUMBER,
822 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
823 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
824 P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
825 P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
826 P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
827 P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
828 P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
829 P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
830 P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
831 P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
832 P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
833 P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
834 P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
835 P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
836 P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
837 P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
838 P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
839 P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
840 P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
841 P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
842 P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
843 P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
844 P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
845 --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
846 P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
847 P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
848 P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
849 P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT FND_API.G_MISS_CHAR,
850 P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
851 P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
852 P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
853 P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
854 P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
855 P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
856 P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
857 P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
858 P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
859 P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
860 P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
861 P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
862 P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
863 P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
864 P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
865 P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
866 P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
867 P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
868 P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
869 P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
870 P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
871 P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
872 P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
873 P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
874 P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
875 P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT FND_API.G_MISS_CHAR,
876 P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
877 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
878 P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
879 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
880 X_MSG_COUNT OUT NOCOPY NUMBER,
881 X_MSG_DATA OUT NOCOPY VARCHAR2,
882 P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
883 P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT FND_API.G_MISS_CHAR,
884 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
885 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
886 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
887 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
888 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
889 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
890 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
891 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
892 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
893 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
894 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
895 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
896 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
897 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
898 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
899 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
900 P_FS_SETUP_COMPLETE IN JTF_RS_RESOURCE_EXTNS.FS_SETUP_COMPLETE%TYPE
901 );
902
903 END jtf_rs_resource_pub;
[Home] [Help]