83: ,p_complaint_reinstated => p_complaint_reinstated
84: ,p_stage_complaint_reinstated => p_stage_complaint_reinstated
85: );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'create_ca_header'
90: ,p_hook_type => 'BP'
91: );
84: ,p_stage_complaint_reinstated => p_stage_complaint_reinstated
85: );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'create_ca_header'
90: ,p_hook_type => 'BP'
91: );
92: end;
156: ,p_compl_ca_header_id => l_compl_ca_header_id
157: ,p_object_version_number => l_object_version_number
158: );
159: exception
160: when hr_api.cannot_find_prog_unit then
161: hr_api.cannot_find_prog_unit_error
162: (p_module_name => 'create_ca_header'
163: ,p_hook_type => 'AP'
164: );
157: ,p_object_version_number => l_object_version_number
158: );
159: exception
160: when hr_api.cannot_find_prog_unit then
161: hr_api.cannot_find_prog_unit_error
162: (p_module_name => 'create_ca_header'
163: ,p_hook_type => 'AP'
164: );
165: end;
166: --
167: -- When in validation only mode raise the Validate_Enabled exception
168: --
169: if p_validate then
170: raise hr_api.validate_enabled;
171: end if;
172: --
173: -- Set all output arguments
174: --
176: p_object_version_number := l_object_version_number;
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 70);
179: exception
180: when hr_api.validate_enabled then
181: --
182: -- As the Validate_Enabled exception has been raised
183: -- we must rollback to the savepoint
184: --
213: (p_validate in boolean default false
214: ,p_effective_date in date
215: ,p_compl_ca_header_id in number
216: ,p_object_version_number in out nocopy number
217: ,p_complaint_id in number default hr_api.g_number
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
214: ,p_effective_date in date
215: ,p_compl_ca_header_id in number
216: ,p_object_version_number in out nocopy number
217: ,p_complaint_id in number default hr_api.g_number
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
215: ,p_compl_ca_header_id in number
216: ,p_object_version_number in out nocopy number
217: ,p_complaint_id in number default hr_api.g_number
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
216: ,p_object_version_number in out nocopy number
217: ,p_complaint_id in number default hr_api.g_number
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
217: ,p_complaint_id in number default hr_api.g_number
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
237: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
237: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
238: )
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
237: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
238: )
239:
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
237: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
238: )
239:
240: is
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
237: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
238: )
239:
240: is
241: l_proc varchar2(72) := g_package||'update_ca_header';
281: ,p_compl_ca_header_id => p_compl_ca_header_id
282: ,p_object_version_number => p_object_version_number
283: );
284: exception
285: when hr_api.cannot_find_prog_unit then
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'update_ca_header'
288: ,p_hook_type => 'BP'
289: );
282: ,p_object_version_number => p_object_version_number
283: );
284: exception
285: when hr_api.cannot_find_prog_unit then
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'update_ca_header'
288: ,p_hook_type => 'BP'
289: );
290: end;
353: ,p_compl_ca_header_id => p_compl_ca_header_id
354: ,p_object_version_number => l_object_version_number
355: );
356: exception
357: when hr_api.cannot_find_prog_unit then
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'update_ca_header'
360: ,p_hook_type => 'AP'
361: );
354: ,p_object_version_number => l_object_version_number
355: );
356: exception
357: when hr_api.cannot_find_prog_unit then
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'update_ca_header'
360: ,p_hook_type => 'AP'
361: );
362: end;
363: --
364: -- When in validation only mode raise the Validate_Enabled exception
365: --
366: if p_validate then
367: raise hr_api.validate_enabled;
368: end if;
369: --
370: -- Set all output arguments
371: --
372: p_object_version_number := l_object_version_number;
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 70);
375: exception
376: when hr_api.validate_enabled then
377: --
378: -- As the Validate_Enabled exception has been raised
379: -- we must rollback to the savepoint
380: --
430: (p_compl_ca_header_id => p_compl_ca_header_id
431: ,p_object_version_number => p_object_version_number
432: );
433: exception
434: when hr_api.cannot_find_prog_unit then
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'delete_ca_header'
437: ,p_hook_type => 'BP'
438: );
431: ,p_object_version_number => p_object_version_number
432: );
433: exception
434: when hr_api.cannot_find_prog_unit then
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'delete_ca_header'
437: ,p_hook_type => 'BP'
438: );
439: end;
454: (p_compl_ca_header_id => p_compl_ca_header_id
455: ,p_object_version_number => p_object_version_number
456: );
457: exception
458: when hr_api.cannot_find_prog_unit then
459: hr_api.cannot_find_prog_unit_error
460: (p_module_name => 'delete_ca_header'
461: ,p_hook_type => 'AP'
462: );
455: ,p_object_version_number => p_object_version_number
456: );
457: exception
458: when hr_api.cannot_find_prog_unit then
459: hr_api.cannot_find_prog_unit_error
460: (p_module_name => 'delete_ca_header'
461: ,p_hook_type => 'AP'
462: );
463: end;
464: --
465: -- When in validation only mode raise the Validate_Enabled exception
466: --
467: if p_validate then
468: raise hr_api.validate_enabled;
469: end if;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 11);
472: exception
469: end if;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 11);
472: exception
473: when hr_api.validate_enabled then
474: -- we must rollback to the savepoint
475: --
476: ROLLBACK TO delete_ca_header;
477: --