1 PACKAGE PA_ASSIGNMENT_APPROVAL_PUB AS
2 /*$Header: PARAAPBS.pls 120.1 2005/08/19 16:46:58 mwasowic noship $*/
3
4 --Global Constants for type of action that can be performed
5 g_approve_action CONSTANT VARCHAR2(7) := 'APPROVE';
6 g_reject_action CONSTANT VARCHAR2(7) := 'REJECT';
7 g_submit_action CONSTANT VARCHAR2(7) := 'SUBMIT';
8 g_revert_action CONSTANT VARCHAR2(7) := 'REVERT';
9 g_update_action CONSTANT VARCHAR2(7) := 'UPDATE';
10 g_cancel_action COnSTANT VARCHAR2(7) := 'CANCEL';
11
12
13 --Global Constants for assignment approval status_code
14 g_working CONSTANT VARCHAR2(24) := 'ASGMT_APPRVL_WORKING';
15 g_approved CONSTANT VARCHAR2(24) := 'ASGMT_APPRVL_APPROVED';
16 g_rejected CONSTANT VARCHAR2(24) := 'ASGMT_APPRVL_REJECTED';
17 g_submitted CONSTANT VARCHAR2(24) := 'ASGMT_APPRVL_SUBMITTED';
18 g_req_resub CONSTANT VARCHAR2(24) := 'ASGMT_APPRVL_REQ_RESUB';
19 g_canceled CONSTANT VARCHAR2(24) := 'ASGMT_APPRVL_CANCELED';
20
21 --Empty tables for mass assignment approval
22 prm_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
23 prm_empty_varchar2_1_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
24 prm_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
25 prm_empty_varchar2_240_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
26
27
28 --Record for the PL/SQL table to store approvers
29 TYPE Asgmt_Approvers_Rec_Type
30 IS RECORD
31 ( person_id NUMBER := FND_API.G_MISS_NUM
32 ,orders NUMBER := FND_API.G_MISS_NUM
33 ,approver_person_type VARCHAR2(100) := FND_API.G_MISS_CHAR
34 );
35
36
37 --Global PL/SQL table used to store approvers
38 TYPE Asgmt_Approvers_Tbl_Type IS TABLE OF Asgmt_Approvers_Rec_Type
39 INDEX BY BINARY_INTEGER;
40
41 --Global PL/SQL table variable declared
42 g_approver_tbl PA_ASSIGNMENT_APPROVAL_PUB.Asgmt_Approvers_Tbl_Type;
43
44
45
46 --
47 --Wrapper API to set approval status and determine which kind of workflow to launch. The API will only be called from
48 -- Submit for Approval Page, when the user hit Submit, Approve or Reject buttons.
49 --
50 --p_action_code allowed: 'APPROVE', 'SUBMIT', 'REJECT'
51 --
52 PROCEDURE Start_Assignment_Approvals
53 ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
54 ,p_new_assignment_flag IN VARCHAR2
55 ,p_action_code IN VARCHAR2
56 ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR
57 ,p_record_version_number IN NUMBER
58 ,p_apr_person_id IN NUMBER DEFAULT NULL
59 ,p_apr_person_name IN VARCHAR2 DEFAULT NULL
60 ,p_apr_person_type IN VARCHAR2 DEFAULT NULL
61 ,p_apr_person_order IN NUMBER DEFAULT NULL
62 ,p_apr_person_exclude IN VARCHAR2 DEFAULT NULL
63 ,p_check_overcommitment_flag IN VARCHAR2 := 'N'
64 ,p_conflict_group_id IN NUMBER DEFAULT NULL
65 ,p_resolve_con_action_code IN VARCHAR2 DEFAULT NULL
66 ,p_api_version IN NUMBER := 1.0
67 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
69 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
70 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
71 ,x_overcommitment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72 ,x_conflict_group_id OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
75 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76
77 );
78
79
80
81
82
83 --
84 --API used to revert the current record in pa_project_assignments table to the last approved record in history table.
85 --
86 PROCEDURE Revert_To_Last_Approved
87 ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
88 ,p_api_version IN NUMBER := 1.0
89 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
90 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
92 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
93 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
94 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
95 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96 );
97
98
99 --
100 -- This procedure populates the PA_ASGMT_CHANGED_ITEMS table with changes on the assignment if the
101 -- assignment has been previously approved (i.e. not a new assignment). It compares the record with
102 -- the last approved record, and stores those changed fields and their old and new values in the table.
103 -- Currently, this api is called by Single/Mass Submit for Approval
104 --
105 PROCEDURE Populate_Changed_Items_Table
106 ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
107 ,p_populate_mode IN VARCHAR2 := 'SAVED'
108 ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
109 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
110 ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
111 ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
112 ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
113 ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
114 ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
115 ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
116 ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
117 ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
118 ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
119 ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
120 ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
121 ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
122 ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
123 ,p_exception_type_code IN VARCHAR2 := NULL
124 ,p_start_date IN DATE := NULL
125 ,p_end_date IN DATE := NULL
126 ,p_requirement_status_code IN VARCHAR2 := NULL
127 ,p_assignment_status_code IN VARCHAR2 := NULL
128 ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
129 ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
130 ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
131 ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
132 ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
133 ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
134 ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
135 ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
136 ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
137 ,p_non_working_day_flag IN VARCHAR2 := 'N'
138 ,p_change_hours_type_code IN VARCHAR2 := NULL
139 ,p_hrs_per_day IN NUMBER := NULL
140 ,p_calendar_percent IN NUMBER := NULL
141 ,p_change_calendar_type_code IN VARCHAR2 := NULL
142 ,p_change_calendar_name IN VARCHAR2 := NULL
143 ,p_change_calendar_id IN NUMBER := NULL
144 ,p_duration_shift_type_code IN VARCHAR2 := NULL
145 ,p_duration_shift_unit_code IN VARCHAR2 := NULL
146 ,p_number_of_shift IN NUMBER := NULL
147 ,p_api_version IN NUMBER := 1.0
148 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
150 ,x_new_assignment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
151 ,x_approval_required_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
152 ,x_record_version_number OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
153 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
154 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
155 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
156
157
158 --
159 -- Procedure : Cancel_Assignment
160 -- Purpose : cancel an assignment and reopen the original requirement.
161 -- Parameters :
162 --
163 PROCEDURE Change_Assignment_Status
164 (
165 p_record_version_number IN Number ,
166 p_assignment_id IN Number ,
167 p_assignment_type IN Varchar2 ,
168 p_start_date IN date ,
169 p_end_date IN date ,
170 p_assignment_status_code IN Varchar2 := FND_API.G_MISS_CHAR,
171 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172 p_commit IN VARCHAR2 := FND_API.G_FALSE,
173 x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
174 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
175 x_msg_data OUT NOCOPY Varchar2 ); --File.Sql.39 bug 4440895
176
177
178 --
179 -- Procedure : Get_Current_Approver
180 -- Purpose : Get the approver which has the current approver flag set.
181 -- Parameters :
182 --
183
184 PROCEDURE Get_Current_Approver
185 (
186 p_assignment_id IN NUMBER ,
187 p_project_id IN NUMBER ,
188 p_apprvl_status_code IN VARCHAR2 ,
189 x_approver_name OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
190
191
192
193 PROCEDURE Cancel_Assignment
194 (
195 p_record_version_number IN Number ,
196 p_assignment_id IN Number ,
197 p_assignment_type IN Varchar2 ,
198 p_start_date IN date ,
199 p_end_date IN date ,
200 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201 p_commit IN VARCHAR2 := FND_API.G_FALSE,
202 x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
203 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
204 x_msg_data OUT NOCOPY Varchar2 ); --File.Sql.39 bug 4440895
205
206
207 /* This API is called from the Mass Submit for approval pages. */
208
209 PROCEDURE mass_submit_for_asgmt_aprvl
210 (p_mode IN VARCHAR2
211 ,p_action IN VARCHAR2
212 ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
213 ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
214 ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
215 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
216 ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
217 ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
218 ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
219 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
220 ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
221 ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
222 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
223 ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
224 ,p_append_description_flag IN VARCHAR2 := 'N'
225 ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
226 ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
227 ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
228 ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
229 ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
230 ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
231 ,p_append_information_flag IN VARCHAR2 := 'N'
232 ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
233 ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
234 ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
238 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
235 ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
236 ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
237 ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
239 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
240 ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
241 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
242 ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
243 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
244 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
245 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
246 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
247 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
248 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
249 ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
250 ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
251 ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
252 ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
253 ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
254 ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
255 ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
256 ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
257 ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
258 ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
259 ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
260 ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
261 ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
262 ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
263 ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
264 ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
265 ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
266 ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
267 ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
268 ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
269 ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
270 ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
271 ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
272 ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
273 ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
274 ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
275 ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
276 ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
277 ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
278 ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
279 ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
280 ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
281 ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282 ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
283 ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
284 ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
288 ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
285 ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
286 ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
287 ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
289 ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
290 ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
291 ,p_non_working_day_flag IN VARCHAR2 := 'N'
292 ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
293 ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
294 ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
295 ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
296 ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
297 ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
298 ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
299 ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
300 ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
301 ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
302 ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
303 ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
304 ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
305 ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
306 ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
307 ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
308 ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
309 ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
310 ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
311 ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
312 ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
313 ,p_api_version IN NUMBER := 1.0
314 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
316 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
317 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
318 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
319 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
320 );
321
322 PROCEDURE mass_assignment_approval
323 ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
324 ,p_mode IN VARCHAR2
325 ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
326 ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
327 ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
328 ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
329 ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
330 ,p_overriding_authority_flag IN VARCHAR2 := 'N'
331 ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
332 ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
333 ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
334 ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
335 ,p_api_version IN NUMBER := 1.0
336 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
337 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
341 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
338 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
339 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
340 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
342 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
343 );
344
345 PROCEDURE mass_process_approval_result
346 ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
347 ,p_mode IN VARCHAR2
348 ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
349 ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
350 ,p_group_id IN NUMBER
351 ,p_approver_group_id IN NUMBER
352 ,p_routing_order IN NUMBER
353 ,p_item_key IN NUMBER
354 ,p_notification_id IN NUMBER
355 ,p_submitter_user_name IN VARCHAR2
356 ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
357 ,p_api_version IN NUMBER := 1.0
358 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
359 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
360 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
361 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
362 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
363 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
364 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
365 );
366
367
368 END PA_ASSIGNMENT_APPROVAL_PUB;