1 PACKAGE pa_assignments_pub AS
2 /*$Header: PARAPUBS.pls 120.2 2007/02/06 09:44:51 dthakker ship $*/
3 --
4
5 --
6 --Global Variable used to determine if any error has occured in the procedure.
7 --
8 g_error_exists VARCHAR2(1) := FND_API.G_FALSE;
9 --
10 --Composite Record used to pass information from the API wrapper
11 --
12 TYPE Assignment_Rec_Type
13 IS RECORD
14 ( assignment_row_id ROWID
15 ,assignment_id pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
16 ,assignment_name pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
17 ,assignment_type pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
18 ,apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
19 ,status_code pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
20 ,staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
21 ,multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE := 'N'
22 ,record_version_number pa_project_assignments.record_version_number%TYPE := FND_API.G_MISS_NUM
23 ,project_id pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
24 ,project_role_id pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
25 ,resource_id pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
26 ,project_party_id pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
27 ,description pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
28 ,note_to_approver pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
29 ,start_date pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
30 ,end_date pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
31 ,assignment_effort pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
32 ,extension_possible pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
33 ,source_assignment_id pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
34 ,min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
35 ,max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
36 ,assignment_number pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
37 ,additional_information pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
38 ,location_id pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
39 ,work_type_id pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
40 ,revenue_currency_code pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
41 ,revenue_bill_rate pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
42 ,markup_percent pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
43 ,expense_owner pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
44 ,expense_limit pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
45 ,expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
46 ,fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
47 ,fcst_job_id pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
48 ,fcst_job_group_id pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
49 ,expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
50 ,expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
51 ,expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
52 ,expenditure_type pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
53 ,calendar_type pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
54 ,calendar_id pa_project_assignments.calendar_id %TYPE := FND_API.G_MISS_NUM
55 ,resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
56 ,no_of_active_candidates pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
57 ,assignment_template_id pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
58 ,template_flag pa_project_assignments.template_flag%TYPE := FND_API.G_MISS_CHAR
59 ,source_assignment_type VARCHAR2(80) := NULL
60 ,comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
61 ,avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
62 ,job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
63 ,search_min_availability pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
64 ,search_country_code pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
65 ,search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
66 ,search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
67 ,search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
68 ,last_auto_search_date pa_project_assignments.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
69 ,enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
70 ,mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
71 ,bill_rate_override pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
72 ,bill_rate_curr_override pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
73 ,markup_percent_override pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
74 ,discount_percentage pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2531267
75 ,rate_disc_reason_code pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2531267
76 ,tp_rate_override pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
77 ,tp_currency_override pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
78 ,tp_calc_base_code_override pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
79 ,tp_percent_applied_override pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
80 ,staffing_owner_person_id pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
81 -- FP.M Development
82 ,resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM
83 ,attribute_category pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
84 ,attribute1 pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
85 ,attribute2 pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
86 ,attribute3 pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
87 ,attribute4 pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
88 ,attribute5 pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
89 ,attribute6 pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
90 ,attribute7 pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
91 ,attribute8 pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
92 ,attribute9 pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
93 ,attribute10 pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
94 ,attribute11 pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
95 ,attribute12 pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
96 ,attribute13 pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
97 ,attribute14 pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
98 ,attribute15 pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
99 /* Added for bug 3051110 */
100 ,transfer_price_rate pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
101 ,transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
102 );
103
104 TYPE Assignment_Tbl_Type IS TABLE OF Assignment_Rec_Type
105 INDEX BY BINARY_INTEGER;
106
107 TYPE Assignment_Id_Rec_Type IS RECORD
108 (assignment_id NUMBER);
109
110 TYPE Assignment_Id_Tbl_Type IS TABLE OF Assignment_Id_Rec_Type
111 INDEX BY BINARY_INTEGER;
112
113 TYPE num_tbl_type IS TABLE OF NUMBER
114 INDEX BY BINARY_INTEGER;
115
116 TYPE res_name_tbl_type IS TABLE OF pa_resources_denorm.resource_name%TYPE
117 INDEX BY BINARY_INTEGER;
118
119 g_assignment_id_tbl Assignment_Id_Tbl_Type;
120
121 -- ----------------------------------------------------------------------------
122 -- |--------------------------<Execute_Create_Assignment>----------------------|
123 -- ----------------------------------------------------------------------------
124 --
125 -- {Start Of Comments}
126 --
127 -- Description:
128 -- This API creates a requirement or an assignment from the scalar values passed to it. It loads the composite
129 -- record with scalar values and calls Create_Assignment.
130 -- Prerequisites:
131 --
132 -- In Parameters:
133 -- Name Reqd Type Description
134 -- p_asgn_creation_mode VARCHAR2 Indicates whether the assignment creation is FULL or
135 -- PARTIAL. Defaults to 'FULL'
136 -- p_unfilled_assignment_status VARCHAR2 Status of the newly created requirement when assignment is
137 -- partial.
138 -- p_assignment_name X VARCHAR2 Required if p_assignment_id is null.
139 -- p_assignment_type Y VARCHAR2 Indicates the type of the object for which status is shown.
140 -- 'OPEN_ASSIGNMENT' => Requirement
141 -- 'STAFFED_ASSIGNMENT'=> Assignment/Project Assignment
142 -- 'STAFFED_ADMIN_ASSIGNMENT' => Administrative Assignment
143 -- p_multiple_status_flag Y VARCHAR2 Indicates whether the underlying schedule for the Assignment
144 -- have more than one statuses. For requirement, use 'N'
145 -- p_status_code X VARCHAR2 Indicates the status of the assignment. This column may be
146 -- null if the underlying schedule has multiple status codes.
147 -- This is mandatory if p_project_status_name is null.
148 -- p_project_id X NUMBER The identifier of the project to which this record belongs
149 -- This is mandatory if p_project_number is null.
150 -- p_project_role_id X NUMBER Identifier of the project role for the record.
151 -- This is mandatory if project_role_name is null.
152 -- p_resource_id NUMBER Identifier of the project resource.
153 -- p_project_party_id NUMBER The identifier of the project party on an assignment.
154 -- p_project_subteam_id X NUMBER The identifier for the project subteam to which this record
155 -- belongs. Mandatory if p_project_subteam_name is null.
156 -- p_description VARCHAR2 The free text description of the record.
157 -- p_start_date Y DATE Start date of the requirement/assignment
158 -- p_end_date Y DATE End date of the requirement/assignment.
159 -- p_assignment_effort NUMBER Total number of hours of the requirement/assignment
160 -- p_extension_possible VARCHAR2 Indicates whether it is possible to extend the
161 -- requirement/assignment.
162 -- p_source_assignment_id NUMBER Identifies the assignment from which this assignment record
163 -- is originated.
164 -- p_min_resource_job_level NUMBER Indicates the minimum acceptable job level for a requirement.
165 -- p_max_resource_job_level NUMBER Indidates the maximum acceptable job level for a requirement.
166 -- p_additional_information VARCHAR2 Free text for additional information on a record.
167 -- p_location_id NUMBER Identifier of the location of the assignment. For new
168 -- assignments this column gets default value from the project
169 -- setup.
170 -- p_work_type_id X NUMBER Identifies the type of work being carried out. Gets defaulted
171 -- from project setup for open assignment and from staffed
172 -- assignments not created from an open assignment.Mandatory
173 -- if work_type_name is null
174 -- p_revenue_currency_code VARCHAR2 Currency code of the revenue
175 -- p_revenue_bill_rate NUMBER Bill rate of the revenue
176 -- p_expense_owner VARCHAR2 Owner of the expense
177 -- p_expense_limit NUMBER The maximum amount that expense owner is willing to pay.
178 -- p_expense_limit_currency_code VARCHAR2 Currency code of the expense limit.
179 -- p_fcst_tp_amount_type VARCHAR2
180 -- p_fcst_job_id NUMBER
181 -- p_calendar_type VARCHAR2 Indicates the base calendar used for generating schedules.
182 -- p_calendar_id NUMBER Identifier of the calendar
183 -- p_resource_calendar_percent NUMBER Daily percentage of the resource calendar
184 -- p_project_name X VARCHAR2 Required if p_project_number and p_project_id are null.
185 -- p_project_number X VARCHAR2 Required if p_project_id and p_project_name are null.
186 -- p_resource_name X VARCHAR2 Required for an assignment and if p_resource_source_id is null
187 -- p_resource_source_id X NUMBER Person ID used by HR, used to staff an assignment.
188 -- Required for an assignment
189 -- p_project_subteam_name VARCHAR2
190 -- p_project_status_name X VARCHAR2 Required if p_project_status_code is null.
191 -- p_project_role_name X VARCHAR2 Required if p_project_role_id is null.
192 -- p_location_city VARCHAR2
193 -- p_location_region VARCHAR2
194 -- p_location_country_name VARCHAR2
195 -- p_location_country_code VARCHAR2
196 -- p_calendar_name X VARCHAR2 Required if p_calendar_id is null.
197 -- p_work_type_name X VARCHAR2 Required if p_work_type_id is null.
198 -- p_attribute_category VARCHAR2 Descriptive flexfield context field
199 -- p_attribute1 VARCHAR2 Descriptive flexfield segment
200 -- p_attribute2 VARCHAR2
201 -- p_attribute3 VARCHAR2
202 -- p_attribute4 VARCHAR2
203 -- p_attribute5 VARCHAR2
204 -- p_attribute6 VARCHAR2
205 -- p_attribute7 VARCHAR2
206 -- p_attribute8 VARCHAR2
207 -- p_attribute9 VARCHAR2
208 -- p_attribute10 VARCHAR2
209 -- p_attribute11 VARCHAR2
210 -- p_attribute12 VARCHAR2
211 -- p_attribute13 VARCHAR2
212 -- p_attribute14 VARCHAR2
213 -- p_attribute15 VARCHAR2
214 -- p_api_version VARCHAR2 A NO Null field, defaults to '1.0'
215 -- p_init_msg_list VARCHAR2 'T' => Initialize message stack
216 -- 'F' => append to exisiting message stack
217 -- p_commit VARCHAR2 'F' => calling program does the database commit.
218 -- 'T' => This API does the database commit
219 -- p_validate_only VARCHAR2 'T' => perform validation only
220 -- 'F' => perform validation and DML
221 -- p_max_msg_count NUMBER Optional. Indicates the maximum number of messages that can
222 -- be put on the message stack.
223 --Out Parameters:
224 --
225 -- The api will set the following out parameters:
226 --
227 -- Name Type Description
228 --
229 -- x_new_assignment_id NUMBER System generated id of the requirement/assignment
230 -- x_assignment_number NUMBER System generated number of the requirement/assignment
231 -- x_assignment_row_id ROWID requirement/assignment row id
232 -- x_resource_id NUMBER Identifier of the Project resource, it is null for a requirement
233 -- x_return_status VARCHAR2 Return Status: 'S' => Successful
234 -- 'E' => Error occured.
235 -- 'U' => Unexpected error occured.
236 -- x_msg_count NUMBER Number of error count.
237 -- x_msg_data VARCHAR2 If only one error occurs, this parameter will contain the error message.
238 -- x_new_assignment_id_tbl Number table type.Poplulating in case of multiple requirements.
239 -- 13-aug-2003 sramesh -- Added the new parameter x_new_assignment_id_tbl for the procedure
240 -- Execute_Create_Assignment and also in the impacted places.
241 -- Access Status:
242 -- Public.
243 --
244 -- {End Of Comments}
245 --
246 PROCEDURE Execute_Create_Assignment
247 ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
248 ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
249 ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
250 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
251 ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
252 ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
253 ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
254 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
255 ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
256 ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
257 ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
258 ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
259 ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
260 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
261 ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
262 ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
263 ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
264 ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
265 ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
266 ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
267 ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
268 ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
269 ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
270 ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
271 ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
272 ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
273 ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
274 ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
275 ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
276 ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
277 ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
278 ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
279 ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
280 ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
281 ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
282 ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
283 ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
284 ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
285 ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
286 ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
287 ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
288 ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
289 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
290 ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
291 ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
292 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
293 ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
294 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
295 ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
296 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
297 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
298 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
299 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
300 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
301 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
302 ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
303 ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
304 ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
305 ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
306 ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
307 ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
308 ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
309 ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
310 ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
311 ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
312 ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM
313 ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
314 ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
315 ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
316 ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
317 ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
318 ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
319 ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
320 ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM
321 ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
322 ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
323 ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
324 ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
325 ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
326 ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
327 ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
328 ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
329 ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
330 ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
331 ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
332 ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
333 ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
334 ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
335 ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
336 ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
337 ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
338 ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
339 ,p_number_of_requirements IN NUMBER := 1
340 ,p_api_version IN NUMBER := 1.0
341 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
342 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
343 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
344 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
345 -- 5130421 Begin
346 ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
347 ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
348 ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
349 ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
350 ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
351 ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
352 ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
353 ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
354 ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
355 -- 5130421 End
356 ,x_new_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895
357 ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
358 ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
359 ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
360 ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
361 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
362 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
363 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
364 );
365
366
367 -- ----------------------------------------------------------------------------
368 -- |----------------------------<Create_Assignment>----------------------------|
369 -- ----------------------------------------------------------------------------
370 --
371 -- {Start Of Comments}
372 --
373 -- Description:
374 -- Creates or validates for creation of a requirement or an assignment record and all of its detail records.
375 -- Prerequisites:
376 --
377 -- In Parameters:
378 -- Name Reqd Type Description
379 -- p_assignment_rec Y Assignment_Rec_Type A record type defined in this package, use to hold
380 -- information concerning the requirment/assignment to be
381 -- created.
382 -- p_asgn_creation_mode VARCHAR2 Indicates whether the assignment creation is FULL or
383 -- PARTIAL. Defaults to 'FULL'
384 -- p_project_name X VARCHAR2 Required if p_project_number and p_project_id are null.
385 -- p_project_number X VARCHAR2 Required if p_project_id and p_project_name are null.
386 -- p_resource_name X VARCHAR2 Required for an assignment and if p_resource_source_id is null
387 -- p_resource_source_id X NUMBER Person ID used by HR, used to staff an assignment.
388 -- Required for an assignment
389 -- p_project_subteam_name VARCHAR2 Name of the subteam
390 -- p_project_subteam_id NUMBER Identifier of the subteam
391 -- p_project_status_name X VARCHAR2 Required if p_project_status_code is null.
392 -- p_project_role_name X VARCHAR2 Required if p_project_role_name is null.
393 -- p_location_city VARCHAR2 name of the city where the job is carried out.
394 -- p_location_region VARCHAR2 name of the region where the job is carried out.
395 -- p_location_country_name VARCHAR2 name of the country where the job is carried out.
396 -- p_location_country_code VARCHAR2 code of the country where the job is carried out.
397 -- p_calendar_name X VARCHAR2 Required if p_calendar_id is null.
398 -- p_work_type_name X VARCHAR2 Required if p_work_type_id is null.
399 -- p_api_version VARCHAR2 A NO Null field, defaults to '1.0'
400 -- p_init_msg_list VARCHAR2 'T' => Initialize message stack
401 -- 'F' => append to exisiting message stack
402 -- p_commit VARCHAR2 'F' => calling program does the database commit.
403 -- 'T' => This API does the database commit
404 -- p_validate_only VARCHAR2 'T' => perform validation only
405 -- 'F' => perform validation and DML
406 -- p_max_msg_count NUMBER Optional. Indicates the maximum number of messages that can
407 -- be put on the message stack.
408 --Out Parameters:
409 --
410 -- The api will set the following out parameters:
411 --
412 -- Name Type Description
413 --
414 -- x_new_assignment_id NUMBER System generated id of the requirement/assignment
415 -- x_assignment_number NUMBER System generated number of the requirement/assignment
416 -- x_assignment_row_id ROWID requirement/assignment row id
417 -- x_resource_id NUMBER Identifier of the Project resource, it is null for a requirement
418 -- x_wf_type VARCHAR2 Type of the workflow that can be launched during an assignment
419 -- x_wf_item_type VARCHAR2 Item Type of the workflow during an assignment
420 -- x_wf_process VARCHAR2 Workflow process during an assignment
421 -- x_return_status VARCHAR2 Return Status: 'S' => Successful
422 -- 'E' => Error occured.
423 -- 'U' => Unexpected error occured.
424 -- x_msg_count NUMBER Number of error count.
425 -- x_msg_data VARCHAR2 If only one error occurs, this parameter will contain the error message.
426 --
427 -- Access Status:
428 -- Public.
429 --
430 -- {End Of Comments}
431 --
432 PROCEDURE Create_Assignment
433 ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
434 ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
435 -- ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
436 ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
437 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
438 ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
439 ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
440 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
441 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
442 ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
443 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
444 ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
445 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
446 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
447 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
448 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
449 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
450 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
451 ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
452 ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
453 ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
454 ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
455 ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
456 ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
457 ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
458 ,p_number_of_requirements IN NUMBER := 1
459 ,p_api_version IN NUMBER := 1.0
460 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
461 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
462 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
463 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
464 ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
465 ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
466 ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
467 ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
468 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
469 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
470 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
471 );
472
473 -- ----------------------------------------------------------------------------
474 -- |----------------------------<Exec_Create_Assign_With_Def>----------------------------|
475 -- ----------------------------------------------------------------------------
476 --
477 -- {Start Of Comments}
478 --
479 -- Description:
480 -- Assign defaults from the role to the composite record, then call Create_Assign_With_Def with the record
481 -- to create a requirement or an assignment using scalar values passed in and the defaults from the role.
482 -- Prerequisites:
483 --
484 -- In Parameters:
485 -- Name Reqd Type Description
486 --
487 -- p_asgn_creation_mode VARCHAR2 Indicates whether the assignment creation is FULL or
488 -- PARTIAL. Defaults to 'FULL'
489 -- p_role_name X VARCHAR2 Required if p_project_role_id is null.
490 -- p_assignment_type Y VARCHAR2 Indicates the type of the object for which status is shown.
491 -- 'OPEN_ASSIGNMENT' => Requirement
492 -- 'STAFFED_ASSIGNMENT'=> Assignment/Project Assignment
493 -- 'STAFFED_ADMIN_ASSIGNMENT' => Administrative Assignment
494 -- p_multiple_status_flag Y VARCHAR2 Indicates whether the underlying schedule for the Assignment
495 -- have more than one statuses. For requirement, use 'N'
496 -- p_project_id X NUMBER The identifier of the project to which this record belongs
497 -- This is mandatory if p_project_number is null.
498 -- p_project_name X VARCHAR2 Required if p_project_number and p_project_id are null.
499 -- p_project_number X VARCHAR2 Required if p_project_id and p_project_name are null.
500 -- p_project_role_id X NUMBER Identifier of the project role for the record.
501 -- This is mandatory if p_role_name is null.
502 -- p_resource_id NUMBER Identifier of the project resource.
503 -- p_project_party_id NUMBER The identifier of the project party on an assignment.
504 -- p_start_date Y DATE Start date of the requirement/assignment
505 -- p_end_date Y DATE End date of the requirement/assignment.
506 -- p_resource_name X VARCHAR2 Required for an assignment and if p_resource_source_id is null
507 -- p_resource_source_id X NUMBER Person ID used by HR, used to staff an assignment.
508 -- Required for an assignment
509 -- p_init_msg_list VARCHAR2 'T' => Initialize message stack
510 -- 'F' => append to exisiting message stack
511 -- p_commit VARCHAR2 'F' => calling program does the database commit.
512 -- 'T' => This API does the database commit
513 -- p_validate_only VARCHAR2 'T' => perform validation only
514 -- 'F' => perform validation and DML
515 -- p_max_msg_count NUMBER Optional. Indicates the maximum number of messages that can
516 -- be put on the message stack.
517 --Out Parameters:
518 --
519 -- The api will set the following out parameters:
520 --
521 -- Name Type Description
522 --
523 -- x_new_assignment_id NUMBER System generated id of the requirement/assignment
524 -- x_assignment_number NUMBER System generated number of the requirement/assignment
525 -- x_assignment_row_id ROWID requirement/assignment row id
526 -- x_resource_id NUMBER Identifier of the Project resource, it is null for a requirement
527 -- x_wf_type VARCHAR2 Type of the workflow that can be launched during an assignment
528 -- x_wf_item_type VARCHAR2 Item Type of the workflow during an assignment
529 -- x_wf_process VARCHAR2 Workflow process during an assignment
530 -- x_return_status VARCHAR2 Return Status: 'S' => Successful
531 -- 'E' => Error occured.
532 -- 'U' => Unexpected error occured.
533 -- x_msg_count NUMBER Number of error count.
534 -- x_msg_data VARCHAR2 If only one error occurs, this parameter will contain the error message.
535 --
536 -- Access Status:
537 -- Public.
538 --
539 -- {End Of Comments}
540 --
541 PROCEDURE Exec_Create_Assign_With_Def
542 ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
543 ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
544 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
545 ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := 'N'
546 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
547 ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
548 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
549 ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
550 ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
551 ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
552 ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
553 ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
554 ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
555 ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
556 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
557 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
558 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
559 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
560 ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
561 ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
562 ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
563 -- ,x_wf_type OUT VARCHAR2
564 -- ,x_wf_item_type OUT VARCHAR2
565 -- ,x_wf_process OUT VARCHAR2
566 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
567 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
568 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
569 );
570
571
572 -- ----------------------------------------------------------------------------
573 -- |----------------------------< Create_Assign_With_Def>----------------------|
574 -- ----------------------------------------------------------------------------
575 --
576 -- {Start Of Comments}
577 --
578 -- Description:
579 -- Create a requirement or an assignment using the composite record passed in which contains role defaults and
580 -- additional scalar values.
581 -- Prerequisites:
582 --
583 -- In Parameters:
584 -- Name Reqd Type Description
585 -- p_assignment_rec Y Assignment_Rec_Type A record type defined in this package, use to hold
586 -- information concerning the requirment/assignment to be
587 -- created.
588 -- p_role_name X VARCHAR2 Required if p_project_role_id is null.
589 -- p_asgn_creation_mode VARCHAR2 Indicates whether the assignment creation is FULL or
590 -- PARTIAL. Defaults to 'FULL'
591 -- p_project_name X VARCHAR2 Required if p_project_number and p_project_id are null.
592 -- p_project_number X VARCHAR2 Required if p_project_id and p_project_name are null.
593 -- p_resource_name X VARCHAR2 Required for an assignment and if p_resource_source_id is null
594 -- p_resource_source_id X NUMBER Person ID used by HR, used to staff an assignment.
595 -- Required for an assignment
596 -- p_api_version VARCHAR2 A NO Null field, defaults to '1.0'
597 -- p_init_msg_list VARCHAR2 'T' => Initialize message stack
598 -- 'F' => append to exisiting message stack
599 -- p_commit VARCHAR2 'F' => calling program does the database commit.
600 -- 'T' => This API does the database commit
601 -- p_validate_only VARCHAR2 'T' => perform validation only
602 -- 'F' => perform validation and DML
603 -- p_max_msg_count NUMBER Optional. Indicates the maximum number of messages that can
604 -- be put on the message stack.
605 --Out Parameters:
606 --
607 -- The api will set the following out parameters:
608 --
609 -- Name Type Description
610 --
611 -- x_new_assignment_id NUMBER System generated id of the requirement/assignment
612 -- x_assignment_number NUMBER System generated number of the requirement/assignment
613 -- x_assignment_row_id ROWID requirement/assignment row id
614 -- x_resource_id NUMBER Identifier of the Project resource, it is null for a requirement
615 -- x_wf_type VARCHAR2 Type of the workflow that can be launched during an assignment
616 -- x_wf_item_type VARCHAR2 Item Type of the workflow during an assignment
617 -- x_wf_process VARCHAR2 Workflow process during an assignment
618 -- x_return_status VARCHAR2 Return Status: 'S' => Successful
619 -- 'E' => Error occured.
620 -- 'U' => Unexpected error occured.
621 -- x_msg_count NUMBER Number of error count.
622 -- x_msg_data VARCHAR2 If only one error occurs, this parameter will contain the error message.
623 --
624 -- Access Status:
625 -- Public.
626 --
627 -- {End Of Comments}
628 --
629 PROCEDURE Create_Assign_With_Def
630 ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
631 ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
632 ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
633 ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
634 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
635 ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
636 ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
637 ,p_api_version IN NUMBER := 1.0
638 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
639 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
640 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
641 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
642 ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
643 ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
644 ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
645 -- ,x_new_unfilled_assignment_id OUT pa_project_assignments.assignment_id%TYPE
646 -- ,x_wf_type OUT VARCHAR2
647 -- ,x_wf_item_type OUT VARCHAR2
648 -- ,x_wf_process OUT VARCHAR2
649 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
650 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
651 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
652 );
653
654 -- ----------------------------------------------------------------------------
655 -- |---------------------<Execute_Staff_Assign_From_Open>----------------------|
656 -- ----------------------------------------------------------------------------
657 --
658 -- {Start Of Comments}
659 --
660 -- Description:
661 -- Create an assignment on top of a requirement by assigning resource to the requirement. Staff_Assign_From_Open
662 -- is called to create the new assignment using defaults from the exisiting requirement and additional scalar
663 -- values (such as resource being assigned, start date and end date).
664 --
665 -- Prerequisites:
666 --
667 -- In Parameters:
668 -- Name Reqd Type Description
669 -- p_asgn_creation_mode VARCHAR2 Indicates whether the assignment creation is FULL or
670 -- PARTIAL.
671 -- p_record_version_number Y NUMBER A number used to keep track how many updates have been done
672 -- on this record. Used to avoid overwrite the latest version
673 -- of the record.
674 -- p_multiple_status_flag Y VARCHAR2 Indicates whether the underlying schedule for the Assignment
675 -- have more than one statuses. For requirement, use 'N'
676 -- p_assignment_status_code X VARCHAR2 Status code for the assignment,required if status_name is null
677 -- p_assignment_status_name X VARCHAR2 Status name for the assignment,required if status_code is null
678 -- p_unfilled_assign_status_code VARCHAR2 In the case of an partial assignment, this is the status code
679 -- for the newly created requirement of the remaining duration.
680 -- p_unfilled_assign_status_name VARCHAR2 Can be used in place of p_unfilled_assign_status_code.
681 -- p_resource_id NUMBER Identifier of the project resource.
682 -- p_project_party_id NUMBER The identifier of the project party on an assignment.
683 -- p_start_date Y DATE Start date of the requirement/assignment
684 -- p_end_date Y DATE End date of the requirement/assignment.
685 -- p_source_assignment_id Y NUMBER The identifier of the source requirement where the resource is
686 -- being assigned to.
687 -- p_resource_name X VARCHAR2 Required for an assignment and if p_resource_source_id is null
688 -- p_resource_source_id X NUMBER Person ID used by HR, used to staff an assignment.
689 -- Required for an assignment
690 -- p_api_version VARCHAR2 A NO Null field, defaults to '1.0'
691 -- p_init_msg_list VARCHAR2 'T' => Initialize message stack
692 -- 'F' => append to exisiting message stack
693 -- p_commit VARCHAR2 'F' => calling program does the database commit.
694 -- 'T' => This API does the database commit
695 -- p_validate_only VARCHAR2 'T' => perform validation only
696 -- 'F' => perform validation and DML
697 -- p_max_msg_count NUMBER Optional. Indicates the maximum number of messages that can
698 -- be put on the message stack.
699 --Out Parameters:
700 --
701 -- The api will set the following out parameters:
702 --
703 -- Name Type Description
704 --
705 -- x_new_assignment_id NUMBER System generated id of the requirement/assignment
706 -- x_assignment_number NUMBER System generated number of the requirement/assignment
707 -- x_assignment_row_id ROWID requirement/assignment row id
708 -- x_resource_id NUMBER Identifier of the Project resource, it is null for a requirement
709 -- x_wf_type VARCHAR2 Type of the workflow that can be launched during an assignment
710 -- x_wf_item_type VARCHAR2 Item Type of the workflow during an assignment
711 -- x_wf_process VARCHAR2 Workflow process during an assignment
712 -- x_return_status VARCHAR2 Return Status: 'S' => Successful
713 -- 'E' => Error occured.
714 -- 'U' => Unexpected error occured.
715 -- x_msg_count NUMBER Number of error count.
716 -- x_msg_data VARCHAR2 If only one error occurs, this parameter will contain the error message.
717 --
718 -- Access Status:
719 -- Public.
720 --
721 -- {End Of Comments}
722 --
723 PROCEDURE Execute_Staff_Assign_From_Open
724 ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
725 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
726 ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
727 ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
728 ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
729 ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
730 ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
731 ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
732 ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
733 ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
734 ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
735 ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
736 ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
737 ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
738 ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
739 ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
740 ,p_api_version IN NUMBER := 1.0
741 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
742 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
743 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
744 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
745 ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
746 ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
747 ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
748 ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
749 -- ,x_wf_type OUT VARCHAR2
750 -- ,x_wf_item_type OUT VARCHAR2
751 -- ,x_wf_process OUT VARCHAR2
752 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
753 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
754 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
755 );
756
757
758 -- ----------------------------------------------------------------------------
759 -- |----------------------------<Staff_Assign_From_Open>----------------------|
760 -- ----------------------------------------------------------------------------
761 --
762 -- {Start Of Comments}
763 --
764 -- Description:
765 -- Create an assignment on top of an requirement by assigning a resource to the requirement. If it is an partial
766 -- assignment, Create_Assignment is called to create a new requirement for the remaining duration if status code/
767 -- name is given for the unfilled duration.
768 -- Prerequisites:
769 --
770 -- In Parameters:
771 -- Name Reqd Type Description
772 -- p_assignment_rec Y Assignment_Rec_Type A record type defined in this package, use to hold
773 -- information concerning the requirment/assignment to be
774 -- created.
775 -- p_asgn_creation_mode VARCHAR2 Indicates whether the assignment creation is FULL or
776 -- PARTIAL.
777 -- p_unfilled_assign_status_code VARCHAR2 In the case of an partial assignment, this is the status code
778 -- for the newly created requirement of the remaining duration.
779 -- p_unfilled_assign_status_name VARCHAR2 Can be used in place of p_unfilled_assign_status_code.
780 -- p_resource_name X VARCHAR2 Required for an assignment and if p_resource_source_id is null
781 -- p_resource_source_id X NUMBER Person ID used by HR, used to staff an assignment.
782 -- Required for an assignment
783 -- p_assignment_status_name X VARCHAR2 Status name for the assignment,required if status_code is null
784 -- p_api_version VARCHAR2 A NO Null field, defaults to '1.0'
785 -- p_init_msg_list VARCHAR2 'T' => Initialize message stack
786 -- 'F' => append to exisiting message stack
787 -- p_commit VARCHAR2 'F' => calling program does the database commit.
788 -- 'T' => This API does the database commit
789 -- p_validate_only VARCHAR2 'T' => perform validation only
790 -- 'F' => perform validation and DML
791 -- p_max_msg_count NUMBER Optional. Indicates the maximum number of messages that can
792 -- be put on the message stack.
793 --Out Parameters:
794 --
795 -- The api will set the following out parameters:
796 --
797 -- Name Type Description
798 --
799 -- x_new_assignment_id NUMBER System generated id of the requirement/assignment
800 -- x_assignment_number NUMBER System generated number of the requirement/assignment
801 -- x_assignment_row_id ROWID requirement/assignment row id
802 -- x_resource_id NUMBER Identifier of the Project resource, it is null for a requirement
803 -- x_wf_type VARCHAR2 Type of the workflow that can be launched during an assignment
804 -- x_wf_item_type VARCHAR2 Item Type of the workflow during an assignment
805 -- x_wf_process VARCHAR2 Workflow process during an assignment
806 -- x_return_status VARCHAR2 Return Status: 'S' => Successful
807 -- 'E' => Error occured.
808 -- 'U' => Unexpected error occured.
809 -- x_msg_count NUMBER Number of error count.
810 -- x_msg_data VARCHAR2 If only one error occurs, this parameter will contain the error message.
811 --
812 -- Access Status:
813 -- Public.
814 --
815 -- {End Of Comments}
816 --
817 PROCEDURE Staff_Assign_From_Open
818 ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
819 ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
820 ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
821 ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
822 ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
823 ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
824 ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
825 ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
826 ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
827 ,p_api_version IN NUMBER := 1.0
828 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
829 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
830 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
831 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
832 ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
833 ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
834 ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
835 --,x_new_unfilled_assignment_id OUT pa_project_assignments.assignment_id%TYPE
836 ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
837 -- ,x_wf_type OUT VARCHAR2
838 -- ,x_wf_item_type OUT VARCHAR2
839 -- ,x_wf_process OUT VARCHAR2
840 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
841 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
842 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
843 );
844
845 -- ----------------------------------------------------------------------------
846 -- |--------------------------<Execute_Update_Assignment>----------------------|
847 -- ----------------------------------------------------------------------------
848 --
849 -- {Start Of Comments}
850 --
851 -- Description:
852 -- This API updates a requirement or an assignment from the scalar values passed to it. It loads the composite
853 -- record with scalar values and calls Update_Assignment.
854 -- Prerequisites:
855 --
856 -- In Parameters:
857 -- Name Reqd Type Description
858 -- p_assignment_row_id ROWID Record row_id
859 -- p_assignment_id X NUMBER System generated number that uniquely identifiers the
860 -- requirement/assignment. Required if p_assignment_name is
861 -- null.
862 -- p_record_version_number Y NUMBER System generated version of row. Increments by one with each
863 -- update.
864 -- p_assignment_name X VARCHAR2 Required if p_assignment_id is null.
865 -- p_assignment_type Y VARCHAR2 Indicates the type of the object for which status is shown.
866 -- 'OPEN_ASSIGNMENT' => Requirement
867 -- 'STAFFED_ASSIGNMENT'=> Assignment/Project Assignment
868 -- 'STAFFED_ADMIN_ASSIGNMENT' => Administrative Assignment
869 -- p_multiple_status_flag Y VARCHAR2 Indicates whether the underlying schedule for the Assignment
870 -- have more than one statuses. For requirement, use 'N'
871 -- p_project_id X NUMBER The identifier of the project to which this record belongs
872 -- This is mandatory if p_project_number is null.
873 -- p_project_role_id NUMBER Identifier of the project role for the record.
874 -- This is mandatory if project_role_name is null.
875 -- p_resource_id NUMBER Identifier of the project resource.
876 -- p_project_party_id NUMBER The identifier of the project party on an assignment.
877 -- p_project_subteam_id NUMBER The identifier for the project subteam to which this
878 -- requirement/assignment belongs.
879 -- p_project_subteam_party_id NUMBER The identifier for the intermediate project subteam party
880 -- that connects between the project subteam and the
881 -- requirement/assignment.
882 -- p_description VARCHAR2 The free text description of the record.
883 -- p_assignment_effort NUMBER Total number of hours of the requirement/assignment
884 -- p_extension_possible VARCHAR2 Indicates whether it is possible to extend the
885 -- requirement/assignment.
886 -- p_source_assignment_id NUMBER Identifies the assignment from which this assignment record
887 -- is originated.
888 -- p_min_resource_job_level NUMBER Indicates the minimum acceptable job level for a requirement.
889 -- p_max_resource_job_level NUMBER Indidates the maximum acceptable job level for a requirement.
890 -- p_assignment_number NUMBER A reference number that uniquely identifies a requirement.
891 -- p_additional_information VARCHAR2 Free text for additional information on a record.
892 -- p_work_type_id NUMBER Identifies the type of work being carried out. Gets defaulted
893 -- from project setup for open assignment and from staffed
894 -- assignments not created from an open assignment.Mandatory
895 -- if work_type_name is null
896 -- p_location_id NUMBER Identifier of the location of the assignment. For new
897 -- assignments this column gets default value from the project
898 -- setup.
899 -- p_revenue_currency_code VARCHAR2 Currency code of the revenue
900 -- p_revenue_bill_rate NUMBER Bill rate of the revenue
901 -- p_expense_owner VARCHAR2 Owner of the expense
902 -- p_expense_limit NUMBER The maximum amount that expense owner is willing to pay.
903 -- p_expense_limit_currency_code VARCHAR2 Currency code of the expense limit.
904 -- p_fcst_tp_amount_type VARCHAR2
905 -- p_fcst_job_id NUMBER
906 -- p_project_number X VARCHAR2 Required if p_project_id is null.
907 -- p_resource_name VARCHAR2 Required for an assignment and if p_resource_source_id is null
908 -- p_resource_source_id NUMBER Person ID used by HR, used to staff an assignment.
909 -- Required for an assignment
910 -- p_resource_id NUMBER Identifier of the project resource.
911 -- p_project_subteam_name VARCHAR2
912 -- p_project_role_name VARCHAR2 Required if p_project_role_id is null.
913 -- p_location_city VARCHAR2
914 -- p_location_region VARCHAR2
915 -- p_location_country_name VARCHAR2
916 -- p_location_country_code VARCHAR2
917 -- p_work_type_name VARCHAR2 Required if p_work_type_id is null.
918 -- p_attribute_category VARCHAR2 Descriptive flexfield context field
919 -- p_attribute1 VARCHAR2 Descriptive flexfield segment
920 -- p_attribute2 VARCHAR2
921 -- p_attribute3 VARCHAR2
922 -- p_attribute4 VARCHAR2
923 -- p_attribute5 VARCHAR2
924 -- p_attribute6 VARCHAR2
925 -- p_attribute7 VARCHAR2
926 -- p_attribute8 VARCHAR2
927 -- p_attribute9 VARCHAR2
928 -- p_attribute10 VARCHAR2
929 -- p_attribute11 VARCHAR2
930 -- p_attribute12 VARCHAR2
931 -- p_attribute13 VARCHAR2
932 -- p_attribute14 VARCHAR2
933 -- p_attribute15 VARCHAR2
934 -- p_api_version VARCHAR2 A NO Null field, defaults to '1.0'
935 -- p_init_msg_list VARCHAR2 'T' => Initialize message stack
936 -- 'F' => append to exisiting message stack
937 -- p_commit VARCHAR2 'F' => calling program does the database commit.
938 -- 'T' => This API does the database commit
939 -- p_validate_only VARCHAR2 'T' => perform validation only
940 -- 'F' => perform validation and DML
941 -- p_max_msg_count NUMBER Optional. Indicates the maximum number of messages that can
942 -- be put on the message stack.
943 -- Out Parameters:
944 --
945 -- The api will set the following out parameters:
946 --
947 -- Name Type Description
948 --
949 -- x_return_status VARCHAR2 Return Status: 'S' => Successful
950 -- 'E' => Error occured.
951 -- 'U' => Unexpected error occured.
952 -- x_msg_count NUMBER Number of error count.
953 -- x_msg_data VARCHAR2 If only one error occurs, this parameter will contain the error message.
954 --
955 -- Access Status:
956 -- Public.
957 --
958 -- {End Of Comments}
959 --
960 PROCEDURE Execute_Update_Assignment
961 ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
962 ,p_assignment_row_id IN ROWID := NULL
963 ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
964 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
965 ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
966 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
967 ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
968 ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
969 ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
970 ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
971 ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
972 ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
973 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
974 ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
975 ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
976 ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
977 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
978 ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
979 ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
980 ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
981 ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
982 ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
983 ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
984 ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
985 ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
986 ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
987 ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
988 ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
989 ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
990 ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
991 ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
992 ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
993 ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
994 ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
995 ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
996 ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
997 ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
998 ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
999 ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1000 ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1001 ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1002 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*2386679*/
1003 ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1004 ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1005 ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1006 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1007 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1008 ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1009 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1010 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1011 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1012 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1013 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1014 ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
1015 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1016 ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1017 ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1018 ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1019 ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1020 ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1021 ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1022 ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
1023 ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
1024 ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
1025 ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1026 ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
1027 ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
1028 ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
1029 ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1030 ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
1031 ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
1032 ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
1033 ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
1034 ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
1035 ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2531267
1036 ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2531267
1037 ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
1038 ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
1039 ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
1040 ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
1041 ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1042 ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1043 ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM
1044 ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
1045 ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
1046 ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
1047 ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
1048 ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
1049 ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
1050 ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
1051 ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
1052 ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
1053 ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
1054 ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
1055 ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
1056 ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
1057 ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
1058 ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
1059 ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
1060 ,p_api_version IN NUMBER := 1.0
1061 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1062 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1063 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1064 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1065 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1066 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1067 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1068 );
1069
1070
1071 -- ----------------------------------------------------------------------------
1072 -- |-------------------------------<Update_Assignment>-------------------------|
1073 -- ----------------------------------------------------------------------------
1074 --
1075 -- {Start Of Comments}
1076 --
1077 -- Description:
1078 -- Updates a requirement/assignment with the scalar values and a given composite record containing information for
1079 -- the update.
1080 --
1081 --
1082 -- Prerequisites:
1083 --
1084 -- In Parameters:
1085 -- Name Reqd Type Description
1086 -- p_assignment_rec Y Assignment_Rec_Type A record type defined in this package, use to hold
1087 -- information concerning the requirment/assignment to be
1088 -- created.
1089
1090 -- p_project_number X VARCHAR2 Required if project_id is null.
1091 -- p_resource_name VARCHAR2 Required for an assignment and if p_resource_source_id is null
1092 -- p_resource_source_id NUMBER Person ID used by HR, used to staff an assignment.
1093 -- Required for an assignment
1094 -- p_resource_id NUMBER Identifier of the project resource.
1095 -- p_project_subteam_id NUMBER The identifier for the project subteam to which this
1096 -- requirement/assignment belongs.
1097 -- p_project_subteam_party_id NUMBER The identifier for the intermediate project subteam party
1098 -- that connects between the project subteam and the
1099 -- requirement/assignment.
1100 -- p_project_subteam_name VARCHAR2
1101 -- p_project_role_name VARCHAR2
1102 -- p_location_city VARCHAR2
1103 -- p_location_region VARCHAR2
1104 -- p_location_country_name VARCHAR2
1105 -- p_location_country_code VARCHAR2
1106 -- p_work_type_name VARCHAR2
1107 -- p_api_version VARCHAR2 A NO Null field, defaults to '1.0'
1108 -- p_init_msg_list VARCHAR2 'T' => Initialize message stack
1109 -- 'F' => append to exisiting message stack
1110 -- p_commit VARCHAR2 'F' => calling program does the database commit.
1111 -- 'T' => This API does the database commit
1112 -- p_validate_only VARCHAR2 'T' => perform validation only
1113 -- 'F' => perform validation and DML
1114 -- p_max_msg_count NUMBER Optional. Indicates the maximum number of messages that can
1115 -- be put on the message stack.
1116 -- Out Parameters:
1117 --
1118 -- The api will set the following out parameters:
1119 --
1120 -- Name Type Description
1121 --
1122 -- x_return_status VARCHAR2 Return Status: 'S' => Successful
1123 -- 'E' => Error occured.
1124 -- 'U' => Unexpected error occured.
1125 -- x_msg_count NUMBER Number of error count.
1126 -- x_msg_data VARCHAR2 If only one error occurs, this parameter will contain the error message.
1127 --
1128 -- Access Status:
1129 -- Public.
1130 --
1131 -- {End Of Comments}
1132 --
1133 PROCEDURE Update_Assignment
1134 ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1135 ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1136 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*bug2386679*/
1137 ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1138 ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1139 ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1140 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1141 ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1142 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1143 ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
1144 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1145 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1146 ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1147 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1148 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1149 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1150 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1151 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1152 ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1153 ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1154 ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1155 ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1156 ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1157 ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
1158 ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1159 ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1160 ,p_api_version IN NUMBER := 1
1161 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1162 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1163 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1164 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1165 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1166 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1167 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1168 );
1169
1170 -- ----------------------------------------------------------------------------
1171 -- |--------------------------<Delete_Assignment>----------------------|
1172 -- ----------------------------------------------------------------------------
1173 --
1174 -- {Start Of Comments}
1175 --
1176 -- Description:
1177 -- This API updates a requirement or an assignment from the scalar values passed to it. It loads the composite
1178 -- record with scalar values and calls Update_Assignment.
1179 -- Prerequisites:
1180 --
1181 -- In Parameters:
1182 -- Name Reqd Type Description
1183 -- p_assignment_row_id ROWID Record row_id
1184 -- p_assignment_id X NUMBER System generated number that uniquely identifiers the
1185 -- requirement/assignment. Required if p_assignment_name is
1186 -- null.
1187 -- p_record_version_number Y NUMBER System generated version of row. Increments by one with each
1188 -- update.
1189 -- p_assignment_type Y VARCHAR2 Indicates the type of the object for which status is shown.
1190 -- 'OPEN_ASSIGNMENT' => Requirement
1191 -- 'STAFFED_ASSIGNMENT'=> Assignment/Project Assignment
1192 -- 'STAFFED_ADMIN_ASSIGNMENT' => Administrative Assignment
1193 -- p_assignment_number NUMBER A reference number that uniquely identifies a requirement.
1194 -- p_calling_module VARCHAR2 Indicates which module is calling this delete requirement or
1195 -- assignment procedure.
1196 -- p_api_version VARCHAR2 A NO Null field, defaults to '1.0'
1197 -- p_init_msg_list VARCHAR2 'T' => Initialize message stack
1198 -- 'F' => append to exisiting message stack
1199 -- p_commit VARCHAR2 'F' => calling program does the database commit.
1200 -- 'T' => This API does the database commit
1201 -- p_validate_only VARCHAR2 'T' => perform validation only
1202 -- 'F' => perform validation and DML
1203 -- p_max_msg_count NUMBER Optional. Indicates the maximum number of messages that can
1204 -- be put on the message stack.
1205 -- Out Parameters:
1206 --
1207 -- The api will set the following out parameters:
1208 --
1209 -- Name Type Description
1210 --
1211 -- x_return_status VARCHAR2 Return Status: 'S' => Successful
1212 -- 'E' => Error occured.
1213 -- 'U' => Unexpected error occured.
1214 -- x_msg_count NUMBER Number of error count.
1215 -- x_msg_data VARCHAR2 If only one error occurs, this parameter will contain the error message.
1216 --
1217 -- Access Status:
1218 -- Public.
1219 --
1220 -- {End Of Comments}
1221 --
1222 PROCEDURE Delete_Assignment
1223 ( p_assignment_row_id IN ROWID := NULL
1224 ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1225 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1226 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1227 ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
1228 ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
1229 ,p_api_version IN NUMBER := 1.0
1230 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1231 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1232 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1233 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1234 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1235 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1236 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1237 );
1238
1239 -- ----------------------------------------------------------------------------
1240 -- |--------------------------<Copy_Team_Role>----------------------|
1241 -- ----------------------------------------------------------------------------
1242 --
1243 -- {Start Of Comments}
1244 --
1245 -- Description:
1246 -- This API creates a new requirement from an existing requirement or assignment.
1247 -- Prerequisites:
1248 --
1249 -- In Parameters:
1250 -- Name Reqd Type Description
1251 -- p_assignment_id X NUMBER System generated number that uniquely identifiers the
1252 -- requirement/assignment.
1253 -- assignment procedure.
1254 -- p_api_version VARCHAR2 A NOT Null field, defaults to '1.0'
1255 -- p_init_msg_list VARCHAR2 'T' => Initialize message stack
1256 -- 'F' => append to exisiting message stack
1257 -- p_commit VARCHAR2 'F' => calling program does the database commit.
1258 -- 'T' => This API does the database commit
1259 -- p_validate_only VARCHAR2 'T' => perform validation only
1260 -- 'F' => perform validation and DML
1261 -- p_max_msg_count NUMBER Optional. Indicates the maximum number of messages that can
1262 -- be put on the message stack.
1263 -- Out Parameters:
1264 --
1265 -- The api will set the following out parameters:
1266 --
1267 -- Name Type Description
1268 --
1269 -- x_new_assignment_id NUMBER System generated id of the requirement/assignment
1270 -- x_assignment_number NUMBER System generated number of the requirement/assignment
1271 -- x_assignment_row_id ROWID requirement/assignment row id
1272 -- x_return_status VARCHAR2 Return Status: 'S' => Successful
1273 -- 'E' => Error occured.
1274 -- 'U' => Unexpected error occured.
1275 -- x_msg_count NUMBER Number of error count.
1276 -- x_msg_data VARCHAR2 If only one error occurs, this parameter will contain the error message.
1277 --
1278 -- Access Status:
1279 -- Public.
1280 --
1281 -- {End Of Comments}
1282 --
1283
1284 PROCEDURE Copy_Team_Role
1285 (p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1286 ,p_asgn_creation_mode IN VARCHAR2 := 'COPY'
1287 ,p_api_version IN NUMBER := 1.0 /*bug2386679*/
1288 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1289 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1290 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1291 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1292 ,x_new_assignment_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1293 ,x_assignment_number OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1294 ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
1295 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1296 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1297 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1298 );
1299
1300 PROCEDURE Mass_Exec_Create_Assignments
1301 ( p_asgn_creation_mode IN VARCHAR2
1302 ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
1303 ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1304 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1305 ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1306 ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
1307 ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1308 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1309 ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
1310 ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1311 ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
1312 ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
1313 ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1314 ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
1315 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1316 ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1317 ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1318 ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1319 ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
1320 ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1321 ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
1322 ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
1323 ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
1324 ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1325 ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1326 ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1327 ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
1328 ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
1329 ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
1330 ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1331 ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1332 ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
1333 ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1334 ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
1335 ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
1336 ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
1337 ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1338 ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1339 ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1340 ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
1341 ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
1342 ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
1343 ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
1344 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
1345 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1346 ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1347 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1348 ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1349 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1350 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1351 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1352 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1353 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1354 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1355 ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1356 ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1357 ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1358 ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1359 ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
1360 ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
1361 ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
1362 ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
1363 ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
1364 ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
1365 ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
1366 ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
1367 ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
1368 ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
1369 ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
1370 ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
1371 ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
1372 ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
1373 ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
1374 ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
1375 ,p_number_of_requirements IN NUMBER := 1
1376 ,p_api_version IN NUMBER := 1.0
1377 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1378 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1379 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1380 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1381 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1382 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1383 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1384 );
1385
1386
1387 PROCEDURE Mass_Create_Assignments
1388 ( p_asgn_creation_mode IN VARCHAR2
1389 ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
1390 ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1391 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1392 ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1393 ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
1394 ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1395 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1396 ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
1397 ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1398 ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
1399 ,p_resource_id_tbl IN system.pa_num_tbl_type
1400 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1401 ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1402 ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1403 ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1404 ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
1405 ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1406 ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
1407 ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
1408 ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
1409 ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1410 ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1411 ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1412 ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
1413 ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
1414 ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
1415 ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1416 ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1417 ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
1418 ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1419 ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
1420 ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
1421 ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
1422 ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1423 ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1424 ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1425 ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
1426 ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
1427 ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
1428 ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
1429 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
1430 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1431 ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1432 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1433 ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1434 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1435 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1436 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1437 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1438 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1439 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1440 ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1441 ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1442 ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1443 ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1444 ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
1445 ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
1446 ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
1447 ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
1448 ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
1449 ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
1450 ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
1451 ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
1452 ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
1453 ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
1454 ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
1455 ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
1456 ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
1457 ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
1458 ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
1459 ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
1460 ,p_number_of_requirements IN NUMBER := 1
1461 ,p_api_version IN NUMBER := 1.0
1462 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1463 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1464 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1465 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1466 ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619
1467 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1468 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1469 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1470 );
1471
1472
1473
1474 PROCEDURE Mass_Exec_Update_Assignments
1475 ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1476 ,p_assignment_id_tbl IN system.pa_num_tbl_type
1477 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1478 ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1479 ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1480 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1481 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1482 ,p_append_description_flag IN VARCHAR2 := 'N'
1483 ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1484 ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1485 ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
1486 ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
1487 ,p_append_information_flag IN VARCHAR2 := 'N'
1488 ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1489 ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1490 ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1491 ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1492 ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1493 ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
1494 ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1495 ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
1496 ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
1497 ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
1498 ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1499 ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1500 ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1501 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1502 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1503 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1504 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1505 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1506 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1507 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1508 ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1509 ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1510 ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1511 ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1512 ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1513 ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1514 ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
1515 ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
1516 ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
1517 ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1518 ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
1519 ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
1520 ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
1521 ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1522 ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
1523 ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
1524 ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1525 ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1526 ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
1527 ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
1528 ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
1529 ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
1530 ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
1531 ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
1532 ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
1533 ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
1534 ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
1535 ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
1536 ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
1537 ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
1538 ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
1539 ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
1540 ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
1541 ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
1542 ,p_api_version IN NUMBER := 1.0
1543 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1544 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1545 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1546 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1547 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1548 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1549 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1550 );
1551
1552
1553
1554 PROCEDURE Mass_Update_Assignments
1555 ( p_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1556 ,p_assignment_id_tbl IN system.pa_num_tbl_type
1557 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1558 ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1559 ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1560 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1561 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1562 ,p_append_description_flag IN VARCHAR2 := 'N'
1563 ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1564 ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1565 ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
1566 ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
1567 ,p_append_information_flag IN VARCHAR2 := 'N'
1568 ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1569 ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1570 ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1571 ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1572 ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1573 ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
1574 ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1575 ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
1576 ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
1577 ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
1578 ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1579 ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1580 ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1581 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1582 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1583 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1584 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1585 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1586 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1587 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1588 ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1589 ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1590 ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1591 ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1592 ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1593 ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1594 ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
1595 ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
1596 ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
1597 ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1598 ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
1599 ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
1600 ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
1601 ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1602 ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
1603 ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
1604 ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
1605 ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
1606 ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
1607 ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
1608 ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
1609 ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
1610 ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
1611 ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
1612 ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
1613 ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
1614 ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
1615 ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
1616 ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
1617 ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
1618 ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
1619 ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
1620 ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
1621 ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
1622 ,p_api_version IN NUMBER := 1.0
1623 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1624 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1625 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1626 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1627 ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619
1628 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1629 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1630 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1631 );
1632
1633
1634 PROCEDURE Execute_Update_Requirement
1635 ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1636 ,p_assignment_row_id IN ROWID := NULL
1637 ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1638 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1639 ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1640 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1641 ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1642 ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1643 ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
1644 ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1645 ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1646 ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1647 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1648 ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
1649 ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1650 ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
1651 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1652 ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
1653 ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1654 ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
1655 ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1656 ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
1657 ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
1658 ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
1659 ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
1660 ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1661 ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1662 ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1663 ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
1664 ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
1665 ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
1666 ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1667 ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1668 ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
1669 ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1670 ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
1671 ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
1672 ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
1673 ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1674 ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1675 ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1676 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
1677 ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1678 ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1679 ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1680 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1681 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1682 ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1683 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1684 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1685 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1686 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1687 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1688 ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
1689 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1690 ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1691 ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1692 ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1693 ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1694 ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1695 ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1696 ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
1697 ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
1698 ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
1699 ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1700 ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
1701 ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
1702 ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
1703 ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1704 ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
1705 ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
1706 ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
1707 ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
1708 ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
1709 ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938
1710 ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938
1711 ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
1712 ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
1713 ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
1714 ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
1715 ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1716 ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1717 ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
1718 ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
1719 ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
1720 ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
1721 ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
1722 ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
1723 ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
1724 ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
1725 ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
1726 ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
1727 ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
1728 ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
1729 ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
1730 ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
1731 ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
1732 ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
1733 ,p_api_version IN NUMBER := 1.0
1734 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1735 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1736 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1737 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1738 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1739 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1740 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1741 );
1742
1743
1744 PROCEDURE DELETE_PJR_TXNS
1745 (p_project_id IN pa_project_assignments.project_id%TYPE
1746 := FND_API.G_MISS_NUM
1747 ,p_calling_module IN VARCHAR2
1748 := FND_API.G_MISS_CHAR
1749 ,p_api_version IN NUMBER
1750 := 1.0
1751 ,p_init_msg_list IN VARCHAR2
1752 := FND_API.G_FALSE
1753 ,p_commit IN VARCHAR2
1754 := FND_API.G_FALSE
1755 ,p_validate_only IN VARCHAR2
1756 := FND_API.G_TRUE
1757 ,p_max_msg_count IN NUMBER
1758 := FND_API.G_MISS_NUM
1759 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1760 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1761 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1762 );
1763
1764 END pa_assignments_pub;