[Home] [Help]
PACKAGE BODY: APPS.GHR_COMPLAINT_API
Source
1 Package Body ghr_complaint_api as
2 /* $Header: ghcmpapi.pkb 120.0 2005/05/29 02:53:39 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ghr_complaint_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |--------------------------< create_complaint >--------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_complaint
13 (p_validate in boolean
14 ,p_effective_date in date
15 ,p_complainant_person_id in number
16 ,p_business_group_id in number
17 ,p_docket_number in varchar2
18 ,p_stage in varchar2
19 ,p_class_flag in varchar2
20 ,p_mixed_flag in varchar2
21 ,p_consolidated_flag in varchar2
22 ,p_remand_flag in varchar2
23 ,p_active_flag in varchar2
24 ,p_information_inquiry in date
25 ,p_pcom_init in date
26 ,p_alleg_incident in date
27 ,p_alleg_discrim_org_id in number
28 ,p_rr_ltr_date in date
29 ,p_rr_ltr_recvd in date
30 ,p_pre_com_elec in varchar2
31 --,p_adr_offered in varchar2
32 ,p_class_agent_flag in varchar2
33 ,p_pre_com_desc in varchar2
34 ,p_counselor_asg in date
35 ,p_init_counselor_interview in date
36 ,p_anonymity_requested in varchar2
37 ,p_counsel_ext_ltr in date
38 ,p_traditional_counsel_outcome in varchar2
39 ,p_final_interview in date
40 ,p_notice_rtf_recvd in date
41 ,p_precom_closed in date
42 ,p_precom_closure_nature in varchar2
43 ,p_counselor_rpt_sub in date
44 ,p_hr_office_org_id in number
45 ,p_eeo_office_org_id in number
46 ,p_serviced_org_id in number
47 ,p_formal_com_filed in date
48 ,p_ack_ltr in date
49 ,p_clarification_ltr_date in date
50 ,p_clarification_response_recvd in date
51 ,p_forwarded_legal_review in date
52 ,p_returned_from_legal in date
53 ,p_letter_type in varchar2
54 ,p_letter_date in date
55 ,p_letter_recvd in date
56 ,p_investigation_source in varchar2
57 ,p_investigator_recvd_req in date
58 ,p_agency_investigator_req in date
59 ,p_investigator_asg in date
60 ,p_investigation_start in date
61 ,p_investigation_end in date
62 ,p_investigation_extended in date
63 ,p_invest_extension_desc in varchar2
64 ,p_agency_recvd_roi in date
65 ,p_comrep_recvd_roi in date
66 ,p_options_ltr_date in date
67 ,p_comrep_recvd_opt_ltr in date
68 ,p_comrep_opt_ltr_response in varchar2
69 ,p_resolution_offer in date
70 ,p_comrep_resol_offer_recvd in date
71 ,p_comrep_resol_offer_response in date
72 ,p_comrep_resol_offer_desc in varchar2
73 ,p_resol_offer_signed in date
74 ,p_resol_offer_desc in varchar2
75 ,p_hearing_source in varchar2
76 ,p_agency_notified_hearing in date
77 ,p_eeoc_hearing_docket_num in varchar2
78 ,p_hearing_complete in date
79 ,p_aj_merit_decision_date in date
80 ,p_agency_recvd_aj_merit_dec in date
81 ,p_aj_merit_decision in varchar2
82 ,p_aj_ca_decision_date in date
83 ,p_agency_recvd_aj_ca_dec in date
84 ,p_aj_ca_decision in varchar2
85 ,p_fad_requested in date
86 ,p_merit_fad in varchar2
87 ,p_attorney_fees_fad in varchar2
88 ,p_comp_damages_fad in varchar2
89 ,p_non_compliance_fad in varchar2
90 ,p_fad_req_recvd_eeo_office in date
91 ,p_fad_req_forwd_to_agency in date
92 ,p_agency_recvd_request in date
93 ,p_fad_due in date
94 ,p_fad_date in date
95 ,p_fad_decision in varchar2
96 --,p_fad_final_action_closure in varchar2
97 ,p_fad_forwd_to_comrep in date
98 ,p_fad_recvd_by_comrep in date
99 ,p_fad_imp_ltr_forwd_to_org in date
100 ,p_fad_decision_forwd_legal in date
101 ,p_fad_decision_recvd_legal in date
102 ,p_fa_source in varchar2
103 ,p_final_action_due in date
104 --,p_final_action_nature_of_closu in varchar2
105 ,p_final_act_forwd_comrep in date
106 ,p_final_act_recvd_comrep in date
107 ,p_final_action_decision_date in date
108 ,p_final_action_decision in varchar2
109 ,p_fa_imp_ltr_forwd_to_org in date
110 ,p_fa_decision_forwd_legal in date
111 ,p_fa_decision_recvd_legal in date
112 ,p_civil_action_filed in date
113 ,p_agency_closure_confirmed in date
114 ,p_consolidated_complaint_id in number
115 ,p_consolidated in date
116 ,p_stage_of_consolidation in varchar2
117 ,p_comrep_notif_consolidation in date
118 ,p_consolidation_desc in varchar2
119 ,p_complaint_closed in date
120 ,p_nature_of_closure in varchar2
121 ,p_complaint_closed_desc in varchar2
122 ,p_filed_formal_class in date
123 ,p_forwd_eeoc in date
124 ,p_aj_cert_decision_date in date
125 ,p_aj_cert_decision_recvd in date
126 ,p_aj_cert_decision in varchar2
127 ,p_class_members_notified in date
128 ,p_number_of_complaintants in number
129 ,p_class_hearing in date
130 ,p_aj_dec in date
131 ,p_agency_recvd_aj_dec in date
132 ,p_aj_decision in varchar2
133 ,p_agency_brief_eeoc in date
134 ,p_agency_notif_of_civil_action in date
135 ,p_fad_source in varchar2
136 ,p_agency_files_forwarded_eeoc in date
137 ,p_hearing_req in date
138 ,p_agency_code in varchar2
139 ,p_audited_by in varchar2
140 ,p_record_received in date
141 ,p_attribute_category in varchar2
142 ,p_attribute1 in varchar2
143 ,p_attribute2 in varchar2
144 ,p_attribute3 in varchar2
145 ,p_attribute4 in varchar2
146 ,p_attribute5 in varchar2
147 ,p_attribute6 in varchar2
148 ,p_attribute7 in varchar2
149 ,p_attribute8 in varchar2
150 ,p_attribute9 in varchar2
151 ,p_attribute10 in varchar2
152 ,p_attribute11 in varchar2
153 ,p_attribute12 in varchar2
154 ,p_attribute13 in varchar2
155 ,p_attribute14 in varchar2
156 ,p_attribute15 in varchar2
157 ,p_attribute16 in varchar2
158 ,p_attribute17 in varchar2
159 ,p_attribute18 in varchar2
160 ,p_attribute19 in varchar2
161 ,p_attribute20 in varchar2
162 ,p_attribute21 in varchar2
163 ,p_attribute22 in varchar2
164 ,p_attribute23 in varchar2
165 ,p_attribute24 in varchar2
166 ,p_attribute25 in varchar2
167 ,p_attribute26 in varchar2
168 ,p_attribute27 in varchar2
169 ,p_attribute28 in varchar2
170 ,p_attribute29 in varchar2
171 ,p_attribute30 in varchar2
172 ,p_complaint_id out nocopy number
173 ,p_object_version_number out nocopy number
174 ) is
175 --
176 -- Declare cursors and local variables
177 --
178
179 l_proc varchar2(72) := g_package||'create_complaint';
180 l_complaint_id ghr_complaints2.complaint_id%TYPE;
181 l_object_version_number ghr_complaints2.object_version_number%TYPE;
182
183 begin
184 hr_utility.set_location('Entering:'|| l_proc, 10);
185 --
186 -- Issue a savepoint
187 --
188 savepoint create_complaint;
189 hr_utility.set_location(l_proc, 20);
190 --
191 -- Truncate the time portion from all IN date parameters
192 --
193
194 --
195 -- Call Before Process User Hook
196 --
197 begin
198 GHR_COMPLAINT_BK_1.create_complaint_b
199 (p_effective_date => trunc(p_effective_date)
200 ,p_business_group_id => p_business_group_id
201 ,p_complainant_person_id => p_complainant_person_id
202 ,p_docket_number => p_docket_number
203 ,p_stage => p_stage
204 ,p_class_flag => p_class_flag
205 ,p_mixed_flag => p_mixed_flag
206 ,p_consolidated_flag => p_consolidated_flag
207 ,p_remand_flag => p_remand_flag
208 ,p_active_flag => p_active_flag
209 ,p_information_inquiry => p_information_inquiry
210 ,p_pcom_init => p_pcom_init
211 ,p_alleg_incident => p_alleg_incident
212 ,p_alleg_discrim_org_id => p_alleg_discrim_org_id
213 ,p_rr_ltr_date => p_rr_ltr_date
214 ,p_rr_ltr_recvd => p_rr_ltr_recvd
215 ,p_pre_com_elec => p_pre_com_elec
216 --,p_adr_offered => p_adr_offered
217 ,p_class_agent_flag => p_class_agent_flag
218 ,p_pre_com_desc => p_pre_com_desc
219 ,p_counselor_asg => p_counselor_asg
220 ,p_init_counselor_interview => p_init_counselor_interview
221 ,p_anonymity_requested => p_anonymity_requested
222 ,p_counsel_ext_ltr => p_counsel_ext_ltr
223 ,p_traditional_counsel_outcome => p_traditional_counsel_outcome
224 ,p_final_interview => p_final_interview
225 ,p_notice_rtf_recvd => p_notice_rtf_recvd
226 ,p_precom_closed => p_precom_closed
227 ,p_precom_closure_nature => p_precom_closure_nature
228 ,p_counselor_rpt_sub => p_counselor_rpt_sub
229 ,p_hr_office_org_id => p_hr_office_org_id
230 ,p_eeo_office_org_id => p_eeo_office_org_id
231 ,p_serviced_org_id => p_serviced_org_id
232 ,p_formal_com_filed => p_formal_com_filed
233 ,p_ack_ltr => p_ack_ltr
234 ,p_clarification_ltr_date => p_clarification_ltr_date
235 ,p_clarification_response_recvd => p_clarification_response_recvd
236 ,p_forwarded_legal_review => p_forwarded_legal_review
237 ,p_returned_from_legal => p_returned_from_legal
238 ,p_letter_type => p_letter_type
239 ,p_letter_date => p_letter_date
240 ,p_letter_recvd => p_letter_recvd
241 ,p_investigation_source => p_investigation_source
242 ,p_investigator_recvd_req => p_investigator_recvd_req
243 ,p_agency_investigator_req => p_agency_investigator_req
244 ,p_investigator_asg => p_investigator_asg
245 ,p_investigation_start => p_investigation_start
246 ,p_investigation_end => p_investigation_end
247 ,p_investigation_extended => p_investigation_extended
248 ,p_invest_extension_desc => p_invest_extension_desc
249 ,p_agency_recvd_roi => p_agency_recvd_roi
250 ,p_comrep_recvd_roi => p_comrep_recvd_roi
251 ,p_options_ltr_date => p_options_ltr_date
252 ,p_comrep_recvd_opt_ltr => p_comrep_recvd_opt_ltr
253 ,p_comrep_opt_ltr_response => p_comrep_opt_ltr_response
254 ,p_resolution_offer => p_resolution_offer
255 ,p_comrep_resol_offer_recvd => p_comrep_resol_offer_recvd
256 ,p_comrep_resol_offer_response => p_comrep_resol_offer_response
257 ,p_comrep_resol_offer_desc => p_comrep_resol_offer_desc
258 ,p_resol_offer_signed => p_resol_offer_signed
259 ,p_resol_offer_desc => p_resol_offer_desc
260 ,p_hearing_source => p_hearing_source
261 ,p_agency_notified_hearing => p_agency_notified_hearing
262 ,p_eeoc_hearing_docket_num => p_eeoc_hearing_docket_num
263 ,p_hearing_complete => p_hearing_complete
264 ,p_aj_merit_decision_date => p_aj_merit_decision_date
265 ,p_agency_recvd_aj_merit_dec => p_agency_recvd_aj_merit_dec
266 ,p_aj_merit_decision => p_aj_merit_decision
267 ,p_aj_ca_decision_date => p_aj_ca_decision_date
268 ,p_agency_recvd_aj_ca_dec => p_agency_recvd_aj_ca_dec
269 ,p_aj_ca_decision => p_aj_ca_decision
270 ,p_fad_requested => p_fad_requested
271 ,p_merit_fad => p_merit_fad
272 ,p_attorney_fees_fad => p_attorney_fees_fad
273 ,p_comp_damages_fad => p_comp_damages_fad
274 ,p_non_compliance_fad => p_non_compliance_fad
275 ,p_fad_req_recvd_eeo_office => p_fad_req_recvd_eeo_office
276 ,p_fad_req_forwd_to_agency => p_fad_req_forwd_to_agency
277 ,p_agency_recvd_request => p_agency_recvd_request
278 ,p_fad_due => p_fad_due
279 ,p_fad_date => p_fad_date
280 ,p_fad_decision => p_fad_decision
281 --,p_fad_final_action_closure => p_fad_final_action_closure
282 ,p_fad_forwd_to_comrep => p_fad_forwd_to_comrep
283 ,p_fad_recvd_by_comrep => p_fad_recvd_by_comrep
284 ,p_fad_imp_ltr_forwd_to_org => p_fad_imp_ltr_forwd_to_org
285 ,p_fad_decision_forwd_legal => p_fad_decision_forwd_legal
286 ,p_fad_decision_recvd_legal => p_fad_decision_recvd_legal
287 ,p_fa_source => p_fa_source
288 ,p_final_action_due => p_final_action_due
289 --,p_final_action_nature_of_closu => p_final_action_nature_of_closu
290 ,p_final_act_forwd_comrep => p_final_act_forwd_comrep
291 ,p_final_act_recvd_comrep => p_final_act_recvd_comrep
292 ,p_final_action_decision_date => p_final_action_decision_date
293 ,p_final_action_decision => p_final_action_decision
294 ,p_fa_imp_ltr_forwd_to_org => p_fa_imp_ltr_forwd_to_org
295 ,p_fa_decision_forwd_legal => p_fa_decision_forwd_legal
296 ,p_fa_decision_recvd_legal => p_fa_decision_recvd_legal
297 ,p_civil_action_filed => p_civil_action_filed
298 ,p_agency_closure_confirmed => p_agency_closure_confirmed
299 ,p_consolidated_complaint_id => p_consolidated_complaint_id
300 ,p_consolidated => p_consolidated
301 ,p_stage_of_consolidation => p_stage_of_consolidation
302 ,p_comrep_notif_consolidation => p_comrep_notif_consolidation
303 ,p_consolidation_desc => p_consolidation_desc
304 ,p_complaint_closed => p_complaint_closed
305 ,p_nature_of_closure => p_nature_of_closure
306 ,p_complaint_closed_desc => p_complaint_closed_desc
307 ,p_filed_formal_class => p_filed_formal_class
308 ,p_forwd_eeoc => p_forwd_eeoc
309 ,p_aj_cert_decision_date => p_aj_cert_decision_date
310 ,p_aj_cert_decision_recvd => p_aj_cert_decision_recvd
311 ,p_aj_cert_decision => p_aj_cert_decision
312 ,p_class_members_notified => p_class_members_notified
313 ,p_number_of_complaintants => p_number_of_complaintants
314 ,p_class_hearing => p_class_hearing
315 ,p_aj_dec => p_aj_dec
316 ,p_agency_recvd_aj_dec => p_agency_recvd_aj_dec
317 ,p_aj_decision => p_aj_decision
318 ,p_agency_brief_eeoc => p_agency_brief_eeoc
319 ,p_agency_notif_of_civil_action => p_agency_notif_of_civil_action
320 ,p_fad_source => p_fad_source
321 ,p_agency_files_forwarded_eeoc => p_agency_files_forwarded_eeoc
322 ,p_hearing_req => p_hearing_req
323 ,p_agency_code => p_agency_code
324 ,p_audited_by => p_audited_by
325 ,p_record_received => p_record_received
326 ,p_attribute_category => p_attribute_category
327 ,p_attribute1 => p_attribute1
328 ,p_attribute2 => p_attribute2
329 ,p_attribute3 => p_attribute3
330 ,p_attribute4 => p_attribute4
331 ,p_attribute5 => p_attribute5
332 ,p_attribute6 => p_attribute6
333 ,p_attribute7 => p_attribute7
334 ,p_attribute8 => p_attribute8
335 ,p_attribute9 => p_attribute9
336 ,p_attribute10 => p_attribute10
337 ,p_attribute11 => p_attribute11
338 ,p_attribute12 => p_attribute12
339 ,p_attribute13 => p_attribute13
340 ,p_attribute14 => p_attribute14
341 ,p_attribute15 => p_attribute15
342 ,p_attribute16 => p_attribute16
343 ,p_attribute17 => p_attribute17
344 ,p_attribute18 => p_attribute18
345 ,p_attribute19 => p_attribute19
346 ,p_attribute20 => p_attribute20
347 ,p_attribute21 => p_attribute21
348 ,p_attribute22 => p_attribute22
349 ,p_attribute23 => p_attribute23
350 ,p_attribute24 => p_attribute24
351 ,p_attribute25 => p_attribute25
352 ,p_attribute26 => p_attribute26
353 ,p_attribute27 => p_attribute27
354 ,p_attribute28 => p_attribute28
355 ,p_attribute29 => p_attribute29
356 ,p_attribute30 => p_attribute30
357 );
358 exception
359 when hr_api.cannot_find_prog_unit then
360 hr_api.cannot_find_prog_unit_error
361 (p_module_name => 'Create_Complaint'
362 ,p_hook_type => 'BP'
363 );
364 end;
365 hr_utility.set_location(l_proc, 30);
366 --
367 -- Validation in addition to Row Handlers
368 --
369
370 hr_utility.set_location(l_proc, 40);
371 --
372 -- Process Logic
373 --
374 ghr_cmp_ins.ins
375 (p_effective_date => p_effective_date
376 ,p_complainant_person_id => p_complainant_person_id
377 ,p_business_group_id => p_business_group_id
378 ,p_docket_number => p_docket_number
379 ,p_stage => p_stage
380 ,p_class_flag => p_class_flag
381 ,p_mixed_flag => p_mixed_flag
382 ,p_consolidated_flag => p_consolidated_flag
383 ,p_remand_flag => p_remand_flag
384 ,p_active_flag => p_active_flag
385 ,p_information_inquiry => p_information_inquiry
386 ,p_pcom_init => p_pcom_init
387 ,p_alleg_incident => p_alleg_incident
388 ,p_alleg_discrim_org_id => p_alleg_discrim_org_id
389 ,p_rr_ltr_date => p_rr_ltr_date
390 ,p_rr_ltr_recvd => p_rr_ltr_recvd
391 ,p_pre_com_elec => p_pre_com_elec
392 --,p_adr_offered => p_adr_offered
393 ,p_class_agent_flag => p_class_agent_flag
394 ,p_pre_com_desc => p_pre_com_desc
395 ,p_counselor_asg => p_counselor_asg
396 ,p_init_counselor_interview => p_init_counselor_interview
397 ,p_anonymity_requested => p_anonymity_requested
398 ,p_counsel_ext_ltr => p_counsel_ext_ltr
399 ,p_traditional_counsel_outcome => p_traditional_counsel_outcome
400 ,p_final_interview => p_final_interview
401 ,p_notice_rtf_recvd => p_notice_rtf_recvd
402 ,p_precom_closed => p_precom_closed
403 ,p_precom_closure_nature => p_precom_closure_nature
404 ,p_counselor_rpt_sub => p_counselor_rpt_sub
405 ,p_hr_office_org_id => p_hr_office_org_id
406 ,p_eeo_office_org_id => p_eeo_office_org_id
407 ,p_serviced_org_id => p_serviced_org_id
408 ,p_formal_com_filed => p_formal_com_filed
409 ,p_ack_ltr => p_ack_ltr
410 ,p_clarification_ltr_date => p_clarification_ltr_date
411 ,p_clarification_response_recvd => p_clarification_response_recvd
412 ,p_forwarded_legal_review => p_forwarded_legal_review
413 ,p_returned_from_legal => p_returned_from_legal
414 ,p_letter_type => p_letter_type
415 ,p_letter_date => p_letter_date
416 ,p_letter_recvd => p_letter_recvd
417 ,p_investigation_source => p_investigation_source
418 ,p_investigator_recvd_req => p_investigator_recvd_req
419 ,p_agency_investigator_req => p_agency_investigator_req
420 ,p_investigator_asg => p_investigator_asg
421 ,p_investigation_start => p_investigation_start
422 ,p_investigation_end => p_investigation_end
423 ,p_investigation_extended => p_investigation_extended
424 ,p_invest_extension_desc => p_invest_extension_desc
425 ,p_agency_recvd_roi => p_agency_recvd_roi
426 ,p_comrep_recvd_roi => p_comrep_recvd_roi
427 ,p_options_ltr_date => p_options_ltr_date
428 ,p_comrep_recvd_opt_ltr => p_comrep_recvd_opt_ltr
429 ,p_comrep_opt_ltr_response => p_comrep_opt_ltr_response
430 ,p_resolution_offer => p_resolution_offer
431 ,p_comrep_resol_offer_recvd => p_comrep_resol_offer_recvd
432 ,p_comrep_resol_offer_response => p_comrep_resol_offer_response
433 ,p_comrep_resol_offer_desc => p_comrep_resol_offer_desc
434 ,p_resol_offer_signed => p_resol_offer_signed
435 ,p_resol_offer_desc => p_resol_offer_desc
436 ,p_hearing_source => p_hearing_source
437 ,p_agency_notified_hearing => p_agency_notified_hearing
438 ,p_eeoc_hearing_docket_num => p_eeoc_hearing_docket_num
439 ,p_hearing_complete => p_hearing_complete
440 ,p_aj_merit_decision_date => p_aj_merit_decision_date
441 ,p_agency_recvd_aj_merit_dec => p_agency_recvd_aj_merit_dec
442 ,p_aj_merit_decision => p_aj_merit_decision
443 ,p_aj_ca_decision_date => p_aj_ca_decision_date
444 ,p_agency_recvd_aj_ca_dec => p_agency_recvd_aj_ca_dec
445 ,p_aj_ca_decision => p_aj_ca_decision
446 ,p_fad_requested => p_fad_requested
447 ,p_merit_fad => p_merit_fad
448 ,p_attorney_fees_fad => p_attorney_fees_fad
449 ,p_comp_damages_fad => p_comp_damages_fad
450 ,p_non_compliance_fad => p_non_compliance_fad
451 ,p_fad_req_recvd_eeo_office => p_fad_req_recvd_eeo_office
452 ,p_fad_req_forwd_to_agency => p_fad_req_forwd_to_agency
453 ,p_agency_recvd_request => p_agency_recvd_request
454 ,p_fad_due => p_fad_due
455 ,p_fad_date => p_fad_date
456 ,p_fad_decision => p_fad_decision
457 --,p_fad_final_action_closure => p_fad_final_action_closure
458 ,p_fad_forwd_to_comrep => p_fad_forwd_to_comrep
459 ,p_fad_recvd_by_comrep => p_fad_recvd_by_comrep
460 ,p_fad_imp_ltr_forwd_to_org => p_fad_imp_ltr_forwd_to_org
461 ,p_fad_decision_forwd_legal => p_fad_decision_forwd_legal
462 ,p_fad_decision_recvd_legal => p_fad_decision_recvd_legal
463 ,p_fa_source => p_fa_source
464 ,p_final_action_due => p_final_action_due
465 --,p_final_action_nature_of_closu => p_final_action_nature_of_closu
466 ,p_final_act_forwd_comrep => p_final_act_forwd_comrep
467 ,p_final_act_recvd_comrep => p_final_act_recvd_comrep
468 ,p_final_action_decision_date => p_final_action_decision_date
469 ,p_final_action_decision => p_final_action_decision
470 ,p_fa_imp_ltr_forwd_to_org => p_fa_imp_ltr_forwd_to_org
471 ,p_fa_decision_forwd_legal => p_fa_decision_forwd_legal
472 ,p_fa_decision_recvd_legal => p_fa_decision_recvd_legal
473 ,p_civil_action_filed => p_civil_action_filed
474 ,p_agency_closure_confirmed => p_agency_closure_confirmed
475 ,p_consolidated_complaint_id => p_consolidated_complaint_id
476 ,p_consolidated => p_consolidated
477 ,p_stage_of_consolidation => p_stage_of_consolidation
478 ,p_comrep_notif_consolidation => p_comrep_notif_consolidation
479 ,p_consolidation_desc => p_consolidation_desc
480 ,p_complaint_closed => p_complaint_closed
481 ,p_nature_of_closure => p_nature_of_closure
482 ,p_complaint_closed_desc => p_complaint_closed_desc
483 ,p_filed_formal_class => p_filed_formal_class
484 ,p_forwd_eeoc => p_forwd_eeoc
485 ,p_aj_cert_decision_date => p_aj_cert_decision_date
486 ,p_aj_cert_decision_recvd => p_aj_cert_decision_recvd
487 ,p_aj_cert_decision => p_aj_cert_decision
488 ,p_class_members_notified => p_class_members_notified
489 ,p_number_of_complaintants => p_number_of_complaintants
490 ,p_class_hearing => p_class_hearing
491 ,p_aj_dec => p_aj_dec
492 ,p_agency_recvd_aj_dec => p_agency_recvd_aj_dec
493 ,p_aj_decision => p_aj_decision
494 ,p_agency_brief_eeoc => p_agency_brief_eeoc
495 ,p_agency_notif_of_civil_action => p_agency_notif_of_civil_action
496 ,p_fad_source => p_fad_source
497 ,p_agency_files_forwarded_eeoc => p_agency_files_forwarded_eeoc
498 ,p_hearing_req => p_hearing_req
499 ,p_agency_code => p_agency_code
500 ,p_audited_by => p_audited_by
501 ,p_record_received => p_record_received
502 ,p_attribute_category => p_attribute_category
503 ,p_attribute1 => p_attribute1
504 ,p_attribute2 => p_attribute2
505 ,p_attribute3 => p_attribute3
506 ,p_attribute4 => p_attribute4
507 ,p_attribute5 => p_attribute5
508 ,p_attribute6 => p_attribute6
509 ,p_attribute7 => p_attribute7
510 ,p_attribute8 => p_attribute8
511 ,p_attribute9 => p_attribute9
512 ,p_attribute10 => p_attribute10
513 ,p_attribute11 => p_attribute11
514 ,p_attribute12 => p_attribute12
515 ,p_attribute13 => p_attribute13
516 ,p_attribute14 => p_attribute14
517 ,p_attribute15 => p_attribute15
518 ,p_attribute16 => p_attribute16
519 ,p_attribute17 => p_attribute17
520 ,p_attribute18 => p_attribute18
521 ,p_attribute19 => p_attribute19
522 ,p_attribute20 => p_attribute20
523 ,p_attribute21 => p_attribute21
524 ,p_attribute22 => p_attribute22
525 ,p_attribute23 => p_attribute23
526 ,p_attribute24 => p_attribute24
527 ,p_attribute25 => p_attribute25
528 ,p_attribute26 => p_attribute26
529 ,p_attribute27 => p_attribute27
530 ,p_attribute28 => p_attribute28
531 ,p_attribute29 => p_attribute29
532 ,p_attribute30 => p_attribute30
533 ,p_complaint_id => l_complaint_id
534 ,p_object_version_number => l_object_version_number
535 );
536
537 hr_utility.set_location(l_proc, 50);
538 --
539 -- Call After Process User Hook
540 --
541 begin
542 GHR_COMPLAINT_BK_1.create_complaint_a
543 (p_effective_date => trunc(p_effective_date)
544 ,p_business_group_id => p_business_group_id
545 ,p_complainant_person_id => p_complainant_person_id
546 ,p_docket_number => p_docket_number
547 ,p_stage => p_stage
548 ,p_class_flag => p_class_flag
549 ,p_mixed_flag => p_mixed_flag
550 ,p_consolidated_flag => p_consolidated_flag
551 ,p_remand_flag => p_remand_flag
552 ,p_active_flag => p_active_flag
553 ,p_information_inquiry => p_information_inquiry
554 ,p_pcom_init => p_pcom_init
555 ,p_alleg_incident => p_alleg_incident
556 ,p_alleg_discrim_org_id => p_alleg_discrim_org_id
557 ,p_rr_ltr_date => p_rr_ltr_date
558 ,p_rr_ltr_recvd => p_rr_ltr_recvd
559 ,p_pre_com_elec => p_pre_com_elec
560 --,p_adr_offered => p_adr_offered
561 ,p_class_agent_flag => p_class_agent_flag
562 ,p_pre_com_desc => p_pre_com_desc
563 ,p_counselor_asg => p_counselor_asg
564 ,p_init_counselor_interview => p_init_counselor_interview
565 ,p_anonymity_requested => p_anonymity_requested
566 ,p_counsel_ext_ltr => p_counsel_ext_ltr
567 ,p_traditional_counsel_outcome => p_traditional_counsel_outcome
568 ,p_final_interview => p_final_interview
569 ,p_notice_rtf_recvd => p_notice_rtf_recvd
570 ,p_precom_closed => p_precom_closed
571 ,p_precom_closure_nature => p_precom_closure_nature
572 ,p_counselor_rpt_sub => p_counselor_rpt_sub
573 ,p_hr_office_org_id => p_hr_office_org_id
574 ,p_eeo_office_org_id => p_eeo_office_org_id
575 ,p_serviced_org_id => p_serviced_org_id
576 ,p_formal_com_filed => p_formal_com_filed
577 ,p_ack_ltr => p_ack_ltr
578 ,p_clarification_ltr_date => p_clarification_ltr_date
579 ,p_clarification_response_recvd => p_clarification_response_recvd
580 ,p_forwarded_legal_review => p_forwarded_legal_review
581 ,p_returned_from_legal => p_returned_from_legal
582 ,p_letter_type => p_letter_type
583 ,p_letter_date => p_letter_date
584 ,p_letter_recvd => p_letter_recvd
585 ,p_investigation_source => p_investigation_source
586 ,p_investigator_recvd_req => p_investigator_recvd_req
587 ,p_agency_investigator_req => p_agency_investigator_req
588 ,p_investigator_asg => p_investigator_asg
589 ,p_investigation_start => p_investigation_start
590 ,p_investigation_end => p_investigation_end
591 ,p_investigation_extended => p_investigation_extended
592 ,p_invest_extension_desc => p_invest_extension_desc
593 ,p_agency_recvd_roi => p_agency_recvd_roi
594 ,p_comrep_recvd_roi => p_comrep_recvd_roi
595 ,p_options_ltr_date => p_options_ltr_date
596 ,p_comrep_recvd_opt_ltr => p_comrep_recvd_opt_ltr
597 ,p_comrep_opt_ltr_response => p_comrep_opt_ltr_response
598 ,p_resolution_offer => p_resolution_offer
599 ,p_comrep_resol_offer_recvd => p_comrep_resol_offer_recvd
600 ,p_comrep_resol_offer_response => p_comrep_resol_offer_response
601 ,p_comrep_resol_offer_desc => p_comrep_resol_offer_desc
602 ,p_resol_offer_signed => p_resol_offer_signed
603 ,p_resol_offer_desc => p_resol_offer_desc
604 ,p_hearing_source => p_hearing_source
605 ,p_agency_notified_hearing => p_agency_notified_hearing
606 ,p_eeoc_hearing_docket_num => p_eeoc_hearing_docket_num
607 ,p_hearing_complete => p_hearing_complete
608 ,p_aj_merit_decision_date => p_aj_merit_decision_date
609 ,p_agency_recvd_aj_merit_dec => p_agency_recvd_aj_merit_dec
610 ,p_aj_merit_decision => p_aj_merit_decision
611 ,p_aj_ca_decision_date => p_aj_ca_decision_date
612 ,p_agency_recvd_aj_ca_dec => p_agency_recvd_aj_ca_dec
613 ,p_aj_ca_decision => p_aj_ca_decision
614 ,p_fad_requested => p_fad_requested
615 ,p_merit_fad => p_merit_fad
616 ,p_attorney_fees_fad => p_attorney_fees_fad
617 ,p_comp_damages_fad => p_comp_damages_fad
618 ,p_non_compliance_fad => p_non_compliance_fad
619 ,p_fad_req_recvd_eeo_office => p_fad_req_recvd_eeo_office
620 ,p_fad_req_forwd_to_agency => p_fad_req_forwd_to_agency
621 ,p_agency_recvd_request => p_agency_recvd_request
622 ,p_fad_due => p_fad_due
623 ,p_fad_date => p_fad_date
624 ,p_fad_decision => p_fad_decision
625 --,p_fad_final_action_closure => p_fad_final_action_closure
626 ,p_fad_forwd_to_comrep => p_fad_forwd_to_comrep
627 ,p_fad_recvd_by_comrep => p_fad_recvd_by_comrep
628 ,p_fad_imp_ltr_forwd_to_org => p_fad_imp_ltr_forwd_to_org
629 ,p_fad_decision_forwd_legal => p_fad_decision_forwd_legal
630 ,p_fad_decision_recvd_legal => p_fad_decision_recvd_legal
631 ,p_fa_source => p_fa_source
632 ,p_final_action_due => p_final_action_due
633 --,p_final_action_nature_of_closu => p_final_action_nature_of_closu
634 ,p_final_act_forwd_comrep => p_final_act_forwd_comrep
635 ,p_final_act_recvd_comrep => p_final_act_recvd_comrep
636 ,p_final_action_decision_date => p_final_action_decision_date
637 ,p_final_action_decision => p_final_action_decision
638 ,p_fa_imp_ltr_forwd_to_org => p_fa_imp_ltr_forwd_to_org
639 ,p_fa_decision_forwd_legal => p_fa_decision_forwd_legal
640 ,p_fa_decision_recvd_legal => p_fa_decision_recvd_legal
641 ,p_civil_action_filed => p_civil_action_filed
642 ,p_agency_closure_confirmed => p_agency_closure_confirmed
643 ,p_consolidated_complaint_id => p_consolidated_complaint_id
644 ,p_consolidated => p_consolidated
645 ,p_stage_of_consolidation => p_stage_of_consolidation
646 ,p_comrep_notif_consolidation => p_comrep_notif_consolidation
647 ,p_consolidation_desc => p_consolidation_desc
648 ,p_complaint_closed => p_complaint_closed
649 ,p_nature_of_closure => p_nature_of_closure
650 ,p_complaint_closed_desc => p_complaint_closed_desc
651 ,p_filed_formal_class => p_filed_formal_class
652 ,p_forwd_eeoc => p_forwd_eeoc
653 ,p_aj_cert_decision_date => p_aj_cert_decision_date
654 ,p_aj_cert_decision_recvd => p_aj_cert_decision_recvd
655 ,p_aj_cert_decision => p_aj_cert_decision
656 ,p_class_members_notified => p_class_members_notified
657 ,p_number_of_complaintants => p_number_of_complaintants
658 ,p_class_hearing => p_class_hearing
659 ,p_aj_dec => p_aj_dec
660 ,p_agency_recvd_aj_dec => p_agency_recvd_aj_dec
661 ,p_aj_decision => p_aj_decision
662 ,p_agency_brief_eeoc => p_agency_brief_eeoc
663 ,p_agency_notif_of_civil_action => p_agency_notif_of_civil_action
664 ,p_fad_source => p_fad_source
665 ,p_agency_files_forwarded_eeoc => p_agency_files_forwarded_eeoc
666 ,p_hearing_req => p_hearing_req
667 ,p_agency_code => p_agency_code
668 ,p_audited_by => p_audited_by
669 ,p_record_received => p_record_received
670 ,p_attribute_category => p_attribute_category
671 ,p_attribute1 => p_attribute1
672 ,p_attribute2 => p_attribute2
673 ,p_attribute3 => p_attribute3
674 ,p_attribute4 => p_attribute4
675 ,p_attribute5 => p_attribute5
676 ,p_attribute6 => p_attribute6
677 ,p_attribute7 => p_attribute7
678 ,p_attribute8 => p_attribute8
679 ,p_attribute9 => p_attribute9
680 ,p_attribute10 => p_attribute10
681 ,p_attribute11 => p_attribute11
682 ,p_attribute12 => p_attribute12
683 ,p_attribute13 => p_attribute13
684 ,p_attribute14 => p_attribute14
685 ,p_attribute15 => p_attribute15
686 ,p_attribute16 => p_attribute16
687 ,p_attribute17 => p_attribute17
688 ,p_attribute18 => p_attribute18
689 ,p_attribute19 => p_attribute19
690 ,p_attribute20 => p_attribute20
691 ,p_attribute21 => p_attribute21
692 ,p_attribute22 => p_attribute22
693 ,p_attribute23 => p_attribute23
694 ,p_attribute24 => p_attribute24
695 ,p_attribute25 => p_attribute25
696 ,p_attribute26 => p_attribute26
697 ,p_attribute27 => p_attribute27
698 ,p_attribute28 => p_attribute28
699 ,p_attribute29 => p_attribute29
700 ,p_attribute30 => p_attribute30
701 ,p_complaint_id => l_complaint_id
702 ,p_object_version_number => l_object_version_number
703 );
704 exception
705 when hr_api.cannot_find_prog_unit then
706 hr_api.cannot_find_prog_unit_error
707 (p_module_name => 'Create_Complaint'
708 ,p_hook_type => 'AP'
709 );
710 end;
711 hr_utility.set_location(l_proc, 60);
712 --
713 -- When in validation only mode raise the Validate_Enabled exception
714 --
715 if p_validate then
716 raise hr_api.validate_enabled;
717 end if;
718 --
719 -- Set all output arguments
720 --
721 p_complaint_id := l_complaint_id;
722 p_object_version_number := l_object_version_number;
723 --
724 hr_utility.set_location(' Leaving:'||l_proc, 70);
725 exception
726 when hr_api.validate_enabled then
727 --
728 -- As the Validate_Enabled exception has been raised
729 -- we must rollback to the savepoint
730 --
731 rollback to create_complaint;
732 --
733 -- Only set output warning arguments
734 -- (Any key or derived arguments must be set to null
735 -- when validation only mode is being used.)
736 --
737 p_complaint_id := null;
738 p_object_version_number := null;
739 hr_utility.set_location(' Leaving:'||l_proc, 80);
740 when others then
741 --
742 -- A validation or unexpected error has occured
743 --
744 rollback to create_complaint;
745 -- RESET In/Out Params and SET Out Params
746 p_complaint_id := null;
747 p_object_version_number := null;
748 hr_utility.set_location(' Leaving:'||l_proc, 90);
749 raise;
750 end create_complaint;
751 --
752 -- ----------------------------------------------------------------------------
753 -- |--------------------------< update_complaint >--------------------------|
754 -- ----------------------------------------------------------------------------
755 --
756 procedure update_complaint
757 (p_validate in boolean
758 ,p_effective_date in date
759 ,p_complaint_id in number
760 ,p_object_version_number in out nocopy number
761 ,p_complainant_person_id in number
762 ,p_business_group_id in number
763 ,p_docket_number in varchar2
764 ,p_stage in varchar2
765 ,p_class_flag in varchar2
766 ,p_mixed_flag in varchar2
767 ,p_consolidated_flag in varchar2
768 ,p_remand_flag in varchar2
769 ,p_active_flag in varchar2
770 ,p_information_inquiry in date
771 ,p_pcom_init in date
772 ,p_alleg_incident in date
773 ,p_alleg_discrim_org_id in number
774 ,p_rr_ltr_date in date
775 ,p_rr_ltr_recvd in date
776 ,p_pre_com_elec in varchar2
777 --,p_adr_offered in varchar2
778 ,p_class_agent_flag in varchar2
779 ,p_pre_com_desc in varchar2
780 ,p_counselor_asg in date
781 ,p_init_counselor_interview in date
782 ,p_anonymity_requested in varchar2
783 ,p_counsel_ext_ltr in date
784 ,p_traditional_counsel_outcome in varchar2
785 ,p_final_interview in date
786 ,p_notice_rtf_recvd in date
787 ,p_precom_closed in date
788 ,p_precom_closure_nature in varchar2
789 ,p_counselor_rpt_sub in date
790 ,p_hr_office_org_id in number
791 ,p_eeo_office_org_id in number
792 ,p_serviced_org_id in number
793 ,p_formal_com_filed in date
794 ,p_ack_ltr in date
795 ,p_clarification_ltr_date in date
796 ,p_clarification_response_recvd in date
797 ,p_forwarded_legal_review in date
798 ,p_returned_from_legal in date
799 ,p_letter_type in varchar2
800 ,p_letter_date in date
801 ,p_letter_recvd in date
802 ,p_investigation_source in varchar2
803 ,p_investigator_recvd_req in date
804 ,p_agency_investigator_req in date
805 ,p_investigator_asg in date
806 ,p_investigation_start in date
807 ,p_investigation_end in date
808 ,p_investigation_extended in date
809 ,p_invest_extension_desc in varchar2
810 ,p_agency_recvd_roi in date
811 ,p_comrep_recvd_roi in date
812 ,p_options_ltr_date in date
813 ,p_comrep_recvd_opt_ltr in date
814 ,p_comrep_opt_ltr_response in varchar2
815 ,p_resolution_offer in date
816 ,p_comrep_resol_offer_recvd in date
817 ,p_comrep_resol_offer_response in date
818 ,p_comrep_resol_offer_desc in varchar2
819 ,p_resol_offer_signed in date
820 ,p_resol_offer_desc in varchar2
821 ,p_hearing_source in varchar2
822 ,p_agency_notified_hearing in date
823 ,p_eeoc_hearing_docket_num in varchar2
824 ,p_hearing_complete in date
825 ,p_aj_merit_decision_date in date
826 ,p_agency_recvd_aj_merit_dec in date
827 ,p_aj_merit_decision in varchar2
828 ,p_aj_ca_decision_date in date
829 ,p_agency_recvd_aj_ca_dec in date
830 ,p_aj_ca_decision in varchar2
831 ,p_fad_requested in date
832 ,p_merit_fad in varchar2
833 ,p_attorney_fees_fad in varchar2
834 ,p_comp_damages_fad in varchar2
835 ,p_non_compliance_fad in varchar2
836 ,p_fad_req_recvd_eeo_office in date
837 ,p_fad_req_forwd_to_agency in date
838 ,p_agency_recvd_request in date
839 ,p_fad_due in date
840 ,p_fad_date in date
841 ,p_fad_decision in varchar2
842 --,p_fad_final_action_closure in varchar2
843 ,p_fad_forwd_to_comrep in date
844 ,p_fad_recvd_by_comrep in date
845 ,p_fad_imp_ltr_forwd_to_org in date
846 ,p_fad_decision_forwd_legal in date
847 ,p_fad_decision_recvd_legal in date
848 ,p_fa_source in varchar2
849 ,p_final_action_due in date
850 --,p_final_action_nature_of_closu in varchar2
851 ,p_final_act_forwd_comrep in date
852 ,p_final_act_recvd_comrep in date
853 ,p_final_action_decision_date in date
854 ,p_final_action_decision in varchar2
855 ,p_fa_imp_ltr_forwd_to_org in date
856 ,p_fa_decision_forwd_legal in date
857 ,p_fa_decision_recvd_legal in date
858 ,p_civil_action_filed in date
859 ,p_agency_closure_confirmed in date
860 ,p_consolidated_complaint_id in number
861 ,p_consolidated in date
862 ,p_stage_of_consolidation in varchar2
863 ,p_comrep_notif_consolidation in date
864 ,p_consolidation_desc in varchar2
865 ,p_complaint_closed in date
866 ,p_nature_of_closure in varchar2
867 ,p_complaint_closed_desc in varchar2
868 ,p_filed_formal_class in date
869 ,p_forwd_eeoc in date
870 ,p_aj_cert_decision_date in date
871 ,p_aj_cert_decision_recvd in date
872 ,p_aj_cert_decision in varchar2
873 ,p_class_members_notified in date
874 ,p_number_of_complaintants in number
875 ,p_class_hearing in date
876 ,p_aj_dec in date
877 ,p_agency_recvd_aj_dec in date
878 ,p_aj_decision in varchar2
879 ,p_agency_brief_eeoc in date
880 ,p_agency_notif_of_civil_action in date
881 ,p_fad_source in varchar2
882 ,p_agency_files_forwarded_eeoc in date
883 ,p_hearing_req in date
884 ,p_agency_code in varchar2
885 ,p_audited_by in varchar2
886 ,p_record_received in date
887 ,p_attribute_category in varchar2
888 ,p_attribute1 in varchar2
889 ,p_attribute2 in varchar2
890 ,p_attribute3 in varchar2
891 ,p_attribute4 in varchar2
892 ,p_attribute5 in varchar2
893 ,p_attribute6 in varchar2
894 ,p_attribute7 in varchar2
895 ,p_attribute8 in varchar2
896 ,p_attribute9 in varchar2
897 ,p_attribute10 in varchar2
898 ,p_attribute11 in varchar2
899 ,p_attribute12 in varchar2
900 ,p_attribute13 in varchar2
901 ,p_attribute14 in varchar2
902 ,p_attribute15 in varchar2
903 ,p_attribute16 in varchar2
904 ,p_attribute17 in varchar2
905 ,p_attribute18 in varchar2
906 ,p_attribute19 in varchar2
907 ,p_attribute20 in varchar2
908 ,p_attribute21 in varchar2
909 ,p_attribute22 in varchar2
910 ,p_attribute23 in varchar2
911 ,p_attribute24 in varchar2
912 ,p_attribute25 in varchar2
913 ,p_attribute26 in varchar2
914 ,p_attribute27 in varchar2
915 ,p_attribute28 in varchar2
916 ,p_attribute29 in varchar2
917 ,p_attribute30 in varchar2
918 ) is
919 --
920 -- Declare cursors and local variables
921 --
922
923 l_proc varchar2(72) := g_package||'create_complaint';
924 l_object_version_number ghr_complaints2.object_version_number%TYPE;
925
926 begin
927 hr_utility.set_location('Entering:'|| l_proc, 10);
928 --
929 -- Issue a savepoint
930 --
931 savepoint update_complaint;
932 hr_utility.set_location(l_proc, 20);
933 l_object_version_number := p_object_version_number;
934 --
935 -- Truncate the time portion from all IN date parameters
936 --
937
938 --
939 -- Call Before Process User Hook
940 --
941 begin
942 GHR_COMPLAINT_BK_2.update_complaint_b
943 (p_effective_date => trunc(p_effective_date)
944 ,p_business_group_id => p_business_group_id
945 ,p_complaint_id => p_complaint_id
946 ,p_object_version_number => p_object_version_number
947 ,p_complainant_person_id => p_complainant_person_id
948 ,p_docket_number => p_docket_number
949 ,p_stage => p_stage
950 ,p_class_flag => p_class_flag
951 ,p_mixed_flag => p_mixed_flag
952 ,p_consolidated_flag => p_consolidated_flag
953 ,p_remand_flag => p_remand_flag
954 ,p_active_flag => p_active_flag
955 ,p_information_inquiry => p_information_inquiry
956 ,p_pcom_init => p_pcom_init
957 ,p_alleg_incident => p_alleg_incident
958 ,p_alleg_discrim_org_id => p_alleg_discrim_org_id
959 ,p_rr_ltr_date => p_rr_ltr_date
960 ,p_rr_ltr_recvd => p_rr_ltr_recvd
961 ,p_pre_com_elec => p_pre_com_elec
962 --,p_adr_offered => p_adr_offered
963 ,p_class_agent_flag => p_class_agent_flag
964 ,p_pre_com_desc => p_pre_com_desc
965 ,p_counselor_asg => p_counselor_asg
966 ,p_init_counselor_interview => p_init_counselor_interview
967 ,p_anonymity_requested => p_anonymity_requested
968 ,p_counsel_ext_ltr => p_counsel_ext_ltr
969 ,p_traditional_counsel_outcome => p_traditional_counsel_outcome
970 ,p_final_interview => p_final_interview
971 ,p_notice_rtf_recvd => p_notice_rtf_recvd
972 ,p_precom_closed => p_precom_closed
973 ,p_precom_closure_nature => p_precom_closure_nature
974 ,p_counselor_rpt_sub => p_counselor_rpt_sub
975 ,p_hr_office_org_id => p_hr_office_org_id
976 ,p_eeo_office_org_id => p_eeo_office_org_id
977 ,p_serviced_org_id => p_serviced_org_id
978 ,p_formal_com_filed => p_formal_com_filed
979 ,p_ack_ltr => p_ack_ltr
980 ,p_clarification_ltr_date => p_clarification_ltr_date
981 ,p_clarification_response_recvd => p_clarification_response_recvd
982 ,p_forwarded_legal_review => p_forwarded_legal_review
983 ,p_returned_from_legal => p_returned_from_legal
984 ,p_letter_type => p_letter_type
985 ,p_letter_date => p_letter_date
986 ,p_letter_recvd => p_letter_recvd
987 ,p_investigation_source => p_investigation_source
988 ,p_investigator_recvd_req => p_investigator_recvd_req
989 ,p_agency_investigator_req => p_agency_investigator_req
990 ,p_investigator_asg => p_investigator_asg
991 ,p_investigation_start => p_investigation_start
992 ,p_investigation_end => p_investigation_end
993 ,p_investigation_extended => p_investigation_extended
994 ,p_invest_extension_desc => p_invest_extension_desc
995 ,p_agency_recvd_roi => p_agency_recvd_roi
996 ,p_comrep_recvd_roi => p_comrep_recvd_roi
997 ,p_options_ltr_date => p_options_ltr_date
998 ,p_comrep_recvd_opt_ltr => p_comrep_recvd_opt_ltr
999 ,p_comrep_opt_ltr_response => p_comrep_opt_ltr_response
1000 ,p_resolution_offer => p_resolution_offer
1001 ,p_comrep_resol_offer_recvd => p_comrep_resol_offer_recvd
1002 ,p_comrep_resol_offer_response => p_comrep_resol_offer_response
1003 ,p_comrep_resol_offer_desc => p_comrep_resol_offer_desc
1004 ,p_resol_offer_signed => p_resol_offer_signed
1005 ,p_resol_offer_desc => p_resol_offer_desc
1006 ,p_hearing_source => p_hearing_source
1007 ,p_agency_notified_hearing => p_agency_notified_hearing
1008 ,p_eeoc_hearing_docket_num => p_eeoc_hearing_docket_num
1009 ,p_hearing_complete => p_hearing_complete
1010 ,p_aj_merit_decision_date => p_aj_merit_decision_date
1011 ,p_agency_recvd_aj_merit_dec => p_agency_recvd_aj_merit_dec
1012 ,p_aj_merit_decision => p_aj_merit_decision
1013 ,p_aj_ca_decision_date => p_aj_ca_decision_date
1014 ,p_agency_recvd_aj_ca_dec => p_agency_recvd_aj_ca_dec
1015 ,p_aj_ca_decision => p_aj_ca_decision
1016 ,p_fad_requested => p_fad_requested
1017 ,p_merit_fad => p_merit_fad
1018 ,p_attorney_fees_fad => p_attorney_fees_fad
1019 ,p_comp_damages_fad => p_comp_damages_fad
1020 ,p_non_compliance_fad => p_non_compliance_fad
1021 ,p_fad_req_recvd_eeo_office => p_fad_req_recvd_eeo_office
1022 ,p_fad_req_forwd_to_agency => p_fad_req_forwd_to_agency
1023 ,p_agency_recvd_request => p_agency_recvd_request
1024 ,p_fad_due => p_fad_due
1025 ,p_fad_date => p_fad_date
1026 ,p_fad_decision => p_fad_decision
1027 --,p_fad_final_action_closure => p_fad_final_action_closure
1028 ,p_fad_forwd_to_comrep => p_fad_forwd_to_comrep
1029 ,p_fad_recvd_by_comrep => p_fad_recvd_by_comrep
1030 ,p_fad_imp_ltr_forwd_to_org => p_fad_imp_ltr_forwd_to_org
1031 ,p_fad_decision_forwd_legal => p_fad_decision_forwd_legal
1032 ,p_fad_decision_recvd_legal => p_fad_decision_recvd_legal
1033 ,p_fa_source => p_fa_source
1034 ,p_final_action_due => p_final_action_due
1035 --,p_final_action_nature_of_closu => p_final_action_nature_of_closu
1036 ,p_final_act_forwd_comrep => p_final_act_forwd_comrep
1037 ,p_final_act_recvd_comrep => p_final_act_recvd_comrep
1038 ,p_final_action_decision_date => p_final_action_decision_date
1039 ,p_final_action_decision => p_final_action_decision
1040 ,p_fa_imp_ltr_forwd_to_org => p_fa_imp_ltr_forwd_to_org
1041 ,p_fa_decision_forwd_legal => p_fa_decision_forwd_legal
1042 ,p_fa_decision_recvd_legal => p_fa_decision_recvd_legal
1043 ,p_civil_action_filed => p_civil_action_filed
1044 ,p_agency_closure_confirmed => p_agency_closure_confirmed
1045 ,p_consolidated_complaint_id => p_consolidated_complaint_id
1046 ,p_consolidated => p_consolidated
1047 ,p_stage_of_consolidation => p_stage_of_consolidation
1048 ,p_comrep_notif_consolidation => p_comrep_notif_consolidation
1049 ,p_consolidation_desc => p_consolidation_desc
1050 ,p_complaint_closed => p_complaint_closed
1051 ,p_nature_of_closure => p_nature_of_closure
1052 ,p_complaint_closed_desc => p_complaint_closed_desc
1053 ,p_filed_formal_class => p_filed_formal_class
1054 ,p_forwd_eeoc => p_forwd_eeoc
1055 ,p_aj_cert_decision_date => p_aj_cert_decision_date
1056 ,p_aj_cert_decision_recvd => p_aj_cert_decision_recvd
1057 ,p_aj_cert_decision => p_aj_cert_decision
1058 ,p_class_members_notified => p_class_members_notified
1059 ,p_number_of_complaintants => p_number_of_complaintants
1060 ,p_class_hearing => p_class_hearing
1061 ,p_aj_dec => p_aj_dec
1062 ,p_agency_recvd_aj_dec => p_agency_recvd_aj_dec
1063 ,p_aj_decision => p_aj_decision
1064 ,p_agency_brief_eeoc => p_agency_brief_eeoc
1065 ,p_agency_notif_of_civil_action => p_agency_notif_of_civil_action
1066 ,p_fad_source => p_fad_source
1067 ,p_agency_files_forwarded_eeoc => p_agency_files_forwarded_eeoc
1068 ,p_hearing_req => p_hearing_req
1069 ,p_agency_code => p_agency_code
1070 ,p_audited_by => p_audited_by
1071 ,p_record_received => p_record_received
1072 ,p_attribute_category => p_attribute_category
1073 ,p_attribute1 => p_attribute1
1074 ,p_attribute2 => p_attribute2
1075 ,p_attribute3 => p_attribute3
1076 ,p_attribute4 => p_attribute4
1077 ,p_attribute5 => p_attribute5
1078 ,p_attribute6 => p_attribute6
1079 ,p_attribute7 => p_attribute7
1080 ,p_attribute8 => p_attribute8
1081 ,p_attribute9 => p_attribute9
1082 ,p_attribute10 => p_attribute10
1083 ,p_attribute11 => p_attribute11
1084 ,p_attribute12 => p_attribute12
1085 ,p_attribute13 => p_attribute13
1086 ,p_attribute14 => p_attribute14
1087 ,p_attribute15 => p_attribute15
1088 ,p_attribute16 => p_attribute16
1089 ,p_attribute17 => p_attribute17
1090 ,p_attribute18 => p_attribute18
1091 ,p_attribute19 => p_attribute19
1092 ,p_attribute20 => p_attribute20
1093 ,p_attribute21 => p_attribute21
1094 ,p_attribute22 => p_attribute22
1095 ,p_attribute23 => p_attribute23
1096 ,p_attribute24 => p_attribute24
1097 ,p_attribute25 => p_attribute25
1098 ,p_attribute26 => p_attribute26
1099 ,p_attribute27 => p_attribute27
1100 ,p_attribute28 => p_attribute28
1101 ,p_attribute29 => p_attribute29
1102 ,p_attribute30 => p_attribute30
1103 );
1104 exception
1105 when hr_api.cannot_find_prog_unit then
1106 hr_api.cannot_find_prog_unit_error
1107 (p_module_name => 'Update_Complaint'
1108 ,p_hook_type => 'BP'
1109 );
1110 end;
1111 hr_utility.set_location(l_proc, 30);
1112 --
1113 -- Validation in addition to Row Handlers
1114 --
1115 -- Store the original ovn in case we rollback when p_validate is true
1116 --
1117 l_object_version_number := p_object_version_number;
1118
1119 hr_utility.set_location(l_proc, 40);
1120 --
1121 -- Process Logic
1122 --
1123 ghr_cmp_upd.upd
1124 (p_effective_date => p_effective_date
1125 ,p_complaint_id => p_complaint_id
1126 ,p_object_version_number => l_object_version_number
1127 ,p_complainant_person_id => p_complainant_person_id
1128 ,p_business_group_id => p_business_group_id
1129 ,p_docket_number => p_docket_number
1130 ,p_stage => p_stage
1131 ,p_class_flag => p_class_flag
1132 ,p_mixed_flag => p_mixed_flag
1133 ,p_consolidated_flag => p_consolidated_flag
1134 ,p_remand_flag => p_remand_flag
1135 ,p_active_flag => p_active_flag
1136 ,p_information_inquiry => p_information_inquiry
1137 ,p_pcom_init => p_pcom_init
1138 ,p_alleg_incident => p_alleg_incident
1139 ,p_alleg_discrim_org_id => p_alleg_discrim_org_id
1140 ,p_rr_ltr_date => p_rr_ltr_date
1141 ,p_rr_ltr_recvd => p_rr_ltr_recvd
1142 ,p_pre_com_elec => p_pre_com_elec
1143 --,p_adr_offered => p_adr_offered
1144 ,p_class_agent_flag => p_class_agent_flag
1145 ,p_pre_com_desc => p_pre_com_desc
1146 ,p_counselor_asg => p_counselor_asg
1147 ,p_init_counselor_interview => p_init_counselor_interview
1148 ,p_anonymity_requested => p_anonymity_requested
1149 ,p_counsel_ext_ltr => p_counsel_ext_ltr
1150 ,p_traditional_counsel_outcome => p_traditional_counsel_outcome
1151 ,p_final_interview => p_final_interview
1152 ,p_notice_rtf_recvd => p_notice_rtf_recvd
1153 ,p_precom_closed => p_precom_closed
1154 ,p_precom_closure_nature => p_precom_closure_nature
1155 ,p_counselor_rpt_sub => p_counselor_rpt_sub
1156 ,p_hr_office_org_id => p_hr_office_org_id
1157 ,p_eeo_office_org_id => p_eeo_office_org_id
1158 ,p_serviced_org_id => p_serviced_org_id
1159 ,p_formal_com_filed => p_formal_com_filed
1160 ,p_ack_ltr => p_ack_ltr
1161 ,p_clarification_ltr_date => p_clarification_ltr_date
1162 ,p_clarification_response_recvd => p_clarification_response_recvd
1163 ,p_forwarded_legal_review => p_forwarded_legal_review
1164 ,p_returned_from_legal => p_returned_from_legal
1165 ,p_letter_type => p_letter_type
1166 ,p_letter_date => p_letter_date
1167 ,p_letter_recvd => p_letter_recvd
1168 ,p_investigation_source => p_investigation_source
1169 ,p_investigator_recvd_req => p_investigator_recvd_req
1170 ,p_agency_investigator_req => p_agency_investigator_req
1171 ,p_investigator_asg => p_investigator_asg
1172 ,p_investigation_start => p_investigation_start
1173 ,p_investigation_end => p_investigation_end
1174 ,p_investigation_extended => p_investigation_extended
1175 ,p_invest_extension_desc => p_invest_extension_desc
1176 ,p_agency_recvd_roi => p_agency_recvd_roi
1177 ,p_comrep_recvd_roi => p_comrep_recvd_roi
1178 ,p_options_ltr_date => p_options_ltr_date
1179 ,p_comrep_recvd_opt_ltr => p_comrep_recvd_opt_ltr
1180 ,p_comrep_opt_ltr_response => p_comrep_opt_ltr_response
1181 ,p_resolution_offer => p_resolution_offer
1182 ,p_comrep_resol_offer_recvd => p_comrep_resol_offer_recvd
1183 ,p_comrep_resol_offer_response => p_comrep_resol_offer_response
1184 ,p_comrep_resol_offer_desc => p_comrep_resol_offer_desc
1185 ,p_resol_offer_signed => p_resol_offer_signed
1186 ,p_resol_offer_desc => p_resol_offer_desc
1187 ,p_hearing_source => p_hearing_source
1188 ,p_agency_notified_hearing => p_agency_notified_hearing
1189 ,p_eeoc_hearing_docket_num => p_eeoc_hearing_docket_num
1190 ,p_hearing_complete => p_hearing_complete
1191 ,p_aj_merit_decision_date => p_aj_merit_decision_date
1192 ,p_agency_recvd_aj_merit_dec => p_agency_recvd_aj_merit_dec
1193 ,p_aj_merit_decision => p_aj_merit_decision
1194 ,p_aj_ca_decision_date => p_aj_ca_decision_date
1195 ,p_agency_recvd_aj_ca_dec => p_agency_recvd_aj_ca_dec
1196 ,p_aj_ca_decision => p_aj_ca_decision
1197 ,p_fad_requested => p_fad_requested
1198 ,p_merit_fad => p_merit_fad
1199 ,p_attorney_fees_fad => p_attorney_fees_fad
1200 ,p_comp_damages_fad => p_comp_damages_fad
1201 ,p_non_compliance_fad => p_non_compliance_fad
1202 ,p_fad_req_recvd_eeo_office => p_fad_req_recvd_eeo_office
1203 ,p_fad_req_forwd_to_agency => p_fad_req_forwd_to_agency
1204 ,p_agency_recvd_request => p_agency_recvd_request
1205 ,p_fad_due => p_fad_due
1206 ,p_fad_date => p_fad_date
1207 ,p_fad_decision => p_fad_decision
1208 --,p_fad_final_action_closure => p_fad_final_action_closure
1209 ,p_fad_forwd_to_comrep => p_fad_forwd_to_comrep
1210 ,p_fad_recvd_by_comrep => p_fad_recvd_by_comrep
1211 ,p_fad_imp_ltr_forwd_to_org => p_fad_imp_ltr_forwd_to_org
1212 ,p_fad_decision_forwd_legal => p_fad_decision_forwd_legal
1213 ,p_fad_decision_recvd_legal => p_fad_decision_recvd_legal
1214 ,p_fa_source => p_fa_source
1215 ,p_final_action_due => p_final_action_due
1216 --,p_final_action_nature_of_closu => p_final_action_nature_of_closu
1217 ,p_final_act_forwd_comrep => p_final_act_forwd_comrep
1218 ,p_final_act_recvd_comrep => p_final_act_recvd_comrep
1219 ,p_final_action_decision_date => p_final_action_decision_date
1220 ,p_final_action_decision => p_final_action_decision
1221 ,p_fa_imp_ltr_forwd_to_org => p_fa_imp_ltr_forwd_to_org
1222 ,p_fa_decision_forwd_legal => p_fa_decision_forwd_legal
1223 ,p_fa_decision_recvd_legal => p_fa_decision_recvd_legal
1224 ,p_civil_action_filed => p_civil_action_filed
1225 ,p_agency_closure_confirmed => p_agency_closure_confirmed
1226 ,p_consolidated_complaint_id => p_consolidated_complaint_id
1227 ,p_consolidated => p_consolidated
1228 ,p_stage_of_consolidation => p_stage_of_consolidation
1229 ,p_comrep_notif_consolidation => p_comrep_notif_consolidation
1230 ,p_consolidation_desc => p_consolidation_desc
1231 ,p_complaint_closed => p_complaint_closed
1232 ,p_nature_of_closure => p_nature_of_closure
1233 ,p_complaint_closed_desc => p_complaint_closed_desc
1234 ,p_filed_formal_class => p_filed_formal_class
1235 ,p_forwd_eeoc => p_forwd_eeoc
1236 ,p_aj_cert_decision_date => p_aj_cert_decision_date
1237 ,p_aj_cert_decision_recvd => p_aj_cert_decision_recvd
1238 ,p_aj_cert_decision => p_aj_cert_decision
1239 ,p_class_members_notified => p_class_members_notified
1240 ,p_number_of_complaintants => p_number_of_complaintants
1241 ,p_class_hearing => p_class_hearing
1242 ,p_aj_dec => p_aj_dec
1243 ,p_agency_recvd_aj_dec => p_agency_recvd_aj_dec
1244 ,p_aj_decision => p_aj_decision
1245 ,p_agency_brief_eeoc => p_agency_brief_eeoc
1246 ,p_agency_notif_of_civil_action => p_agency_notif_of_civil_action
1247 ,p_fad_source => p_fad_source
1248 ,p_agency_files_forwarded_eeoc => p_agency_files_forwarded_eeoc
1249 ,p_hearing_req => p_hearing_req
1250 ,p_agency_code => p_agency_code
1251 ,p_audited_by => p_audited_by
1252 ,p_record_received => p_record_received
1253 ,p_attribute_category => p_attribute_category
1254 ,p_attribute1 => p_attribute1
1255 ,p_attribute2 => p_attribute2
1256 ,p_attribute3 => p_attribute3
1257 ,p_attribute4 => p_attribute4
1258 ,p_attribute5 => p_attribute5
1259 ,p_attribute6 => p_attribute6
1260 ,p_attribute7 => p_attribute7
1261 ,p_attribute8 => p_attribute8
1262 ,p_attribute9 => p_attribute9
1263 ,p_attribute10 => p_attribute10
1264 ,p_attribute11 => p_attribute11
1265 ,p_attribute12 => p_attribute12
1266 ,p_attribute13 => p_attribute13
1267 ,p_attribute14 => p_attribute14
1268 ,p_attribute15 => p_attribute15
1269 ,p_attribute16 => p_attribute16
1270 ,p_attribute17 => p_attribute17
1271 ,p_attribute18 => p_attribute18
1272 ,p_attribute19 => p_attribute19
1273 ,p_attribute20 => p_attribute20
1274 ,p_attribute21 => p_attribute21
1275 ,p_attribute22 => p_attribute22
1276 ,p_attribute23 => p_attribute23
1277 ,p_attribute24 => p_attribute24
1278 ,p_attribute25 => p_attribute25
1279 ,p_attribute26 => p_attribute26
1280 ,p_attribute27 => p_attribute27
1281 ,p_attribute28 => p_attribute28
1282 ,p_attribute29 => p_attribute29
1283 ,p_attribute30 => p_attribute30
1284 );
1285
1286 hr_utility.set_location(l_proc, 50);
1287 --
1288 -- Call After Process User Hook
1289 --
1290 begin
1291 GHR_COMPLAINT_BK_2.update_complaint_a
1292 (p_effective_date => trunc(p_effective_date)
1293 ,p_business_group_id => p_business_group_id
1294 ,p_complaint_id => p_complaint_id
1295 ,p_object_version_number => p_object_version_number
1296 ,p_complainant_person_id => p_complainant_person_id
1297 ,p_docket_number => p_docket_number
1298 ,p_stage => p_stage
1299 ,p_class_flag => p_class_flag
1300 ,p_mixed_flag => p_mixed_flag
1301 ,p_consolidated_flag => p_consolidated_flag
1302 ,p_remand_flag => p_remand_flag
1303 ,p_active_flag => p_active_flag
1304 ,p_information_inquiry => p_information_inquiry
1305 ,p_pcom_init => p_pcom_init
1306 ,p_alleg_incident => p_alleg_incident
1307 ,p_alleg_discrim_org_id => p_alleg_discrim_org_id
1308 ,p_rr_ltr_date => p_rr_ltr_date
1309 ,p_rr_ltr_recvd => p_rr_ltr_recvd
1310 ,p_pre_com_elec => p_pre_com_elec
1311 --,p_adr_offered => p_adr_offered
1312 ,p_class_agent_flag => p_class_agent_flag
1313 ,p_pre_com_desc => p_pre_com_desc
1314 ,p_counselor_asg => p_counselor_asg
1315 ,p_init_counselor_interview => p_init_counselor_interview
1316 ,p_anonymity_requested => p_anonymity_requested
1317 ,p_counsel_ext_ltr => p_counsel_ext_ltr
1318 ,p_traditional_counsel_outcome => p_traditional_counsel_outcome
1319 ,p_final_interview => p_final_interview
1320 ,p_notice_rtf_recvd => p_notice_rtf_recvd
1321 ,p_precom_closed => p_precom_closed
1322 ,p_precom_closure_nature => p_precom_closure_nature
1323 ,p_counselor_rpt_sub => p_counselor_rpt_sub
1324 ,p_hr_office_org_id => p_hr_office_org_id
1325 ,p_eeo_office_org_id => p_eeo_office_org_id
1326 ,p_serviced_org_id => p_serviced_org_id
1327 ,p_formal_com_filed => p_formal_com_filed
1328 ,p_ack_ltr => p_ack_ltr
1329 ,p_clarification_ltr_date => p_clarification_ltr_date
1330 ,p_clarification_response_recvd => p_clarification_response_recvd
1331 ,p_forwarded_legal_review => p_forwarded_legal_review
1332 ,p_returned_from_legal => p_returned_from_legal
1333 ,p_letter_type => p_letter_type
1334 ,p_letter_date => p_letter_date
1335 ,p_letter_recvd => p_letter_recvd
1336 ,p_investigation_source => p_investigation_source
1337 ,p_investigator_recvd_req => p_investigator_recvd_req
1338 ,p_agency_investigator_req => p_agency_investigator_req
1339 ,p_investigator_asg => p_investigator_asg
1340 ,p_investigation_start => p_investigation_start
1341 ,p_investigation_end => p_investigation_end
1342 ,p_investigation_extended => p_investigation_extended
1343 ,p_invest_extension_desc => p_invest_extension_desc
1344 ,p_agency_recvd_roi => p_agency_recvd_roi
1345 ,p_comrep_recvd_roi => p_comrep_recvd_roi
1346 ,p_options_ltr_date => p_options_ltr_date
1347 ,p_comrep_recvd_opt_ltr => p_comrep_recvd_opt_ltr
1348 ,p_comrep_opt_ltr_response => p_comrep_opt_ltr_response
1349 ,p_resolution_offer => p_resolution_offer
1350 ,p_comrep_resol_offer_recvd => p_comrep_resol_offer_recvd
1351 ,p_comrep_resol_offer_response => p_comrep_resol_offer_response
1352 ,p_comrep_resol_offer_desc => p_comrep_resol_offer_desc
1353 ,p_resol_offer_signed => p_resol_offer_signed
1354 ,p_resol_offer_desc => p_resol_offer_desc
1355 ,p_hearing_source => p_hearing_source
1356 ,p_agency_notified_hearing => p_agency_notified_hearing
1357 ,p_eeoc_hearing_docket_num => p_eeoc_hearing_docket_num
1358 ,p_hearing_complete => p_hearing_complete
1359 ,p_aj_merit_decision_date => p_aj_merit_decision_date
1360 ,p_agency_recvd_aj_merit_dec => p_agency_recvd_aj_merit_dec
1361 ,p_aj_merit_decision => p_aj_merit_decision
1362 ,p_aj_ca_decision_date => p_aj_ca_decision_date
1363 ,p_agency_recvd_aj_ca_dec => p_agency_recvd_aj_ca_dec
1364 ,p_aj_ca_decision => p_aj_ca_decision
1365 ,p_fad_requested => p_fad_requested
1366 ,p_merit_fad => p_merit_fad
1367 ,p_attorney_fees_fad => p_attorney_fees_fad
1368 ,p_comp_damages_fad => p_comp_damages_fad
1369 ,p_non_compliance_fad => p_non_compliance_fad
1370 ,p_fad_req_recvd_eeo_office => p_fad_req_recvd_eeo_office
1371 ,p_fad_req_forwd_to_agency => p_fad_req_forwd_to_agency
1372 ,p_agency_recvd_request => p_agency_recvd_request
1373 ,p_fad_due => p_fad_due
1374 ,p_fad_date => p_fad_date
1375 ,p_fad_decision => p_fad_decision
1376 --,p_fad_final_action_closure => p_fad_final_action_closure
1377 ,p_fad_forwd_to_comrep => p_fad_forwd_to_comrep
1378 ,p_fad_recvd_by_comrep => p_fad_recvd_by_comrep
1379 ,p_fad_imp_ltr_forwd_to_org => p_fad_imp_ltr_forwd_to_org
1380 ,p_fad_decision_forwd_legal => p_fad_decision_forwd_legal
1381 ,p_fad_decision_recvd_legal => p_fad_decision_recvd_legal
1382 ,p_fa_source => p_fa_source
1383 ,p_final_action_due => p_final_action_due
1384 --,p_final_action_nature_of_closu => p_final_action_nature_of_closu
1385 ,p_final_act_forwd_comrep => p_final_act_forwd_comrep
1386 ,p_final_act_recvd_comrep => p_final_act_recvd_comrep
1387 ,p_final_action_decision_date => p_final_action_decision_date
1388 ,p_final_action_decision => p_final_action_decision
1389 ,p_fa_imp_ltr_forwd_to_org => p_fa_imp_ltr_forwd_to_org
1390 ,p_fa_decision_forwd_legal => p_fa_decision_forwd_legal
1391 ,p_fa_decision_recvd_legal => p_fa_decision_recvd_legal
1392 ,p_civil_action_filed => p_civil_action_filed
1393 ,p_agency_closure_confirmed => p_agency_closure_confirmed
1394 ,p_consolidated_complaint_id => p_consolidated_complaint_id
1395 ,p_consolidated => p_consolidated
1396 ,p_stage_of_consolidation => p_stage_of_consolidation
1397 ,p_comrep_notif_consolidation => p_comrep_notif_consolidation
1398 ,p_consolidation_desc => p_consolidation_desc
1399 ,p_complaint_closed => p_complaint_closed
1400 ,p_nature_of_closure => p_nature_of_closure
1401 ,p_complaint_closed_desc => p_complaint_closed_desc
1402 ,p_filed_formal_class => p_filed_formal_class
1403 ,p_forwd_eeoc => p_forwd_eeoc
1404 ,p_aj_cert_decision_date => p_aj_cert_decision_date
1405 ,p_aj_cert_decision_recvd => p_aj_cert_decision_recvd
1406 ,p_aj_cert_decision => p_aj_cert_decision
1407 ,p_class_members_notified => p_class_members_notified
1408 ,p_number_of_complaintants => p_number_of_complaintants
1409 ,p_class_hearing => p_class_hearing
1410 ,p_aj_dec => p_aj_dec
1411 ,p_agency_recvd_aj_dec => p_agency_recvd_aj_dec
1412 ,p_aj_decision => p_aj_decision
1413 ,p_agency_brief_eeoc => p_agency_brief_eeoc
1414 ,p_agency_notif_of_civil_action => p_agency_notif_of_civil_action
1415 ,p_fad_source => p_fad_source
1416 ,p_agency_files_forwarded_eeoc => p_agency_files_forwarded_eeoc
1417 ,p_hearing_req => p_hearing_req
1418 ,p_agency_code => p_agency_code
1419 ,p_audited_by => p_audited_by
1420 ,p_record_received => p_record_received
1421 ,p_attribute_category => p_attribute_category
1422 ,p_attribute1 => p_attribute1
1423 ,p_attribute2 => p_attribute2
1424 ,p_attribute3 => p_attribute3
1425 ,p_attribute4 => p_attribute4
1426 ,p_attribute5 => p_attribute5
1427 ,p_attribute6 => p_attribute6
1428 ,p_attribute7 => p_attribute7
1429 ,p_attribute8 => p_attribute8
1430 ,p_attribute9 => p_attribute9
1431 ,p_attribute10 => p_attribute10
1432 ,p_attribute11 => p_attribute11
1433 ,p_attribute12 => p_attribute12
1434 ,p_attribute13 => p_attribute13
1435 ,p_attribute14 => p_attribute14
1436 ,p_attribute15 => p_attribute15
1437 ,p_attribute16 => p_attribute16
1438 ,p_attribute17 => p_attribute17
1439 ,p_attribute18 => p_attribute18
1440 ,p_attribute19 => p_attribute19
1441 ,p_attribute20 => p_attribute20
1442 ,p_attribute21 => p_attribute21
1443 ,p_attribute22 => p_attribute22
1444 ,p_attribute23 => p_attribute23
1445 ,p_attribute24 => p_attribute24
1446 ,p_attribute25 => p_attribute25
1447 ,p_attribute26 => p_attribute26
1448 ,p_attribute27 => p_attribute27
1449 ,p_attribute28 => p_attribute28
1450 ,p_attribute29 => p_attribute29
1451 ,p_attribute30 => p_attribute30
1452 );
1453 exception
1454 when hr_api.cannot_find_prog_unit then
1455 hr_api.cannot_find_prog_unit_error
1456 (p_module_name => 'Update_Complaint'
1457 ,p_hook_type => 'AP'
1458 );
1459 end;
1460 hr_utility.set_location(l_proc, 60);
1461 --
1462 -- When in validation only mode raise the Validate_Enabled exception
1463 --
1464 if p_validate then
1465 raise hr_api.validate_enabled;
1466 end if;
1467 --
1468 -- Set all output arguments
1469 --
1470 p_object_version_number := l_object_version_number;
1471 --
1472 hr_utility.set_location(' Leaving:'||l_proc, 70);
1473 exception
1474 when hr_api.validate_enabled then
1475 --
1476 -- As the Validate_Enabled exception has been raised
1477 -- we must rollback to the savepoint
1478 --
1479 rollback to update_complaint;
1480 --
1481 -- Only set output warning arguments
1482 -- (Any key or derived arguments must be set to null
1483 -- when validation only mode is being used.)
1484 --
1485 l_object_version_number := p_object_version_number;
1486 hr_utility.set_location(' Leaving:'||l_proc, 80);
1487 when others then
1488 --
1489 -- A validation or unexpected error has occured
1490 --
1491 rollback to update_complaint;
1492 --RESET In/Out Params and SET Out Params
1493 l_object_version_number := p_object_version_number;
1494 hr_utility.set_location(' Leaving:'||l_proc, 90);
1495 raise;
1496 end update_complaint;
1497
1498 end ghr_complaint_api;