APPS.GHR_CAH_UPD dependencies on HR_API

Line 100: ,p_complaint_id in number default hr_api.g_number

96: Procedure upd
97: (p_effective_date in date
98: ,p_compl_ca_header_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_complaint_id in number default hr_api.g_number
101: ,p_ca_source in varchar2 default hr_api.g_varchar2
102: ,p_last_compliance_report in date default hr_api.g_date
103: ,p_compliance_closed in date default hr_api.g_date
104: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2

Line 101: ,p_ca_source in varchar2 default hr_api.g_varchar2

97: (p_effective_date in date
98: ,p_compl_ca_header_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_complaint_id in number default hr_api.g_number
101: ,p_ca_source in varchar2 default hr_api.g_varchar2
102: ,p_last_compliance_report in date default hr_api.g_date
103: ,p_compliance_closed in date default hr_api.g_date
104: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
105: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2

Line 102: ,p_last_compliance_report in date default hr_api.g_date

98: ,p_compl_ca_header_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_complaint_id in number default hr_api.g_number
101: ,p_ca_source in varchar2 default hr_api.g_varchar2
102: ,p_last_compliance_report in date default hr_api.g_date
103: ,p_compliance_closed in date default hr_api.g_date
104: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
105: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
106: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2

Line 103: ,p_compliance_closed in date default hr_api.g_date

99: ,p_object_version_number in out nocopy number
100: ,p_complaint_id in number default hr_api.g_number
101: ,p_ca_source in varchar2 default hr_api.g_varchar2
102: ,p_last_compliance_report in date default hr_api.g_date
103: ,p_compliance_closed in date default hr_api.g_date
104: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
105: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
106: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
107: ,p_pfe_received in date default hr_api.g_date

Line 104: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2

100: ,p_complaint_id in number default hr_api.g_number
101: ,p_ca_source in varchar2 default hr_api.g_varchar2
102: ,p_last_compliance_report in date default hr_api.g_date
103: ,p_compliance_closed in date default hr_api.g_date
104: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
105: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
106: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
107: ,p_pfe_received in date default hr_api.g_date
108: ,p_agency_brief_pfe_due in date default hr_api.g_date

Line 105: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2

101: ,p_ca_source in varchar2 default hr_api.g_varchar2
102: ,p_last_compliance_report in date default hr_api.g_date
103: ,p_compliance_closed in date default hr_api.g_date
104: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
105: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
106: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
107: ,p_pfe_received in date default hr_api.g_date
108: ,p_agency_brief_pfe_due in date default hr_api.g_date
109: ,p_agency_brief_pfe_date in date default hr_api.g_date

Line 106: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2

102: ,p_last_compliance_report in date default hr_api.g_date
103: ,p_compliance_closed in date default hr_api.g_date
104: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
105: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
106: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
107: ,p_pfe_received in date default hr_api.g_date
108: ,p_agency_brief_pfe_due in date default hr_api.g_date
109: ,p_agency_brief_pfe_date in date default hr_api.g_date
110: ,p_decision_pfe_date in date default hr_api.g_date

Line 107: ,p_pfe_received in date default hr_api.g_date

103: ,p_compliance_closed in date default hr_api.g_date
104: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
105: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
106: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
107: ,p_pfe_received in date default hr_api.g_date
108: ,p_agency_brief_pfe_due in date default hr_api.g_date
109: ,p_agency_brief_pfe_date in date default hr_api.g_date
110: ,p_decision_pfe_date in date default hr_api.g_date
111: ,p_decision_pfe in varchar2 default hr_api.g_varchar2

Line 108: ,p_agency_brief_pfe_due in date default hr_api.g_date

104: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
105: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
106: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
107: ,p_pfe_received in date default hr_api.g_date
108: ,p_agency_brief_pfe_due in date default hr_api.g_date
109: ,p_agency_brief_pfe_date in date default hr_api.g_date
110: ,p_decision_pfe_date in date default hr_api.g_date
111: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
112: ,p_agency_recvd_pfe_decision in date default hr_api.g_date

Line 109: ,p_agency_brief_pfe_date in date default hr_api.g_date

105: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
106: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
107: ,p_pfe_received in date default hr_api.g_date
108: ,p_agency_brief_pfe_due in date default hr_api.g_date
109: ,p_agency_brief_pfe_date in date default hr_api.g_date
110: ,p_decision_pfe_date in date default hr_api.g_date
111: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
112: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
113: ,p_agency_pfe_brief_forwd in date default hr_api.g_date

Line 110: ,p_decision_pfe_date in date default hr_api.g_date

106: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
107: ,p_pfe_received in date default hr_api.g_date
108: ,p_agency_brief_pfe_due in date default hr_api.g_date
109: ,p_agency_brief_pfe_date in date default hr_api.g_date
110: ,p_decision_pfe_date in date default hr_api.g_date
111: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
112: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
113: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
114: ,p_agency_notified_noncom in date default hr_api.g_date

Line 111: ,p_decision_pfe in varchar2 default hr_api.g_varchar2

107: ,p_pfe_received in date default hr_api.g_date
108: ,p_agency_brief_pfe_due in date default hr_api.g_date
109: ,p_agency_brief_pfe_date in date default hr_api.g_date
110: ,p_decision_pfe_date in date default hr_api.g_date
111: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
112: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
113: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
114: ,p_agency_notified_noncom in date default hr_api.g_date
115: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2

Line 112: ,p_agency_recvd_pfe_decision in date default hr_api.g_date

108: ,p_agency_brief_pfe_due in date default hr_api.g_date
109: ,p_agency_brief_pfe_date in date default hr_api.g_date
110: ,p_decision_pfe_date in date default hr_api.g_date
111: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
112: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
113: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
114: ,p_agency_notified_noncom in date default hr_api.g_date
115: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
116: ,p_eeo_off_req_data_from_org in date default hr_api.g_date

Line 113: ,p_agency_pfe_brief_forwd in date default hr_api.g_date

109: ,p_agency_brief_pfe_date in date default hr_api.g_date
110: ,p_decision_pfe_date in date default hr_api.g_date
111: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
112: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
113: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
114: ,p_agency_notified_noncom in date default hr_api.g_date
115: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
116: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
117: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date

Line 114: ,p_agency_notified_noncom in date default hr_api.g_date

110: ,p_decision_pfe_date in date default hr_api.g_date
111: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
112: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
113: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
114: ,p_agency_notified_noncom in date default hr_api.g_date
115: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
116: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
117: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
118: ,p_dec_implemented in date default hr_api.g_date

Line 115: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2

111: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
112: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
113: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
114: ,p_agency_notified_noncom in date default hr_api.g_date
115: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
116: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
117: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
118: ,p_dec_implemented in date default hr_api.g_date
119: ,p_complaint_reinstated in date default hr_api.g_date

Line 116: ,p_eeo_off_req_data_from_org in date default hr_api.g_date

112: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
113: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
114: ,p_agency_notified_noncom in date default hr_api.g_date
115: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
116: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
117: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
118: ,p_dec_implemented in date default hr_api.g_date
119: ,p_complaint_reinstated in date default hr_api.g_date
120: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2

Line 117: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date

113: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
114: ,p_agency_notified_noncom in date default hr_api.g_date
115: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
116: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
117: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
118: ,p_dec_implemented in date default hr_api.g_date
119: ,p_complaint_reinstated in date default hr_api.g_date
120: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
121: );

Line 118: ,p_dec_implemented in date default hr_api.g_date

114: ,p_agency_notified_noncom in date default hr_api.g_date
115: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
116: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
117: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
118: ,p_dec_implemented in date default hr_api.g_date
119: ,p_complaint_reinstated in date default hr_api.g_date
120: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
121: );
122: --

Line 119: ,p_complaint_reinstated in date default hr_api.g_date

115: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
116: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
117: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
118: ,p_dec_implemented in date default hr_api.g_date
119: ,p_complaint_reinstated in date default hr_api.g_date
120: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
121: );
122: --
123: end ghr_cah_upd;

Line 120: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2

116: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
117: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
118: ,p_dec_implemented in date default hr_api.g_date
119: ,p_complaint_reinstated in date default hr_api.g_date
120: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
121: );
122: --
123: end ghr_cah_upd;