DBA Data[Home] [Help]

APPS.GHR_COMPLAINTS_CA_HEADERS_API dependencies on HR_API

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

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