1 PACKAGE PA_RES_MANAGEMENT_AMG_PUB AS
2 /* $Header: PAPMRSPS.pls 120.1.12010000.1 2008/07/25 04:31:16 appldev 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(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422 , additional_information VARCHAR2(240) := 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(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
793 , additional_information VARCHAR2(240) := 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 */
1040 TYPE CANDIDATE_IN_REC_TYPE IS RECORD
1041 (
1042 candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1043 , requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1044 , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1045 , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1046 , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1047 , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1048 , ranking NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1049 , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1050 , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1051 );
1052
1053
1054 -- This table is used to pass the required parameters for candidate APIs.
1055 /*
1056 * It is table of record type CANDIDATE_IN_REC_TYPE.
1057 */
1058 TYPE CANDIDATE_IN_TBL_TYPE IS TABLE OF CANDIDATE_IN_REC_TYPE
1059 INDEX BY BINARY_INTEGER;
1060
1061
1062 -- This record is used to pass the required parameters for candidate log APIs.
1063 /* Name: CANDIDATE_LOG_REC_TYPE
1064 * Decription: This record type supplies parameters for candidate logs.
1065 *
1066 * Attributes:
1067 * CANDIDATE_ID Identifier of the candidate
1068 * Usage: Create
1069 * Reference: pa_project_assignments.assignment_id
1070 * STATUS_CODE Status code of the candidate. Valid values are
1071 * obtained from PA_PROJECT_STATUSES where status_type
1072 * is CANDIDATE.
1073 * Usage: Create
1074 * Reference: pa_project_statuses.project_status_code
1075 * CHANGE_REASON_CODE Change reason for status change. Valid values
1076 * are obtained from pa_lookups where lookup_type is
1077 * CANDIDATE_STS_CHANGE_REASON.
1078 * Usage: Create
1079 * Reference: pa_candidate_reviews.change_reason_code
1080 * REVIEW_COMMENTS Review comments on candidate
1081 * Usage: Create
1082 * Reference: pa_candidate_reviews.review_comments
1083 */
1084 TYPE CANDIDATE_LOG_REC_TYPE IS RECORD
1085 (
1086 candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1087 , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1088 , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1089 , review_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1090 );
1091
1092 -- This table is used to pass the required parameters for candidate log APIs.
1093 /*
1094 * It is table of record type CANDIDATE_LOG_REC_TYPE
1095 */
1096 TYPE CANDIDATE_LOG_TBL_TYPE IS TABLE OF CANDIDATE_LOG_REC_TYPE
1097 INDEX BY BINARY_INTEGER;
1098
1099 -- This record is used to pass the required parameters for submit assignment APIs.
1100 /* Name: SUBMIT_ASSIGNMENT_IN_REC_TYPE
1101 * Decription: This record is used to pass the required parameters for
1102 * submit assignment APIs.
1103 *
1104 * Attributes:
1105 * ASSIGNMENT_ID Identifier of the assignment
1106 * Reference: pa_project_assignments.assignment_id
1107 * AUTO_APPROVE Indicates whether automatically approve the assignment
1108 * if resource authority is available.
1109 * APR_PERSON_ID_1 The first approver for the assignment
1110 * Reference: per_all_people_f.person_id
1111 * APR_PERSON_ID_2 The second approver for the assignment
1112 * Reference: per_all_people_f.person_id
1113 * NOTE_TO_APPROVER Comment for approvers
1114 * RECORD_VERSION_NUMBER The system-generated version number of this record.
1115 * The value is incremented by one with each update.
1116 *
1117 */
1118 TYPE SUBMIT_ASSIGNMENT_IN_REC_TYPE IS RECORD
1119 (
1120 assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1121 ,auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1122 ,apr_person_id_1 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1123 ,apr_person_id_2 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1124 ,note_to_approver VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1125 ,record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1126 );
1127
1128 /*
1129 * It is table of record type SUBMIT_ASSIGNMENT_IN_REC_TYPE.
1130 */
1131 TYPE SUBMIT_ASSIGNMENT_IN_TBL_TYPE IS TABLE OF SUBMIT_ASSIGNMENT_IN_REC_TYPE
1132 INDEX BY BINARY_INTEGER;
1133
1134 -- This is a public API to create one or more requirements for one or more projects
1135 /* Name: CREATE_REQUIREMENTS
1136 * Description: This procedure enables you to create project requirements.
1137 *
1138 * Parameters:
1139 * Parameter Name Null? Description
1140 * P_COMMIT NULL API standard (default = F)
1141 * P_INIT_MSG_LIST NULL API standard (default = T)
1142 * P_API_VERSION_NUMBER NOT NULL API standard
1143 * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1144 * see the REQUIREMENT_IN_TBL_TYPE
1145 * datatype table.
1146 * X_REQUIREMENT_ID_TBL N/A Table of requirement IDs created by
1147 * the API
1148 * Reference: pa_project_assignments.assignment_id
1149 * X_RETURN_STATUS N/A The return status of the API. Valid
1150 * values are: S (success)
1151 * E (error)
1152 * U (unexpected error)
1153 * X_MSG_COUNT N/A The number of error messages in the
1154 * message stack
1155 * X_MSG_DATA N/A The error message text if only one
1156 * error exists
1157 */
1158 /*#
1159 * This is a public API to create one or more requirements for one or more projects
1160 * @param p_api_version_number API standard version number
1161 * @rep:paraminfo {@rep:required}
1162 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1163 * @param p_commit API standard (default = F): indicates if transaction will be committed
1164 * @param p_requirement_in_tbl Table of requirement records
1165 * @rep:paraminfo {@rep:required}
1166 * @param x_requirement_id_tbl Table of requirement IDs created by the API
1167 * @rep:paraminfo {@rep:required}
1168 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1169 * @rep:paraminfo {@rep:required}
1170 * @param x_msg_count API standard: number of error messages
1171 * @rep:paraminfo {@rep:required}
1172 * @param x_msg_data API standard: error message
1173 * @rep:paraminfo {@rep:required}
1174 * @rep:scope public
1175 * @rep:lifecycle active
1176 * @rep:displayname Create Requirements
1177 * @rep:compatibility S
1178 */
1179 PROCEDURE CREATE_REQUIREMENTS
1180 (
1181 p_api_version_number IN NUMBER := 1.0
1182 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1183 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1184 , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1185 , x_requirement_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1186 , x_return_status OUT NOCOPY VARCHAR2
1187 , x_msg_count OUT NOCOPY NUMBER
1188 , x_msg_data OUT NOCOPY VARCHAR2
1189 );
1190
1191 -- This is a public API to update one or more requirements for one or more projects
1192 /* Name: UPDATE_REQUIREMENTS
1193 * Description: This procedure enables you to update project requirements.
1194 *
1195 * Parameters:
1196 * Parameter Name Null? Description
1197 * P_COMMIT NULL API standard (default = F)
1198 * P_INIT_MSG_LIST NULL API standard (default = T)
1199 * P_API_VERSION_NUMBER NOT NULL API standard
1200 * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1201 * see the REQUIREMENT_IN_TBL_TYPE
1202 * datatype table.
1203 * X_RETURN_STATUS N/A The return status of the API. Valid
1204 * values are: S (success)
1205 * E (error)
1206 * U (unexpected error)
1207 * X_MSG_COUNT N/A The number of error messages in the
1208 * message stack
1209 * X_MSG_DATA N/A The error message text if only one
1210 * error exists
1211 */
1212 /*#
1213 * This is a public API to update one or more requirements for one or more projects
1214 * @param p_api_version_number API standard version number
1215 * @rep:paraminfo {@rep:required}
1216 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1217 * @param p_commit API standard (default = F): indicates if transaction will be committed
1218 * @param p_requirement_in_tbl Table of requirement records
1219 * @rep:paraminfo {@rep:required}
1220 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1221 * @rep:paraminfo {@rep:required}
1222 * @param x_msg_count API standard: number of error messages
1223 * @rep:paraminfo {@rep:required}
1224 * @param x_msg_data API standard: error message
1225 * @rep:paraminfo {@rep:required}
1226 * @rep:scope public
1227 * @rep:lifecycle active
1228 * @rep:displayname Update Requirements
1229 * @rep:compatibility S
1230 */
1231 PROCEDURE UPDATE_REQUIREMENTS
1232 (
1233 p_api_version_number IN NUMBER := 1.0
1234 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1235 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1236 , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1237 , x_return_status OUT NOCOPY VARCHAR2
1238 , x_msg_count OUT NOCOPY NUMBER
1239 , x_msg_data OUT NOCOPY VARCHAR2
1240 );
1241
1242 -- This is a public API to delete one or more requirements for one or more projects
1243 /* Name: DELETE_REQUIREMENTS
1244 * Description: This procedure enables you to delete project requirements.
1245 *
1246 * Parameters:
1247 * Parameter Name Null? Description
1248 * P_COMMIT NULL API standard (default = F)
1249 * P_INIT_MSG_LIST NULL API standard (default = T)
1250 * P_API_VERSION_NUMBER NOT NULL API standard
1251 * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1252 * see the REQUIREMENT_IN_TBL_TYPE
1253 * datatype table.
1254 * X_RETURN_STATUS N/A The return status of the API. Valid
1255 * values are: S (success)
1256 * E (error)
1257 * U (unexpected error)
1258 * X_MSG_COUNT N/A The number of error messages in the
1259 * message stack
1260 * X_MSG_DATA N/A The error message text if only one
1261 * error exists
1262 */
1263 /*#
1264 * This is a public API to delete one or more requirements for one or more projects
1265 * @param p_api_version_number API standard version number
1266 * @rep:paraminfo {@rep:required}
1267 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1268 * @param p_commit API standard (default = F): indicates if transaction will be committed
1269 * @param p_requirement_in_tbl Table of requirement records
1270 * @rep:paraminfo {@rep:required}
1271 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1272 * @rep:paraminfo {@rep:required}
1273 * @param x_msg_count API standard: number of error messages
1274 * @rep:paraminfo {@rep:required}
1275 * @param x_msg_data API standard: error message
1276 * @rep:paraminfo {@rep:required}
1277 * @rep:scope public
1278 * @rep:lifecycle active
1279 * @rep:displayname Delete Requirements
1280 * @rep:compatibility S
1281 */
1282 PROCEDURE DELETE_REQUIREMENTS
1283 (
1284 p_api_version_number IN NUMBER := 1.0
1285 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1286 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1287 , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1288 , x_return_status OUT NOCOPY VARCHAR2
1289 , x_msg_count OUT NOCOPY NUMBER
1290 , x_msg_data OUT NOCOPY VARCHAR2
1291 );
1292
1293 -- This is a public API to staff one or more requirements for one or more projects
1294 /* Name: STAFF_REQUIREMENTS
1295 * Description: This procedure enables you to staff requirements.
1296 *
1297 * Parameters:
1298 * Parameter Name Null? Description
1299 * P_COMMIT NULL API standard (default = F)
1300 * P_INIT_MSG_LIST NULL API standard (default = T)
1301 * P_API_VERSION_NUMBER NOT NULL API standard
1302 * P_STAFF_REQUIREMENT_TBL NOT NULL Table of staffing information for each
1303 * requirement. Please see the
1304 * Staff_requirement_tbl_TYPE datatype
1305 * table.
1306 * X_ASSIGNMENT_ID_TBL N/A Table of staffed assignment IDs.
1307 * Reference: pa_project_assignments.assignment_id
1308 * X_RETURN_STATUS N/A The return status of the API. Valid
1309 * values are: S (success)
1310 * E (error)
1311 * U (unexpected error)
1312 * X_MSG_COUNT N/A The number of error messages in the
1313 * message stack
1314 * X_MSG_DATA N/A The error message text if only one
1315 * error exists
1316 */
1317 /*#
1318 * This is a public API to staff one or more requirements for one or more projects
1319 * @param p_api_version_number API standard version number
1320 * @rep:paraminfo {@rep:required}
1321 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1322 * @param p_commit API standard (default = F): indicates if transaction will be committed
1323 * @param p_staff_requirement_tbl Table of staffing information for each requirement
1324 * @rep:paraminfo {@rep:required}
1325 * @param x_assignment_id_tbl Table of staffed assignment IDs.
1326 * @rep:paraminfo {@rep:required}
1327 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1328 * @rep:paraminfo {@rep:required}
1329 * @param x_msg_count API standard: number of error messages
1330 * @rep:paraminfo {@rep:required}
1331 * @param x_msg_data API standard: error message
1332 * @rep:paraminfo {@rep:required}
1333 * @rep:scope public
1334 * @rep:lifecycle active
1335 * @rep:displayname Staff Requirements
1336 * @rep:compatibility S
1337 */
1338 PROCEDURE STAFF_REQUIREMENTS
1339 (
1340 p_api_version_number IN NUMBER := 1.0
1341 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1342 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1343 , p_staff_requirement_tbl IN STAFF_REQUIREMENT_TBL_TYPE
1344 , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1345 , x_return_status OUT NOCOPY VARCHAR2
1346 , x_msg_count OUT NOCOPY NUMBER
1347 , x_msg_data OUT NOCOPY VARCHAR2
1348 );
1349
1350 -- This is a public API to copy one or more team roles
1351 /* Name: COPY_TEAM_ROLES
1352 * Description: This procedure enables you to copy team roles from existing
1353 * project assignments or requirements.
1354 *
1355 * Parameters:
1356 * Parameter Name Null? Description
1357 * P_COMMIT NULL API standard (default = F)
1358 * P_INIT_MSG_LIST NULL API standard (default = T)
1359 * P_API_VERSION_NUMBER NOT NULL API standard
1360 * P_REQ_ASGN_ID_TBL NOT NULL Table of requirement or assignment IDs.
1361 * Reference: pa_project_assignments.assignment_id
1362 * X_REQ_ASGN_ID_TBL N/A Table of requirement or assignment IDs
1363 * created by the API.
1364 * Reference: pa_project_assignments.assignment_id
1365 * X_RETURN_STATUS N/A The return status of the API. Valid
1366 * values are: S (success)
1367 * E (error)
1368 * U (unexpected error)
1369 * X_MSG_COUNT N/A The number of error messages in the
1370 * message stack
1371 * X_MSG_DATA N/A The error message text if only one
1372 * error exists
1373 */
1374 /*#
1375 * This is a public API to copy one or more team roles
1376 * @param p_api_version_number API standard version number
1377 * @rep:paraminfo {@rep:required}
1378 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1379 * @param p_commit API standard (default = F): indicates if transaction will be committed
1380 * @param p_req_asgn_id_tbl Table of requirement or assignment IDs
1381 * @rep:paraminfo {@rep:required}
1382 * @param x_req_asgn_id_tbl Table of requirement or assignment IDs
1383 * @rep:paraminfo {@rep:required}
1384 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1385 * @rep:paraminfo {@rep:required}
1386 * @param x_msg_count API standard: number of error messages
1387 * @rep:paraminfo {@rep:required}
1388 * @param x_msg_data API standard: error message
1389 * @rep:paraminfo {@rep:required}
1390 * @rep:scope public
1391 * @rep:lifecycle active
1392 * @rep:displayname Copy Team Roles
1393 * @rep:compatibility S
1394 */
1395 PROCEDURE COPY_TEAM_ROLES
1396 (
1397 p_api_version_number IN NUMBER := 1.0
1398 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1399 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1400 , p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1401 , x_req_asgn_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1402 , x_return_status OUT NOCOPY VARCHAR2
1403 , x_msg_count OUT NOCOPY NUMBER
1404 , x_msg_data OUT NOCOPY VARCHAR2
1405 );
1406
1407 -- This is a public API to create one or more assignments for one or more projects
1408 /* Name: CREATE_ASSIGNMENTS
1409 * Description: This procedure enables you to create project assignments.
1410 *
1411 * Parameters:
1412 * Parameter Name Null? Description
1413 * P_COMMIT NULL API standard (default = F)
1414 * P_INIT_MSG_LIST NULL API standard (default = T)
1415 * P_API_VERSION_NUMBER NOT NULL API standard
1416 * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1417 * see the ASSIGNMENT_IN_TBL_TYPE
1418 * datatype table.
1419 * X_ASSIGNMENT_ID_TBL N/A Table to store assignment IDs created
1420 * by the API.
1421 * Reference: pa_project_assignments.assignment_id
1422 * X_RETURN_STATUS N/A The return status of the API. Valid
1423 * values are: S (success)
1424 * E (error)
1425 * U (unexpected error)
1426 * X_MSG_COUNT N/A The number of error messages in the
1427 * message stack
1428 * X_MSG_DATA N/A The error message text if only one
1429 * error exists
1430 */
1431 /*#
1432 * This is a public API to create one or more assignments for one or more projects
1433 * @param p_api_version_number API standard version number
1434 * @rep:paraminfo {@rep:required}
1435 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1436 * @param p_commit API standard (default = F): indicates if transaction will be committed
1437 * @param p_assignment_in_tbl Table of assignment records
1438 * @rep:paraminfo {@rep:required}
1439 * @param x_assignment_id_tbl Table to store assignment IDs created by the API
1440 * @rep:paraminfo {@rep:required}
1441 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1442 * @rep:paraminfo {@rep:required}
1443 * @param x_msg_count API standard: number of error messages
1444 * @rep:paraminfo {@rep:required}
1445 * @param x_msg_data API standard: error message
1446 * @rep:paraminfo {@rep:required}
1447 * @rep:scope public
1448 * @rep:lifecycle active
1449 * @rep:displayname Create Assignments
1450 * @rep:compatibility S
1451 */
1452 PROCEDURE CREATE_ASSIGNMENTS
1453 (
1454 p_api_version_number IN NUMBER := 1.0
1455 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1456 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1457 , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
1458 , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1459 , x_return_status OUT NOCOPY VARCHAR2
1460 , x_msg_count OUT NOCOPY NUMBER
1461 , x_msg_data OUT NOCOPY VARCHAR2
1462 ) ;
1463
1464 -- This is a public API to update one or more assignments for one or more projects.
1465 /* Name: UPDATE_ASSIGNMENTS
1466 * Description: This procedure enables you to update project assignments.
1467 *
1468 * Parameters:
1469 * Parameter Name Null? Description
1470 * P_COMMIT NULL API standard (default = F)
1471 * P_INIT_MSG_LIST NULL API standard (default = T)
1472 * P_API_VERSION_NUMBER NOT NULL API standard
1473 * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1474 * see the ASSIGNMENT_IN_TBL_TYPE
1475 * datatype table.
1476 * X_RETURN_STATUS N/A The return status of the API. Valid
1477 * values are: S (success)
1478 * E (error)
1479 * U (unexpected error)
1480 * X_MSG_COUNT N/A The number of error messages in the
1481 * message stack
1482 * X_MSG_DATA N/A The error message text if only one
1483 * error exists
1484 */
1485 /*#
1486 * This is a public API to update one or more assignments for one or more projects.
1487 * @param p_api_version_number API standard version number
1488 * @rep:paraminfo {@rep:required}
1489 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1490 * @param p_commit API standard (default = F): indicates if transaction will be committed
1491 * @param p_assignment_in_tbl Table of assignment records
1492 * @rep:paraminfo {@rep:required}
1493 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1494 * @rep:paraminfo {@rep:required}
1495 * @param x_msg_count API standard: number of error messages
1496 * @rep:paraminfo {@rep:required}
1497 * @param x_msg_data API standard: error message
1498 * @rep:paraminfo {@rep:required}
1499 * @rep:scope public
1500 * @rep:lifecycle active
1501 * @rep:displayname Update Assignments
1502 * @rep:compatibility S
1503 */
1504 PROCEDURE UPDATE_ASSIGNMENTS
1505 (
1506 p_api_version_number IN NUMBER := 1.0
1507 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1508 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1509 , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
1510 , x_return_status OUT NOCOPY VARCHAR2
1511 , x_msg_count OUT NOCOPY NUMBER
1512 , x_msg_data OUT NOCOPY VARCHAR2
1513 );
1514
1515 -- This is a public API to Delete one or more assignments for one or more projects.
1516 /* Name: DELETE_ASSIGNMENTS
1517 * Description: This procedure enables you to delete project assignments.
1518 *
1519 * Parameters:
1520 * Parameter Name Null? Description
1521 * P_COMMIT NULL API standard (default = F)
1522 * P_INIT_MSG_LIST NULL API standard (default = T)
1523 * P_API_VERSION_NUMBER NOT NULL API standard
1524 * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1525 * see the ASSIGNMENT_IN_TBL_TYPE
1526 * datatype table.
1527 * X_RETURN_STATUS N/A The return status of the API. Valid
1528 * values are: S (success)
1529 * E (error)
1530 * U (unexpected error)
1531 * X_MSG_COUNT N/A The number of error messages in the
1532 * message stack
1533 * X_MSG_DATA N/A The error message text if only one
1534 * error exists
1535 */
1536 /*#
1537 * This is a public API to Delete one or more assignments for one or more projects.
1538 * @param p_api_version_number API standard version number
1539 * @rep:paraminfo {@rep:required}
1540 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1541 * @param p_commit API standard (default = F): indicates if transaction will be committed
1542 * @param p_assignment_in_tbl Table of assignment records
1543 * @rep:paraminfo {@rep:required}
1544 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1545 * @rep:paraminfo {@rep:required}
1546 * @param x_msg_count API standard: number of error messages
1547 * @rep:paraminfo {@rep:required}
1548 * @param x_msg_data API standard: error message
1549 * @rep:paraminfo {@rep:required}
1550 * @rep:scope public
1551 * @rep:lifecycle active
1552 * @rep:displayname Delete Assignments
1553 * @rep:compatibility S
1554 */
1555 PROCEDURE DELETE_ASSIGNMENTS (
1556 p_commit IN VARCHAR2 := 'F'
1557 , p_init_msg_list IN VARCHAR2 := 'T'
1558 , p_api_version_number IN NUMBER := 1.0
1559 , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
1560 , x_return_status OUT NOCOPY VARCHAR2
1561 , x_msg_count OUT NOCOPY NUMBER
1562 , x_msg_data OUT NOCOPY VARCHAR2 ) ;
1563
1564 -- This is a public API to submit/approve one or more assignments for one or more projects.
1565 /* Name: SUBMIT_ASSIGNMENTS
1566 * Description: This procedure enables you to submit and approve project
1567 * assignments.
1568 *
1569 * Parameters:
1570 * Parameter Name Null? Description
1571 * P_COMMIT NULL API standard (default = F)
1572 * P_INIT_MSG_LIST NULL API standard (default = T)
1573 * P_API_VERSION_NUMBER NOT NULL API standard
1574 * P_SUBMIT_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1575 * see the SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1576 * datatype table.
1577 * X_RETURN_STATUS N/A The return status of the API. Valid
1578 * values are: S (success)
1579 * E (error)
1580 * U (unexpected error)
1581 * X_MSG_COUNT N/A The number of error messages in the
1582 * message stack
1583 * X_MSG_DATA N/A The error message text if only one
1584 * error exists
1585 */
1586 /*#
1587 * This is a public API to submit/approve one or more assignments for one or more projects.
1588 * @param p_api_version_number API standard version number
1589 * @rep:paraminfo {@rep:required}
1590 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1591 * @param p_commit API standard (default = F): indicates if transaction will be committed
1592 * @param p_submit_assignment_in_tbl Table of assignment records
1593 * @rep:paraminfo {@rep:required}
1594 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1595 * @rep:paraminfo {@rep:required}
1596 * @param x_msg_count API standard: number of error messages
1597 * @rep:paraminfo {@rep:required}
1598 * @param x_msg_data API standard: error message
1599 * @rep:paraminfo {@rep:required}
1600 * @rep:scope public
1601 * @rep:lifecycle active
1602 * @rep:displayname Submit Assignments
1603 * @rep:compatibility S
1604 */
1605 PROCEDURE SUBMIT_ASSIGNMENTS
1606 (
1607 p_api_version_number IN NUMBER := 1.0
1608 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1609 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1610 , p_submit_assignment_in_tbl IN SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1611 , x_return_status OUT NOCOPY VARCHAR2
1612 , x_msg_count OUT NOCOPY NUMBER
1613 , x_msg_data OUT NOCOPY VARCHAR2
1614 );
1615
1616 --This is a public API to create one or more competences for one or more project requirements.
1617 /* Name: CREATE_REQUIREMENT_COMPETENCE
1618 * Description: This procedure enables you to create competences for
1619 * project requirements.
1620 * Parameters:
1621 * Parameter Name Null? Description
1622 * P_COMMIT NULL API standard (default = F)
1623 * P_INIT_MSG_LIST NULL API standard (default = T)
1624 * P_API_VERSION_NUMBER NOT NULL API standard
1625 * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1626 * see the COMPETENCE_IN_TBL_TYPE
1627 * datatype table.
1628 * X_COMPETENCE_ELEMENT_ID_TBL N/A Table to store the competence element
1629 * IDs created by the API.
1630 * Reference: per_comepetence_elements.competence_element_id
1631 * X_RETURN_STATUS N/A The return status of the API. Valid
1632 * values are: S (success)
1633 * E (error)
1634 * U (unexpected error)
1635 * X_MSG_COUNT N/A The number of error messages in the
1636 * message stack
1637 * X_MSG_DATA N/A The error message text if only one
1638 * error exists
1639 */
1640 /*#
1641 * This is a public API to create one or more competences for one or more project requirements.
1642 * @param p_api_version_number API standard version number
1643 * @rep:paraminfo {@rep:required}
1644 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1645 * @param p_commit API standard (default = F): indicates if transaction will be committed
1646 * @param p_competence_in_tbl Table of competence records
1647 * @rep:paraminfo {@rep:required}
1648 * @param x_competence_element_id_tbl Table to store the competence element IDs created by the API
1649 * @rep:paraminfo {@rep:required}
1650 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1651 * @rep:paraminfo {@rep:required}
1652 * @param x_msg_count API standard: number of error messages
1653 * @rep:paraminfo {@rep:required}
1654 * @param x_msg_data API standard: error message
1655 * @rep:paraminfo {@rep:required}
1656 * @rep:scope public
1657 * @rep:lifecycle active
1658 * @rep:displayname Create Requirement Competence
1659 * @rep:compatibility S
1660 */
1661 PROCEDURE CREATE_REQUIREMENT_COMPETENCE
1662 (
1663 p_commit IN VARCHAR2 :='F'
1664 , p_init_msg_list IN VARCHAR2 :='T'
1665 , p_api_version_number IN NUMBER :=1.0
1666 , p_competence_in_tbl IN COMPETENCE_IN_TBL_TYPE
1667 , x_competence_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1668 , x_return_status OUT NOCOPY VARCHAR2
1669 , x_msg_count OUT NOCOPY NUMBER
1670 , x_msg_data OUT NOCOPY VARCHAR2
1671 );
1672
1673 --This is a public API to update one or more competences for one or more project requirements
1674 /* Name: UPDATE_REQUIREMENT_COMPETENCE
1675 * Description: This procedure enables you to update competences for
1676 * project requirements.
1677 * Parameters:
1678 * Parameter Name Null? Description
1679 * P_COMMIT NULL API standard (default = F)
1680 * P_INIT_MSG_LIST NULL API standard (default = T)
1681 * P_API_VERSION_NUMBER NOT NULL API standard
1682 * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1683 * see the COMPETENCE_IN_TBL_TYPE
1684 * datatype table.
1685 * X_RETURN_STATUS N/A The return status of the API. Valid
1686 * values are: S (success)
1687 * E (error)
1688 * U (unexpected error)
1689 * X_MSG_COUNT N/A The number of error messages in the
1690 * message stack
1691 * X_MSG_DATA N/A The error message text if only one
1692 * error exists
1693 */
1694 /*#
1695 * This is a public API to update one or more competences for one or more project requirements
1696 * @param p_api_version_number API standard version number
1697 * @rep:paraminfo {@rep:required}
1698 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1699 * @param p_commit API standard (default = F): indicates if transaction will be committed
1700 * @param p_competence_in_tbl Table of competence records
1701 * @rep:paraminfo {@rep:required}
1702 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1703 * @rep:paraminfo {@rep:required}
1704 * @param x_msg_count API standard: number of error messages
1705 * @rep:paraminfo {@rep:required}
1706 * @param x_msg_data API standard: error message
1707 * @rep:paraminfo {@rep:required}
1708 * @rep:scope public
1709 * @rep:lifecycle active
1710 * @rep:displayname Update Requirement Competence
1711 * @rep:compatibility S
1712 */
1713 PROCEDURE UPDATE_REQUIREMENT_COMPETENCE
1714 (
1715 p_commit IN VARCHAR2 := 'F'
1716 , p_init_msg_list IN VARCHAR2 := 'T'
1717 , p_api_version_number IN NUMBER := 1.0
1718 , p_competence_in_tbl IN COMPETENCE_IN_TBL_TYPE
1719 , x_return_status OUT NOCOPY VARCHAR2
1720 , x_msg_count OUT NOCOPY NUMBER
1721 , x_msg_data OUT NOCOPY VARCHAR2
1722 );
1723
1724
1725 --This is a public API to delete one or more competences for one or more project requirements.
1726 /* Name: DELETE_REQUIREMENT_COMPETENCE
1727 * Description: This procedure enables you to delete competences for
1728 * project requirements.
1729 * Parameters:
1730 * Parameter Name Null? Description
1731 * P_COMMIT NULL API standard (default = F)
1732 * P_INIT_MSG_LIST NULL API standard (default = T)
1733 * P_API_VERSION_NUMBER NOT NULL API standard
1734 * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1735 * see the COMPETENCE_IN_TBL_TYPE
1736 * datatype table.
1737 * X_RETURN_STATUS N/A The return status of the API. Valid
1738 * values are: S (success)
1739 * E (error)
1740 * U (unexpected error)
1741 * X_MSG_COUNT N/A The number of error messages in the
1742 * message stack
1743 * X_MSG_DATA N/A The error message text if only one
1744 * error exists
1745 */
1746 /*#
1747 * This is a public API to delete one or more competences for one or more project requirements.
1748 * @param p_api_version_number API standard version number
1749 * @rep:paraminfo {@rep:required}
1750 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1751 * @param p_commit API standard (default = F): indicates if transaction will be committed
1752 * @param p_competence_in_tbl Table of competence records
1753 * @rep:paraminfo {@rep:required}
1754 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1755 * @rep:paraminfo {@rep:required}
1756 * @param x_msg_count API standard: number of error messages
1757 * @rep:paraminfo {@rep:required}
1758 * @param x_msg_data API standard: error message
1759 * @rep:paraminfo {@rep:required}
1760 * @rep:scope public
1761 * @rep:lifecycle active
1762 * @rep:displayname Delete Requirement Competence
1763 * @rep:compatibility S
1764 */
1765 PROCEDURE DELETE_REQUIREMENT_COMPETENCE
1766 (
1767 p_commit IN VARCHAR2 :='F'
1768 , p_init_msg_list IN VARCHAR2 := 'T'
1769 , p_api_version_number IN NUMBER := 1.0
1770 , p_competence_in_tbl IN COMPETENCE_IN_TBL_TYPE
1771 , x_return_status OUT NOCOPY VARCHAR2
1772 , x_msg_count OUT NOCOPY NUMBER
1773 , x_msg_data OUT NOCOPY VARCHAR2
1774 );
1775
1776
1777
1778 -- This is a public API to create/nominate one or more candidates for project requirements.
1779 /* Name: CREATE_CANDIDATES
1780 * Description: This procedure enables you to nominate candidates for
1781 * project requirements.
1782 * Parameters:
1783 * Parameter Name Null? Description
1784 * P_COMMIT NULL API standard (default = F)
1785 * P_INIT_MSG_LIST NULL API standard (default = T)
1786 * P_API_VERSION_NUMBER NOT NULL API standard
1787 * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1788 * the CANDIDATE_IN_TBL_TYPE datatype table.
1789 * X_CANDIDATE_ID_TBL N/A Table to store the candidate IDs
1790 * created by the API.
1791 * Reference: pa_candidates.candidate_id
1792 * X_RETURN_STATUS N/A The return status of the API. Valid
1793 * values are: S (success)
1794 * E (error)
1795 * U (unexpected error)
1796 * X_MSG_COUNT N/A The number of error messages in the
1797 * message stack
1798 * X_MSG_DATA N/A The error message text if only one
1799 * error exists
1800 */
1801 /*#
1802 * This is a public API to create/nominate one or more candidates for project requirements
1803 * @param p_api_version_number API standard version number
1804 * @rep:paraminfo {@rep:required}
1805 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1806 * @param p_commit API standard (default = F): indicates if transaction will be committed
1807 * @param p_candidate_in_tbl Table of candidate records
1808 * @rep:paraminfo {@rep:required}
1809 * @param x_candidate_id_tbl Table to store the candidate IDs created by the API.
1810 * @rep:paraminfo {@rep:required}
1811 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1812 * @rep:paraminfo {@rep:required}
1813 * @param x_msg_count API standard: number of error messages
1814 * @rep:paraminfo {@rep:required}
1815 * @param x_msg_data API standard: error message
1816 * @rep:paraminfo {@rep:required}
1817 * @rep:scope public
1818 * @rep:lifecycle active
1819 * @rep:displayname Create Candidates
1820 * @rep:compatibility S
1821 */
1822 PROCEDURE CREATE_CANDIDATES
1823 (
1824 p_commit IN VARCHAR2 := FND_API.G_FALSE
1825 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1826 , p_api_version_number IN NUMBER := 1.0
1827 , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
1828 , x_candidate_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1829 , x_return_status OUT NOCOPY VARCHAR2
1830 , x_msg_count OUT NOCOPY NUMBER
1831 , x_msg_data OUT NOCOPY VARCHAR2
1832 );
1833
1834
1835 -- This is a public API to update one or more candidates for project requirements.
1836 /* Name: UPDATE_CANDIDATES
1837 * Description: This procedure enables you to update the candidates for
1838 * project requirements.
1839 * Parameters:
1840 * Parameter Name Null? Description
1841 * P_COMMIT NULL API standard (default = F)
1842 * P_INIT_MSG_LIST NULL API standard (default = T)
1843 * P_API_VERSION_NUMBER NOT NULL API standard
1844 * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1845 * the CANDIDATE_IN_TBL_TYPE datatype table.
1846 * X_RETURN_STATUS N/A The return status of the API. Valid
1847 * values are: S (success)
1848 * E (error)
1849 * U (unexpected error)
1850 * X_MSG_COUNT N/A The number of error messages in the
1851 * message stack
1852 * X_MSG_DATA N/A The error message text if only one
1853 * error exists
1854 */
1855 /*#
1856 * This is a public API to update one or more candidates for project requirements
1857 * @param p_api_version_number API standard version number
1858 * @rep:paraminfo {@rep:required}
1859 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1860 * @param p_commit API standard (default = F): indicates if transaction will be committed
1861 * @param p_candidate_in_tbl Table of candidate records
1862 * @rep:paraminfo {@rep:required}
1863 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1864 * @rep:paraminfo {@rep:required}
1865 * @param x_msg_count API standard: number of error messages
1866 * @rep:paraminfo {@rep:required}
1867 * @param x_msg_data API standard: error message
1868 * @rep:paraminfo {@rep:required}
1869 * @rep:scope public
1870 * @rep:lifecycle active
1871 * @rep:displayname Update Candidates
1872 * @rep:compatibility S
1873 */
1874 PROCEDURE UPDATE_CANDIDATES
1875 (
1876 p_commit IN VARCHAR2 := FND_API.G_FALSE
1877 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1878 , p_api_version_number IN NUMBER := 1.0
1879 , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
1880 , x_return_status OUT NOCOPY VARCHAR2
1881 , x_msg_count OUT NOCOPY NUMBER
1882 , x_msg_data OUT NOCOPY VARCHAR2
1883 );
1884
1885
1886 -- This is a public API to delete one or more candidates for project requirements.
1887 /* Name: DELETE_CANDIDATES
1888 * Description: This procedure enables you to delete candidates from
1889 * project requirements.
1890 * Parameters:
1891 * Parameter Name Null? Description
1892 * P_COMMIT NULL API standard (default = F)
1893 * P_INIT_MSG_LIST NULL API standard (default = T)
1894 * P_API_VERSION_NUMBER NOT NULL API standard
1895 * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1896 * the CANDIDATE_IN_TBL_TYPE datatype table.
1897 * X_RETURN_STATUS N/A The return status of the API. Valid
1898 * values are: S (success)
1899 * E (error)
1900 * U (unexpected error)
1901 * X_MSG_COUNT N/A The number of error messages in the
1902 * message stack
1903 * X_MSG_DATA N/A The error message text if only one
1904 * error exists
1905 */
1906 /*#
1907 * This is a public API to delete one or more candidates for project requirements.
1908 * @param p_api_version_number API standard version number
1909 * @rep:paraminfo {@rep:required}
1910 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1911 * @param p_commit API standard (default = F): indicates if transaction will be committed
1912 * @param p_candidate_in_tbl Table of candidate records
1913 * @rep:paraminfo {@rep:required}
1914 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1915 * @rep:paraminfo {@rep:required}
1916 * @param x_msg_count API standard: number of error messages
1917 * @rep:paraminfo {@rep:required}
1918 * @param x_msg_data API standard: error message
1919 * @rep:paraminfo {@rep:required}
1920 * @rep:scope public
1921 * @rep:lifecycle active
1922 * @rep:displayname Delete Candidates
1923 * @rep:compatibility S
1924 */
1925 PROCEDURE DELETE_CANDIDATES
1926 (
1927 p_commit IN VARCHAR2 := FND_API.G_FALSE
1928 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1929 , p_api_version_number IN NUMBER := 1.0
1930 , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
1931 , x_return_status OUT NOCOPY VARCHAR2
1932 , x_msg_count OUT NOCOPY NUMBER
1933 , x_msg_data OUT NOCOPY VARCHAR2
1934 );
1935
1936
1937 -- This is a public API to create log for one or more candidates for project requirements.
1938 /* Name: CREATE_CANDIDATE_LOG
1939 * Description: This procedure creates a log for one or more candidates for
1940 * project requirements.
1941 * Parameters:
1942 * Parameter Name Null? Description
1943 * P_COMMIT NULL API standard (default = F)
1944 * P_INIT_MSG_LIST NULL API standard (default = T)
1945 * P_API_VERSION_NUMBER NOT NULL API standard
1946 * P_CANDIDATE_LOG_TBL NOT NULL Table of candidate review records.
1947 * Please see the CANDIDATE_LOG_TBL_TYPE
1948 * datatype table.
1949 * X_CANDIDATE_REVIEW_ID_TBL N/A Table to store the candidate review IDs
1950 * created by the API.
1951 * Reference: pa_candidate_reviews.candidate_review_id
1952 * X_RETURN_STATUS N/A The return status of the API. Valid
1953 * values are: S (success)
1954 * E (error)
1955 * U (unexpected error)
1956 * X_MSG_COUNT N/A The number of error messages in the
1957 * message stack
1958 * X_MSG_DATA N/A The error message text if only one
1959 * error exists
1960 */
1961 /*#
1962 * This is a public API to create log for one or more candidates for project requirements.
1963 * @param p_api_version_number API standard version number
1964 * @rep:paraminfo {@rep:required}
1965 * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1966 * @param p_commit API standard (default = F): indicates if transaction will be committed
1967 * @param p_candidate_log_tbl Table of candidate review records
1968 * @rep:paraminfo {@rep:required}
1969 * @param x_candidate_review_id_tbl Table to store the candidate review IDs created by the API
1970 * @rep:paraminfo {@rep:required}
1971 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1972 * @rep:paraminfo {@rep:required}
1973 * @param x_msg_count API standard: number of error messages
1974 * @rep:paraminfo {@rep:required}
1975 * @param x_msg_data API standard: error message
1976 * @rep:paraminfo {@rep:required}
1977 * @rep:scope public
1978 * @rep:lifecycle active
1979 * @rep:displayname Create Candidate Log
1980 * @rep:compatibility S
1981 */
1982 PROCEDURE CREATE_CANDIDATE_LOG
1983 (
1984 p_commit IN VARCHAR2 := FND_API.G_FALSE
1985 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1986 , p_api_version_number IN NUMBER := 1.0
1987 , p_candidate_log_tbl IN CANDIDATE_LOG_TBL_TYPE
1988 , x_candidate_review_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1989 , x_return_status OUT NOCOPY VARCHAR2
1990 , x_msg_count OUT NOCOPY NUMBER
1991 , x_msg_data OUT NOCOPY VARCHAR2
1992 );
1993
1994 END PA_RES_MANAGEMENT_AMG_PUB;