1 PACKAGE PA_RES_MANAGEMENT_AMG_PUB AUTHID CURRENT_USER AS
2 /* $Header: PAPMRSPS.pls 120.1.12010000.3 2010/03/22 09:55:59 vgovvala ship $ */
3 /*#
4 * This package contains the public APIs for Project Resource Management
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Resource Management Public API
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJ_RESOURCE
11 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
12 */
13 -- This record type is used for passing the requirement information to APIs.
14 /* Name: REQUIREMENT_IN_REC_TYPE
15 * Description: This record is used to pass the required parameters for
16 * requirement APIs.
17 *
18 * Attributes:
19 * REQUIREMENT_ID Identifier of the requirement
20 * Usage: Update, Delete
21 * Reference: pa_project_assignments.assignment_id
22 * REQUIREMENT_NAME The user-defined name that identifies the requirement.
23 * If a value is not supplied, the role name is used
24 * Usage: Create, Update
25 * Reference: pa_project_assignments.assignment_name
26 * TEAM_TEMPLATE_ID The identifier of the requirement template to which
27 * this requirement belongs
28 * Usage: Create
29 * Reference: pa_team_templates.team_template_id
30 * NUMBER_OF_REQUIREMENTS The number of requirements that you want to create
31 * using the details passed in. This parameter is used
32 * when creating requirements for team template
33 * Usage: Create
34 * Reference:N/A
35 * PROJECT_ROLE_ID Identifier of the project role for the requirement.
36 * The role must be part of the role list, if a role
37 * list is attached to the project or team template
38 * Usage: Create
39 * Reference: pa_project_assignments.project_role_id
40 * PROJECT_ROLE_NAME The name of the project role. Used when PROJECT_ROLE_ID
41 * is not supplied. The role must be part of the role list,
42 * if a role list is attached to the project or team template
43 * Usage: Create
44 * Reference: pa_project_role_types.meaning
45 * PROJECT_ID The identifier of the project to which this requirement belongs
46 * Usage: Create
47 * Reference: pa_project_assignments.project_id
48 * PROJECT_NAME The name of the project to which this requirement belongs.
49 * Used when PROJECT_ID is not supplied
50 * Usage: Create
51 * Reference: pa_projects_all.name
52 * PROJECT_NUMBER The number of the project to which this requirement belongs.
53 * Used when PROJECT_ID is not supplied
54 * Usage: Create
55 * Reference: pa_projects_all.segment1
56 * STAFFING_OWNER_PERSON_ID The owner person for the staffing of this requirement.
57 * If not supplied, the value is obtained from the project setup
58 * Usage: Create, Update
59 * Reference: pa_project_assignments.staffing_owner_person_id
60 * STAFFING_PRIORITY_CODE The staffing priority of the requirement. Valid values
61 * are obtained from lookup type STAFFING_PRIORITY_CODE
62 * Usage: Create, Update
63 * Reference: pa_project_assignments.staffing_priority_code
64 * STAFFING_PRIORITY_NAME The name of the staffing priority of the requirement. Used
65 * when STAFFING_PRIORITY_CODE is not supplied. Valid values
66 * are obtained from lookup type STAFFING_PRIORITY_CODE
67 * Usage: Create, Update
68 * Reference: pa_lookups.meaning
69 * PROJECT_SUBTEAM_ID The identifier for the project subteam to which this
70 * requirement belongs
71 * Usage: Create, Update
72 * Reference: pa_project_assignments.project_subteam_id
73 * PROJECT_SUBTEAM_NAME The name of the project subteam to which this requirement
74 * belongs. Used when PROJECT_SUBTEAM_ID is not supplied
75 * Usage: Create, Update
76 * Reference: pa_project_subteams.name
77 * LOCATION_ID Identifier of the location of the requirement. For new
78 * requirements, this parameter gets its default value from
79 * the project setup
80 * Usage: Create, Update
81 * Reference: pa_project_assignments.location_id
82 * LOCATION_COUNTRY_CODE The country code of the location. Used when LOCATION_ID is
83 * not supplied
84 * Usage: Create, Update
85 * Reference: pa_locations.country_code
86 * LOCATION_COUNTRY_NAME The country where this requirement will be performed. Used
87 * when LOCATION_ID is not supplied
88 * Usage: Create, Update
89 * Reference: fnd_territories_tl.territory_short_name
90 * LOCATION_REGION The region where this requirement will be performed. Used
91 * when LOCATION_ID is not supplied
92 * Usage: Create, Update
93 * Reference: pa_locations.region
94 * LOCATION_CITY The city where this requirement will be performed. Used
95 * when LOCATION_ID is not supplied
96 * Usage: Create, Update
97 * Reference: pa_locations.city
98 * MIN_RESOURCE_JOB_LEVEL The minimum acceptable job level for the requirement.
99 * For new requirements, this parameter obtains its default
100 * values from the project roles setup
101 * Usage: Create, Update
102 * Reference: pa_project_assignments.min_resource_job_level
103 * MAX_RESOURCE_JOB_LEVEL The maximum acceptable job level for the requirement.
104 * For new requirements, this parameter obtains its default
105 * values from the project roles setup
106 * Usage: Create, Update
107 * Reference: pa_project_assignments.max_resource_job_level
108 * DESCRIPTION The free text description of the requirement
109 * Usage: Create, Update
110 * Reference: pa_project_assignments.description
111 * ADDITIONAL_INFORMATION The free text additional information of the requirement
112 * Usage: Create, Update
113 * Reference: pa_project_assignments.additional_information
114 * START_DATE The start date of the requirement
115 * Usage: Create
116 * Reference: Pa_project_assignments.start_date
117 * END_DATE The end date of the requirement
118 * Usage: Create
119 * Reference: Pa_project_assignments.end_date
120 * STATUS_CODE The status of the requirement. This parameter may be null
121 * if the underlying schedule has multiple status codes.
122 * Valid values are obtained from PA_PROJECT_STATUSES with
123 * status type as OPEN_ASGMT
124 * Usage: Create, Update
125 * Reference: pa_project_assignments.status_code
126 * STATUS_NAME The status of the requirement. Used when STATUS_CODE is
127 * not supplied. Valid values are obtained from
128 * PA_PROJECT_STATUSES with status type as OPEN_ASGMT
129 * Usage: Create, Update
130 * Reference: pa_project_statuses.project_status_name
131 * CALENDAR_TYPE The base calendar used to generate schedules. It can be a
132 * project calendar, resource calendar or any other calendar.
133 * For requirements, the base calendar cannot be a resource
134 * calendar.Valid values are obtained from lookup type
135 * CHANGE_CALENDAR_TYPE_CODE
136 * Usage: Create
137 * Reference: pa_lookups.lookup_code
138 * CALENDAR_ID Identifier of the calendar for the requirement. If
139 * P_CALENDAR_TYPE is PROJECT, then the default value is
140 * obtained from the project setup
141 * Usage: Create
142 * Reference: pa_project_assignments.calendar_id
143 * CALENDAR_NAME The calendar for the requirement. If P_CALENDAR_TYPE is
144 * PROJECT, then the default value is obtained from the project
145 * setup. Used when CALENDAR_ID is not supplied
146 * Usage: Create
147 * Reference: jtf_calendars_tl.calendar_name
148 * START_ADV_ACTION_SET_FLAG Flag indicating whether the advertisement rule will start
149 * automatically. If not specified, the value is obtained
150 * from the project setup
151 * Usage: Create
152 * Reference: pa_projects_all.start_adv_action_set_flag
153 * ADV_ACTION_SET_ID Identifier of the advertisement rule to be applied on this
154 * requirement. If not specified, the value is obtained from
155 * project setup
156 * Usage: Create
157 * Reference: pa_action_sets.action_set_id
158 * ADV_ACTION_SET_NAME The name of the advertisement rule to be applied on this
159 * requirement. If not specified, the value is obtained from
160 * project setup.from the project setup. Used when
161 * ADV_ACTION_SET_ID is not supplied
162 * Usage: Create
163 * Reference: pa_action_sets.action_set_name
164 * COMP_MATCH_WEIGHTING The weight of competence match for evaluating candidate search
165 * score. If not specified, the value is obtained from the project setup
166 * Usage: Create, Update
167 * Reference: pa_project_assignments.competence_match_weighting
168 * AVAIL_MATCH_WEIGHTING The weight of availability match for evaluating candidate search
169 * score. If not specified, the value is obtained from project setup
170 * Usage: Create, Update
171 * Reference: pa_project_assignments.availability_match_weighting
172 * JOB_LEVEL_MATCH_WEIGHTING The weight of job match for evaluating candidate search score.
173 * If not specified, then the value is obtained from the project setup.
174 * Usage: Create, Update
175 * Reference: pa_project_assignments.job_level_match_weighting
176 * ENABLE_AUTO_CAND_NOM_FLAG Flag indicating whether to enable automatic candidate nominations
177 * for this requirement. If not specified, then the value is
178 * obtained from the project setup
179 * Usage: Create, Update
180 * Reference: pa_project_assignments.enable_auto_cand_nom_flag
181 * SEARCH_MIN_AVAILABILITY The minimum availability percentage of resources that can be
182 * assigned on this requirement. If not specified, then the value
183 * is obtained from the project setup
184 * Usage: Create, Update
185 * Reference: pa_project_assignments.search_min_availability
186 * SEARCH_EXP_ORG_STR_VER_ID Identifier of the expenditure organization hierarchy version.
187 * This parameter is used in candidate searches for this requirement.
188 * If not specified, then the value is obtained from the project setup
189 * Usage: Create, Update
190 * Reference: pa_project_assignments.search_exp_org_struct_ver_id
191 * SEARCH_EXP_ORG_HIER_NAME The expenditure organization hierarchy name. This parameter is
192 * used in candidate searches for this requirement if
193 * SEARCH_EXP_ORG_STRUCT_VER_ID is not specified. If the hierarchy
194 * has multiple versions, then you must supply a value for
195 * SEARCH_EXP_ORG_STRUCT_VER_ID, so that the API find the version
196 * Usage: Create, Update
197 * Reference: per_organization_structures.name
198 * SEARCH_EXP_START_ORG_ID Identifier of the start organization in the organization hierarchy.
199 * This parameter is used in candidate searches for this requirement.
200 * If not specified, then the value is obtained from the project setup
201 * Usage: Create, Update
202 * Reference: pa_project_assignments.search_exp_start_org_id
203 * SEARCH_EXP_START_ORG_NAME The start organization name in the organization hierarchy. This
204 * parameter is used in candidate searches for this requirement if
205 * SEARCH_EXP_START_ORG_ID is not specified
206 * Usage: Create, Update
207 * Reference: hr_organization_units.name
208 * SEARCH_COUNTRY_CODE The country code for candidate search. If not specified, then
209 * the value is obtained from the project setup
210 * Usage: Create, Update
211 * Reference: pa_project_assignments.search_country_code
212 * SEARCH_COUNTRY_NAME The country name for candidate search. If not specified, then
213 * the value is obtained from the project setup
214 * Usage: Create, Update
215 * Reference: fnd_territories_tl.territory_short_name
216 * SEARCH_MIN_CANDIDATE_SCORE The minimum score required for candidate nomination. If not
217 * specified, then the value is obtained from the project setup
218 * Usage: Create, Update
219 * Reference: pa_project_assignments.search_min_candidate_score
220 * EXPENDITURE_ORG_ID The default operating unit for the requirement. If not
221 * specified, then the value is obtained from the project setup
222 * Usage: Create, Update
223 * Reference: pa_project_assignments.expenditure_org_id
224 * EXPENDITURE_ORG_NAME The default operating unit for the requirement. If not
225 * specified, then the value is obtained from the project setup
226 * Usage: Create, Update
227 * Reference: hr_organizations_tl.name
228 * EXPENDITURE_ORGANIZATION_ID The project organization for the requirement. If not
229 * specified, then the value is obtained from the project setup
230 * Usage: Create, Update
231 * Reference: pa_project_assignments. expenditure_organization_id
232 * EXPENDITURE_ORGANIZATION_NAME The project organization for the requirement. If not
233 * specified, then the value is obtained from the project setup
234 * Usage: Create, Update
235 * Reference: hr_organizations_tl.name
236 * EXPENDITURE_TYPE_CLASS The expenditure type class to be used to generate forecast
237 * transactions. If not specified, the value is obtained from the
238 * forecasting options. Valid values are: ST - Straight Time
239 * OT - Overtime
240 * Usage: Create, Update
241 * Reference: pa_project_assignments.expenditure_type_class
242 * EXPENDITURE_TYPE Identifies the type of expenditure used to generate forecast
243 * transactions. If not specified, the value is obtained from the
244 * forecasting options.
245 * Usage: Create, Update
246 * Reference: pa_project_assignments.expenditure_type
247 * FCST_JOB_GROUP_ID Identifier of the job group associated with the forecasting job.
248 * If not specified, the value is obtained from the team role
249 * Usage: Create, Update
250 * Reference: pa_project_assignments.fcst_job_group_id
251 * FCST_JOB_GROUP_NAME The job group name associated with the forecasting job. If
252 * not specified, the value is obtained from the team role.
253 * This parameter is used when FCST_JOB_GROUP_ID is not supplied
254 * Usage: Create, Update
255 * Reference: per_job_groups.displayed_name
256 * FCST_JOB_ID The identifier of the job for the forecast of the requirement.
257 * This parameter is used to determine cost, revenue, and transfer
258 * price rates for the requirement during forecast processing.
259 * Usage: Create, Update
260 * Reference: pa_project_assignments.fcst_job_id
261 * FCST_JOB_NAME The job name for the forecast of the requirement. This parameter
262 * is used to determine cost, revenue, and transfer price rates for
263 * the requirement during forecast processing. It is used when
264 * FCST_JOB_ID is not supplied
265 * Usage: Create, Update
266 * Reference: per_jobs.name
267 * WORK_TYPE_ID The type of work being performed. This parameter is used as a
268 * default value for work type schedules. The default value is
269 * obtained from the project setup
270 * Usage: Create, Update
271 * Reference: pa_project_assignments.work_type_id
272 * WORK_TYPE_NAME The work type name being performed. Used when WORK_TYPE_ID
273 * is not supplied
274 * Usage: Create, Update
275 * Reference: pa_work_types_vl.name
276 * BILL_RATE_OPTION The bill rate option. Valid values are: RATE, MARKUP, DISCOUNT, NONE
277 * Usage: Create, Update
278 * Reference: N/A
279 * BILL_RATE_OVERRIDE The override bill rate for the requirement. This parameter is
280 * used when the value of BILL_RATE_OPTION is RATE.
281 * Usage: Create, Update
282 * Reference: pa_project_assignments.bill_rate_override
283 * BILL_RATE_CURR_OVERRIDE The override bill rate currency code for the requirement. This
284 * parameter is used when the value of BILL_RATE_OPTION is RATE
285 * and a value is supplied for BILL_RATE_OVERRIDE
286 * Usage: Create, Update
287 * Reference: pa_project_assignments.bill_rate_curr_override
288 * MARKUP_PERCENT_OVERRIDE The override markup percentage for the requirement. This
289 * parameter is used when the value of BILL_RATE_OPTION is MARKUP
290 * Usage: Create, Update
291 * Reference: pa_project_assignments.markup_percent_override
292 * DISCOUNT_PERCENTAGE The override discounts percentage for the requirement. This
293 * parameter is used when the value of BILL_RATE_OPTION is DISCOUNT
294 * Usage: Create, Update
295 * Reference: pa_project_assignments.discount_percentage
296 * RATE_DISC_REASON_CODE The identifier of the discount reason for discount. This parameter
297 * is mandatory when either of BILL_RATE_OVERRIDE, MARKUP_PERCENT_OVERRIDE
298 * DISCOUNT_PERCENTAGE is supplied, and "Require Rate and Discount Reason"
299 * option is enabled in implementation. Valid values are obtained from
300 * lookup type RATE AND DISCOUNT REASON. This parameter is not used when
301 * the value of BILL_RATE_OPTION is NONE
302 * Usage: Create, Update
303 * Reference: pa_project_assignments.rate_disc_reason_code
304 * TP_RATE_OPTION The transfer price options. Valid values are:RATE, BASIS, NONE
305 * Usage: Create, Update
306 * Reference: N/A
307 * TP_RATE_OVERRIDE The override transfer price rate for the requirement. This
308 * parameter is used when the value of TP_RATE_OPTION is RATE
309 * Usage: Create, Update
310 * Reference: pa_project_assignments.tp_rate_override
311 * TP_CURRENCY_OVERRIDE The override transfer price currency code for the requirement.
312 * Used when a value is supplied for TP_RATE_OVERRIDE, and the
313 * value of TP_RATE_OPTION is RATE.
314 * Usage: Create, Update
315 * Reference: pa_project_assignments.tp_currency_override
316 * TP_CALC_BASE_CODE_OVERRIDE The override transfer price basis code (for example, raw cost,
317 * or burden cost, etc). This parameter is used when the value of
318 * TP_RATE_OPTION is BASIS. The valid values can be obtained from
319 * lookup type CC_MARKUP_BASE_CODE
320 * Usage: Create, Update
321 * Reference: pa_project_assignments.tp_calc_base_code_override
322 * TP_PERCENT_APPLIED_OVERRIDE Percentage of a given basis. This parameter is used when the
323 * value of TP_RATE_OPTION is BASIS and a value is supplied for
324 * TP_CALC_BASE_CODE_OVERRIDE
325 * Usage: Create, Update
326 * Reference: pa_project_assignments.tp_percent_applied_override
327 * EXTENSION_POSSIBLE Flag indicating whether it is possible to extend the requirement.
328 * Valid values are Y and N
329 * Usage: Create, Update
330 * Reference: pa_project_assignments.extension_possible
331 * EXPENSE_OWNER The owner of the requirement expenses. The valid values can be
332 * obtained from lookup type EXPENSE_OWNER_TYPE
333 * Usage: Create, Update
334 * Reference: pa_project_assignments.expense_owner
335 * EXPENSE_LIMIT The maximum amount that the expense owner is willing to pay
336 * Usage: Create, Update
337 * Reference: pa_project_assignments.expense_limit
338 * ORIG_SYSTEM_CODE Code specifying the system where this requirement was generated
339 * Usage: Create, Update
340 * Reference: pa_project_assignments.orig_system_code
341 * ORIG_SYSTEM_REFERENCE Reference code specifying the system where this requirement
342 * was generated
343 * Usage: Create, Update
344 * Reference: pa_project_assignments.orig_system_reference
345 * RECORD_VERSION_NUMBER The system-generated version number of this record. The value is
346 * incremented by one with each update
347 * Usage: Update, Delete
348 * Reference: pa_project_assignments.record_version_number
349 * ATTRIBUTE_CATEGORY Descriptive flexfield context field
350 * Usage: Create, Update
351 * Reference: pa_project_assignments.attribute_category
352 * ATTRIBUTE1 Descriptive flexfield attribute
353 * Usage: Create, Update
354 * Reference: pa_project_assignments.attribute1
355 * ATTRIBUTE2 Descriptive flexfield attribute
356 * Usage: Create, Update
357 * Reference: pa_project_assignments.attribute2
358 * ATTRIBUTE3 Descriptive flexfield attribute
359 * Usage: Create, Update
360 * Reference: pa_project_assignments.attribute3
361 * ATTRIBUTE4 Descriptive flexfield attribute
362 * Usage: Create, Update
363 * Reference: pa_project_assignments.attribute4
364 * ATTRIBUTE5 Descriptive flexfield attribute
365 * Usage: Create, Update
366 * Reference: pa_project_assignments.attribute5
367 * ATTRIBUTE6 Descriptive flexfield attribute
368 * Usage: Create, Update
369 * Reference: pa_project_assignments.attribute6
370 * ATTRIBUTE7 Descriptive flexfield attribute
371 * Usage: Create, Update
372 * Reference: pa_project_assignments.attribute7
373 * ATTRIBUTE8 Descriptive flexfield attribute
374 * Usage: Create, Update
375 * Reference: pa_project_assignments.attribute8
376 * ATTRIBUTE9 Descriptive flexfield attribute
377 * Usage: Create, Update
378 * Reference: pa_project_assignments.attribute9
379 * ATTRIBUTE10 Descriptive flexfield attribute
380 * Usage: Create, Update
381 * Reference: pa_project_assignments.attribute10
382 * ATTRIBUTE11 Descriptive flexfield attribute
383 * Usage: Create, Update
384 * Reference: pa_project_assignments.attribute11
385 * ATTRIBUTE12 Descriptive flexfield attribute
386 * Usage: Create, Update
387 * Reference: pa_project_assignments.attribute12
388 * ATTRIBUTE13 Descriptive flexfield attribute
389 * Usage: Create, Update
390 * Reference: pa_project_assignments.attribute13
391 * ATTRIBUTE14 Descriptive flexfield attribute
392 * Usage: Create, Update
393 * Reference: pa_project_assignments.attribute14
394 * ATTRIBUTE15 Descriptive flexfield attribute
395 * Usage: Create, Update
396 * Reference: pa_project_assignments.attribute15
397 */
398 TYPE REQUIREMENT_IN_REC_TYPE IS RECORD
399 (
400 requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
401 , requirement_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402 , team_template_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
403 , number_of_requirements NUMBER := 1
404 , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
405 , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406 , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
407 , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408 , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409 , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
410 , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411 , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412 , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
413 , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414 , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415 , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
416 , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
417 , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418 , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
419 , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420 , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
421 , description VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422 , additional_information VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423 , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
424 , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
425 , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426 , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
427 --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428 --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429 , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430 , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
431 , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432 , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
433 , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
434 , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
435 , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
436 , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
437 , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438 , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439 , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440 , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441 , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
442 , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443 , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444 , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
445 , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446 , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447 , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448 , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449 , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450 , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451 , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452 , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453 , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454 , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455 , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
456 , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457 , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458 , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459 , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460 , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
461 , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462 , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
463 , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
464 , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465 , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466 , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
467 , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468 , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
469 , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
470 , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471 , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472 , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
473 , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474 , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475 , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
476 , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
477 , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478 , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
479 , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480 , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481 , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
482 , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483 , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484 , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485 , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
486 , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
487 , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
488 , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
489 , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
490 , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
491 , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492 );
493
494 -- This table type is used for passing the multiple requirements information to APIs.
495 /*
496 * It is table of record type REQUIREMENT_IN_REC_TYPE.
497 */
498 TYPE REQUIREMENT_IN_TBL_TYPE IS TABLE OF REQUIREMENT_IN_REC_TYPE
499 INDEX BY BINARY_INTEGER;
500
501 /* Name: REQUIREMENT_IN_REC_TYPE
502 * Description: This record is used to pass the required parameters for
503 * requirement APIs.
504 *
505 * Attributes:
506 * ASSIGNMENT_ID Identifier of the assignment
507 * Usage: Update, Delete
508 * Reference: pa_project_assignments.assignment_id
509 * ASSIGNMENT_NAME The user-defined name that identifies the assignment.
510 * If a value is not supplied, the role name is used
511 * Usage: Create, Update
512 * Reference: pa_project_assignments.assignment_name
513 * ASSIGNMENT_TYPE The type of assignment. Valid values are:
514 * STAFFED_ASSIGNMENT, STAFFED_ADMIN_ASSIGNMENT
515 * Usage: Create
516 * Reference: pa_project_assignments.assignment_type
517 * PROJECT_ROLE_ID Identifier of the project role for the assignment.
518 * The role must be part of the role list, if a role
519 * list is attached to the project
520 * Usage: Create
521 * Reference: pa_project_assignments.project_role_id
522 * PROJECT_ROLE_NAME The name of the project role. Used when PROJECT_ROLE_ID
523 * is not supplied. The role must be part of the role list,
524 * if a role list is attached to the project
525 * Usage: Create
526 * Reference: pa_project_role_types.meaning
527 * PROJECT_ID The identifier of the project to which this assignment belongs
528 * Usage: Create
529 * Reference: pa_project_assignments.project_id
530 * PROJECT_NAME The name of the project to which this assignment belongs.
531 * Used when PROJECT_ID is not supplied
532 * Usage: Create
533 * Reference: pa_projects_all.name
534 * PROJECT_NUMBER The number of the project to which this assignment belongs.
535 * Used when PROJECT_ID is not supplied
536 * Usage: Create
537 * Reference: pa_projects_all.segment1
538 * RESOURCE_ID Identifier of the project resource
539 * Usage: Create
540 * Reference: pa_project_assignments.resource_id
541 * STAFFING_OWNER_PERSON_ID The owner person for the staffing of this assignment.
542 * If not supplied, the value is obtained from the project setup
543 * Usage: Create, Update
544 * Reference: pa_project_assignments.staffing_owner_person_id
545 * STAFFING_PRIORITY_CODE The staffing priority of the assignment. Valid values
546 * are obtained from lookup type STAFFING_PRIORITY_CODE
547 * Usage: Create, Update
548 * Reference: pa_project_assignments.staffing_priority_code
549 * STAFFING_PRIORITY_NAME The name of the staffing priority of the assignment. Used
550 * when STAFFING_PRIORITY_CODE is not supplied. Valid values
551 * are obtained from lookup type STAFFING_PRIORITY_CODE
552 * Usage: Create, Update
553 * Reference: pa_lookups.meaning
554 * PROJECT_SUBTEAM_ID The identifier for the project subteam to which this
555 * assignment belongs
556 * Usage: Create, Update
557 * Reference: pa_project_assignments.project_subteam_id
558 * PROJECT_SUBTEAM_NAME The name of the project subteam to which this assignment
559 * belongs. Used when PROJECT_SUBTEAM_ID is not supplied
560 * Usage: Create, Update
561 * Reference: pa_project_subteams.name
562 * LOCATION_ID Identifier of the location of the assignment. For new
563 * assignments, this parameter gets its default value from
564 * the project setup
565 * Usage: Create, Update
566 * Reference: pa_project_assignments.location_id
567 * LOCATION_COUNTRY_CODE The country code of the location. Used when LOCATION_ID is
568 * not supplied
569 * Usage: Create, Update
570 * Reference: pa_locations.country_code
571 * LOCATION_COUNTRY_NAME The country where this assignment will be performed. Used
572 * when LOCATION_ID is not supplied
573 * Usage: Create, Update
574 * Reference: fnd_territories_tl.territory_short_name
575 * LOCATION_REGION The region where this assignment will be performed. Used
576 * when LOCATION_ID is not supplied
577 * Usage: Create, Update
578 * Reference: pa_locations.region
579 * LOCATION_CITY The city where this assignment will be performed. Used
580 * when LOCATION_ID is not supplied
581 * Usage: Create, Update
582 * Reference: pa_locations.city
583 * DESCRIPTION The free text description of the assignment
584 * Usage: Create, Update
585 * Reference: pa_project_assignments.description
586 * ADDITIONAL_INFORMATION The free text additional information of the assignment
587 * Usage: Create, Update
588 * Reference: pa_project_assignments.additional_information
589 * START_DATE The start date of the assignment
590 * Usage: Create
591 * Reference: Pa_project_assignments.start_date
592 * END_DATE The end date of the assignment
593 * Usage: Create
594 * Reference: Pa_project_assignments.end_date
595 * STATUS_CODE The status of the assignment. Valid values are obtained from
596 * PA_PROJECT_STATUSES with STAFFED_ASGMT as status type
597 * Usage: Create, Update
598 * Reference: pa_project_assignments.status_code
599 * STATUS_NAME The status of the assignment. Used when a value is not supplied
600 * for STATUS_CODE. Valid values are obtained from PA_PROJECT_STATUSES
601 * with STAFFED_ASGMT as status type
602 * Usage: Create, Update
603 * Reference: pa_project_statuses.project_status_name
604 * CALENDAR_TYPE The base calendar used to generate schedules. It can be a
605 * project calendar, resource calendar or any other calendar.
606 * For requirements, the base calendar cannot be a resource
607 * calendar.Valid values are obtained from lookup type
608 * CHANGE_CALENDAR_TYPE_CODE
609 * Usage: Create
610 * Reference: pa_lookups.lookup_code
611 * CALENDAR_ID Identifier of the calendar for the assignment. If
612 * P_CALENDAR_TYPE is PROJECT, then the default value is
613 * obtained from the project setup
614 * Usage: Create
615 * Reference: pa_project_assignments.calendar_id
616 * CALENDAR_NAME The calendar for the assignment. If P_CALENDAR_TYPE is
617 * PROJECT, then the default value is obtained from the project
618 * setup. Used when CALENDAR_ID is not supplied
619 * Usage: Create
620 * Reference: jtf_calendars_tl.calendar_name
621 * RESOURCE_CALENDAR_PERCENT The daily percentage of resource calendar
622 * Usage: Create
623 * Reference: pa_project_assignments.resource_calendar_percent
624 * EXPENDITURE_TYPE_CLASS The expenditure type class to be used to generate forecast
625 * transactions. If not specified, the value is obtained from the
626 * forecasting options. Valid values are: ST - Straight Time
627 * OT - Overtime
628 * Usage: Create, Update
629 * Reference: pa_project_assignments.expenditure_type_class
630 * EXPENDITURE_TYPE Identifies the type of expenditure used to generate forecast
631 * transactions. If not specified, the value is obtained from the
632 * forecasting options.
633 * Usage: Create, Update
634 * Reference: pa_project_assignments.expenditure_type
635 * WORK_TYPE_ID The type of work being performed. This parameter is used as a
636 * default value for work type schedules. The default value is
637 * obtained from the project setup
638 * Usage: Create, Update
639 * Reference: pa_project_assignments.work_type_id
640 * WORK_TYPE_NAME The work type name being performed. Used when WORK_TYPE_ID
641 * is not supplied
642 * Usage: Create, Update
643 * Reference: pa_work_types_vl.name
644 * BILL_RATE_OPTION The bill rate option. Valid values are: RATE, MARKUP, DISCOUNT, NONE
645 * Usage: Create, Update
646 * Reference: N/A
647 * BILL_RATE_OVERRIDE The override bill rate for the assignment. This parameter is
648 * used when the value of BILL_RATE_OPTION is RATE.
649 * Usage: Create, Update
650 * Reference: pa_project_assignments.bill_rate_override
651 * BILL_RATE_CURR_OVERRIDE The override bill rate currency code for the assignment. This
652 * parameter is used when the value of BILL_RATE_OPTION is RATE
653 * and a value is supplied for BILL_RATE_OVERRIDE
654 * Usage: Create, Update
655 * Reference: pa_project_assignments.bill_rate_curr_override
656 * MARKUP_PERCENT_OVERRIDE The override markup percentage for the assignment. This
657 * parameter is used when the value of BILL_RATE_OPTION is MARKUP
658 * Usage: Create, Update
659 * Reference: pa_project_assignments.markup_percent_override
660 * DISCOUNT_PERCENTAGE The override discounts percentage for the assignment. This
661 * parameter is used when the value of BILL_RATE_OPTION is DISCOUNT
662 * Usage: Create, Update
663 * Reference: pa_project_assignments.discount_percentage
664 * RATE_DISC_REASON_CODE The identifier of the discount reason for discount. This parameter
665 * is mandatory when either of BILL_RATE_OVERRIDE, MARKUP_PERCENT_OVERRIDE
666 * DISCOUNT_PERCENTAGE is supplied, and "Require Rate and Discount Reason"
667 * option is enabled in implementation. Valid values are obtained from
668 * lookup type RATE AND DISCOUNT REASON. This parameter is not used when
669 * the value of BILL_RATE_OPTION is NONE
670 * Usage: Create, Update
671 * Reference: pa_project_assignments.rate_disc_reason_code
672 * TP_RATE_OPTION The transfer price options. Valid values are:RATE, BASIS, NONE
673 * Usage: Create, Update
674 * Reference: N/A
675 * TP_RATE_OVERRIDE The override transfer price rate for the assignment. This
676 * parameter is used when the value of TP_RATE_OPTION is RATE
677 * Usage: Create, Update
678 * Reference: pa_project_assignments.tp_rate_override
679 * TP_CURRENCY_OVERRIDE The override transfer price currency code for the assignment.
680 * Used when a value is supplied for TP_RATE_OVERRIDE, and the
681 * value of TP_RATE_OPTION is RATE.
682 * Usage: Create, Update
683 * Reference: pa_project_assignments.tp_currency_override
684 * TP_CALC_BASE_CODE_OVERRIDE The override transfer price basis code (for example, raw cost,
685 * or burden cost, etc). This parameter is used when the value of
686 * TP_RATE_OPTION is BASIS. The valid values can be obtained from
687 * lookup type CC_MARKUP_BASE_CODE
688 * Usage: Create, Update
689 * Reference: pa_project_assignments.tp_calc_base_code_override
690 * TP_PERCENT_APPLIED_OVERRIDE Percentage of a given basis. This parameter is used when the
691 * value of TP_RATE_OPTION is BASIS and a value is supplied for
692 * TP_CALC_BASE_CODE_OVERRIDE
693 * Usage: Create, Update
694 * Reference: pa_project_assignments.tp_percent_applied_override
695 * EXTENSION_POSSIBLE Flag indicating whether it is possible to extend the assignment.
696 * Valid values are Y and N
697 * Usage: Create, Update
698 * Reference: pa_project_assignments.extension_possible
699 * EXPENSE_OWNER The owner of the assignment expenses. The valid values can be
700 * obtained from lookup type EXPENSE_OWNER_TYPE
701 * Usage: Create, Update
702 * Reference: pa_project_assignments.expense_owner
703 * EXPENSE_LIMIT The maximum amount that the expense owner is willing to pay
704 * Usage: Create, Update
705 * Reference: pa_project_assignments.expense_limit
706 * ORIG_SYSTEM_CODE Code specifying the system where this assignment was generated
707 * Usage: Create, Update
708 * Reference: pa_project_assignments.orig_system_code
709 * ORIG_SYSTEM_REFERENCE Reference code specifying the system where this assignment
710 * was generated
711 * Usage: Create, Update
712 * Reference: pa_project_assignments.orig_system_reference
713 * RECORD_VERSION_NUMBER The system-generated version number of this record. The value is
714 * incremented by one with each update
715 * Usage: Update, Delete
716 * Reference: pa_project_assignments.record_version_number
717 * AUTO_APPROVE Flag indicating whether the assignment should be automatically
718 * approved, if privelege is there
719 * Usage: Update, Delete
720 * Reference: N/A
721 * ATTRIBUTE_CATEGORY Descriptive flexfield context field
722 * Usage: Create, Update
723 * Reference: pa_project_assignments.attribute_category
724 * ATTRIBUTE1 Descriptive flexfield attribute
725 * Usage: Create, Update
726 * Reference: pa_project_assignments.attribute1
727 * ATTRIBUTE2 Descriptive flexfield attribute
728 * Usage: Create, Update
729 * Reference: pa_project_assignments.attribute2
730 * ATTRIBUTE3 Descriptive flexfield attribute
731 * Usage: Create, Update
732 * Reference: pa_project_assignments.attribute3
733 * ATTRIBUTE4 Descriptive flexfield attribute
734 * Usage: Create, Update
735 * Reference: pa_project_assignments.attribute4
736 * ATTRIBUTE5 Descriptive flexfield attribute
737 * Usage: Create, Update
738 * Reference: pa_project_assignments.attribute5
739 * ATTRIBUTE6 Descriptive flexfield attribute
740 * Usage: Create, Update
741 * Reference: pa_project_assignments.attribute6
742 * ATTRIBUTE7 Descriptive flexfield attribute
743 * Usage: Create, Update
744 * Reference: pa_project_assignments.attribute7
745 * ATTRIBUTE8 Descriptive flexfield attribute
746 * Usage: Create, Update
747 * Reference: pa_project_assignments.attribute8
748 * ATTRIBUTE9 Descriptive flexfield attribute
749 * Usage: Create, Update
750 * Reference: pa_project_assignments.attribute9
751 * ATTRIBUTE10 Descriptive flexfield attribute
752 * Usage: Create, Update
753 * Reference: pa_project_assignments.attribute10
754 * ATTRIBUTE11 Descriptive flexfield attribute
755 * Usage: Create, Update
756 * Reference: pa_project_assignments.attribute11
757 * ATTRIBUTE12 Descriptive flexfield attribute
758 * Usage: Create, Update
759 * Reference: pa_project_assignments.attribute12
760 * ATTRIBUTE13 Descriptive flexfield attribute
761 * Usage: Create, Update
762 * Reference: pa_project_assignments.attribute13
763 * ATTRIBUTE14 Descriptive flexfield attribute
764 * Usage: Create, Update
765 * Reference: pa_project_assignments.attribute14
766 * ATTRIBUTE15 Descriptive flexfield attribute
767 * Usage: Create, Update
768 * Reference: pa_project_assignments.attribute15
769 */
770 -- This record type is used for passing the assignment information to APIs.
771 TYPE ASSIGNMENT_IN_REC_TYPE IS RECORD
772 (
773 assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
774 , assignment_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
775 , assignment_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
776 , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
777 , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778 , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
779 , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780 , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
781 , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
782 , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
783 , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784 , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
785 , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
786 , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787 , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788 , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
789 , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790 , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
791 , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
792 , description VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
793 , additional_information VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
794 , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
795 , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
796 , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
797 , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
798 --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
799 --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
800 , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
801 , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
802 , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
803 , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
804 , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805 , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
806 , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
807 , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
808 , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
809 , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
810 , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
811 , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
812 , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813 , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
814 , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
815 , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
816 , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
817 , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
818 , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
819 , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
820 , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
821 , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822 , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
823 , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
824 , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
825 , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
826 , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
827 , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
828 , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
829 , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
830 , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
831 , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
832 , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
833 , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
834 , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
835 , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
836 , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
837 , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
838 , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
839 , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
840 , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
841 , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
842 );
843
844 -- This table type is used for passing the multiple assignments information to APIs.
845 /*
846 * It is table of record type ASSIGNMENT_IN_TBL_TYPE.
847 */
848 TYPE ASSIGNMENT_IN_TBL_TYPE IS TABLE OF ASSIGNMENT_IN_REC_TYPE
849 INDEX BY BINARY_INTEGER;
850
851 -- This record type is used for passing the requirement information to APIs.
852 /* Name: STAFF_REQUIREMENT_REC_TYPE
853 * Description: This record is used to pass the required parameters for
854 * staff requirement APIs.
855 *
856 * Attributes:
857 * SOURCE_REQUIREMENT_ID Identifier of the existing base requirement
858 * Reference:pa_project_assignments.assignment_id
859 * RESOURCE_ID Identifier of the project resource
860 * Reference:pa_project_assignments.resource_id
861 * PERSON_ID Identifier of the person. This attribute is
862 * required if an assignment is being created and
863 * the value of RESOURCE_ID is null.
864 * Reference:Per_all_people_f.person_id
865 * START_DATE The start date of the assignment. This
866 * attribute is required.
867 * Reference:Pa_project_assignments.start_date
868 * END_DATE The end date of the assignment. This attribute
869 * is required.
870 * Reference:Pa_project_assignments.end_date
871 * ASSIGNMENT_STATUS_CODE Status code of the assignment. This attribute
872 * is required if STATUS_NAME is null. Valid
873 * values are obtained from PA_PROJECT_STATUSES,
874 * where STAFFED_ASGMT is the STATUS_TYPE.
875 * Reference:Pa_project_assignments.status_code
876 * ASSIGNMENT_STATUS_NAME Status name for the assignment. This attribute
877 * is required if STATUS_CODE is null.
878 * Reference:Pa_project_statuses.project_status_name
879 * UNFILLED_ASSIGN_STATUS_CODE The status code of the newly-created
880 * requirement for the unfilled section when a
881 * partial assignment occurs. Valid values are
882 * obtained from PA_PROJECT_STATUSES, where
883 * OPEN_ASGMT is the STATUS_TYPE.
884 * Reference:Pa_project_assignments.status_code
885 * UNFILLED_ASSIGN_STATUS_NAME This parameter can be used in place of
886 * UNFILLED_ASSIGN_STATUS_CODE.
887 * Reference:Pa_project_statuses.project_status_name
888 * REMAINING_CANDIDATE_CODE When the API is used to staff a requirement
889 * that has associated candidates, this field
890 * specifies the status code to assign to
891 * candidates who are not assigned to fill the
892 * requirement. Valid values are obtained from
893 * PA_PROJECT_STATUSES, where CANDIDATE is the
894 * STATUS_TYPE.
895 * Reference:Pa_candidates.status_code
896 * CHANGE_REASON_CODE The reason code for changing the candidate
897 * status code. Valid values are obtained from
898 * PA_LOOKUPS, where CANDIDATE_STS_CHANGE_REASON
899 * is the LOOKUP_TYPE.
900 * Reference:Pa_candidates_reviews.change_reason_code
901 * RECORD_VERSION_NUMBER The system-generated version number of this
902 * record. The value is incremented by one with
903 * each update.
904 * Usage: Update
905 * Reference:pa_project_assignments.record_version_number
906 */
907 TYPE STAFF_REQUIREMENT_REC_TYPE IS RECORD
908 (
909 source_requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
910 , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
911 , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
912 , assignment_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913 , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914 , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915 , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916 , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917 , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918 , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
919 , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
920 , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
921 );
922
923
924 -- This table type is used for passing the required parameters for staff requirement APIs
925 /*
926 * It is table of record type STAFF_REQUIREMENT_TBL_TYPE.
927 */
928 TYPE STAFF_REQUIREMENT_TBL_TYPE IS TABLE OF STAFF_REQUIREMENT_REC_TYPE
929 INDEX BY BINARY_INTEGER;
930
931
932 -- This record is used to pass the required parameters for competence APIs.
933 /* Name: COMPETENCE_IN_REC_TYPE
934 * Description: This record type enables you to supply information about
935 * multiple competences.
936 *
937 * Attributes:
938 * REQUIREMENT_ID Identifier of the requirement.
939 * Usage: Create
940 * Reference: pa_project_assignments.assignment_id
941 * COMPETENCE_ELEMENT_ID Identifier of the competence element
942 * Usage: Update, Delete
943 * Reference: per_competence_elements.competence_element_id
944 * COMPETENCE_ID Identifier of the competence
945 * Usage: Create
946 * Reference: per_competences.competence_id
947 * COMPETENCE_NAME Name of the competence. Used when
948 * P_COMPETENCE_ID is not supplied
949 * Usage: Create
950 * Reference: per_comepetences.name
951 * COMPETENCE_ALIAS Alias for the competence. Used when
952 * P_COMPETENCE_ID is not supplied.
953 * Usage: Create
954 * Reference: per_comepetences.competence_alias
955 * RATING_LEVEL_ID Identifier of the rating level
956 * Usage: Create, Update
957 * Reference: per_competence_elements.rating_level_id
958 * RATING_LEVEL_VALUE Identifier of the rating level value. Used
959 * when P_RATING_LEVEL_ID is not supplied.
960 * Usage: Create, Update
961 * Reference: per_rating_levels.step_value
962 * MANDATORY_FLAG Flag indicating if competence is mandatory
963 * Usage: Create, Update
964 * Reference: per_competence_elements.mandatory
965 * RECORD_VERSION_NUMBER Record version number of the competence record
966 * being updated. This parameter is derived if it
967 * is not supplied.
968 * Usage: Update, Delete
969 * Reference: per_competence_elements.object_version_number
970 *
971 */
972 TYPE COMPETENCE_IN_REC_TYPE IS RECORD(
973 requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
974 , competence_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
975 , competence_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
976 , competence_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
977 , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
978 , rating_level_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
979 , rating_level_value NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
980 , mandatory_flag VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
981 , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
982 );
983
984
985 -- This table is used to pass the required parameters for competence APIs.
986 /*
987 * It is table of record type COMPETENCE_IN_REC_TYPE.
988 */
989 TYPE COMPETENCE_IN_TBL_TYPE IS TABLE OF COMPETENCE_IN_REC_TYPE
990 INDEX BY BINARY_INTEGER;
991
992
993 -- This record is used to pass the required parameters for candidate APIs.
994 /* Name: CANDIDATE_IN_REC_TYPE
995 * Decription: This record type enables you to pass information about
996 * multiple candidates.
997 *
998 * Attributes:
999 * CANDIDATE_ID Identifier of the candidate, used when updating an existing
1000 * candidate.
1001 * Usage: Update
1002 * Reference: pa_candidates.candidate_id
1003 * REQUIREMENT_ID Identifier of the requirement for which the nomination is
1004 * being created or updated
1005 * Usage: Create, Delete
1006 * Reference: pa_project_assignments.assignment_id
1007 * RESOURCE_ID Identifier of the resource being nominated
1008 * Usage: Create
1009 * Reference: pa_resources_denorm.resource_id
1010 * PERSON_ID Identifier of the person being nominated. This parameter
1011 * is used when P_RESOURCE_ID is not supplied.
1012 * Usage: Create
1013 * Reference: per_all_people_f.person_id
1014 * STATUS_CODE Status code of the candidate. Valid values can be
1015 * obtained from PA_PROJECT_STATUSES where status_type
1016 * is CANDIDATE.
1017 * Usage: Create, Update
1018 * Reference: pa_project_statuses.project_status_code
1019 * NOMINATION_COMMENTS Comments by the nominator to add the resource on
1020 * the assignment.
1021 * Usage: Create
1022 * Reference: pa_candidates.nomination_comments
1023 * RANKING Ranking of the candidate being updated. This parameter
1024 * is used when updating an existing candidate.
1025 * Usage: Update
1026 * Reference: pa_candidates.candidate_ranking
1027 * CHANGE_REASON_CODE Change reason for status change. Required for only
1028 * certain cases of status code changes. This parameter
1029 * is used when updating an existing candidate.
1030 * Valid values are obtained from PA_LOOKUPS where
1031 * LOOKUP_TYPE is CANDIDATE_STS_CHANGE_REASON.
1032 * Usage: Update
1033 * Reference: pa_candidate_reviews.change_reason_code
1034 * RECORD_VERSION_NUMBER Record version number of the candidate record
1035 * being updated. This parameter is used when updating
1036 * an existing candidate.
1037 * Usage: Update
1038 * Reference: pa_candidates.record_version_number
1039 --Added below attribute columns for Bug 8339510
1040 * ATTRIBUTE_CATEGORY Descriptive flexfield context field
1041 * Usage: Create, Update
1042 * Reference: pa_project_assignments.attribute_category
1043 * ATTRIBUTE1 Descriptive flexfield attribute
1044 * Usage: Create, Update
1045 * Reference: pa_project_assignments.attribute1
1046 * ATTRIBUTE2 Descriptive flexfield attribute
1047 * Usage: Create, Update
1048 * Reference: pa_project_assignments.attribute2
1049 * ATTRIBUTE3 Descriptive flexfield attribute
1050 * Usage: Create, Update
1051 * Reference: pa_project_assignments.attribute3
1052 * ATTRIBUTE4 Descriptive flexfield attribute
1053 * Usage: Create, Update
1054 * Reference: pa_project_assignments.attribute4
1055 * ATTRIBUTE5 Descriptive flexfield attribute
1056 * Usage: Create, Update
1057 * Reference: pa_project_assignments.attribute5
1058 * ATTRIBUTE6 Descriptive flexfield attribute
1059 * Usage: Create, Update
1060 * Reference: pa_project_assignments.attribute6
1061 * ATTRIBUTE7 Descriptive flexfield attribute
1062 * Usage: Create, Update
1063 * Reference: pa_project_assignments.attribute7
1064 * ATTRIBUTE8 Descriptive flexfield attribute
1065 * Usage: Create, Update
1066 * Reference: pa_project_assignments.attribute8
1067 * ATTRIBUTE9 Descriptive flexfield attribute
1068 * Usage: Create, Update
1069 * Reference: pa_project_assignments.attribute9
1070 * ATTRIBUTE10 Descriptive flexfield attribute
1071 * Usage: Create, Update
1072 * Reference: pa_project_assignments.attribute10
1073 * ATTRIBUTE11 Descriptive flexfield attribute
1074 * Usage: Create, Update
1075 * Reference: pa_project_assignments.attribute11
1076 * ATTRIBUTE12 Descriptive flexfield attribute
1077 * Usage: Create, Update
1078 * Reference: pa_project_assignments.attribute12
1079 * ATTRIBUTE13 Descriptive flexfield attribute
1080 * Usage: Create, Update
1081 * Reference: pa_project_assignments.attribute13
1082 * ATTRIBUTE14 Descriptive flexfield attribute
1083 * Usage: Create, Update
1084 * Reference: pa_project_assignments.attribute14
1085 * ATTRIBUTE15 Descriptive flexfield attribute
1086 * Usage: Create, Update
1087 * Reference: pa_project_assignments.attribute15
1088 */
1089 TYPE CANDIDATE_IN_REC_TYPE IS RECORD
1090 (
1091 candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1092 , requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1093 , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1094 , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1095 , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1096 , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1097 , ranking NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1098 , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1099 , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1100 --Added below attribute columns for Bug 8339510
1101 , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1102 , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1103 , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1104 , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1105 , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1106 , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1107 , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1108 , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1109 , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1110 , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1111 , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1112 , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1113 , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1114 , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1115 , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1116 , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1117 );
1118
1119
1120 -- This table is used to pass the required parameters for candidate APIs.
1121 /*
1122 * It is table of record type CANDIDATE_IN_REC_TYPE.
1123 */
1124 TYPE CANDIDATE_IN_TBL_TYPE IS TABLE OF CANDIDATE_IN_REC_TYPE
1125 INDEX BY BINARY_INTEGER;
1126
1127
1128 -- This record is used to pass the required parameters for candidate log APIs.
1129 /* Name: CANDIDATE_LOG_REC_TYPE
1130 * Decription: This record type supplies parameters for candidate logs.
1131 *
1132 * Attributes:
1133 * CANDIDATE_ID Identifier of the candidate
1134 * Usage: Create
1135 * Reference: pa_project_assignments.assignment_id
1136 * STATUS_CODE Status code of the candidate. Valid values are
1137 * obtained from PA_PROJECT_STATUSES where status_type
1138 * is CANDIDATE.
1139 * Usage: Create
1140 * Reference: pa_project_statuses.project_status_code
1141 * CHANGE_REASON_CODE Change reason for status change. Valid values
1142 * are obtained from pa_lookups where lookup_type is
1143 * CANDIDATE_STS_CHANGE_REASON.
1144 * Usage: Create
1145 * Reference: pa_candidate_reviews.change_reason_code
1146 * REVIEW_COMMENTS Review comments on candidate
1147 * Usage: Create
1148 * Reference: pa_candidate_reviews.review_comments
1149 --Added below attribute columns for Bug 8339510
1150 * ATTRIBUTE_CATEGORY Descriptive flexfield context field
1151 * Usage: Create, Update
1152 * Reference: pa_project_assignments.attribute_category
1153 * ATTRIBUTE1 Descriptive flexfield attribute
1154 * Usage: Create, Update
1155 * Reference: pa_project_assignments.attribute1
1156 * ATTRIBUTE2 Descriptive flexfield attribute
1157 * Usage: Create, Update
1158 * Reference: pa_project_assignments.attribute2
1159 * ATTRIBUTE3 Descriptive flexfield attribute
1160 * Usage: Create, Update
1161 * Reference: pa_project_assignments.attribute3
1162 * ATTRIBUTE4 Descriptive flexfield attribute
1163 * Usage: Create, Update
1164 * Reference: pa_project_assignments.attribute4
1165 * ATTRIBUTE5 Descriptive flexfield attribute
1166 * Usage: Create, Update
1167 * Reference: pa_project_assignments.attribute5
1168 * ATTRIBUTE6 Descriptive flexfield attribute
1169 * Usage: Create, Update
1170 * Reference: pa_project_assignments.attribute6
1171 * ATTRIBUTE7 Descriptive flexfield attribute
1172 * Usage: Create, Update
1173 * Reference: pa_project_assignments.attribute7
1174 * ATTRIBUTE8 Descriptive flexfield attribute
1175 * Usage: Create, Update
1176 * Reference: pa_project_assignments.attribute8
1177 * ATTRIBUTE9 Descriptive flexfield attribute
1178 * Usage: Create, Update
1179 * Reference: pa_project_assignments.attribute9
1180 * ATTRIBUTE10 Descriptive flexfield attribute
1181 * Usage: Create, Update
1182 * Reference: pa_project_assignments.attribute10
1183 * ATTRIBUTE11 Descriptive flexfield attribute
1184 * Usage: Create, Update
1185 * Reference: pa_project_assignments.attribute11
1186 * ATTRIBUTE12 Descriptive flexfield attribute
1187 * Usage: Create, Update
1188 * Reference: pa_project_assignments.attribute12
1189 * ATTRIBUTE13 Descriptive flexfield attribute
1190 * Usage: Create, Update
1191 * Reference: pa_project_assignments.attribute13
1192 * ATTRIBUTE14 Descriptive flexfield attribute
1193 * Usage: Create, Update
1194 * Reference: pa_project_assignments.attribute14
1195 * ATTRIBUTE15 Descriptive flexfield attribute
1196 * Usage: Create, Update
1197 * Reference: pa_project_assignments.attribute15
1198 */
1199 TYPE CANDIDATE_LOG_REC_TYPE IS RECORD
1200 (
1201 candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1202 , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1203 , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1204 , review_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1205 --Added below attribute columns for Bug 8339510
1206 , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1207 , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1208 , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1209 , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1210 , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1211 , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1212 , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1213 , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1214 , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1215 , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1216 , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1217 , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1218 , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1219 , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1220 , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1221 , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1222 );
1223
1224 -- This table is used to pass the required parameters for candidate log APIs.
1225 /*
1226 * It is table of record type CANDIDATE_LOG_REC_TYPE
1227 */
1228 TYPE CANDIDATE_LOG_TBL_TYPE IS TABLE OF CANDIDATE_LOG_REC_TYPE
1229 INDEX BY BINARY_INTEGER;
1230
1231 -- This record is used to pass the required parameters for submit assignment APIs.
1232 /* Name: SUBMIT_ASSIGNMENT_IN_REC_TYPE
1233 * Decription: This record is used to pass the required parameters for
1234 * submit assignment APIs.
1235 *
1236 * Attributes:
1237 * ASSIGNMENT_ID Identifier of the assignment
1238 * Reference: pa_project_assignments.assignment_id
1239 * AUTO_APPROVE Indicates whether automatically approve the assignment
1240 * if resource authority is available.
1241 * APR_PERSON_ID_1 The first approver for the assignment
1242 * Reference: per_all_people_f.person_id
1243 * APR_PERSON_ID_2 The second approver for the assignment
1244 * Reference: per_all_people_f.person_id
1245 * NOTE_TO_APPROVER Comment for approvers
1246 * RECORD_VERSION_NUMBER The system-generated version number of this record.
1247 * The value is incremented by one with each update.
1248 *
1249 */
1250 TYPE SUBMIT_ASSIGNMENT_IN_REC_TYPE IS RECORD
1251 (
1252 assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1253 ,auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1254 ,apr_person_id_1 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1255 ,apr_person_id_2 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1256 ,note_to_approver VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1257 ,record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1258 );
1259
1260 /*
1261 * It is table of record type SUBMIT_ASSIGNMENT_IN_REC_TYPE.
1262 */
1263 TYPE SUBMIT_ASSIGNMENT_IN_TBL_TYPE IS TABLE OF SUBMIT_ASSIGNMENT_IN_REC_TYPE
1264 INDEX BY BINARY_INTEGER;
1265
1266 -- This is a public API to create one or more requirements for one or more projects
1267 /* Name: CREATE_REQUIREMENTS
1268 * Description: This procedure enables you to create project requirements.
1269 *
1270 * Parameters:
1271 * Parameter Name Null? Description
1272 * P_COMMIT NULL API standard (default = F)
1273 * P_INIT_MSG_LIST NULL API standard (default = T)
1274 * P_API_VERSION_NUMBER NOT NULL API standard
1275 * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1276 * see the REQUIREMENT_IN_TBL_TYPE
1277 * datatype table.
1278 * X_REQUIREMENT_ID_TBL N/A Table of requirement IDs created by
1279 * the API
1280 * Reference: pa_project_assignments.assignment_id
1281 * X_RETURN_STATUS N/A The return status of the API. Valid
1282 * values are: S (success)
1283 * E (error)
1284 * U (unexpected error)
1285 * X_MSG_COUNT N/A The number of error messages in the
1286 * message stack
1287 * X_MSG_DATA N/A The error message text if only one
1288 * error exists
1289 */
1290 /*#
1291 * This is a public API to create one or more requirements for one or more projects
1292 * @param p_api_version_number API standard version number
1293 * @rep:paraminfo {@rep:required}
1294 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1295 * @param p_commit API standard (default = F): indicates if transaction will be committed
1296 * @param p_requirement_in_tbl Table of requirement records
1297 * @rep:paraminfo {@rep:required}
1298 * @param x_requirement_id_tbl Table of requirement IDs created by the API
1299 * @rep:paraminfo {@rep:required}
1300 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1301 * @rep:paraminfo {@rep:required}
1302 * @param x_msg_count API standard: number of error messages
1303 * @rep:paraminfo {@rep:required}
1304 * @param x_msg_data API standard: error message
1305 * @rep:paraminfo {@rep:required}
1306 * @rep:scope public
1307 * @rep:lifecycle active
1308 * @rep:displayname Create Requirements
1309 * @rep:compatibility S
1310 */
1311 PROCEDURE CREATE_REQUIREMENTS
1312 (
1313 p_api_version_number IN NUMBER := 1.0
1314 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1315 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1316 , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1317 , x_requirement_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1318 , x_return_status OUT NOCOPY VARCHAR2
1319 , x_msg_count OUT NOCOPY NUMBER
1320 , x_msg_data OUT NOCOPY VARCHAR2
1321 );
1322
1323 -- This is a public API to update one or more requirements for one or more projects
1324 /* Name: UPDATE_REQUIREMENTS
1325 * Description: This procedure enables you to update project requirements.
1326 *
1327 * Parameters:
1328 * Parameter Name Null? Description
1329 * P_COMMIT NULL API standard (default = F)
1330 * P_INIT_MSG_LIST NULL API standard (default = T)
1331 * P_API_VERSION_NUMBER NOT NULL API standard
1332 * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1333 * see the REQUIREMENT_IN_TBL_TYPE
1334 * datatype table.
1335 * X_RETURN_STATUS N/A The return status of the API. Valid
1336 * values are: S (success)
1337 * E (error)
1338 * U (unexpected error)
1339 * X_MSG_COUNT N/A The number of error messages in the
1340 * message stack
1341 * X_MSG_DATA N/A The error message text if only one
1342 * error exists
1343 */
1344 /*#
1345 * This is a public API to update one or more requirements for one or more projects
1346 * @param p_api_version_number API standard version number
1347 * @rep:paraminfo {@rep:required}
1348 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1349 * @param p_commit API standard (default = F): indicates if transaction will be committed
1350 * @param p_requirement_in_tbl Table of requirement records
1351 * @rep:paraminfo {@rep:required}
1352 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1353 * @rep:paraminfo {@rep:required}
1354 * @param x_msg_count API standard: number of error messages
1355 * @rep:paraminfo {@rep:required}
1356 * @param x_msg_data API standard: error message
1357 * @rep:paraminfo {@rep:required}
1358 * @rep:scope public
1359 * @rep:lifecycle active
1360 * @rep:displayname Update Requirements
1361 * @rep:compatibility S
1362 */
1363 PROCEDURE UPDATE_REQUIREMENTS
1364 (
1365 p_api_version_number IN NUMBER := 1.0
1366 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1367 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1368 , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1369 , x_return_status OUT NOCOPY VARCHAR2
1370 , x_msg_count OUT NOCOPY NUMBER
1371 , x_msg_data OUT NOCOPY VARCHAR2
1372 );
1373
1374 -- This is a public API to delete one or more requirements for one or more projects
1375 /* Name: DELETE_REQUIREMENTS
1376 * Description: This procedure enables you to delete project requirements.
1377 *
1378 * Parameters:
1379 * Parameter Name Null? Description
1380 * P_COMMIT NULL API standard (default = F)
1381 * P_INIT_MSG_LIST NULL API standard (default = T)
1382 * P_API_VERSION_NUMBER NOT NULL API standard
1383 * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1384 * see the REQUIREMENT_IN_TBL_TYPE
1385 * datatype table.
1386 * X_RETURN_STATUS N/A The return status of the API. Valid
1387 * values are: S (success)
1388 * E (error)
1389 * U (unexpected error)
1390 * X_MSG_COUNT N/A The number of error messages in the
1391 * message stack
1392 * X_MSG_DATA N/A The error message text if only one
1393 * error exists
1394 */
1395 /*#
1396 * This is a public API to delete one or more requirements for one or more projects
1397 * @param p_api_version_number API standard version number
1398 * @rep:paraminfo {@rep:required}
1399 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1400 * @param p_commit API standard (default = F): indicates if transaction will be committed
1401 * @param p_requirement_in_tbl Table of requirement records
1402 * @rep:paraminfo {@rep:required}
1403 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1404 * @rep:paraminfo {@rep:required}
1405 * @param x_msg_count API standard: number of error messages
1406 * @rep:paraminfo {@rep:required}
1407 * @param x_msg_data API standard: error message
1408 * @rep:paraminfo {@rep:required}
1409 * @rep:scope public
1410 * @rep:lifecycle active
1411 * @rep:displayname Delete Requirements
1412 * @rep:compatibility S
1413 */
1414 PROCEDURE DELETE_REQUIREMENTS
1415 (
1416 p_api_version_number IN NUMBER := 1.0
1417 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1418 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1419 , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1420 , x_return_status OUT NOCOPY VARCHAR2
1421 , x_msg_count OUT NOCOPY NUMBER
1422 , x_msg_data OUT NOCOPY VARCHAR2
1423 );
1424
1425 -- This is a public API to staff one or more requirements for one or more projects
1426 /* Name: STAFF_REQUIREMENTS
1427 * Description: This procedure enables you to staff requirements.
1428 *
1429 * Parameters:
1430 * Parameter Name Null? Description
1431 * P_COMMIT NULL API standard (default = F)
1432 * P_INIT_MSG_LIST NULL API standard (default = T)
1433 * P_API_VERSION_NUMBER NOT NULL API standard
1434 * P_STAFF_REQUIREMENT_TBL NOT NULL Table of staffing information for each
1435 * requirement. Please see the
1436 * Staff_requirement_tbl_TYPE datatype
1437 * table.
1438 * X_ASSIGNMENT_ID_TBL N/A Table of staffed assignment IDs.
1439 * Reference: pa_project_assignments.assignment_id
1440 * X_RETURN_STATUS N/A The return status of the API. Valid
1441 * values are: S (success)
1442 * E (error)
1443 * U (unexpected error)
1444 * X_MSG_COUNT N/A The number of error messages in the
1445 * message stack
1446 * X_MSG_DATA N/A The error message text if only one
1447 * error exists
1448 */
1449 /*#
1450 * This is a public API to staff one or more requirements for one or more projects
1451 * @param p_api_version_number API standard version number
1452 * @rep:paraminfo {@rep:required}
1453 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1454 * @param p_commit API standard (default = F): indicates if transaction will be committed
1455 * @param p_staff_requirement_tbl Table of staffing information for each requirement
1456 * @rep:paraminfo {@rep:required}
1457 * @param x_assignment_id_tbl Table of staffed assignment IDs.
1458 * @rep:paraminfo {@rep:required}
1459 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1460 * @rep:paraminfo {@rep:required}
1461 * @param x_msg_count API standard: number of error messages
1462 * @rep:paraminfo {@rep:required}
1463 * @param x_msg_data API standard: error message
1464 * @rep:paraminfo {@rep:required}
1465 * @rep:scope public
1466 * @rep:lifecycle active
1467 * @rep:displayname Staff Requirements
1468 * @rep:compatibility S
1469 */
1470 PROCEDURE STAFF_REQUIREMENTS
1471 (
1472 p_api_version_number IN NUMBER := 1.0
1473 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1474 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1475 , p_staff_requirement_tbl IN STAFF_REQUIREMENT_TBL_TYPE
1476 , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1477 , x_return_status OUT NOCOPY VARCHAR2
1478 , x_msg_count OUT NOCOPY NUMBER
1479 , x_msg_data OUT NOCOPY VARCHAR2
1480 );
1481
1482 -- This is a public API to copy one or more team roles
1483 /* Name: COPY_TEAM_ROLES
1484 * Description: This procedure enables you to copy team roles from existing
1485 * project assignments or requirements.
1486 *
1487 * Parameters:
1488 * Parameter Name Null? Description
1489 * P_COMMIT NULL API standard (default = F)
1490 * P_INIT_MSG_LIST NULL API standard (default = T)
1491 * P_API_VERSION_NUMBER NOT NULL API standard
1492 * P_REQ_ASGN_ID_TBL NOT NULL Table of requirement or assignment IDs.
1493 * Reference: pa_project_assignments.assignment_id
1494 * X_REQ_ASGN_ID_TBL N/A Table of requirement or assignment IDs
1495 * created by the API.
1496 * Reference: pa_project_assignments.assignment_id
1497 * X_RETURN_STATUS N/A The return status of the API. Valid
1498 * values are: S (success)
1499 * E (error)
1500 * U (unexpected error)
1501 * X_MSG_COUNT N/A The number of error messages in the
1502 * message stack
1503 * X_MSG_DATA N/A The error message text if only one
1504 * error exists
1505 */
1506 /*#
1507 * This is a public API to copy one or more team roles
1508 * @param p_api_version_number API standard version number
1509 * @rep:paraminfo {@rep:required}
1510 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1511 * @param p_commit API standard (default = F): indicates if transaction will be committed
1512 * @param p_req_asgn_id_tbl Table of requirement or assignment IDs
1513 * @rep:paraminfo {@rep:required}
1514 * @param x_req_asgn_id_tbl Table of requirement or assignment IDs
1515 * @rep:paraminfo {@rep:required}
1516 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1517 * @rep:paraminfo {@rep:required}
1518 * @param x_msg_count API standard: number of error messages
1519 * @rep:paraminfo {@rep:required}
1520 * @param x_msg_data API standard: error message
1521 * @rep:paraminfo {@rep:required}
1522 * @rep:scope public
1523 * @rep:lifecycle active
1524 * @rep:displayname Copy Team Roles
1525 * @rep:compatibility S
1526 */
1527 PROCEDURE COPY_TEAM_ROLES
1528 (
1529 p_api_version_number IN NUMBER := 1.0
1530 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1531 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1532 , p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1533 , x_req_asgn_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1534 , x_return_status OUT NOCOPY VARCHAR2
1535 , x_msg_count OUT NOCOPY NUMBER
1536 , x_msg_data OUT NOCOPY VARCHAR2
1537 );
1538
1539 -- This is a public API to create one or more assignments for one or more projects
1540 /* Name: CREATE_ASSIGNMENTS
1541 * Description: This procedure enables you to create project assignments.
1542 *
1543 * Parameters:
1544 * Parameter Name Null? Description
1545 * P_COMMIT NULL API standard (default = F)
1546 * P_INIT_MSG_LIST NULL API standard (default = T)
1547 * P_API_VERSION_NUMBER NOT NULL API standard
1548 * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1549 * see the ASSIGNMENT_IN_TBL_TYPE
1550 * datatype table.
1551 * X_ASSIGNMENT_ID_TBL N/A Table to store assignment IDs created
1552 * by the API.
1553 * Reference: pa_project_assignments.assignment_id
1554 * X_RETURN_STATUS N/A The return status of the API. Valid
1555 * values are: S (success)
1556 * E (error)
1557 * U (unexpected error)
1558 * X_MSG_COUNT N/A The number of error messages in the
1559 * message stack
1560 * X_MSG_DATA N/A The error message text if only one
1561 * error exists
1562 */
1563 /*#
1564 * This is a public API to create one or more assignments for one or more projects
1565 * @param p_api_version_number API standard version number
1566 * @rep:paraminfo {@rep:required}
1567 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1568 * @param p_commit API standard (default = F): indicates if transaction will be committed
1569 * @param p_assignment_in_tbl Table of assignment records
1570 * @rep:paraminfo {@rep:required}
1571 * @param x_assignment_id_tbl Table to store assignment IDs created by the API
1572 * @rep:paraminfo {@rep:required}
1573 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1574 * @rep:paraminfo {@rep:required}
1575 * @param x_msg_count API standard: number of error messages
1576 * @rep:paraminfo {@rep:required}
1577 * @param x_msg_data API standard: error message
1578 * @rep:paraminfo {@rep:required}
1579 * @rep:scope public
1580 * @rep:lifecycle active
1581 * @rep:displayname Create Assignments
1582 * @rep:compatibility S
1583 */
1584 PROCEDURE CREATE_ASSIGNMENTS
1585 (
1586 p_api_version_number IN NUMBER := 1.0
1587 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1588 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1589 , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
1590 , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1591 , x_return_status OUT NOCOPY VARCHAR2
1592 , x_msg_count OUT NOCOPY NUMBER
1593 , x_msg_data OUT NOCOPY VARCHAR2
1594 ) ;
1595
1596 -- This is a public API to update one or more assignments for one or more projects.
1597 /* Name: UPDATE_ASSIGNMENTS
1598 * Description: This procedure enables you to update project assignments.
1599 *
1600 * Parameters:
1601 * Parameter Name Null? Description
1602 * P_COMMIT NULL API standard (default = F)
1603 * P_INIT_MSG_LIST NULL API standard (default = T)
1604 * P_API_VERSION_NUMBER NOT NULL API standard
1605 * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1606 * see the ASSIGNMENT_IN_TBL_TYPE
1607 * datatype table.
1608 * X_RETURN_STATUS N/A The return status of the API. Valid
1609 * values are: S (success)
1610 * E (error)
1611 * U (unexpected error)
1612 * X_MSG_COUNT N/A The number of error messages in the
1613 * message stack
1614 * X_MSG_DATA N/A The error message text if only one
1615 * error exists
1616 */
1617 /*#
1618 * This is a public API to update one or more assignments for one or more projects.
1619 * @param p_api_version_number API standard version number
1620 * @rep:paraminfo {@rep:required}
1621 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1622 * @param p_commit API standard (default = F): indicates if transaction will be committed
1623 * @param p_assignment_in_tbl Table of assignment records
1624 * @rep:paraminfo {@rep:required}
1625 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1626 * @rep:paraminfo {@rep:required}
1627 * @param x_msg_count API standard: number of error messages
1628 * @rep:paraminfo {@rep:required}
1629 * @param x_msg_data API standard: error message
1630 * @rep:paraminfo {@rep:required}
1631 * @rep:scope public
1632 * @rep:lifecycle active
1633 * @rep:displayname Update Assignments
1634 * @rep:compatibility S
1635 */
1636 PROCEDURE UPDATE_ASSIGNMENTS
1637 (
1638 p_api_version_number IN NUMBER := 1.0
1639 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1640 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1641 , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
1642 , x_return_status OUT NOCOPY VARCHAR2
1643 , x_msg_count OUT NOCOPY NUMBER
1644 , x_msg_data OUT NOCOPY VARCHAR2
1645 );
1646
1647 -- This is a public API to Delete one or more assignments for one or more projects.
1648 /* Name: DELETE_ASSIGNMENTS
1649 * Description: This procedure enables you to delete project assignments.
1650 *
1651 * Parameters:
1652 * Parameter Name Null? Description
1653 * P_COMMIT NULL API standard (default = F)
1654 * P_INIT_MSG_LIST NULL API standard (default = T)
1655 * P_API_VERSION_NUMBER NOT NULL API standard
1656 * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1657 * see the ASSIGNMENT_IN_TBL_TYPE
1658 * datatype table.
1659 * X_RETURN_STATUS N/A The return status of the API. Valid
1660 * values are: S (success)
1661 * E (error)
1662 * U (unexpected error)
1663 * X_MSG_COUNT N/A The number of error messages in the
1664 * message stack
1665 * X_MSG_DATA N/A The error message text if only one
1666 * error exists
1667 */
1668 /*#
1669 * This is a public API to Delete one or more assignments for one or more projects.
1670 * @param p_api_version_number API standard version number
1671 * @rep:paraminfo {@rep:required}
1672 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1673 * @param p_commit API standard (default = F): indicates if transaction will be committed
1674 * @param p_assignment_in_tbl Table of assignment records
1675 * @rep:paraminfo {@rep:required}
1676 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1677 * @rep:paraminfo {@rep:required}
1678 * @param x_msg_count API standard: number of error messages
1679 * @rep:paraminfo {@rep:required}
1680 * @param x_msg_data API standard: error message
1681 * @rep:paraminfo {@rep:required}
1682 * @rep:scope public
1683 * @rep:lifecycle active
1684 * @rep:displayname Delete Assignments
1685 * @rep:compatibility S
1686 */
1687 PROCEDURE DELETE_ASSIGNMENTS (
1688 p_commit IN VARCHAR2 := 'F'
1689 , p_init_msg_list IN VARCHAR2 := 'T'
1690 , p_api_version_number IN NUMBER := 1.0
1691 , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
1692 , x_return_status OUT NOCOPY VARCHAR2
1693 , x_msg_count OUT NOCOPY NUMBER
1694 , x_msg_data OUT NOCOPY VARCHAR2 ) ;
1695
1696 -- This is a public API to submit/approve one or more assignments for one or more projects.
1697 /* Name: SUBMIT_ASSIGNMENTS
1698 * Description: This procedure enables you to submit and approve project
1699 * assignments.
1700 *
1701 * Parameters:
1702 * Parameter Name Null? Description
1703 * P_COMMIT NULL API standard (default = F)
1704 * P_INIT_MSG_LIST NULL API standard (default = T)
1705 * P_API_VERSION_NUMBER NOT NULL API standard
1706 * P_SUBMIT_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1707 * see the SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1708 * datatype table.
1709 * X_RETURN_STATUS N/A The return status of the API. Valid
1710 * values are: S (success)
1711 * E (error)
1712 * U (unexpected error)
1713 * X_MSG_COUNT N/A The number of error messages in the
1714 * message stack
1715 * X_MSG_DATA N/A The error message text if only one
1716 * error exists
1717 */
1718 /*#
1719 * This is a public API to submit/approve one or more assignments for one or more projects.
1720 * @param p_api_version_number API standard version number
1721 * @rep:paraminfo {@rep:required}
1722 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1723 * @param p_commit API standard (default = F): indicates if transaction will be committed
1724 * @param p_submit_assignment_in_tbl Table of assignment records
1725 * @rep:paraminfo {@rep:required}
1726 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1727 * @rep:paraminfo {@rep:required}
1728 * @param x_msg_count API standard: number of error messages
1729 * @rep:paraminfo {@rep:required}
1730 * @param x_msg_data API standard: error message
1731 * @rep:paraminfo {@rep:required}
1732 * @rep:scope public
1733 * @rep:lifecycle active
1734 * @rep:displayname Submit Assignments
1735 * @rep:compatibility S
1736 */
1737 PROCEDURE SUBMIT_ASSIGNMENTS
1738 (
1739 p_api_version_number IN NUMBER := 1.0
1740 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1741 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1742 , p_submit_assignment_in_tbl IN SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1743 , x_return_status OUT NOCOPY VARCHAR2
1744 , x_msg_count OUT NOCOPY NUMBER
1745 , x_msg_data OUT NOCOPY VARCHAR2
1746 );
1747
1748 --This is a public API to create one or more competences for one or more project requirements.
1749 /* Name: CREATE_REQUIREMENT_COMPETENCE
1750 * Description: This procedure enables you to create competences for
1751 * project requirements.
1752 * Parameters:
1753 * Parameter Name Null? Description
1754 * P_COMMIT NULL API standard (default = F)
1755 * P_INIT_MSG_LIST NULL API standard (default = T)
1756 * P_API_VERSION_NUMBER NOT NULL API standard
1757 * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1758 * see the COMPETENCE_IN_TBL_TYPE
1759 * datatype table.
1760 * X_COMPETENCE_ELEMENT_ID_TBL N/A Table to store the competence element
1761 * IDs created by the API.
1762 * Reference: per_comepetence_elements.competence_element_id
1763 * X_RETURN_STATUS N/A The return status of the API. Valid
1764 * values are: S (success)
1765 * E (error)
1766 * U (unexpected error)
1767 * X_MSG_COUNT N/A The number of error messages in the
1768 * message stack
1769 * X_MSG_DATA N/A The error message text if only one
1770 * error exists
1771 */
1772 /*#
1773 * This is a public API to create one or more competences for one or more project requirements.
1774 * @param p_api_version_number API standard version number
1775 * @rep:paraminfo {@rep:required}
1776 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1777 * @param p_commit API standard (default = F): indicates if transaction will be committed
1778 * @param p_competence_in_tbl Table of competence records
1779 * @rep:paraminfo {@rep:required}
1780 * @param x_competence_element_id_tbl Table to store the competence element IDs created by the API
1781 * @rep:paraminfo {@rep:required}
1782 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1783 * @rep:paraminfo {@rep:required}
1784 * @param x_msg_count API standard: number of error messages
1785 * @rep:paraminfo {@rep:required}
1786 * @param x_msg_data API standard: error message
1787 * @rep:paraminfo {@rep:required}
1788 * @rep:scope public
1789 * @rep:lifecycle active
1790 * @rep:displayname Create Requirement Competence
1791 * @rep:compatibility S
1792 */
1793 PROCEDURE CREATE_REQUIREMENT_COMPETENCE
1794 (
1795 p_commit IN VARCHAR2 :='F'
1796 , p_init_msg_list IN VARCHAR2 :='T'
1797 , p_api_version_number IN NUMBER :=1.0
1798 , p_competence_in_tbl IN COMPETENCE_IN_TBL_TYPE
1799 , x_competence_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1800 , x_return_status OUT NOCOPY VARCHAR2
1801 , x_msg_count OUT NOCOPY NUMBER
1802 , x_msg_data OUT NOCOPY VARCHAR2
1803 );
1804
1805 --This is a public API to update one or more competences for one or more project requirements
1806 /* Name: UPDATE_REQUIREMENT_COMPETENCE
1807 * Description: This procedure enables you to update competences for
1808 * project requirements.
1809 * Parameters:
1810 * Parameter Name Null? Description
1811 * P_COMMIT NULL API standard (default = F)
1812 * P_INIT_MSG_LIST NULL API standard (default = T)
1813 * P_API_VERSION_NUMBER NOT NULL API standard
1814 * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1815 * see the COMPETENCE_IN_TBL_TYPE
1816 * datatype table.
1817 * X_RETURN_STATUS N/A The return status of the API. Valid
1818 * values are: S (success)
1819 * E (error)
1820 * U (unexpected error)
1821 * X_MSG_COUNT N/A The number of error messages in the
1822 * message stack
1823 * X_MSG_DATA N/A The error message text if only one
1824 * error exists
1825 */
1826 /*#
1827 * This is a public API to update one or more competences for one or more project requirements
1828 * @param p_api_version_number API standard version number
1829 * @rep:paraminfo {@rep:required}
1830 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1831 * @param p_commit API standard (default = F): indicates if transaction will be committed
1832 * @param p_competence_in_tbl Table of competence records
1833 * @rep:paraminfo {@rep:required}
1834 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1835 * @rep:paraminfo {@rep:required}
1836 * @param x_msg_count API standard: number of error messages
1837 * @rep:paraminfo {@rep:required}
1838 * @param x_msg_data API standard: error message
1839 * @rep:paraminfo {@rep:required}
1840 * @rep:scope public
1841 * @rep:lifecycle active
1842 * @rep:displayname Update Requirement Competence
1843 * @rep:compatibility S
1844 */
1845 PROCEDURE UPDATE_REQUIREMENT_COMPETENCE
1846 (
1847 p_commit IN VARCHAR2 := 'F'
1848 , p_init_msg_list IN VARCHAR2 := 'T'
1849 , p_api_version_number IN NUMBER := 1.0
1850 , p_competence_in_tbl IN COMPETENCE_IN_TBL_TYPE
1851 , x_return_status OUT NOCOPY VARCHAR2
1852 , x_msg_count OUT NOCOPY NUMBER
1853 , x_msg_data OUT NOCOPY VARCHAR2
1854 );
1855
1856
1857 --This is a public API to delete one or more competences for one or more project requirements.
1858 /* Name: DELETE_REQUIREMENT_COMPETENCE
1859 * Description: This procedure enables you to delete competences for
1860 * project requirements.
1861 * Parameters:
1862 * Parameter Name Null? Description
1863 * P_COMMIT NULL API standard (default = F)
1864 * P_INIT_MSG_LIST NULL API standard (default = T)
1865 * P_API_VERSION_NUMBER NOT NULL API standard
1866 * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1867 * see the COMPETENCE_IN_TBL_TYPE
1868 * datatype table.
1869 * X_RETURN_STATUS N/A The return status of the API. Valid
1870 * values are: S (success)
1871 * E (error)
1872 * U (unexpected error)
1873 * X_MSG_COUNT N/A The number of error messages in the
1874 * message stack
1875 * X_MSG_DATA N/A The error message text if only one
1876 * error exists
1877 */
1878 /*#
1879 * This is a public API to delete one or more competences for one or more project requirements.
1880 * @param p_api_version_number API standard version number
1881 * @rep:paraminfo {@rep:required}
1882 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1883 * @param p_commit API standard (default = F): indicates if transaction will be committed
1884 * @param p_competence_in_tbl Table of competence records
1885 * @rep:paraminfo {@rep:required}
1886 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1887 * @rep:paraminfo {@rep:required}
1888 * @param x_msg_count API standard: number of error messages
1889 * @rep:paraminfo {@rep:required}
1890 * @param x_msg_data API standard: error message
1891 * @rep:paraminfo {@rep:required}
1892 * @rep:scope public
1893 * @rep:lifecycle active
1894 * @rep:displayname Delete Requirement Competence
1895 * @rep:compatibility S
1896 */
1897 PROCEDURE DELETE_REQUIREMENT_COMPETENCE
1898 (
1899 p_commit IN VARCHAR2 :='F'
1900 , p_init_msg_list IN VARCHAR2 := 'T'
1901 , p_api_version_number IN NUMBER := 1.0
1902 , p_competence_in_tbl IN COMPETENCE_IN_TBL_TYPE
1903 , x_return_status OUT NOCOPY VARCHAR2
1904 , x_msg_count OUT NOCOPY NUMBER
1905 , x_msg_data OUT NOCOPY VARCHAR2
1906 );
1907
1908
1909
1910 -- This is a public API to create/nominate one or more candidates for project requirements.
1911 /* Name: CREATE_CANDIDATES
1912 * Description: This procedure enables you to nominate candidates for
1913 * project requirements.
1914 * Parameters:
1915 * Parameter Name Null? Description
1916 * P_COMMIT NULL API standard (default = F)
1917 * P_INIT_MSG_LIST NULL API standard (default = T)
1918 * P_API_VERSION_NUMBER NOT NULL API standard
1919 * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1920 * the CANDIDATE_IN_TBL_TYPE datatype table.
1921 * X_CANDIDATE_ID_TBL N/A Table to store the candidate IDs
1922 * created by the API.
1923 * Reference: pa_candidates.candidate_id
1924 * X_RETURN_STATUS N/A The return status of the API. Valid
1925 * values are: S (success)
1926 * E (error)
1927 * U (unexpected error)
1928 * X_MSG_COUNT N/A The number of error messages in the
1929 * message stack
1930 * X_MSG_DATA N/A The error message text if only one
1931 * error exists
1932 */
1933 /*#
1934 * This is a public API to create/nominate one or more candidates for project requirements
1935 * @param p_api_version_number API standard version number
1936 * @rep:paraminfo {@rep:required}
1937 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1938 * @param p_commit API standard (default = F): indicates if transaction will be committed
1939 * @param p_candidate_in_tbl Table of candidate records
1940 * @rep:paraminfo {@rep:required}
1941 * @param x_candidate_id_tbl Table to store the candidate IDs created by the API.
1942 * @rep:paraminfo {@rep:required}
1943 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1944 * @rep:paraminfo {@rep:required}
1945 * @param x_msg_count API standard: number of error messages
1946 * @rep:paraminfo {@rep:required}
1947 * @param x_msg_data API standard: error message
1948 * @rep:paraminfo {@rep:required}
1949 * @rep:scope public
1950 * @rep:lifecycle active
1951 * @rep:displayname Create Candidates
1952 * @rep:compatibility S
1953 */
1954 PROCEDURE CREATE_CANDIDATES
1955 (
1956 p_commit IN VARCHAR2 := FND_API.G_FALSE
1957 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1958 , p_api_version_number IN NUMBER := 1.0
1959 , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
1960 , x_candidate_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1961 , x_return_status OUT NOCOPY VARCHAR2
1962 , x_msg_count OUT NOCOPY NUMBER
1963 , x_msg_data OUT NOCOPY VARCHAR2
1964 );
1965
1966
1967 -- This is a public API to update one or more candidates for project requirements.
1968 /* Name: UPDATE_CANDIDATES
1969 * Description: This procedure enables you to update the candidates for
1970 * project requirements.
1971 * Parameters:
1972 * Parameter Name Null? Description
1973 * P_COMMIT NULL API standard (default = F)
1974 * P_INIT_MSG_LIST NULL API standard (default = T)
1975 * P_API_VERSION_NUMBER NOT NULL API standard
1976 * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1977 * the CANDIDATE_IN_TBL_TYPE datatype table.
1978 * X_RETURN_STATUS N/A The return status of the API. Valid
1979 * values are: S (success)
1980 * E (error)
1981 * U (unexpected error)
1982 * X_MSG_COUNT N/A The number of error messages in the
1983 * message stack
1984 * X_MSG_DATA N/A The error message text if only one
1985 * error exists
1986 */
1987 /*#
1988 * This is a public API to update one or more candidates for project requirements
1989 * @param p_api_version_number API standard version number
1990 * @rep:paraminfo {@rep:required}
1991 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1992 * @param p_commit API standard (default = F): indicates if transaction will be committed
1993 * @param p_candidate_in_tbl Table of candidate records
1994 * @rep:paraminfo {@rep:required}
1995 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1996 * @rep:paraminfo {@rep:required}
1997 * @param x_msg_count API standard: number of error messages
1998 * @rep:paraminfo {@rep:required}
1999 * @param x_msg_data API standard: error message
2000 * @rep:paraminfo {@rep:required}
2001 * @rep:scope public
2002 * @rep:lifecycle active
2003 * @rep:displayname Update Candidates
2004 * @rep:compatibility S
2005 */
2006 PROCEDURE UPDATE_CANDIDATES
2007 (
2008 p_commit IN VARCHAR2 := FND_API.G_FALSE
2009 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2010 , p_api_version_number IN NUMBER := 1.0
2011 , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
2012 , x_return_status OUT NOCOPY VARCHAR2
2013 , x_msg_count OUT NOCOPY NUMBER
2014 , x_msg_data OUT NOCOPY VARCHAR2
2015 );
2016
2017
2018 -- This is a public API to delete one or more candidates for project requirements.
2019 /* Name: DELETE_CANDIDATES
2020 * Description: This procedure enables you to delete candidates from
2021 * project requirements.
2022 * Parameters:
2023 * Parameter Name Null? Description
2024 * P_COMMIT NULL API standard (default = F)
2025 * P_INIT_MSG_LIST NULL API standard (default = T)
2026 * P_API_VERSION_NUMBER NOT NULL API standard
2027 * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
2028 * the CANDIDATE_IN_TBL_TYPE datatype table.
2029 * X_RETURN_STATUS N/A The return status of the API. Valid
2030 * values are: S (success)
2031 * E (error)
2032 * U (unexpected error)
2033 * X_MSG_COUNT N/A The number of error messages in the
2034 * message stack
2035 * X_MSG_DATA N/A The error message text if only one
2036 * error exists
2037 */
2038 /*#
2039 * This is a public API to delete one or more candidates for project requirements.
2040 * @param p_api_version_number API standard version number
2041 * @rep:paraminfo {@rep:required}
2042 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
2043 * @param p_commit API standard (default = F): indicates if transaction will be committed
2044 * @param p_candidate_in_tbl Table of candidate records
2045 * @rep:paraminfo {@rep:required}
2046 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2047 * @rep:paraminfo {@rep:required}
2048 * @param x_msg_count API standard: number of error messages
2049 * @rep:paraminfo {@rep:required}
2050 * @param x_msg_data API standard: error message
2051 * @rep:paraminfo {@rep:required}
2052 * @rep:scope public
2053 * @rep:lifecycle active
2054 * @rep:displayname Delete Candidates
2055 * @rep:compatibility S
2056 */
2057 PROCEDURE DELETE_CANDIDATES
2058 (
2059 p_commit IN VARCHAR2 := FND_API.G_FALSE
2060 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2061 , p_api_version_number IN NUMBER := 1.0
2062 , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
2063 , x_return_status OUT NOCOPY VARCHAR2
2064 , x_msg_count OUT NOCOPY NUMBER
2065 , x_msg_data OUT NOCOPY VARCHAR2
2066 );
2067
2068
2069 -- This is a public API to create log for one or more candidates for project requirements.
2070 /* Name: CREATE_CANDIDATE_LOG
2071 * Description: This procedure creates a log for one or more candidates for
2072 * project requirements.
2073 * Parameters:
2074 * Parameter Name Null? Description
2075 * P_COMMIT NULL API standard (default = F)
2076 * P_INIT_MSG_LIST NULL API standard (default = T)
2077 * P_API_VERSION_NUMBER NOT NULL API standard
2078 * P_CANDIDATE_LOG_TBL NOT NULL Table of candidate review records.
2079 * Please see the CANDIDATE_LOG_TBL_TYPE
2080 * datatype table.
2081 * X_CANDIDATE_REVIEW_ID_TBL N/A Table to store the candidate review IDs
2082 * created by the API.
2083 * Reference: pa_candidate_reviews.candidate_review_id
2084 * X_RETURN_STATUS N/A The return status of the API. Valid
2085 * values are: S (success)
2086 * E (error)
2087 * U (unexpected error)
2088 * X_MSG_COUNT N/A The number of error messages in the
2089 * message stack
2090 * X_MSG_DATA N/A The error message text if only one
2091 * error exists
2092 */
2093 /*#
2094 * This is a public API to create log for one or more candidates for project requirements.
2095 * @param p_api_version_number API standard version number
2096 * @rep:paraminfo {@rep:required}
2097 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
2098 * @param p_commit API standard (default = F): indicates if transaction will be committed
2099 * @param p_candidate_log_tbl Table of candidate review records
2100 * @rep:paraminfo {@rep:required}
2101 * @param x_candidate_review_id_tbl Table to store the candidate review IDs created by the API
2102 * @rep:paraminfo {@rep:required}
2103 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2104 * @rep:paraminfo {@rep:required}
2105 * @param x_msg_count API standard: number of error messages
2106 * @rep:paraminfo {@rep:required}
2107 * @param x_msg_data API standard: error message
2108 * @rep:paraminfo {@rep:required}
2109 * @rep:scope public
2110 * @rep:lifecycle active
2111 * @rep:displayname Create Candidate Log
2112 * @rep:compatibility S
2113 */
2114 PROCEDURE CREATE_CANDIDATE_LOG
2115 (
2116 p_commit IN VARCHAR2 := FND_API.G_FALSE
2117 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2118 , p_api_version_number IN NUMBER := 1.0
2119 , p_candidate_log_tbl IN CANDIDATE_LOG_TBL_TYPE
2120 , x_candidate_review_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2121 , x_return_status OUT NOCOPY VARCHAR2
2122 , x_msg_count OUT NOCOPY NUMBER
2123 , x_msg_data OUT NOCOPY VARCHAR2
2124 );
2125
2126 END PA_RES_MANAGEMENT_AMG_PUB;
[Home] [Help]