APPS.GHR_COMPLAINTS_CA_HEADERS_API dependencies on HR_API

Line 87: when hr_api.cannot_find_prog_unit then

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: );

Line 88: hr_api.cannot_find_prog_unit_error

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;

Line 160: when hr_api.cannot_find_prog_unit then

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: );

Line 161: hr_api.cannot_find_prog_unit_error

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;

Line 170: raise hr_api.validate_enabled;

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: --

Line 180: when hr_api.validate_enabled then

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: --

Line 217: ,p_complaint_id in number default hr_api.g_number

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

Line 218: ,p_ca_source 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

Line 219: ,p_last_compliance_report in date default hr_api.g_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
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2

Line 220: ,p_compliance_closed in date default hr_api.g_date

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

Line 221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2

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

Line 222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2

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

Line 223: ,p_pfe_docket_number 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
227: ,p_decision_pfe_date in date default hr_api.g_date

Line 224: ,p_pfe_received 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

Line 225: ,p_agency_brief_pfe_due 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
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date

Line 226: ,p_agency_brief_pfe_date 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

Line 227: ,p_decision_pfe_date 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

Line 228: ,p_decision_pfe 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
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2

Line 229: ,p_agency_recvd_pfe_decision 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
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date

Line 230: ,p_agency_pfe_brief_forwd 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

Line 231: ,p_agency_notified_noncom 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

Line 232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2

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

Line 233: ,p_eeo_off_req_data_from_org 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

Line 234: ,p_org_forwd_data_to_eeo_off 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
238: )

Line 235: ,p_dec_implemented 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: )
239:

Line 236: ,p_complaint_reinstated 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:
240: is

Line 237: ,p_stage_complaint_reinstated 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
241: l_proc varchar2(72) := g_package||'update_ca_header';

Line 285: when hr_api.cannot_find_prog_unit then

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: );

Line 286: hr_api.cannot_find_prog_unit_error

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;

Line 357: when hr_api.cannot_find_prog_unit then

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: );

Line 358: hr_api.cannot_find_prog_unit_error

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;

Line 367: raise hr_api.validate_enabled;

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: --

Line 376: when hr_api.validate_enabled then

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: --

Line 434: when hr_api.cannot_find_prog_unit then

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: );

Line 435: hr_api.cannot_find_prog_unit_error

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;

Line 458: when hr_api.cannot_find_prog_unit then

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: );

Line 459: hr_api.cannot_find_prog_unit_error

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;

Line 468: raise hr_api.validate_enabled;

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

Line 473: when hr_api.validate_enabled then

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: --