[Home] [Help]
PACKAGE: APPS.GHR_COMPLAINT_API
Source
1 Package ghr_complaint_api as
2 /* $Header: ghcmpapi.pkh 120.2 2006/01/11 10:26:12 jmhyer noship $ */
3 /*#
4 * This package contains the procedures for creating and updating GHR
5 * Complaints Tracking Complaint records.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Complaint
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------------< create_complaint >-------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a Complaints Tracking Complaint record.
18 *
19 * This API creates a Complaint record for a person or class action in table
20 * ghr_complaints2.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Human Resources.
24 *
25 * <p><b>Prerequisites</b><br>
26 * The business group and persons must exist on the effective date.
27 *
28 * <p><b>Post Success</b><br>
29 * The API creates a Complaint record in the database.
30 *
31 * <p><b>Post Failure</b><br>
32 * The API does not create the Complaint record and an error is raised.
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_effective_date Reference date for validating lookup values are
37 * applicable during the start to end active date range. This date does not
38 * determine when the changes take effect.
39 * @param p_complainant_person_id Uniquely identifies the Complainant Person.
40 * @param p_business_group_id Uniquely identifies the Business Group.
41 * @param p_docket_number {@rep:casecolumn GHR_COMPLAINTS2.DOCKET_NUMBER}
42 * @param p_stage Complaint Stage. Valid values are defined by
43 * 'GHR_US_HEADER_STAGE' lookup type.
44 * @param p_class_flag {@rep:casecolumn GHR_COMPLAINTS2.CLASS_FLAG}
45 * @param p_mixed_flag {@rep:casecolumn GHR_COMPLAINTS2.MIXED_FLAG}
46 * @param p_consolidated_flag {@rep:casecolumn
47 * GHR_COMPLAINTS2.CONSOLIDATED_FLAG}
48 * @param p_remand_flag {@rep:casecolumn GHR_COMPLAINTS2.REMAND_FLAG}
49 * @param p_active_flag {@rep:casecolumn GHR_COMPLAINTS2.ACTIVE_FLAG}
50 * @param p_information_inquiry {@rep:casecolumn
51 * GHR_COMPLAINTS2.INFORMATION_INQUIRY}
52 * @param p_pcom_init {@rep:casecolumn GHR_COMPLAINTS2.PCOM_INIT}
53 * @param p_alleg_incident {@rep:casecolumn GHR_COMPLAINTS2.ALLEG_INCIDENT}
54 * @param p_rr_ltr_date {@rep:casecolumn GHR_COMPLAINTS2.RR_LTR_DATE}
55 * @param p_rr_ltr_recvd {@rep:casecolumn GHR_COMPLAINTS2.RR_LTR_RECVD}
56 * @param p_pre_com_elec Complaint Pre-Complaint Election. Valid values are
57 * defined by 'GHR_US_PRE_COMP_ELECTION' lookup type.
58 * @param p_class_agent_flag {@rep:casecolumn GHR_COMPLAINTS2.CLASS_AGENT_FLAG}
59 * @param p_pre_com_desc {@rep:casecolumn GHR_COMPLAINTS2.PRE_COM_DESC}
60 * @param p_counselor_asg {@rep:casecolumn GHR_COMPLAINTS2.COUNSELOR_ASG}
61 * @param p_init_counselor_interview {@rep:casecolumn
62 * GHR_COMPLAINTS2.INIT_COUNSELOR_INTERVIEW}
63 * @param p_anonymity_requested {@rep:casecolumn
64 * GHR_COMPLAINTS2.ANONYMITY_REQUESTED}
65 * @param p_counsel_ext_ltr {@rep:casecolumn GHR_COMPLAINTS2.COUNSEL_EXT_LTR}
66 * @param p_traditional_counsel_outcome Complaint Traditional Counseling
67 * Outcome. Valid values are defined by 'GHR_US_COUNSEL_OUTCOME' lookup type.
68 * @param p_final_interview {@rep:casecolumn GHR_COMPLAINTS2.FINAL_INTERVIEW}
69 * @param p_notice_rtf_recvd {@rep:casecolumn GHR_COMPLAINTS2.NOTICE_RTF_RECVD}
70 * @param p_precom_closed {@rep:casecolumn GHR_COMPLAINTS2.PRECOM_CLOSED}
71 * @param p_precom_closure_nature Complaint Pre-Complaint Nature of Closure.
72 * Valid values are defined by 'GHR_US_NATURE_OF_CLOSURE' lookup type.
73 * @param p_counselor_rpt_sub {@rep:casecolumn
74 * GHR_COMPLAINTS2.COUNSELOR_RPT_SUB}
75 * @param p_formal_com_filed {@rep:casecolumn GHR_COMPLAINTS2.FORMAL_COM_FILED}
76 * @param p_ack_ltr {@rep:casecolumn GHR_COMPLAINTS2.ACK_LTR}
77 * @param p_clarification_ltr_date {@rep:casecolumn
78 * GHR_COMPLAINTS2.CLARIFICATION_LTR_DATE}
79 * @param p_clarification_response_recvd {@rep:casecolumn
80 * GHR_COMPLAINTS2.CLARIFICATION_RESPONSE_RECVD}
81 * @param p_forwarded_legal_review {@rep:casecolumn
82 * GHR_COMPLAINTS2.FORWARDED_LEGAL_REVIEW}
83 * @param p_returned_from_legal {@rep:casecolumn
84 * GHR_COMPLAINTS2.RETURNED_FROM_LEGAL}
85 * @param p_letter_type Complaint Letter Type. Valid values are defined by
86 * 'GHR_US_LETTER_TYPE' lookup type.
87 * @param p_letter_date {@rep:casecolumn GHR_COMPLAINTS2.LETTER_DATE}
88 * @param p_letter_recvd {@rep:casecolumn GHR_COMPLAINTS2.LETTER_RECVD}
89 * @param p_investigation_source Complaint Investigation Source. Valid values
90 * are defined by 'GHR_US_COMPLAINT_SOURCE' lookup type.
91 * @param p_investigator_recvd_req {@rep:casecolumn
92 * GHR_COMPLAINTS2.INVESTIGATOR_RECVD_REQ}
93 * @param p_agency_investigator_req {@rep:casecolumn
94 * GHR_COMPLAINTS2.AGENCY_INVESTIGATOR_REQ}
95 * @param p_investigator_asg {@rep:casecolumn GHR_COMPLAINTS2.INVESTIGATOR_ASG}
96 * @param p_investigation_start {@rep:casecolumn
97 * GHR_COMPLAINTS2.INVESTIGATION_START}
98 * @param p_investigation_end {@rep:casecolumn
99 * GHR_COMPLAINTS2.INVESTIGATION_END}
100 * @param p_investigation_extended {@rep:casecolumn
101 * GHR_COMPLAINTS2.INVESTIGATION_EXTENDED}
102 * @param p_invest_extension_desc Complaint Investigation Extension
103 * Description. Valid values are defined by 'GHR_US_EXTENSION_DESC' lookup
104 * type.
105 * @param p_agency_recvd_roi {@rep:casecolumn GHR_COMPLAINTS2.AGENCY_RECVD_ROI}
106 * @param p_comrep_recvd_roi {@rep:casecolumn GHR_COMPLAINTS2.COMREP_RECVD_ROI}
107 * @param p_options_ltr_date {@rep:casecolumn GHR_COMPLAINTS2.OPTIONS_LTR_DATE}
108 * @param p_comrep_recvd_opt_ltr {@rep:casecolumn
109 * GHR_COMPLAINTS2.COMREP_RECVD_OPT_LTR}
110 * @param p_comrep_opt_ltr_response Complaint Complainant Representative
111 * Options Letter Response. Valid values are defined by
112 * 'GHR_US_OPTIONS_RESPONSE' lookup type.
113 * @param p_resolution_offer {@rep:casecolumn GHR_COMPLAINTS2.RESOLUTION_OFFER}
114 * @param p_comrep_resol_offer_recvd {@rep:casecolumn
115 * GHR_COMPLAINTS2.COMREP_RESOL_OFFER_RECVD}
116 * @param p_comrep_resol_offer_response {@rep:casecolumn
117 * GHR_COMPLAINTS2.COMREP_RESOL_OFFER_RESPONSE}
118 * @param p_comrep_resol_offer_desc Complaint Complainant Representative
119 * Resolution Offer Description. Valid values are defined by
120 * 'GHR_US_RESOLUTION_RESP' lookup type.
121 * @param p_resol_offer_signed {@rep:casecolumn
122 * GHR_COMPLAINTS2.RESOL_OFFER_SIGNED}
123 * @param p_resol_offer_desc {@rep:casecolumn GHR_COMPLAINTS2.RESOL_OFFER_DESC}
124 * @param p_hearing_source Complaint Hearing Source. Valid values are defined
125 * by 'GHR_US_COMPLAINT_SOURCE' lookup type.
126 * @param p_agency_notified_hearing {@rep:casecolumn
127 * GHR_COMPLAINTS2.AGENCY_NOTIFIED_HEARING}
128 * @param p_eeoc_hearing_docket_num {@rep:casecolumn
129 * GHR_COMPLAINTS2.EEOC_HEARING_DOCKET_NUM}
130 * @param p_hearing_complete {@rep:casecolumn GHR_COMPLAINTS2.HEARING_COMPLETE}
131 * @param p_aj_merit_decision_date {@rep:casecolumn
132 * GHR_COMPLAINTS2.AJ_MERIT_DECISION_DATE}
133 * @param p_agency_recvd_aj_merit_dec {@rep:casecolumn
134 * GHR_COMPLAINTS2.AGENCY_RECVD_AJ_MERIT_DEC}
135 * @param p_aj_merit_decision Complaint Administrative Judge (AJ) Merit
136 * Decision. Valid values are defined by 'GHR_US_MERIT_DECISION' lookup type.
137 * @param p_aj_ca_decision_date {@rep:casecolumn
138 * GHR_COMPLAINTS2.AJ_CA_DECISION_DATE}
139 * @param p_agency_recvd_aj_ca_dec {@rep:casecolumn
140 * GHR_COMPLAINTS2.AGENCY_RECVD_AJ_CA_DEC}
141 * @param p_aj_ca_decision Complaint Administrative Judge (AJ) Corrective
142 * Action Decision. Valid values are defined by 'GHR_US_AJ_CERT_DECISION'
143 * lookup type.
144 * @param p_fad_requested {@rep:casecolumn GHR_COMPLAINTS2.FAD_REQUESTED}
145 * @param p_merit_fad {@rep:casecolumn GHR_COMPLAINTS2.MERIT_FAD}
146 * @param p_attorney_fees_fad {@rep:casecolumn
147 * GHR_COMPLAINTS2.ATTORNEY_FEES_FAD}
148 * @param p_comp_damages_fad {@rep:casecolumn GHR_COMPLAINTS2.COMP_DAMAGES_FAD}
149 * @param p_non_compliance_fad {@rep:casecolumn
150 * GHR_COMPLAINTS2.NON_COMPLIANCE_FAD}
151 * @param p_fad_req_recvd_eeo_office {@rep:casecolumn
152 * GHR_COMPLAINTS2.FAD_REQ_RECVD_EEO_OFFICE}
153 * @param p_fad_req_forwd_to_agency {@rep:casecolumn
154 * GHR_COMPLAINTS2.FAD_REQ_FORWD_TO_AGENCY}
155 * @param p_agency_recvd_request {@rep:casecolumn
156 * GHR_COMPLAINTS2.AGENCY_RECVD_REQUEST}
157 * @param p_fad_due {@rep:casecolumn GHR_COMPLAINTS2.FAD_DUE}
158 * @param p_fad_date {@rep:casecolumn GHR_COMPLAINTS2.FAD_DECISION}
159 * @param p_fad_decision Complaint Final Agency Decision (FAD). Valid values
160 * are defined by 'GHR_US_FAD_DECISION' lookup type.
161 * @param p_fad_forwd_to_comrep {@rep:casecolumn
162 * GHR_COMPLAINTS2.FAD_FORWD_TO_COMREP}
163 * @param p_fad_recvd_by_comrep {@rep:casecolumn
164 * GHR_COMPLAINTS2.FAD_RECVD_BY_COMREP}
165 * @param p_fad_imp_ltr_forwd_to_org {@rep:casecolumn
166 * GHR_COMPLAINTS2.FAD_IMP_LTR_FORWD_TO_ORG}
167 * @param p_fad_decision_forwd_legal {@rep:casecolumn
168 * GHR_COMPLAINTS2.FAD_DECISION_FORWD_LEGAL}
169 * @param p_fad_decision_recvd_legal {@rep:casecolumn
170 * GHR_COMPLAINTS2.FAD_DECISION_RECVD_LEGAL}
171 * @param p_fa_source Complaint Final Action Source. Valid values are defined
172 * by 'GHR_US_COMPLAINT_SOURCE' lookup type.
173 * @param p_final_action_due {@rep:casecolumn GHR_COMPLAINTS2.FINAL_ACTION_DUE}
174 * @param p_final_act_forwd_comrep {@rep:casecolumn
175 * GHR_COMPLAINTS2.FINAL_ACT_FORWD_COMREP}
176 * @param p_final_act_recvd_comrep {@rep:casecolumn
177 * GHR_COMPLAINTS2.FINAL_ACT_RECVD_COMREP}
178 * @param p_final_action_decision_date {@rep:casecolumn
179 * GHR_COMPLAINTS2.FINAL_ACTION_DECISION_DATE}
180 * @param p_final_action_decision Complaint Final Action Decision (FAD). Valid
181 * values are defined by 'GHR_US_FAA_DECISION' lookup type.
182 * @param p_fa_imp_ltr_forwd_to_org {@rep:casecolumn
183 * GHR_COMPLAINTS2.FA_IMP_LTR_FORWD_TO_ORG}
184 * @param p_fa_decision_forwd_legal {@rep:casecolumn
185 * GHR_COMPLAINTS2.FA_DECISION_FORWD_LEGAL}
186 * @param p_fa_decision_recvd_legal {@rep:casecolumn
187 * GHR_COMPLAINTS2.FA_DECISION_RECVD_LEGAL}
188 * @param p_civil_action_filed {@rep:casecolumn
189 * GHR_COMPLAINTS2.CIVIL_ACTION_FILED}
190 * @param p_agency_closure_confirmed {@rep:casecolumn
191 * GHR_COMPLAINTS2.AGENCY_CLOSURE_CONFIRMED}
192 * @param p_consolidated_complaint_id {@rep:casecolumn
193 * GHR_COMPLAINTS2.CONSOLIDATED_COMPLAINT_ID}
194 * @param p_consolidated {@rep:casecolumn GHR_COMPLAINTS2.CONSOLIDATED}
195 * @param p_stage_of_consolidation Complaint Stage of Consolidation. Valid
196 * values are defined by 'GHR_US_COMP_CONSOLIDATE_STAGE' lookup type.
197 * @param p_comrep_notif_consolidation {@rep:casecolumn
198 * GHR_COMPLAINTS2.COMREP_NOTIF_CONSOLIDATION}
199 * @param p_consolidation_desc {@rep:casecolumn
200 * GHR_COMPLAINTS2.CONSOLIDATION_DESC}
201 * @param p_complaint_closed {@rep:casecolumn GHR_COMPLAINTS2.COMPLAINT_CLOSED}
202 * @param p_nature_of_closure Complaint Nature of Closure. Valid values are
203 * defined by 'GHR_US_NATURE_OF_CLOSURE_2' lookup type.
204 * @param p_complaint_closed_desc {@rep:casecolumn
205 * GHR_COMPLAINTS2.COMPLAINT_CLOSED_DESC}
206 * @param p_filed_formal_class {@rep:casecolumn
207 * GHR_COMPLAINTS2.FILED_FORMAL_CLASS}
208 * @param p_forwd_eeoc {@rep:casecolumn GHR_COMPLAINTS2.FORWD_EEOC}
209 * @param p_aj_cert_decision_date {@rep:casecolumn
210 * GHR_COMPLAINTS2.AJ_CERT_DECISION_DATE}
211 * @param p_aj_cert_decision_recvd {@rep:casecolumn
212 * GHR_COMPLAINTS2.AJ_CERT_DECISION_RECVD}
213 * @param p_aj_cert_decision Complaint Administrative Judge (AJ) Certified
214 * Decision. Valid values are defined by 'GHR_US_AJ_CERT_DECISION' lookup type.
215 * @param p_class_members_notified {@rep:casecolumn
216 * GHR_COMPLAINTS2.CLASS_MEMBERS_NOTIFIED}
217 * @param p_number_of_complaintants {@rep:casecolumn
218 * GHR_COMPLAINTS2.NUMBER_OF_COMPLAINTANTS}
219 * @param p_class_hearing {@rep:casecolumn GHR_COMPLAINTS2.CLASS_HEARING}
220 * @param p_aj_dec {@rep:casecolumn GHR_COMPLAINTS2.AJ_DEC}
221 * @param p_agency_recvd_aj_dec {@rep:casecolumn
222 * GHR_COMPLAINTS2.AGENCY_RECVD_AJ_DEC}
223 * @param p_aj_decision Complaint Administrative Judge (AJ) Decision. Valid
224 * values are defined by 'GHR_US_AJ_REC_DECISION' lookup type.
225 * @param p_agency_brief_eeoc {@rep:casecolumn
226 * GHR_COMPLAINTS2.AGENCY_BRIEF_EEOC}
227 * @param p_agency_notif_of_civil_action {@rep:casecolumn
228 * GHR_COMPLAINTS2.AGENCY_NOTIF_OF_CIVIL_ACTION}
229 * @param p_fad_source Complaint Final Agency Decision (FAD) Source. Valid
230 * values are defined by 'GHR_US_COMPLAINT_SOURCE' lookup type.
231 * @param p_agency_files_forwarded_eeoc {@rep:casecolumn
232 * GHR_COMPLAINTS2.AGENCY_FILES_FORWARDED_EEOC}
233 * @param p_hearing_req {@rep:casecolumn GHR_COMPLAINTS2.HEARING_REQ}
234 * @param p_agency_code Complaint Two Character Agency Code. Valid values are
235 * defined by 'GHR_US_AGENCY_CODE_2' lookup type.
236 * @param p_complaint_id If p_validate is false, then this uniquely identifies
237 * the Complaint created. If p_validate is true, then set to null.
238 * @param p_object_version_number If p_validate is false, then set to the
239 * version number of the created Complaint. If p_validate is true, then the
240 * value will be null.
241 * @param p_audited_by {@rep:casecolumn GHR_COMPLAINTS2.AUDITED_BY}
242 * @param p_eeo_office_org_id {@rep:casecolumn
243 * GHR_COMPLAINTS2.EEO_OFFICE_ORG_ID}
244 * @param p_hr_office_org_id {@rep:casecolumn
245 * GHR_COMPLAINTS2.HR_OFFICE_ORG_ID}
246 * @param p_attribute10 Descriptive flexfield segment.
247 * @param p_attribute11 Descriptive flexfield segment.
248 * @param p_attribute12 Descriptive flexfield segment.
249 * @param p_attribute13 Descriptive flexfield segment.
250 * @param p_attribute14 Descriptive flexfield segment.
251 * @param p_attribute15 Descriptive flexfield segment.
252 * @param p_attribute16 Descriptive flexfield segment.
253 * @param p_attribute17 Descriptive flexfield segment.
254 * @param p_attribute18 Descriptive flexfield segment.
255 * @param p_attribute19 Descriptive flexfield segment.
256 * @param p_attribute20 Descriptive flexfield segment.
257 * @param p_attribute21 Descriptive flexfield segment.
258 * @param p_attribute22 Descriptive flexfield segment.
259 * @param p_attribute23 Descriptive flexfield segment.
260 * @param p_attribute24 Descriptive flexfield segment.
261 * @param p_attribute25 Descriptive flexfield segment.
262 * @param p_attribute1 Descriptive flexfield segment.
263 * @param p_attribute26 Descriptive flexfield segment.
264 * @param p_attribute2 Descriptive flexfield segment.
265 * @param p_attribute3 Descriptive flexfield segment.
266 * @param p_attribute4 Descriptive flexfield segment.
267 * @param p_attribute27 Descriptive flexfield segment.
268 * @param p_attribute5 Descriptive flexfield segment.
269 * @param p_attribute28 Descriptive flexfield segment.
270 * @param p_attribute6 Descriptive flexfield segment.
271 * @param p_attribute29 Descriptive flexfield segment.
272 * @param p_attribute7 Descriptive flexfield segment.
273 * @param p_attribute8 Descriptive flexfield segment.
274 * @param p_attribute9 Descriptive flexfield segment.
275 * @param p_attribute30 Descriptive flexfield segment.
276 * @param p_attribute_category This context value determines which flexfield
277 * structure to use with the descriptive flexfield segments.
278 * @param p_serviced_org_id {@rep:casecolumn
279 * GHR_COMPLAINTS2.SERVICED_ORG_ID}
280 * @param p_alleg_discrim_org_id {@rep:casecolumn
281 * GHR_COMPLAINTS2.ALLEG_DISCRIM_ORG_ID}
282 * @param p_record_received {@rep:casecolumn
283 * GHR_COMPLAINTS2.RECORD_RECEIVED}
284 * @rep:displayname Create Complaint
285 * @rep:category BUSINESS_ENTITY GHR_EEO_COMPLAINT
286 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
287 * @rep:scope public
288 * @rep:lifecycle active
289 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
290 */
291 --
292 -- {End Of Comments}
293 --
294 procedure create_complaint
295 (p_validate in boolean default false
296 ,p_effective_date in date
297 ,p_complainant_person_id in number default null
298 ,p_business_group_id in number default null
299 ,p_docket_number in varchar2 default null
300 ,p_stage in varchar2 default null
301 ,p_class_flag in varchar2 default null
302 ,p_mixed_flag in varchar2 default null
303 ,p_consolidated_flag in varchar2 default null
304 ,p_remand_flag in varchar2 default null
305 ,p_active_flag in varchar2 default null
306 ,p_information_inquiry in date default null
307 ,p_pcom_init in date default null
311 ,p_rr_ltr_recvd in date default null
308 ,p_alleg_incident in date default null
309 ,p_alleg_discrim_org_id in number default null
310 ,p_rr_ltr_date in date default null
312 ,p_pre_com_elec in varchar2 default null
313 --,p_adr_offered in varchar2 default null
314 ,p_class_agent_flag in varchar2 default null
315 ,p_pre_com_desc in varchar2 default null
316 ,p_counselor_asg in date default null
317 ,p_init_counselor_interview in date default null
318 ,p_anonymity_requested in varchar2 default null
319 ,p_counsel_ext_ltr in date default null
320 ,p_traditional_counsel_outcome in varchar2 default null
321 ,p_final_interview in date default null
322 ,p_notice_rtf_recvd in date default null
323 ,p_precom_closed in date default null
324 ,p_precom_closure_nature in varchar2 default null
325 ,p_counselor_rpt_sub in date default null
326 ,p_hr_office_org_id in number default null
327 ,p_eeo_office_org_id in number default null
328 ,p_serviced_org_id in number default null
329 ,p_formal_com_filed in date default null
330 ,p_ack_ltr in date default null
331 ,p_clarification_ltr_date in date default null
332 ,p_clarification_response_recvd in date default null
333 ,p_forwarded_legal_review in date default null
334 ,p_returned_from_legal in date default null
335 ,p_letter_type in varchar2 default null
336 ,p_letter_date in date default null
337 ,p_letter_recvd in date default null
338 ,p_investigation_source in varchar2 default null
339 ,p_investigator_recvd_req in date default null
340 ,p_agency_investigator_req in date default null
341 ,p_investigator_asg in date default null
342 ,p_investigation_start in date default null
343 ,p_investigation_end in date default null
344 ,p_investigation_extended in date default null
345 ,p_invest_extension_desc in varchar2 default null
346 ,p_agency_recvd_roi in date default null
347 ,p_comrep_recvd_roi in date default null
348 ,p_options_ltr_date in date default null
349 ,p_comrep_recvd_opt_ltr in date default null
350 ,p_comrep_opt_ltr_response in varchar2 default null
351 ,p_resolution_offer in date default null
352 ,p_comrep_resol_offer_recvd in date default null
353 ,p_comrep_resol_offer_response in date default null
354 ,p_comrep_resol_offer_desc in varchar2 default null
355 ,p_resol_offer_signed in date default null
356 ,p_resol_offer_desc in varchar2 default null
357 ,p_hearing_source in varchar2 default null
358 ,p_agency_notified_hearing in date default null
359 ,p_eeoc_hearing_docket_num in varchar2 default null
360 ,p_hearing_complete in date default null
361 ,p_aj_merit_decision_date in date default null
362 ,p_agency_recvd_aj_merit_dec in date default null
363 ,p_aj_merit_decision in varchar2 default null
364 ,p_aj_ca_decision_date in date default null
365 ,p_agency_recvd_aj_ca_dec in date default null
366 ,p_aj_ca_decision in varchar2 default null
367 ,p_fad_requested in date default null
368 ,p_merit_fad in varchar2 default null
369 ,p_attorney_fees_fad in varchar2 default null
370 ,p_comp_damages_fad in varchar2 default null
371 ,p_non_compliance_fad in varchar2 default null
372 ,p_fad_req_recvd_eeo_office in date default null
373 ,p_fad_req_forwd_to_agency in date default null
374 ,p_agency_recvd_request in date default null
375 ,p_fad_due in date default null
376 ,p_fad_date in date default null
377 ,p_fad_decision in varchar2 default null
378 --,p_fad_final_action_closure in varchar2 default null
379 ,p_fad_forwd_to_comrep in date default null
380 ,p_fad_recvd_by_comrep in date default null
381 ,p_fad_imp_ltr_forwd_to_org in date default null
382 ,p_fad_decision_forwd_legal in date default null
383 ,p_fad_decision_recvd_legal in date default null
384 ,p_fa_source in varchar2 default null
385 ,p_final_action_due in date default null
386 --,p_final_action_nature_of_closu in varchar2 default null
387 ,p_final_act_forwd_comrep in date default null
388 ,p_final_act_recvd_comrep in date default null
389 ,p_final_action_decision_date in date default null
390 ,p_final_action_decision in varchar2 default null
391 ,p_fa_imp_ltr_forwd_to_org in date default null
392 ,p_fa_decision_forwd_legal in date default null
393 ,p_fa_decision_recvd_legal in date default null
394 ,p_civil_action_filed in date default null
395 ,p_agency_closure_confirmed in date default null
396 ,p_consolidated_complaint_id in number default null
397 ,p_consolidated in date default null
398 ,p_stage_of_consolidation in varchar2 default null
399 ,p_comrep_notif_consolidation in date default null
400 ,p_consolidation_desc in varchar2 default null
401 ,p_complaint_closed in date default null
402 ,p_nature_of_closure in varchar2 default null
403 ,p_complaint_closed_desc in varchar2 default null
404 ,p_filed_formal_class in date default null
405 ,p_forwd_eeoc in date default null
406 ,p_aj_cert_decision_date in date default null
407 ,p_aj_cert_decision_recvd in date default null
408 ,p_aj_cert_decision in varchar2 default null
409 ,p_class_members_notified in date default null
410 ,p_number_of_complaintants in number default null
411 ,p_class_hearing in date default null
412 ,p_aj_dec in date default null
413 ,p_agency_recvd_aj_dec in date default null
414 ,p_aj_decision in varchar2 default null
415 ,p_agency_brief_eeoc in date default null
416 ,p_agency_notif_of_civil_action in date default null
417 ,p_fad_source in varchar2 default null
418 ,p_agency_files_forwarded_eeoc in date default null
419 ,p_hearing_req in date default null
420 ,p_agency_code in varchar2 default null
421 ,p_audited_by in varchar2 default null
422 ,p_record_received in date default null
423 ,p_attribute_category in varchar2 default null
424 ,p_attribute1 in varchar2 default null
425 ,p_attribute2 in varchar2 default null
426 ,p_attribute3 in varchar2 default null
427 ,p_attribute4 in varchar2 default null
428 ,p_attribute5 in varchar2 default null
429 ,p_attribute6 in varchar2 default null
430 ,p_attribute7 in varchar2 default null
431 ,p_attribute8 in varchar2 default null
432 ,p_attribute9 in varchar2 default null
433 ,p_attribute10 in varchar2 default null
434 ,p_attribute11 in varchar2 default null
435 ,p_attribute12 in varchar2 default null
436 ,p_attribute13 in varchar2 default null
437 ,p_attribute14 in varchar2 default null
438 ,p_attribute15 in varchar2 default null
439 ,p_attribute16 in varchar2 default null
440 ,p_attribute17 in varchar2 default null
441 ,p_attribute18 in varchar2 default null
442 ,p_attribute19 in varchar2 default null
443 ,p_attribute20 in varchar2 default null
444 ,p_attribute21 in varchar2 default null
445 ,p_attribute22 in varchar2 default null
446 ,p_attribute23 in varchar2 default null
447 ,p_attribute24 in varchar2 default null
448 ,p_attribute25 in varchar2 default null
449 ,p_attribute26 in varchar2 default null
450 ,p_attribute27 in varchar2 default null
451 ,p_attribute28 in varchar2 default null
452 ,p_attribute29 in varchar2 default null
453 ,p_attribute30 in varchar2 default null
454 ,p_complaint_id out nocopy number
455 ,p_object_version_number out nocopy number
456 );
457 --
458 -- ----------------------------------------------------------------------------
459 -- |-----------------------------< update_complaint >-------------------------|
460 -- ----------------------------------------------------------------------------
461 --
462 -- {Start Of Comments}
463 /*#
464 * This API updates a Complaints Tracking Complaint record.
465 *
466 * This API updates a Complaint record for a person or class action in table
467 * ghr_complaints2.
468 *
469 * <p><b>Licensing</b><br>
470 * This API is licensed for use with Human Resources.
471 *
472 * <p><b>Prerequisites</b><br>
476 * The API updates the Complaint record in the database.
473 * The business group and persons must exist on the effective date.
474 *
475 * <p><b>Post Success</b><br>
477 *
478 * <p><b>Post Failure</b><br>
479 * The API does not update the Complaint record and an error is raised.
480 * @param p_validate If true, then validation alone will be performed and the
481 * database will remain unchanged. If false and all validation checks pass,
482 * then the database will be modified.
483 * @param p_effective_date Reference date for validating lookup values are
484 * applicable during the start to end active date range. This date does not
485 * determine when the changes take effect.
486 * @param p_complaint_id Uniquely identifies the Complaint record to be
487 * updated.
488 * @param p_object_version_number Pass in the current version number of the
489 * Complaint to be updated. When the API completes if p_validate is false, will
490 * be set to the new version number of the updated Complaint. If p_validate is
491 * true will be set to the same value which was passed in.
492 * @param p_complainant_person_id Uniquely identifies the Complaint Person to
493 * be updated.
494 * @param p_business_group_id Uniquely identifies the Business Group.
495 * @param p_docket_number {@rep:casecolumn GHR_COMPLAINTS2.DOCKET_NUMBER}
496 * @param p_stage Complaint Stage. Valid values are defined by
497 * 'GHR_US_HEADER_STAGE' lookup type.
498 * @param p_class_flag {@rep:casecolumn GHR_COMPLAINTS2.CLASS_FLAG}
499 * @param p_mixed_flag {@rep:casecolumn GHR_COMPLAINTS2.MIXED_FLAG}
500 * @param p_consolidated_flag {@rep:casecolumn
501 * GHR_COMPLAINTS2.CONSOLIDATED_FLAG}
502 * @param p_remand_flag {@rep:casecolumn GHR_COMPLAINTS2.REMAND_FLAG}
503 * @param p_active_flag {@rep:casecolumn GHR_COMPLAINTS2.ACTIVE_FLAG}
504 * @param p_information_inquiry {@rep:casecolumn
505 * GHR_COMPLAINTS2.INFORMATION_INQUIRY}
506 * @param p_pcom_init {@rep:casecolumn GHR_COMPLAINTS2.PCOM_INIT}
507 * @param p_alleg_incident {@rep:casecolumn GHR_COMPLAINTS2.ALLEG_INCIDENT}
508 * @param p_rr_ltr_date {@rep:casecolumn GHR_COMPLAINTS2.RR_LTR_DATE}
509 * @param p_rr_ltr_recvd {@rep:casecolumn GHR_COMPLAINTS2.RR_LTR_RECVD}
510 * @param p_pre_com_elec Complaint Pre-Complaint Election. Valid values are
511 * defined by 'GHR_US_PRE_COMP_ELECTION' lookup type.
512 * @param p_class_agent_flag {@rep:casecolumn GHR_COMPLAINTS2.CLASS_AGENT_FLAG}
513 * @param p_pre_com_desc {@rep:casecolumn GHR_COMPLAINTS2.PRE_COM_DESC}
514 * @param p_counselor_asg {@rep:casecolumn GHR_COMPLAINTS2.COUNSELOR_ASG}
515 * @param p_init_counselor_interview {@rep:casecolumn
516 * GHR_COMPLAINTS2.INIT_COUNSELOR_INTERVIEW}
517 * @param p_anonymity_requested {@rep:casecolumn
518 * GHR_COMPLAINTS2.ANONYMITY_REQUESTED}
519 * @param p_counsel_ext_ltr {@rep:casecolumn GHR_COMPLAINTS2.COUNSEL_EXT_LTR}
520 * @param p_traditional_counsel_outcome Complaint Traditional Counseling
521 * Outcome. Valid values are defined by 'GHR_US_COUNSEL_OUTCOME' lookup type.
522 * @param p_final_interview {@rep:casecolumn GHR_COMPLAINTS2.FINAL_INTERVIEW}
523 * @param p_notice_rtf_recvd {@rep:casecolumn GHR_COMPLAINTS2.NOTICE_RTF_RECVD}
524 * @param p_precom_closed {@rep:casecolumn GHR_COMPLAINTS2.PRECOM_CLOSED}
525 * @param p_precom_closure_nature Complaint Pre-Complaint Nature of Closure.
526 * Valid values are defined by 'GHR_US_NATURE_OF_CLOSURE' lookup type.
527 * @param p_counselor_rpt_sub {@rep:casecolumn
528 * GHR_COMPLAINTS2.COUNSELOR_RPT_SUB}
529 * @param p_formal_com_filed {@rep:casecolumn GHR_COMPLAINTS2.FORMAL_COM_FILED}
530 * @param p_ack_ltr {@rep:casecolumn GHR_COMPLAINTS2.ACK_LTR}
531 * @param p_clarification_ltr_date {@rep:casecolumn
532 * GHR_COMPLAINTS2.CLARIFICATION_LTR_DATE}
533 * @param p_clarification_response_recvd {@rep:casecolumn
534 * GHR_COMPLAINTS2.CLARIFICATION_RESPONSE_RECVD}
535 * @param p_forwarded_legal_review {@rep:casecolumn
536 * GHR_COMPLAINTS2.FORWARDED_LEGAL_REVIEW}
537 * @param p_returned_from_legal {@rep:casecolumn
538 * GHR_COMPLAINTS2.RETURNED_FROM_LEGAL}
539 * @param p_letter_type Complaint Letter Type. Valid values are defined by
540 * 'GHR_US_LETTER_TYPE' lookup type.
541 * @param p_letter_date {@rep:casecolumn GHR_COMPLAINTS2.LETTER_DATE}
542 * @param p_letter_recvd {@rep:casecolumn GHR_COMPLAINTS2.LETTER_RECVD}
543 * @param p_investigation_source Complaint Investigation Source. Valid values
544 * are defined by 'GHR_US_COMPLAINT_SOURCE' lookup type.
545 * @param p_investigator_recvd_req {@rep:casecolumn
546 * GHR_COMPLAINTS2.INVESTIGATOR_RECVD_REQ}
547 * @param p_agency_investigator_req {@rep:casecolumn
548 * GHR_COMPLAINTS2.AGENCY_INVESTIGATOR_REQ}
549 * @param p_investigator_asg {@rep:casecolumn GHR_COMPLAINTS2.INVESTIGATOR_ASG}
550 * @param p_investigation_start {@rep:casecolumn
551 * GHR_COMPLAINTS2.INVESTIGATION_START}
552 * @param p_investigation_end {@rep:casecolumn
553 * GHR_COMPLAINTS2.INVESTIGATION_END}
554 * @param p_investigation_extended {@rep:casecolumn
555 * GHR_COMPLAINTS2.INVESTIGATION_EXTENDED}
556 * @param p_invest_extension_desc Complaint Investigation Extension
557 * Description. Valid values are defined by 'GHR_US_EXTENSION_DESC' lookup
558 * type.
559 * @param p_agency_recvd_roi {@rep:casecolumn GHR_COMPLAINTS2.AGENCY_RECVD_ROI}
560 * @param p_comrep_recvd_roi {@rep:casecolumn GHR_COMPLAINTS2.COMREP_RECVD_ROI}
561 * @param p_options_ltr_date {@rep:casecolumn GHR_COMPLAINTS2.OPTIONS_LTR_DATE}
562 * @param p_comrep_recvd_opt_ltr {@rep:casecolumn
563 * GHR_COMPLAINTS2.COMREP_RECVD_OPT_LTR}
564 * @param p_comrep_opt_ltr_response Complaint Complainant Representative
565 * Options Letter Response. Valid values are defined by
566 * 'GHR_US_OPTIONS_RESPONSE' lookup type.
567 * @param p_resolution_offer {@rep:casecolumn GHR_COMPLAINTS2.RESOLUTION_OFFER}
568 * @param p_comrep_resol_offer_recvd {@rep:casecolumn
569 * GHR_COMPLAINTS2.COMREP_RESOL_OFFER_RECVD}
570 * @param p_comrep_resol_offer_response {@rep:casecolumn
571 * GHR_COMPLAINTS2.COMREP_RESOL_OFFER_RESPONSE}
575 * @param p_resol_offer_signed {@rep:casecolumn
572 * @param p_comrep_resol_offer_desc Complaint Complainant Representative
573 * Resolution Offer Description. Valid values are defined by
574 * 'GHR_US_RESOLUTION_RESP' lookup type.
576 * GHR_COMPLAINTS2.RESOL_OFFER_SIGNED}
577 * @param p_resol_offer_desc {@rep:casecolumn GHR_COMPLAINTS2.RESOL_OFFER_DESC}
578 * @param p_hearing_source Complaint Hearing Source. Valid values are defined
579 * by 'GHR_US_COMPLAINT_SOURCE' lookup type.
580 * @param p_agency_notified_hearing {@rep:casecolumn
581 * GHR_COMPLAINTS2.AGENCY_NOTIFIED_HEARING}
582 * @param p_eeoc_hearing_docket_num {@rep:casecolumn
583 * GHR_COMPLAINTS2.EEOC_HEARING_DOCKET_NUM}
584 * @param p_hearing_complete {@rep:casecolumn GHR_COMPLAINTS2.HEARING_REQ}
585 * @param p_aj_merit_decision_date {@rep:casecolumn
586 * GHR_COMPLAINTS2.AJ_MERIT_DECISION_DATE}
587 * @param p_agency_recvd_aj_merit_dec {@rep:casecolumn
588 * GHR_COMPLAINTS2.AGENCY_RECVD_AJ_MERIT_DEC}
589 * @param p_aj_merit_decision Complaint Administrative Judge (AJ) Merit
590 * Decision. Valid values are defined by 'GHR_US_MERIT_DECISION' lookup type.
591 * @param p_aj_ca_decision_date {@rep:casecolumn
592 * GHR_COMPLAINTS2.AJ_CA_DECISION_DATE}
593 * @param p_agency_recvd_aj_ca_dec {@rep:casecolumn
594 * GHR_COMPLAINTS2.AGENCY_RECVD_AJ_CA_DEC}
595 * @param p_aj_ca_decision Complaint Administrative Judge (AJ) Corrective
596 * Action Decision. Valid values are defined by 'GHR_US_AJ_CERT_DECISION'
597 * lookup type.
598 * @param p_fad_requested {@rep:casecolumn GHR_COMPLAINTS2.FAD_REQUESTED}
599 * @param p_merit_fad {@rep:casecolumn GHR_COMPLAINTS2.MERIT_FAD}
600 * @param p_attorney_fees_fad {@rep:casecolumn
601 * GHR_COMPLAINTS2.ATTORNEY_FEES_FAD}
602 * @param p_comp_damages_fad {@rep:casecolumn GHR_COMPLAINTS2.COMP_DAMAGES_FAD}
603 * @param p_non_compliance_fad {@rep:casecolumn
604 * GHR_COMPLAINTS2.NON_COMPLIANCE_FAD}
605 * @param p_fad_req_recvd_eeo_office {@rep:casecolumn
606 * GHR_COMPLAINTS2.FAD_REQ_RECVD_EEO_OFFICE}
607 * @param p_fad_req_forwd_to_agency {@rep:casecolumn
608 * GHR_COMPLAINTS2.FAD_REQ_FORWD_TO_AGENCY}
609 * @param p_agency_recvd_request {@rep:casecolumn
610 * GHR_COMPLAINTS2.AGENCY_RECVD_REQUEST}
611 * @param p_fad_due {@rep:casecolumn GHR_COMPLAINTS2.FAD_DUE}
612 * @param p_fad_date {@rep:casecolumn GHR_COMPLAINTS2.FAD_DATE}
613 * @param p_fad_decision Complaint Final Agency Decision (FAD). Valid values
614 * are defined by 'GHR_US_FAD_DECISION' lookup type.
615 * @param p_fad_forwd_to_comrep {@rep:casecolumn
616 * GHR_COMPLAINTS2.FAD_FORWD_TO_COMREP}
617 * @param p_fad_recvd_by_comrep {@rep:casecolumn
618 * GHR_COMPLAINTS2.FAD_RECVD_BY_COMREP}
619 * @param p_fad_imp_ltr_forwd_to_org {@rep:casecolumn
620 * GHR_COMPLAINTS2.FAD_IMP_LTR_FORWD_TO_ORG}
621 * @param p_fad_decision_forwd_legal {@rep:casecolumn
622 * GHR_COMPLAINTS2.FAD_DECISION_FORWD_LEGAL}
623 * @param p_fad_decision_recvd_legal {@rep:casecolumn
624 * GHR_COMPLAINTS2.FAD_DECISION_RECVD_LEGAL}
625 * @param p_fa_source Complaint Final Action Source. Valid values are defined
626 * by 'GHR_US_COMPLAINT_SOURCE' lookup type.
627 * @param p_final_action_due {@rep:casecolumn GHR_COMPLAINTS2.FINAL_ACTION_DUE}
628 * @param p_final_act_forwd_comrep {@rep:casecolumn
629 * GHR_COMPLAINTS2.FINAL_ACT_FORWD_COMREP}
630 * @param p_final_act_recvd_comrep {@rep:casecolumn
631 * GHR_COMPLAINTS2.FINAL_ACT_RECVD_COMREP}
632 * @param p_final_action_decision_date {@rep:casecolumn
633 * GHR_COMPLAINTS2.FINAL_ACTION_DECISION_DATE}
634 * @param p_final_action_decision Complaint Final Action Decision (FAD). Valid
635 * values are defined by 'GHR_US_FAA_DECISION' lookup type.
636 * @param p_fa_imp_ltr_forwd_to_org {@rep:casecolumn
637 * GHR_COMPLAINTS2.FA_IMP_LTR_FORWD_TO_ORG}
638 * @param p_fa_decision_forwd_legal {@rep:casecolumn
639 * GHR_COMPLAINTS2.FA_DECISION_FORWD_LEGAL}
640 * @param p_fa_decision_recvd_legal {@rep:casecolumn
641 * GHR_COMPLAINTS2.FA_DECISION_RECVD_LEGAL}
642 * @param p_civil_action_filed {@rep:casecolumn
643 * GHR_COMPLAINTS2.CIVIL_ACTION_FILED}
644 * @param p_agency_closure_confirmed {@rep:casecolumn
645 * GHR_COMPLAINTS2.AGENCY_CLOSURE_CONFIRMED}
646 * @param p_consolidated_complaint_id {@rep:casecolumn
647 * GHR_COMPLAINTS2.CONSOLIDATED_COMPLAINT_ID}
648 * @param p_consolidated {@rep:casecolumn GHR_COMPLAINTS2.CONSOLIDATED}
649 * @param p_stage_of_consolidation Complaint Stage of Consolidation. Valid
650 * values are defined by 'GHR_US_COMP_CONSOLIDATE_STAGE' lookup type.
651 * @param p_comrep_notif_consolidation {@rep:casecolumn
652 * GHR_COMPLAINTS2.COMREP_NOTIF_CONSOLIDATION}
653 * @param p_consolidation_desc {@rep:casecolumn
654 * GHR_COMPLAINTS2.CONSOLIDATION_DESC}
655 * @param p_complaint_closed {@rep:casecolumn GHR_COMPLAINTS2.COMPLAINT_CLOSED}
656 * @param p_nature_of_closure Complaint Nature of Closure. Valid values are
657 * defined by 'GHR_US_NATURE_OF_CLOSURE_2' lookup type.
658 * @param p_complaint_closed_desc {@rep:casecolumn
659 * GHR_COMPLAINTS2.COMPLAINT_CLOSED_DESC}
660 * @param p_filed_formal_class {@rep:casecolumn
661 * GHR_COMPLAINTS2.FILED_FORMAL_CLASS}
662 * @param p_forwd_eeoc {@rep:casecolumn GHR_COMPLAINTS2.FORWD_EEOC}
663 * @param p_aj_cert_decision_date {@rep:casecolumn
664 * GHR_COMPLAINTS2.AJ_CERT_DECISION_DATE}
665 * @param p_aj_cert_decision_recvd {@rep:casecolumn
666 * GHR_COMPLAINTS2.AJ_CERT_DECISION_RECVD}
667 * @param p_aj_cert_decision Complaint Administrative Judge (AJ) Certified
668 * Decision. Valid values are defined by 'GHR_US_AJ_CERT_DECISION' lookup type.
669 * @param p_class_members_notified {@rep:casecolumn
670 * GHR_COMPLAINTS2.CLASS_MEMBERS_NOTIFIED}
671 * @param p_number_of_complaintants {@rep:casecolumn
672 * GHR_COMPLAINTS2.NUMBER_OF_COMPLAINTANTS}
673 * @param p_class_hearing {@rep:casecolumn GHR_COMPLAINTS2.CLASS_HEARING}
674 * @param p_aj_dec {@rep:casecolumn GHR_COMPLAINTS2.AJ_DEC}
675 * @param p_agency_recvd_aj_dec {@rep:casecolumn
676 * GHR_COMPLAINTS2.AGENCY_RECVD_AJ_DEC}
680 * GHR_COMPLAINTS2.AGENCY_BRIEF_EEOC}
677 * @param p_aj_decision Complaint Administrative Judge (AJ) Decision. Valid
678 * values are defined by 'GHR_US_AJ_REC_DECISION' lookup type.
679 * @param p_agency_brief_eeoc {@rep:casecolumn
681 * @param p_agency_notif_of_civil_action {@rep:casecolumn
682 * GHR_COMPLAINTS2.AGENCY_NOTIF_OF_CIVIL_ACTION}
683 * @param p_fad_source Complaint Final Agency Decision (FAD) Source. Valid
684 * values are defined by 'GHR_US_COMPLAINT_SOURCE' lookup type.
685 * @param p_agency_files_forwarded_eeoc {@rep:casecolumn
686 * GHR_COMPLAINTS2.AGENCY_FILES_FORWARDED_EEOC}
687 * @param p_hearing_req {@rep:casecolumn GHR_COMPLAINTS2.HEARING_REQ}
688 * @param p_agency_code Complaint Two Character Agency Code. Valid values are
689 * defined by 'GHR_US_AGENCY_CODE_2' lookup type.
690 * @param p_attribute_category This context value determines which flexfield
691 * structure to use with the descriptive flexfield segments.
692 * @param p_record_received {@rep:casecolumn
693 * GHR_COMPLAINTS2.RECORD_RECEIVED}
694 * @param p_attribute10 Descriptive flexfield segment.
695 * @param p_attribute11 Descriptive flexfield segment.
696 * @param p_attribute12 Descriptive flexfield segment.
697 * @param p_attribute13 Descriptive flexfield segment.
698 * @param p_attribute14 Descriptive flexfield segment.
699 * @param p_attribute15 Descriptive flexfield segment.
700 * @param p_attribute16 Descriptive flexfield segment.
701 * @param p_alleg_discrim_org_id {@rep:casecolumn
702 * GHR_COMPLAINTS2.ALLEG_DISCRIM_ORG_ID}
703 * @param p_attribute17 Descriptive flexfield segment.
704 * @param p_attribute18 Descriptive flexfield segment.
705 * @param p_attribute19 Descriptive flexfield segment.
706 * @param p_attribute20 Descriptive flexfield segment.
707 * @param p_attribute21 Descriptive flexfield segment.
708 * @param p_attribute22 Descriptive flexfield segment.
709 * @param p_attribute23 Descriptive flexfield segment.
710 * @param p_attribute24 Descriptive flexfield segment.
711 * @param p_attribute25 Descriptive flexfield segment.
712 * @param p_attribute26 Descriptive flexfield segment.
713 * @param p_attribute27 Descriptive flexfield segment.
714 * @param p_attribute28 Descriptive flexfield segment.
715 * @param p_attribute29 Descriptive flexfield segment.
716 * @param p_attribute30 Descriptive flexfield segment.
717 * @param p_hr_office_org_id {@rep:casecolumn
718 * GHR_COMPLAINTS2.HR_OFFICE_ORG_ID}
719 * @param p_audited_by {@rep:casecolumn
720 * GHR_COMPLAINTS2.AUDITED_BY}
721 * @param p_eeo_office_org_id {@rep:casecolumn
722 * GHR_COMPLAINTS2.EEO_OFFICE_ORG_ID}
723 * @param p_attribute1 Descriptive flexfield segment.
724 * @param p_attribute2 Descriptive flexfield segment.
725 * @param p_attribute3 Descriptive flexfield segment.
726 * @param p_attribute4 Descriptive flexfield segment.
727 * @param p_attribute5 Descriptive flexfield segment.
728 * @param p_attribute6 Descriptive flexfield segment.
729 * @param p_attribute7 Descriptive flexfield segment.
730 * @param p_attribute8 Descriptive flexfield segment.
731 * @param p_attribute9 Descriptive flexfield segment.
732 * @param p_serviced_org_id {@rep:casecolumn
733 * GHR_COMPLAINTS2.SERVICED_ORG_ID}
734 * @rep:displayname Update Complaint
735 * @rep:category BUSINESS_ENTITY GHR_EEO_COMPLAINT
736 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
737 * @rep:scope public
738 * @rep:lifecycle active
739 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
740 */
741 --
742 -- {End Of Comments}
743 --
744 procedure update_complaint
745 (p_validate in boolean default false
746 ,p_effective_date in date
747 ,p_complaint_id in number
748 ,p_object_version_number in out nocopy number
749 ,p_complainant_person_id in number default hr_api.g_number
750 ,p_business_group_id in number default hr_api.g_number
751 ,p_docket_number in varchar2 default hr_api.g_varchar2
752 ,p_stage in varchar2 default hr_api.g_varchar2
753 ,p_class_flag in varchar2 default hr_api.g_varchar2
754 ,p_mixed_flag in varchar2 default hr_api.g_varchar2
755 ,p_consolidated_flag in varchar2 default hr_api.g_varchar2
756 ,p_remand_flag in varchar2 default hr_api.g_varchar2
757 ,p_active_flag in varchar2 default hr_api.g_varchar2
758 ,p_information_inquiry in date default hr_api.g_date
759 ,p_pcom_init in date default hr_api.g_date
760 ,p_alleg_incident in date default hr_api.g_date
761 ,p_alleg_discrim_org_id in number default hr_api.g_number
762 ,p_rr_ltr_date in date default hr_api.g_date
763 ,p_rr_ltr_recvd in date default hr_api.g_date
764 ,p_pre_com_elec in varchar2 default hr_api.g_varchar2
765 --,p_adr_offered in varchar2 default hr_api.g_varchar2
766 ,p_class_agent_flag in varchar2 default hr_api.g_varchar2
767 ,p_pre_com_desc in varchar2 default hr_api.g_varchar2
768 ,p_counselor_asg in date default hr_api.g_date
769 ,p_init_counselor_interview in date default hr_api.g_date
770 ,p_anonymity_requested in varchar2 default hr_api.g_varchar2
771 ,p_counsel_ext_ltr in date default hr_api.g_date
772 ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2
773 ,p_final_interview in date default hr_api.g_date
774 ,p_notice_rtf_recvd in date default hr_api.g_date
775 ,p_precom_closed in date default hr_api.g_date
776 ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2
777 ,p_counselor_rpt_sub in date default hr_api.g_date
778 ,p_hr_office_org_id in number default hr_api.g_number
779 ,p_eeo_office_org_id in number default hr_api.g_number
780 ,p_serviced_org_id in number default hr_api.g_number
781 ,p_formal_com_filed in date default hr_api.g_date
782 ,p_ack_ltr in date default hr_api.g_date
783 ,p_clarification_ltr_date in date default hr_api.g_date
784 ,p_clarification_response_recvd in date default hr_api.g_date
785 ,p_forwarded_legal_review in date default hr_api.g_date
786 ,p_returned_from_legal in date default hr_api.g_date
787 ,p_letter_type in varchar2 default hr_api.g_varchar2
788 ,p_letter_date in date default hr_api.g_date
789 ,p_letter_recvd in date default hr_api.g_date
790 ,p_investigation_source in varchar2 default hr_api.g_varchar2
791 ,p_investigator_recvd_req in date default hr_api.g_date
792 ,p_agency_investigator_req in date default hr_api.g_date
793 ,p_investigator_asg in date default hr_api.g_date
794 ,p_investigation_start in date default hr_api.g_date
795 ,p_investigation_end in date default hr_api.g_date
796 ,p_investigation_extended in date default hr_api.g_date
797 ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2
798 ,p_agency_recvd_roi in date default hr_api.g_date
799 ,p_comrep_recvd_roi in date default hr_api.g_date
800 ,p_options_ltr_date in date default hr_api.g_date
801 ,p_comrep_recvd_opt_ltr in date default hr_api.g_date
802 ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2
803 ,p_resolution_offer in date default hr_api.g_date
804 ,p_comrep_resol_offer_recvd in date default hr_api.g_date
805 ,p_comrep_resol_offer_response in date default hr_api.g_date
806 ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2
807 ,p_resol_offer_signed in date default hr_api.g_date
808 ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2
809 ,p_hearing_source in varchar2 default hr_api.g_varchar2
810 ,p_agency_notified_hearing in date default hr_api.g_date
811 ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2
812 ,p_hearing_complete in date default hr_api.g_date
813 ,p_aj_merit_decision_date in date default hr_api.g_date
814 ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date
815 ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2
816 ,p_aj_ca_decision_date in date default hr_api.g_date
817 ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date
818 ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2
819 ,p_fad_requested in date default hr_api.g_date
820 ,p_merit_fad in varchar2 default hr_api.g_varchar2
821 ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2
822 ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2
823 ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2
824 ,p_fad_req_recvd_eeo_office in date default hr_api.g_date
825 ,p_fad_req_forwd_to_agency in date default hr_api.g_date
826 ,p_agency_recvd_request in date default hr_api.g_date
827 ,p_fad_due in date default hr_api.g_date
828 ,p_fad_date in date default hr_api.g_date
829 ,p_fad_decision in varchar2 default hr_api.g_varchar2
830 --,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2
831 ,p_fad_forwd_to_comrep in date default hr_api.g_date
832 ,p_fad_recvd_by_comrep in date default hr_api.g_date
833 ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date
834 ,p_fad_decision_forwd_legal in date default hr_api.g_date
835 ,p_fad_decision_recvd_legal in date default hr_api.g_date
836 ,p_fa_source in varchar2 default hr_api.g_varchar2
837 ,p_final_action_due in date default hr_api.g_date
838 --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2
839 ,p_final_act_forwd_comrep in date default hr_api.g_date
840 ,p_final_act_recvd_comrep in date default hr_api.g_date
841 ,p_final_action_decision_date in date default hr_api.g_date
842 ,p_final_action_decision in varchar2 default hr_api.g_varchar2
843 ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date
844 ,p_fa_decision_forwd_legal in date default hr_api.g_date
845 ,p_fa_decision_recvd_legal in date default hr_api.g_date
846 ,p_civil_action_filed in date default hr_api.g_date
847 ,p_agency_closure_confirmed in date default hr_api.g_date
848 ,p_consolidated_complaint_id in number default hr_api.g_number
849 ,p_consolidated in date default hr_api.g_date
850 ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2
851 ,p_comrep_notif_consolidation in date default hr_api.g_date
852 ,p_consolidation_desc in varchar2 default hr_api.g_varchar2
853 ,p_complaint_closed in date default hr_api.g_date
854 ,p_nature_of_closure in varchar2 default hr_api.g_varchar2
855 ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2
856 ,p_filed_formal_class in date default hr_api.g_date
857 ,p_forwd_eeoc in date default hr_api.g_date
858 ,p_aj_cert_decision_date in date default hr_api.g_date
859 ,p_aj_cert_decision_recvd in date default hr_api.g_date
860 ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2
861 ,p_class_members_notified in date default hr_api.g_date
862 ,p_number_of_complaintants in number default hr_api.g_number
863 ,p_class_hearing in date default hr_api.g_date
864 ,p_aj_dec in date default hr_api.g_date
865 ,p_agency_recvd_aj_dec in date default hr_api.g_date
866 ,p_aj_decision in varchar2 default hr_api.g_varchar2
867 ,p_agency_brief_eeoc in date default hr_api.g_date
868 ,p_agency_notif_of_civil_action in date default hr_api.g_date
869 ,p_fad_source in varchar2 default hr_api.g_varchar2
870 ,p_agency_files_forwarded_eeoc in date default hr_api.g_date
871 ,p_hearing_req in date default hr_api.g_date
872 ,p_agency_code in varchar2 default hr_api.g_varchar2
873 ,p_audited_by in varchar2 default hr_api.g_varchar2
874 ,p_record_received in date default hr_api.g_date
875 ,p_attribute_category in varchar2 default hr_api.g_varchar2
876 ,p_attribute1 in varchar2 default hr_api.g_varchar2
877 ,p_attribute2 in varchar2 default hr_api.g_varchar2
878 ,p_attribute3 in varchar2 default hr_api.g_varchar2
879 ,p_attribute4 in varchar2 default hr_api.g_varchar2
880 ,p_attribute5 in varchar2 default hr_api.g_varchar2
881 ,p_attribute6 in varchar2 default hr_api.g_varchar2
882 ,p_attribute7 in varchar2 default hr_api.g_varchar2
883 ,p_attribute8 in varchar2 default hr_api.g_varchar2
884 ,p_attribute9 in varchar2 default hr_api.g_varchar2
885 ,p_attribute10 in varchar2 default hr_api.g_varchar2
886 ,p_attribute11 in varchar2 default hr_api.g_varchar2
887 ,p_attribute12 in varchar2 default hr_api.g_varchar2
888 ,p_attribute13 in varchar2 default hr_api.g_varchar2
889 ,p_attribute14 in varchar2 default hr_api.g_varchar2
890 ,p_attribute15 in varchar2 default hr_api.g_varchar2
891 ,p_attribute16 in varchar2 default hr_api.g_varchar2
892 ,p_attribute17 in varchar2 default hr_api.g_varchar2
893 ,p_attribute18 in varchar2 default hr_api.g_varchar2
894 ,p_attribute19 in varchar2 default hr_api.g_varchar2
895 ,p_attribute20 in varchar2 default hr_api.g_varchar2
896 ,p_attribute21 in varchar2 default hr_api.g_varchar2
897 ,p_attribute22 in varchar2 default hr_api.g_varchar2
898 ,p_attribute23 in varchar2 default hr_api.g_varchar2
899 ,p_attribute24 in varchar2 default hr_api.g_varchar2
900 ,p_attribute25 in varchar2 default hr_api.g_varchar2
901 ,p_attribute26 in varchar2 default hr_api.g_varchar2
902 ,p_attribute27 in varchar2 default hr_api.g_varchar2
903 ,p_attribute28 in varchar2 default hr_api.g_varchar2
904 ,p_attribute29 in varchar2 default hr_api.g_varchar2
905 ,p_attribute30 in varchar2 default hr_api.g_varchar2
906 );
907
908 --
909 end ghr_complaint_api;