DBA Data[Home] [Help]

APPS.GHR_CMP_UPD dependencies on HR_API

Line 100: ,p_complainant_person_id in number default hr_api.g_number

96: Procedure upd
97: (p_effective_date in date
98: ,p_complaint_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_complainant_person_id in number default hr_api.g_number
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_docket_number in varchar2 default hr_api.g_varchar2
103: ,p_stage in varchar2 default hr_api.g_varchar2
104: ,p_class_flag in varchar2 default hr_api.g_varchar2

Line 101: ,p_business_group_id in number default hr_api.g_number

97: (p_effective_date in date
98: ,p_complaint_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_complainant_person_id in number default hr_api.g_number
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_docket_number in varchar2 default hr_api.g_varchar2
103: ,p_stage in varchar2 default hr_api.g_varchar2
104: ,p_class_flag in varchar2 default hr_api.g_varchar2
105: ,p_mixed_flag in varchar2 default hr_api.g_varchar2

Line 102: ,p_docket_number in varchar2 default hr_api.g_varchar2

98: ,p_complaint_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_complainant_person_id in number default hr_api.g_number
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_docket_number in varchar2 default hr_api.g_varchar2
103: ,p_stage in varchar2 default hr_api.g_varchar2
104: ,p_class_flag in varchar2 default hr_api.g_varchar2
105: ,p_mixed_flag in varchar2 default hr_api.g_varchar2
106: ,p_consolidated_flag in varchar2 default hr_api.g_varchar2

Line 103: ,p_stage in varchar2 default hr_api.g_varchar2

99: ,p_object_version_number in out nocopy number
100: ,p_complainant_person_id in number default hr_api.g_number
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_docket_number in varchar2 default hr_api.g_varchar2
103: ,p_stage in varchar2 default hr_api.g_varchar2
104: ,p_class_flag in varchar2 default hr_api.g_varchar2
105: ,p_mixed_flag in varchar2 default hr_api.g_varchar2
106: ,p_consolidated_flag in varchar2 default hr_api.g_varchar2
107: ,p_remand_flag in varchar2 default hr_api.g_varchar2

Line 104: ,p_class_flag in varchar2 default hr_api.g_varchar2

100: ,p_complainant_person_id in number default hr_api.g_number
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_docket_number in varchar2 default hr_api.g_varchar2
103: ,p_stage in varchar2 default hr_api.g_varchar2
104: ,p_class_flag in varchar2 default hr_api.g_varchar2
105: ,p_mixed_flag in varchar2 default hr_api.g_varchar2
106: ,p_consolidated_flag in varchar2 default hr_api.g_varchar2
107: ,p_remand_flag in varchar2 default hr_api.g_varchar2
108: ,p_active_flag in varchar2 default hr_api.g_varchar2

Line 105: ,p_mixed_flag in varchar2 default hr_api.g_varchar2

101: ,p_business_group_id in number default hr_api.g_number
102: ,p_docket_number in varchar2 default hr_api.g_varchar2
103: ,p_stage in varchar2 default hr_api.g_varchar2
104: ,p_class_flag in varchar2 default hr_api.g_varchar2
105: ,p_mixed_flag in varchar2 default hr_api.g_varchar2
106: ,p_consolidated_flag in varchar2 default hr_api.g_varchar2
107: ,p_remand_flag in varchar2 default hr_api.g_varchar2
108: ,p_active_flag in varchar2 default hr_api.g_varchar2
109: ,p_information_inquiry in date default hr_api.g_date

Line 106: ,p_consolidated_flag in varchar2 default hr_api.g_varchar2

102: ,p_docket_number in varchar2 default hr_api.g_varchar2
103: ,p_stage in varchar2 default hr_api.g_varchar2
104: ,p_class_flag in varchar2 default hr_api.g_varchar2
105: ,p_mixed_flag in varchar2 default hr_api.g_varchar2
106: ,p_consolidated_flag in varchar2 default hr_api.g_varchar2
107: ,p_remand_flag in varchar2 default hr_api.g_varchar2
108: ,p_active_flag in varchar2 default hr_api.g_varchar2
109: ,p_information_inquiry in date default hr_api.g_date
110: ,p_pcom_init in date default hr_api.g_date

Line 107: ,p_remand_flag in varchar2 default hr_api.g_varchar2

103: ,p_stage in varchar2 default hr_api.g_varchar2
104: ,p_class_flag in varchar2 default hr_api.g_varchar2
105: ,p_mixed_flag in varchar2 default hr_api.g_varchar2
106: ,p_consolidated_flag in varchar2 default hr_api.g_varchar2
107: ,p_remand_flag in varchar2 default hr_api.g_varchar2
108: ,p_active_flag in varchar2 default hr_api.g_varchar2
109: ,p_information_inquiry in date default hr_api.g_date
110: ,p_pcom_init in date default hr_api.g_date
111: ,p_alleg_incident in date default hr_api.g_date

Line 108: ,p_active_flag in varchar2 default hr_api.g_varchar2

104: ,p_class_flag in varchar2 default hr_api.g_varchar2
105: ,p_mixed_flag in varchar2 default hr_api.g_varchar2
106: ,p_consolidated_flag in varchar2 default hr_api.g_varchar2
107: ,p_remand_flag in varchar2 default hr_api.g_varchar2
108: ,p_active_flag in varchar2 default hr_api.g_varchar2
109: ,p_information_inquiry in date default hr_api.g_date
110: ,p_pcom_init in date default hr_api.g_date
111: ,p_alleg_incident in date default hr_api.g_date
112: ,p_alleg_discrim_org_id in number default hr_api.g_number

Line 109: ,p_information_inquiry in date default hr_api.g_date

105: ,p_mixed_flag in varchar2 default hr_api.g_varchar2
106: ,p_consolidated_flag in varchar2 default hr_api.g_varchar2
107: ,p_remand_flag in varchar2 default hr_api.g_varchar2
108: ,p_active_flag in varchar2 default hr_api.g_varchar2
109: ,p_information_inquiry in date default hr_api.g_date
110: ,p_pcom_init in date default hr_api.g_date
111: ,p_alleg_incident in date default hr_api.g_date
112: ,p_alleg_discrim_org_id in number default hr_api.g_number
113: ,p_rr_ltr_date in date default hr_api.g_date

Line 110: ,p_pcom_init in date default hr_api.g_date

106: ,p_consolidated_flag in varchar2 default hr_api.g_varchar2
107: ,p_remand_flag in varchar2 default hr_api.g_varchar2
108: ,p_active_flag in varchar2 default hr_api.g_varchar2
109: ,p_information_inquiry in date default hr_api.g_date
110: ,p_pcom_init in date default hr_api.g_date
111: ,p_alleg_incident in date default hr_api.g_date
112: ,p_alleg_discrim_org_id in number default hr_api.g_number
113: ,p_rr_ltr_date in date default hr_api.g_date
114: ,p_rr_ltr_recvd in date default hr_api.g_date

Line 111: ,p_alleg_incident in date default hr_api.g_date

107: ,p_remand_flag in varchar2 default hr_api.g_varchar2
108: ,p_active_flag in varchar2 default hr_api.g_varchar2
109: ,p_information_inquiry in date default hr_api.g_date
110: ,p_pcom_init in date default hr_api.g_date
111: ,p_alleg_incident in date default hr_api.g_date
112: ,p_alleg_discrim_org_id in number default hr_api.g_number
113: ,p_rr_ltr_date in date default hr_api.g_date
114: ,p_rr_ltr_recvd in date default hr_api.g_date
115: ,p_pre_com_elec in varchar2 default hr_api.g_varchar2

Line 112: ,p_alleg_discrim_org_id in number default hr_api.g_number

108: ,p_active_flag in varchar2 default hr_api.g_varchar2
109: ,p_information_inquiry in date default hr_api.g_date
110: ,p_pcom_init in date default hr_api.g_date
111: ,p_alleg_incident in date default hr_api.g_date
112: ,p_alleg_discrim_org_id in number default hr_api.g_number
113: ,p_rr_ltr_date in date default hr_api.g_date
114: ,p_rr_ltr_recvd in date default hr_api.g_date
115: ,p_pre_com_elec in varchar2 default hr_api.g_varchar2
116: --,p_adr_offered in varchar2 default hr_api.g_varchar2

Line 113: ,p_rr_ltr_date in date default hr_api.g_date

109: ,p_information_inquiry in date default hr_api.g_date
110: ,p_pcom_init in date default hr_api.g_date
111: ,p_alleg_incident in date default hr_api.g_date
112: ,p_alleg_discrim_org_id in number default hr_api.g_number
113: ,p_rr_ltr_date in date default hr_api.g_date
114: ,p_rr_ltr_recvd in date default hr_api.g_date
115: ,p_pre_com_elec in varchar2 default hr_api.g_varchar2
116: --,p_adr_offered in varchar2 default hr_api.g_varchar2
117: ,p_class_agent_flag in varchar2 default hr_api.g_varchar2

Line 114: ,p_rr_ltr_recvd in date default hr_api.g_date

110: ,p_pcom_init in date default hr_api.g_date
111: ,p_alleg_incident in date default hr_api.g_date
112: ,p_alleg_discrim_org_id in number default hr_api.g_number
113: ,p_rr_ltr_date in date default hr_api.g_date
114: ,p_rr_ltr_recvd in date default hr_api.g_date
115: ,p_pre_com_elec in varchar2 default hr_api.g_varchar2
116: --,p_adr_offered in varchar2 default hr_api.g_varchar2
117: ,p_class_agent_flag in varchar2 default hr_api.g_varchar2
118: ,p_pre_com_desc in varchar2 default hr_api.g_varchar2

Line 115: ,p_pre_com_elec in varchar2 default hr_api.g_varchar2

111: ,p_alleg_incident in date default hr_api.g_date
112: ,p_alleg_discrim_org_id in number default hr_api.g_number
113: ,p_rr_ltr_date in date default hr_api.g_date
114: ,p_rr_ltr_recvd in date default hr_api.g_date
115: ,p_pre_com_elec in varchar2 default hr_api.g_varchar2
116: --,p_adr_offered in varchar2 default hr_api.g_varchar2
117: ,p_class_agent_flag in varchar2 default hr_api.g_varchar2
118: ,p_pre_com_desc in varchar2 default hr_api.g_varchar2
119: ,p_counselor_asg in date default hr_api.g_date

Line 116: --,p_adr_offered in varchar2 default hr_api.g_varchar2

112: ,p_alleg_discrim_org_id in number default hr_api.g_number
113: ,p_rr_ltr_date in date default hr_api.g_date
114: ,p_rr_ltr_recvd in date default hr_api.g_date
115: ,p_pre_com_elec in varchar2 default hr_api.g_varchar2
116: --,p_adr_offered in varchar2 default hr_api.g_varchar2
117: ,p_class_agent_flag in varchar2 default hr_api.g_varchar2
118: ,p_pre_com_desc in varchar2 default hr_api.g_varchar2
119: ,p_counselor_asg in date default hr_api.g_date
120: ,p_init_counselor_interview in date default hr_api.g_date

Line 117: ,p_class_agent_flag in varchar2 default hr_api.g_varchar2

113: ,p_rr_ltr_date in date default hr_api.g_date
114: ,p_rr_ltr_recvd in date default hr_api.g_date
115: ,p_pre_com_elec in varchar2 default hr_api.g_varchar2
116: --,p_adr_offered in varchar2 default hr_api.g_varchar2
117: ,p_class_agent_flag in varchar2 default hr_api.g_varchar2
118: ,p_pre_com_desc in varchar2 default hr_api.g_varchar2
119: ,p_counselor_asg in date default hr_api.g_date
120: ,p_init_counselor_interview in date default hr_api.g_date
121: ,p_anonymity_requested in varchar2 default hr_api.g_varchar2

Line 118: ,p_pre_com_desc in varchar2 default hr_api.g_varchar2

114: ,p_rr_ltr_recvd in date default hr_api.g_date
115: ,p_pre_com_elec in varchar2 default hr_api.g_varchar2
116: --,p_adr_offered in varchar2 default hr_api.g_varchar2
117: ,p_class_agent_flag in varchar2 default hr_api.g_varchar2
118: ,p_pre_com_desc in varchar2 default hr_api.g_varchar2
119: ,p_counselor_asg in date default hr_api.g_date
120: ,p_init_counselor_interview in date default hr_api.g_date
121: ,p_anonymity_requested in varchar2 default hr_api.g_varchar2
122: ,p_counsel_ext_ltr in date default hr_api.g_date

Line 119: ,p_counselor_asg in date default hr_api.g_date

115: ,p_pre_com_elec in varchar2 default hr_api.g_varchar2
116: --,p_adr_offered in varchar2 default hr_api.g_varchar2
117: ,p_class_agent_flag in varchar2 default hr_api.g_varchar2
118: ,p_pre_com_desc in varchar2 default hr_api.g_varchar2
119: ,p_counselor_asg in date default hr_api.g_date
120: ,p_init_counselor_interview in date default hr_api.g_date
121: ,p_anonymity_requested in varchar2 default hr_api.g_varchar2
122: ,p_counsel_ext_ltr in date default hr_api.g_date
123: ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2

Line 120: ,p_init_counselor_interview in date default hr_api.g_date

116: --,p_adr_offered in varchar2 default hr_api.g_varchar2
117: ,p_class_agent_flag in varchar2 default hr_api.g_varchar2
118: ,p_pre_com_desc in varchar2 default hr_api.g_varchar2
119: ,p_counselor_asg in date default hr_api.g_date
120: ,p_init_counselor_interview in date default hr_api.g_date
121: ,p_anonymity_requested in varchar2 default hr_api.g_varchar2
122: ,p_counsel_ext_ltr in date default hr_api.g_date
123: ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2
124: ,p_final_interview in date default hr_api.g_date

Line 121: ,p_anonymity_requested in varchar2 default hr_api.g_varchar2

117: ,p_class_agent_flag in varchar2 default hr_api.g_varchar2
118: ,p_pre_com_desc in varchar2 default hr_api.g_varchar2
119: ,p_counselor_asg in date default hr_api.g_date
120: ,p_init_counselor_interview in date default hr_api.g_date
121: ,p_anonymity_requested in varchar2 default hr_api.g_varchar2
122: ,p_counsel_ext_ltr in date default hr_api.g_date
123: ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2
124: ,p_final_interview in date default hr_api.g_date
125: ,p_notice_rtf_recvd in date default hr_api.g_date

Line 122: ,p_counsel_ext_ltr in date default hr_api.g_date

118: ,p_pre_com_desc in varchar2 default hr_api.g_varchar2
119: ,p_counselor_asg in date default hr_api.g_date
120: ,p_init_counselor_interview in date default hr_api.g_date
121: ,p_anonymity_requested in varchar2 default hr_api.g_varchar2
122: ,p_counsel_ext_ltr in date default hr_api.g_date
123: ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2
124: ,p_final_interview in date default hr_api.g_date
125: ,p_notice_rtf_recvd in date default hr_api.g_date
126: ,p_precom_closed in date default hr_api.g_date

Line 123: ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2

119: ,p_counselor_asg in date default hr_api.g_date
120: ,p_init_counselor_interview in date default hr_api.g_date
121: ,p_anonymity_requested in varchar2 default hr_api.g_varchar2
122: ,p_counsel_ext_ltr in date default hr_api.g_date
123: ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2
124: ,p_final_interview in date default hr_api.g_date
125: ,p_notice_rtf_recvd in date default hr_api.g_date
126: ,p_precom_closed in date default hr_api.g_date
127: ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2

Line 124: ,p_final_interview in date default hr_api.g_date

120: ,p_init_counselor_interview in date default hr_api.g_date
121: ,p_anonymity_requested in varchar2 default hr_api.g_varchar2
122: ,p_counsel_ext_ltr in date default hr_api.g_date
123: ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2
124: ,p_final_interview in date default hr_api.g_date
125: ,p_notice_rtf_recvd in date default hr_api.g_date
126: ,p_precom_closed in date default hr_api.g_date
127: ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2
128: ,p_counselor_rpt_sub in date default hr_api.g_date

Line 125: ,p_notice_rtf_recvd in date default hr_api.g_date

121: ,p_anonymity_requested in varchar2 default hr_api.g_varchar2
122: ,p_counsel_ext_ltr in date default hr_api.g_date
123: ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2
124: ,p_final_interview in date default hr_api.g_date
125: ,p_notice_rtf_recvd in date default hr_api.g_date
126: ,p_precom_closed in date default hr_api.g_date
127: ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2
128: ,p_counselor_rpt_sub in date default hr_api.g_date
129: ,p_hr_office_org_id in number default hr_api.g_number

Line 126: ,p_precom_closed in date default hr_api.g_date

122: ,p_counsel_ext_ltr in date default hr_api.g_date
123: ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2
124: ,p_final_interview in date default hr_api.g_date
125: ,p_notice_rtf_recvd in date default hr_api.g_date
126: ,p_precom_closed in date default hr_api.g_date
127: ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2
128: ,p_counselor_rpt_sub in date default hr_api.g_date
129: ,p_hr_office_org_id in number default hr_api.g_number
130: ,p_eeo_office_org_id in number default hr_api.g_number

Line 127: ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2

123: ,p_traditional_counsel_outcome in varchar2 default hr_api.g_varchar2
124: ,p_final_interview in date default hr_api.g_date
125: ,p_notice_rtf_recvd in date default hr_api.g_date
126: ,p_precom_closed in date default hr_api.g_date
127: ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2
128: ,p_counselor_rpt_sub in date default hr_api.g_date
129: ,p_hr_office_org_id in number default hr_api.g_number
130: ,p_eeo_office_org_id in number default hr_api.g_number
131: ,p_serviced_org_id in number default hr_api.g_number

Line 128: ,p_counselor_rpt_sub in date default hr_api.g_date

124: ,p_final_interview in date default hr_api.g_date
125: ,p_notice_rtf_recvd in date default hr_api.g_date
126: ,p_precom_closed in date default hr_api.g_date
127: ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2
128: ,p_counselor_rpt_sub in date default hr_api.g_date
129: ,p_hr_office_org_id in number default hr_api.g_number
130: ,p_eeo_office_org_id in number default hr_api.g_number
131: ,p_serviced_org_id in number default hr_api.g_number
132: ,p_formal_com_filed in date default hr_api.g_date

Line 129: ,p_hr_office_org_id in number default hr_api.g_number

125: ,p_notice_rtf_recvd in date default hr_api.g_date
126: ,p_precom_closed in date default hr_api.g_date
127: ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2
128: ,p_counselor_rpt_sub in date default hr_api.g_date
129: ,p_hr_office_org_id in number default hr_api.g_number
130: ,p_eeo_office_org_id in number default hr_api.g_number
131: ,p_serviced_org_id in number default hr_api.g_number
132: ,p_formal_com_filed in date default hr_api.g_date
133: ,p_ack_ltr in date default hr_api.g_date

Line 130: ,p_eeo_office_org_id in number default hr_api.g_number

126: ,p_precom_closed in date default hr_api.g_date
127: ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2
128: ,p_counselor_rpt_sub in date default hr_api.g_date
129: ,p_hr_office_org_id in number default hr_api.g_number
130: ,p_eeo_office_org_id in number default hr_api.g_number
131: ,p_serviced_org_id in number default hr_api.g_number
132: ,p_formal_com_filed in date default hr_api.g_date
133: ,p_ack_ltr in date default hr_api.g_date
134: ,p_clarification_ltr_date in date default hr_api.g_date

Line 131: ,p_serviced_org_id in number default hr_api.g_number

127: ,p_precom_closure_nature in varchar2 default hr_api.g_varchar2
128: ,p_counselor_rpt_sub in date default hr_api.g_date
129: ,p_hr_office_org_id in number default hr_api.g_number
130: ,p_eeo_office_org_id in number default hr_api.g_number
131: ,p_serviced_org_id in number default hr_api.g_number
132: ,p_formal_com_filed in date default hr_api.g_date
133: ,p_ack_ltr in date default hr_api.g_date
134: ,p_clarification_ltr_date in date default hr_api.g_date
135: ,p_clarification_response_recvd in date default hr_api.g_date

Line 132: ,p_formal_com_filed in date default hr_api.g_date

128: ,p_counselor_rpt_sub in date default hr_api.g_date
129: ,p_hr_office_org_id in number default hr_api.g_number
130: ,p_eeo_office_org_id in number default hr_api.g_number
131: ,p_serviced_org_id in number default hr_api.g_number
132: ,p_formal_com_filed in date default hr_api.g_date
133: ,p_ack_ltr in date default hr_api.g_date
134: ,p_clarification_ltr_date in date default hr_api.g_date
135: ,p_clarification_response_recvd in date default hr_api.g_date
136: ,p_forwarded_legal_review in date default hr_api.g_date

Line 133: ,p_ack_ltr in date default hr_api.g_date

129: ,p_hr_office_org_id in number default hr_api.g_number
130: ,p_eeo_office_org_id in number default hr_api.g_number
131: ,p_serviced_org_id in number default hr_api.g_number
132: ,p_formal_com_filed in date default hr_api.g_date
133: ,p_ack_ltr in date default hr_api.g_date
134: ,p_clarification_ltr_date in date default hr_api.g_date
135: ,p_clarification_response_recvd in date default hr_api.g_date
136: ,p_forwarded_legal_review in date default hr_api.g_date
137: ,p_returned_from_legal in date default hr_api.g_date

Line 134: ,p_clarification_ltr_date in date default hr_api.g_date

130: ,p_eeo_office_org_id in number default hr_api.g_number
131: ,p_serviced_org_id in number default hr_api.g_number
132: ,p_formal_com_filed in date default hr_api.g_date
133: ,p_ack_ltr in date default hr_api.g_date
134: ,p_clarification_ltr_date in date default hr_api.g_date
135: ,p_clarification_response_recvd in date default hr_api.g_date
136: ,p_forwarded_legal_review in date default hr_api.g_date
137: ,p_returned_from_legal in date default hr_api.g_date
138: ,p_letter_type in varchar2 default hr_api.g_varchar2

Line 135: ,p_clarification_response_recvd in date default hr_api.g_date

131: ,p_serviced_org_id in number default hr_api.g_number
132: ,p_formal_com_filed in date default hr_api.g_date
133: ,p_ack_ltr in date default hr_api.g_date
134: ,p_clarification_ltr_date in date default hr_api.g_date
135: ,p_clarification_response_recvd in date default hr_api.g_date
136: ,p_forwarded_legal_review in date default hr_api.g_date
137: ,p_returned_from_legal in date default hr_api.g_date
138: ,p_letter_type in varchar2 default hr_api.g_varchar2
139: ,p_letter_date in date default hr_api.g_date

Line 136: ,p_forwarded_legal_review in date default hr_api.g_date

132: ,p_formal_com_filed in date default hr_api.g_date
133: ,p_ack_ltr in date default hr_api.g_date
134: ,p_clarification_ltr_date in date default hr_api.g_date
135: ,p_clarification_response_recvd in date default hr_api.g_date
136: ,p_forwarded_legal_review in date default hr_api.g_date
137: ,p_returned_from_legal in date default hr_api.g_date
138: ,p_letter_type in varchar2 default hr_api.g_varchar2
139: ,p_letter_date in date default hr_api.g_date
140: ,p_letter_recvd in date default hr_api.g_date

Line 137: ,p_returned_from_legal in date default hr_api.g_date

133: ,p_ack_ltr in date default hr_api.g_date
134: ,p_clarification_ltr_date in date default hr_api.g_date
135: ,p_clarification_response_recvd in date default hr_api.g_date
136: ,p_forwarded_legal_review in date default hr_api.g_date
137: ,p_returned_from_legal in date default hr_api.g_date
138: ,p_letter_type in varchar2 default hr_api.g_varchar2
139: ,p_letter_date in date default hr_api.g_date
140: ,p_letter_recvd in date default hr_api.g_date
141: ,p_investigation_source in varchar2 default hr_api.g_varchar2

Line 138: ,p_letter_type in varchar2 default hr_api.g_varchar2

134: ,p_clarification_ltr_date in date default hr_api.g_date
135: ,p_clarification_response_recvd in date default hr_api.g_date
136: ,p_forwarded_legal_review in date default hr_api.g_date
137: ,p_returned_from_legal in date default hr_api.g_date
138: ,p_letter_type in varchar2 default hr_api.g_varchar2
139: ,p_letter_date in date default hr_api.g_date
140: ,p_letter_recvd in date default hr_api.g_date
141: ,p_investigation_source in varchar2 default hr_api.g_varchar2
142: ,p_investigator_recvd_req in date default hr_api.g_date

Line 139: ,p_letter_date in date default hr_api.g_date

135: ,p_clarification_response_recvd in date default hr_api.g_date
136: ,p_forwarded_legal_review in date default hr_api.g_date
137: ,p_returned_from_legal in date default hr_api.g_date
138: ,p_letter_type in varchar2 default hr_api.g_varchar2
139: ,p_letter_date in date default hr_api.g_date
140: ,p_letter_recvd in date default hr_api.g_date
141: ,p_investigation_source in varchar2 default hr_api.g_varchar2
142: ,p_investigator_recvd_req in date default hr_api.g_date
143: ,p_agency_investigator_req in date default hr_api.g_date

Line 140: ,p_letter_recvd in date default hr_api.g_date

136: ,p_forwarded_legal_review in date default hr_api.g_date
137: ,p_returned_from_legal in date default hr_api.g_date
138: ,p_letter_type in varchar2 default hr_api.g_varchar2
139: ,p_letter_date in date default hr_api.g_date
140: ,p_letter_recvd in date default hr_api.g_date
141: ,p_investigation_source in varchar2 default hr_api.g_varchar2
142: ,p_investigator_recvd_req in date default hr_api.g_date
143: ,p_agency_investigator_req in date default hr_api.g_date
144: ,p_investigator_asg in date default hr_api.g_date

Line 141: ,p_investigation_source in varchar2 default hr_api.g_varchar2

137: ,p_returned_from_legal in date default hr_api.g_date
138: ,p_letter_type in varchar2 default hr_api.g_varchar2
139: ,p_letter_date in date default hr_api.g_date
140: ,p_letter_recvd in date default hr_api.g_date
141: ,p_investigation_source in varchar2 default hr_api.g_varchar2
142: ,p_investigator_recvd_req in date default hr_api.g_date
143: ,p_agency_investigator_req in date default hr_api.g_date
144: ,p_investigator_asg in date default hr_api.g_date
145: ,p_investigation_start in date default hr_api.g_date

Line 142: ,p_investigator_recvd_req in date default hr_api.g_date

138: ,p_letter_type in varchar2 default hr_api.g_varchar2
139: ,p_letter_date in date default hr_api.g_date
140: ,p_letter_recvd in date default hr_api.g_date
141: ,p_investigation_source in varchar2 default hr_api.g_varchar2
142: ,p_investigator_recvd_req in date default hr_api.g_date
143: ,p_agency_investigator_req in date default hr_api.g_date
144: ,p_investigator_asg in date default hr_api.g_date
145: ,p_investigation_start in date default hr_api.g_date
146: ,p_investigation_end in date default hr_api.g_date

Line 143: ,p_agency_investigator_req in date default hr_api.g_date

139: ,p_letter_date in date default hr_api.g_date
140: ,p_letter_recvd in date default hr_api.g_date
141: ,p_investigation_source in varchar2 default hr_api.g_varchar2
142: ,p_investigator_recvd_req in date default hr_api.g_date
143: ,p_agency_investigator_req in date default hr_api.g_date
144: ,p_investigator_asg in date default hr_api.g_date
145: ,p_investigation_start in date default hr_api.g_date
146: ,p_investigation_end in date default hr_api.g_date
147: ,p_investigation_extended in date default hr_api.g_date

Line 144: ,p_investigator_asg in date default hr_api.g_date

140: ,p_letter_recvd in date default hr_api.g_date
141: ,p_investigation_source in varchar2 default hr_api.g_varchar2
142: ,p_investigator_recvd_req in date default hr_api.g_date
143: ,p_agency_investigator_req in date default hr_api.g_date
144: ,p_investigator_asg in date default hr_api.g_date
145: ,p_investigation_start in date default hr_api.g_date
146: ,p_investigation_end in date default hr_api.g_date
147: ,p_investigation_extended in date default hr_api.g_date
148: ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2

Line 145: ,p_investigation_start in date default hr_api.g_date

141: ,p_investigation_source in varchar2 default hr_api.g_varchar2
142: ,p_investigator_recvd_req in date default hr_api.g_date
143: ,p_agency_investigator_req in date default hr_api.g_date
144: ,p_investigator_asg in date default hr_api.g_date
145: ,p_investigation_start in date default hr_api.g_date
146: ,p_investigation_end in date default hr_api.g_date
147: ,p_investigation_extended in date default hr_api.g_date
148: ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2
149: ,p_agency_recvd_roi in date default hr_api.g_date

Line 146: ,p_investigation_end in date default hr_api.g_date

142: ,p_investigator_recvd_req in date default hr_api.g_date
143: ,p_agency_investigator_req in date default hr_api.g_date
144: ,p_investigator_asg in date default hr_api.g_date
145: ,p_investigation_start in date default hr_api.g_date
146: ,p_investigation_end in date default hr_api.g_date
147: ,p_investigation_extended in date default hr_api.g_date
148: ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2
149: ,p_agency_recvd_roi in date default hr_api.g_date
150: ,p_comrep_recvd_roi in date default hr_api.g_date

Line 147: ,p_investigation_extended in date default hr_api.g_date

143: ,p_agency_investigator_req in date default hr_api.g_date
144: ,p_investigator_asg in date default hr_api.g_date
145: ,p_investigation_start in date default hr_api.g_date
146: ,p_investigation_end in date default hr_api.g_date
147: ,p_investigation_extended in date default hr_api.g_date
148: ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2
149: ,p_agency_recvd_roi in date default hr_api.g_date
150: ,p_comrep_recvd_roi in date default hr_api.g_date
151: ,p_options_ltr_date in date default hr_api.g_date

Line 148: ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2

144: ,p_investigator_asg in date default hr_api.g_date
145: ,p_investigation_start in date default hr_api.g_date
146: ,p_investigation_end in date default hr_api.g_date
147: ,p_investigation_extended in date default hr_api.g_date
148: ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2
149: ,p_agency_recvd_roi in date default hr_api.g_date
150: ,p_comrep_recvd_roi in date default hr_api.g_date
151: ,p_options_ltr_date in date default hr_api.g_date
152: ,p_comrep_recvd_opt_ltr in date default hr_api.g_date

Line 149: ,p_agency_recvd_roi in date default hr_api.g_date

145: ,p_investigation_start in date default hr_api.g_date
146: ,p_investigation_end in date default hr_api.g_date
147: ,p_investigation_extended in date default hr_api.g_date
148: ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2
149: ,p_agency_recvd_roi in date default hr_api.g_date
150: ,p_comrep_recvd_roi in date default hr_api.g_date
151: ,p_options_ltr_date in date default hr_api.g_date
152: ,p_comrep_recvd_opt_ltr in date default hr_api.g_date
153: ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2

Line 150: ,p_comrep_recvd_roi in date default hr_api.g_date

146: ,p_investigation_end in date default hr_api.g_date
147: ,p_investigation_extended in date default hr_api.g_date
148: ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2
149: ,p_agency_recvd_roi in date default hr_api.g_date
150: ,p_comrep_recvd_roi in date default hr_api.g_date
151: ,p_options_ltr_date in date default hr_api.g_date
152: ,p_comrep_recvd_opt_ltr in date default hr_api.g_date
153: ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2
154: ,p_resolution_offer in date default hr_api.g_date

Line 151: ,p_options_ltr_date in date default hr_api.g_date

147: ,p_investigation_extended in date default hr_api.g_date
148: ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2
149: ,p_agency_recvd_roi in date default hr_api.g_date
150: ,p_comrep_recvd_roi in date default hr_api.g_date
151: ,p_options_ltr_date in date default hr_api.g_date
152: ,p_comrep_recvd_opt_ltr in date default hr_api.g_date
153: ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2
154: ,p_resolution_offer in date default hr_api.g_date
155: ,p_comrep_resol_offer_recvd in date default hr_api.g_date

Line 152: ,p_comrep_recvd_opt_ltr in date default hr_api.g_date

148: ,p_invest_extension_desc in varchar2 default hr_api.g_varchar2
149: ,p_agency_recvd_roi in date default hr_api.g_date
150: ,p_comrep_recvd_roi in date default hr_api.g_date
151: ,p_options_ltr_date in date default hr_api.g_date
152: ,p_comrep_recvd_opt_ltr in date default hr_api.g_date
153: ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2
154: ,p_resolution_offer in date default hr_api.g_date
155: ,p_comrep_resol_offer_recvd in date default hr_api.g_date
156: ,p_comrep_resol_offer_response in date default hr_api.g_date

Line 153: ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2

149: ,p_agency_recvd_roi in date default hr_api.g_date
150: ,p_comrep_recvd_roi in date default hr_api.g_date
151: ,p_options_ltr_date in date default hr_api.g_date
152: ,p_comrep_recvd_opt_ltr in date default hr_api.g_date
153: ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2
154: ,p_resolution_offer in date default hr_api.g_date
155: ,p_comrep_resol_offer_recvd in date default hr_api.g_date
156: ,p_comrep_resol_offer_response in date default hr_api.g_date
157: ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2

Line 154: ,p_resolution_offer in date default hr_api.g_date

150: ,p_comrep_recvd_roi in date default hr_api.g_date
151: ,p_options_ltr_date in date default hr_api.g_date
152: ,p_comrep_recvd_opt_ltr in date default hr_api.g_date
153: ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2
154: ,p_resolution_offer in date default hr_api.g_date
155: ,p_comrep_resol_offer_recvd in date default hr_api.g_date
156: ,p_comrep_resol_offer_response in date default hr_api.g_date
157: ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2
158: ,p_resol_offer_signed in date default hr_api.g_date

Line 155: ,p_comrep_resol_offer_recvd in date default hr_api.g_date

151: ,p_options_ltr_date in date default hr_api.g_date
152: ,p_comrep_recvd_opt_ltr in date default hr_api.g_date
153: ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2
154: ,p_resolution_offer in date default hr_api.g_date
155: ,p_comrep_resol_offer_recvd in date default hr_api.g_date
156: ,p_comrep_resol_offer_response in date default hr_api.g_date
157: ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2
158: ,p_resol_offer_signed in date default hr_api.g_date
159: ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2

Line 156: ,p_comrep_resol_offer_response in date default hr_api.g_date

152: ,p_comrep_recvd_opt_ltr in date default hr_api.g_date
153: ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2
154: ,p_resolution_offer in date default hr_api.g_date
155: ,p_comrep_resol_offer_recvd in date default hr_api.g_date
156: ,p_comrep_resol_offer_response in date default hr_api.g_date
157: ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2
158: ,p_resol_offer_signed in date default hr_api.g_date
159: ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2
160: ,p_hearing_source in varchar2 default hr_api.g_varchar2

Line 157: ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2

153: ,p_comrep_opt_ltr_response in varchar2 default hr_api.g_varchar2
154: ,p_resolution_offer in date default hr_api.g_date
155: ,p_comrep_resol_offer_recvd in date default hr_api.g_date
156: ,p_comrep_resol_offer_response in date default hr_api.g_date
157: ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2
158: ,p_resol_offer_signed in date default hr_api.g_date
159: ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2
160: ,p_hearing_source in varchar2 default hr_api.g_varchar2
161: ,p_agency_notified_hearing in date default hr_api.g_date

Line 158: ,p_resol_offer_signed in date default hr_api.g_date

154: ,p_resolution_offer in date default hr_api.g_date
155: ,p_comrep_resol_offer_recvd in date default hr_api.g_date
156: ,p_comrep_resol_offer_response in date default hr_api.g_date
157: ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2
158: ,p_resol_offer_signed in date default hr_api.g_date
159: ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2
160: ,p_hearing_source in varchar2 default hr_api.g_varchar2
161: ,p_agency_notified_hearing in date default hr_api.g_date
162: ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2

Line 159: ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2

155: ,p_comrep_resol_offer_recvd in date default hr_api.g_date
156: ,p_comrep_resol_offer_response in date default hr_api.g_date
157: ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2
158: ,p_resol_offer_signed in date default hr_api.g_date
159: ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2
160: ,p_hearing_source in varchar2 default hr_api.g_varchar2
161: ,p_agency_notified_hearing in date default hr_api.g_date
162: ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2
163: ,p_hearing_complete in date default hr_api.g_date

Line 160: ,p_hearing_source in varchar2 default hr_api.g_varchar2

156: ,p_comrep_resol_offer_response in date default hr_api.g_date
157: ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2
158: ,p_resol_offer_signed in date default hr_api.g_date
159: ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2
160: ,p_hearing_source in varchar2 default hr_api.g_varchar2
161: ,p_agency_notified_hearing in date default hr_api.g_date
162: ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2
163: ,p_hearing_complete in date default hr_api.g_date
164: ,p_aj_merit_decision_date in date default hr_api.g_date

Line 161: ,p_agency_notified_hearing in date default hr_api.g_date

157: ,p_comrep_resol_offer_desc in varchar2 default hr_api.g_varchar2
158: ,p_resol_offer_signed in date default hr_api.g_date
159: ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2
160: ,p_hearing_source in varchar2 default hr_api.g_varchar2
161: ,p_agency_notified_hearing in date default hr_api.g_date
162: ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2
163: ,p_hearing_complete in date default hr_api.g_date
164: ,p_aj_merit_decision_date in date default hr_api.g_date
165: ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date

Line 162: ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2

158: ,p_resol_offer_signed in date default hr_api.g_date
159: ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2
160: ,p_hearing_source in varchar2 default hr_api.g_varchar2
161: ,p_agency_notified_hearing in date default hr_api.g_date
162: ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2
163: ,p_hearing_complete in date default hr_api.g_date
164: ,p_aj_merit_decision_date in date default hr_api.g_date
165: ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date
166: ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2

Line 163: ,p_hearing_complete in date default hr_api.g_date

159: ,p_resol_offer_desc in varchar2 default hr_api.g_varchar2
160: ,p_hearing_source in varchar2 default hr_api.g_varchar2
161: ,p_agency_notified_hearing in date default hr_api.g_date
162: ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2
163: ,p_hearing_complete in date default hr_api.g_date
164: ,p_aj_merit_decision_date in date default hr_api.g_date
165: ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date
166: ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2
167: ,p_aj_ca_decision_date in date default hr_api.g_date

Line 164: ,p_aj_merit_decision_date in date default hr_api.g_date

160: ,p_hearing_source in varchar2 default hr_api.g_varchar2
161: ,p_agency_notified_hearing in date default hr_api.g_date
162: ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2
163: ,p_hearing_complete in date default hr_api.g_date
164: ,p_aj_merit_decision_date in date default hr_api.g_date
165: ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date
166: ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2
167: ,p_aj_ca_decision_date in date default hr_api.g_date
168: ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date

Line 165: ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date

161: ,p_agency_notified_hearing in date default hr_api.g_date
162: ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2
163: ,p_hearing_complete in date default hr_api.g_date
164: ,p_aj_merit_decision_date in date default hr_api.g_date
165: ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date
166: ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2
167: ,p_aj_ca_decision_date in date default hr_api.g_date
168: ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date
169: ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2

Line 166: ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2

162: ,p_eeoc_hearing_docket_num in varchar2 default hr_api.g_varchar2
163: ,p_hearing_complete in date default hr_api.g_date
164: ,p_aj_merit_decision_date in date default hr_api.g_date
165: ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date
166: ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2
167: ,p_aj_ca_decision_date in date default hr_api.g_date
168: ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date
169: ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2
170: ,p_fad_requested in date default hr_api.g_date

Line 167: ,p_aj_ca_decision_date in date default hr_api.g_date

163: ,p_hearing_complete in date default hr_api.g_date
164: ,p_aj_merit_decision_date in date default hr_api.g_date
165: ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date
166: ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2
167: ,p_aj_ca_decision_date in date default hr_api.g_date
168: ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date
169: ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2
170: ,p_fad_requested in date default hr_api.g_date
171: ,p_merit_fad in varchar2 default hr_api.g_varchar2

Line 168: ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date

164: ,p_aj_merit_decision_date in date default hr_api.g_date
165: ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date
166: ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2
167: ,p_aj_ca_decision_date in date default hr_api.g_date
168: ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date
169: ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2
170: ,p_fad_requested in date default hr_api.g_date
171: ,p_merit_fad in varchar2 default hr_api.g_varchar2
172: ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2

Line 169: ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2

165: ,p_agency_recvd_aj_merit_dec in date default hr_api.g_date
166: ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2
167: ,p_aj_ca_decision_date in date default hr_api.g_date
168: ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date
169: ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2
170: ,p_fad_requested in date default hr_api.g_date
171: ,p_merit_fad in varchar2 default hr_api.g_varchar2
172: ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2
173: ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2

Line 170: ,p_fad_requested in date default hr_api.g_date

166: ,p_aj_merit_decision in varchar2 default hr_api.g_varchar2
167: ,p_aj_ca_decision_date in date default hr_api.g_date
168: ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date
169: ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2
170: ,p_fad_requested in date default hr_api.g_date
171: ,p_merit_fad in varchar2 default hr_api.g_varchar2
172: ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2
173: ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2
174: ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2

Line 171: ,p_merit_fad in varchar2 default hr_api.g_varchar2

167: ,p_aj_ca_decision_date in date default hr_api.g_date
168: ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date
169: ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2
170: ,p_fad_requested in date default hr_api.g_date
171: ,p_merit_fad in varchar2 default hr_api.g_varchar2
172: ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2
173: ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2
174: ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2
175: ,p_fad_req_recvd_eeo_office in date default hr_api.g_date

Line 172: ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2

168: ,p_agency_recvd_aj_ca_dec in date default hr_api.g_date
169: ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2
170: ,p_fad_requested in date default hr_api.g_date
171: ,p_merit_fad in varchar2 default hr_api.g_varchar2
172: ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2
173: ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2
174: ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2
175: ,p_fad_req_recvd_eeo_office in date default hr_api.g_date
176: ,p_fad_req_forwd_to_agency in date default hr_api.g_date

Line 173: ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2

169: ,p_aj_ca_decision in varchar2 default hr_api.g_varchar2
170: ,p_fad_requested in date default hr_api.g_date
171: ,p_merit_fad in varchar2 default hr_api.g_varchar2
172: ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2
173: ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2
174: ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2
175: ,p_fad_req_recvd_eeo_office in date default hr_api.g_date
176: ,p_fad_req_forwd_to_agency in date default hr_api.g_date
177: ,p_agency_recvd_request in date default hr_api.g_date

Line 174: ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2

170: ,p_fad_requested in date default hr_api.g_date
171: ,p_merit_fad in varchar2 default hr_api.g_varchar2
172: ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2
173: ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2
174: ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2
175: ,p_fad_req_recvd_eeo_office in date default hr_api.g_date
176: ,p_fad_req_forwd_to_agency in date default hr_api.g_date
177: ,p_agency_recvd_request in date default hr_api.g_date
178: ,p_fad_due in date default hr_api.g_date

Line 175: ,p_fad_req_recvd_eeo_office in date default hr_api.g_date

171: ,p_merit_fad in varchar2 default hr_api.g_varchar2
172: ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2
173: ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2
174: ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2
175: ,p_fad_req_recvd_eeo_office in date default hr_api.g_date
176: ,p_fad_req_forwd_to_agency in date default hr_api.g_date
177: ,p_agency_recvd_request in date default hr_api.g_date
178: ,p_fad_due in date default hr_api.g_date
179: ,p_fad_date in date default hr_api.g_date

Line 176: ,p_fad_req_forwd_to_agency in date default hr_api.g_date

172: ,p_attorney_fees_fad in varchar2 default hr_api.g_varchar2
173: ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2
174: ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2
175: ,p_fad_req_recvd_eeo_office in date default hr_api.g_date
176: ,p_fad_req_forwd_to_agency in date default hr_api.g_date
177: ,p_agency_recvd_request in date default hr_api.g_date
178: ,p_fad_due in date default hr_api.g_date
179: ,p_fad_date in date default hr_api.g_date
180: ,p_fad_decision in varchar2 default hr_api.g_varchar2

Line 177: ,p_agency_recvd_request in date default hr_api.g_date

173: ,p_comp_damages_fad in varchar2 default hr_api.g_varchar2
174: ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2
175: ,p_fad_req_recvd_eeo_office in date default hr_api.g_date
176: ,p_fad_req_forwd_to_agency in date default hr_api.g_date
177: ,p_agency_recvd_request in date default hr_api.g_date
178: ,p_fad_due in date default hr_api.g_date
179: ,p_fad_date in date default hr_api.g_date
180: ,p_fad_decision in varchar2 default hr_api.g_varchar2
181: -- ,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2

Line 178: ,p_fad_due in date default hr_api.g_date

174: ,p_non_compliance_fad in varchar2 default hr_api.g_varchar2
175: ,p_fad_req_recvd_eeo_office in date default hr_api.g_date
176: ,p_fad_req_forwd_to_agency in date default hr_api.g_date
177: ,p_agency_recvd_request in date default hr_api.g_date
178: ,p_fad_due in date default hr_api.g_date
179: ,p_fad_date in date default hr_api.g_date
180: ,p_fad_decision in varchar2 default hr_api.g_varchar2
181: -- ,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2
182: ,p_fad_forwd_to_comrep in date default hr_api.g_date

Line 179: ,p_fad_date in date default hr_api.g_date

175: ,p_fad_req_recvd_eeo_office in date default hr_api.g_date
176: ,p_fad_req_forwd_to_agency in date default hr_api.g_date
177: ,p_agency_recvd_request in date default hr_api.g_date
178: ,p_fad_due in date default hr_api.g_date
179: ,p_fad_date in date default hr_api.g_date
180: ,p_fad_decision in varchar2 default hr_api.g_varchar2
181: -- ,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2
182: ,p_fad_forwd_to_comrep in date default hr_api.g_date
183: ,p_fad_recvd_by_comrep in date default hr_api.g_date

Line 180: ,p_fad_decision in varchar2 default hr_api.g_varchar2

176: ,p_fad_req_forwd_to_agency in date default hr_api.g_date
177: ,p_agency_recvd_request in date default hr_api.g_date
178: ,p_fad_due in date default hr_api.g_date
179: ,p_fad_date in date default hr_api.g_date
180: ,p_fad_decision in varchar2 default hr_api.g_varchar2
181: -- ,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2
182: ,p_fad_forwd_to_comrep in date default hr_api.g_date
183: ,p_fad_recvd_by_comrep in date default hr_api.g_date
184: ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date

Line 181: -- ,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2

177: ,p_agency_recvd_request in date default hr_api.g_date
178: ,p_fad_due in date default hr_api.g_date
179: ,p_fad_date in date default hr_api.g_date
180: ,p_fad_decision in varchar2 default hr_api.g_varchar2
181: -- ,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2
182: ,p_fad_forwd_to_comrep in date default hr_api.g_date
183: ,p_fad_recvd_by_comrep in date default hr_api.g_date
184: ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date
185: ,p_fad_decision_forwd_legal in date default hr_api.g_date

Line 182: ,p_fad_forwd_to_comrep in date default hr_api.g_date

178: ,p_fad_due in date default hr_api.g_date
179: ,p_fad_date in date default hr_api.g_date
180: ,p_fad_decision in varchar2 default hr_api.g_varchar2
181: -- ,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2
182: ,p_fad_forwd_to_comrep in date default hr_api.g_date
183: ,p_fad_recvd_by_comrep in date default hr_api.g_date
184: ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date
185: ,p_fad_decision_forwd_legal in date default hr_api.g_date
186: ,p_fad_decision_recvd_legal in date default hr_api.g_date

Line 183: ,p_fad_recvd_by_comrep in date default hr_api.g_date

179: ,p_fad_date in date default hr_api.g_date
180: ,p_fad_decision in varchar2 default hr_api.g_varchar2
181: -- ,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2
182: ,p_fad_forwd_to_comrep in date default hr_api.g_date
183: ,p_fad_recvd_by_comrep in date default hr_api.g_date
184: ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date
185: ,p_fad_decision_forwd_legal in date default hr_api.g_date
186: ,p_fad_decision_recvd_legal in date default hr_api.g_date
187: ,p_fa_source in varchar2 default hr_api.g_varchar2

Line 184: ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date

180: ,p_fad_decision in varchar2 default hr_api.g_varchar2
181: -- ,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2
182: ,p_fad_forwd_to_comrep in date default hr_api.g_date
183: ,p_fad_recvd_by_comrep in date default hr_api.g_date
184: ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date
185: ,p_fad_decision_forwd_legal in date default hr_api.g_date
186: ,p_fad_decision_recvd_legal in date default hr_api.g_date
187: ,p_fa_source in varchar2 default hr_api.g_varchar2
188: ,p_final_action_due in date default hr_api.g_date

Line 185: ,p_fad_decision_forwd_legal in date default hr_api.g_date

181: -- ,p_fad_final_action_closure in varchar2 default hr_api.g_varchar2
182: ,p_fad_forwd_to_comrep in date default hr_api.g_date
183: ,p_fad_recvd_by_comrep in date default hr_api.g_date
184: ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date
185: ,p_fad_decision_forwd_legal in date default hr_api.g_date
186: ,p_fad_decision_recvd_legal in date default hr_api.g_date
187: ,p_fa_source in varchar2 default hr_api.g_varchar2
188: ,p_final_action_due in date default hr_api.g_date
189: --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2

Line 186: ,p_fad_decision_recvd_legal in date default hr_api.g_date

182: ,p_fad_forwd_to_comrep in date default hr_api.g_date
183: ,p_fad_recvd_by_comrep in date default hr_api.g_date
184: ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date
185: ,p_fad_decision_forwd_legal in date default hr_api.g_date
186: ,p_fad_decision_recvd_legal in date default hr_api.g_date
187: ,p_fa_source in varchar2 default hr_api.g_varchar2
188: ,p_final_action_due in date default hr_api.g_date
189: --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2
190: ,p_final_act_forwd_comrep in date default hr_api.g_date

Line 187: ,p_fa_source in varchar2 default hr_api.g_varchar2

183: ,p_fad_recvd_by_comrep in date default hr_api.g_date
184: ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date
185: ,p_fad_decision_forwd_legal in date default hr_api.g_date
186: ,p_fad_decision_recvd_legal in date default hr_api.g_date
187: ,p_fa_source in varchar2 default hr_api.g_varchar2
188: ,p_final_action_due in date default hr_api.g_date
189: --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2
190: ,p_final_act_forwd_comrep in date default hr_api.g_date
191: ,p_final_act_recvd_comrep in date default hr_api.g_date

Line 188: ,p_final_action_due in date default hr_api.g_date

184: ,p_fad_imp_ltr_forwd_to_org in date default hr_api.g_date
185: ,p_fad_decision_forwd_legal in date default hr_api.g_date
186: ,p_fad_decision_recvd_legal in date default hr_api.g_date
187: ,p_fa_source in varchar2 default hr_api.g_varchar2
188: ,p_final_action_due in date default hr_api.g_date
189: --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2
190: ,p_final_act_forwd_comrep in date default hr_api.g_date
191: ,p_final_act_recvd_comrep in date default hr_api.g_date
192: ,p_final_action_decision_date in date default hr_api.g_date

Line 189: --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2

185: ,p_fad_decision_forwd_legal in date default hr_api.g_date
186: ,p_fad_decision_recvd_legal in date default hr_api.g_date
187: ,p_fa_source in varchar2 default hr_api.g_varchar2
188: ,p_final_action_due in date default hr_api.g_date
189: --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2
190: ,p_final_act_forwd_comrep in date default hr_api.g_date
191: ,p_final_act_recvd_comrep in date default hr_api.g_date
192: ,p_final_action_decision_date in date default hr_api.g_date
193: ,p_final_action_decision in varchar2 default hr_api.g_varchar2

Line 190: ,p_final_act_forwd_comrep in date default hr_api.g_date

186: ,p_fad_decision_recvd_legal in date default hr_api.g_date
187: ,p_fa_source in varchar2 default hr_api.g_varchar2
188: ,p_final_action_due in date default hr_api.g_date
189: --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2
190: ,p_final_act_forwd_comrep in date default hr_api.g_date
191: ,p_final_act_recvd_comrep in date default hr_api.g_date
192: ,p_final_action_decision_date in date default hr_api.g_date
193: ,p_final_action_decision in varchar2 default hr_api.g_varchar2
194: ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date

Line 191: ,p_final_act_recvd_comrep in date default hr_api.g_date

187: ,p_fa_source in varchar2 default hr_api.g_varchar2
188: ,p_final_action_due in date default hr_api.g_date
189: --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2
190: ,p_final_act_forwd_comrep in date default hr_api.g_date
191: ,p_final_act_recvd_comrep in date default hr_api.g_date
192: ,p_final_action_decision_date in date default hr_api.g_date
193: ,p_final_action_decision in varchar2 default hr_api.g_varchar2
194: ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date
195: ,p_fa_decision_forwd_legal in date default hr_api.g_date

Line 192: ,p_final_action_decision_date in date default hr_api.g_date

188: ,p_final_action_due in date default hr_api.g_date
189: --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2
190: ,p_final_act_forwd_comrep in date default hr_api.g_date
191: ,p_final_act_recvd_comrep in date default hr_api.g_date
192: ,p_final_action_decision_date in date default hr_api.g_date
193: ,p_final_action_decision in varchar2 default hr_api.g_varchar2
194: ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date
195: ,p_fa_decision_forwd_legal in date default hr_api.g_date
196: ,p_fa_decision_recvd_legal in date default hr_api.g_date

Line 193: ,p_final_action_decision in varchar2 default hr_api.g_varchar2

189: --,p_final_action_nature_of_closu in varchar2 default hr_api.g_varchar2
190: ,p_final_act_forwd_comrep in date default hr_api.g_date
191: ,p_final_act_recvd_comrep in date default hr_api.g_date
192: ,p_final_action_decision_date in date default hr_api.g_date
193: ,p_final_action_decision in varchar2 default hr_api.g_varchar2
194: ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date
195: ,p_fa_decision_forwd_legal in date default hr_api.g_date
196: ,p_fa_decision_recvd_legal in date default hr_api.g_date
197: ,p_civil_action_filed in date default hr_api.g_date

Line 194: ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date

190: ,p_final_act_forwd_comrep in date default hr_api.g_date
191: ,p_final_act_recvd_comrep in date default hr_api.g_date
192: ,p_final_action_decision_date in date default hr_api.g_date
193: ,p_final_action_decision in varchar2 default hr_api.g_varchar2
194: ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date
195: ,p_fa_decision_forwd_legal in date default hr_api.g_date
196: ,p_fa_decision_recvd_legal in date default hr_api.g_date
197: ,p_civil_action_filed in date default hr_api.g_date
198: ,p_agency_closure_confirmed in date default hr_api.g_date

Line 195: ,p_fa_decision_forwd_legal in date default hr_api.g_date

191: ,p_final_act_recvd_comrep in date default hr_api.g_date
192: ,p_final_action_decision_date in date default hr_api.g_date
193: ,p_final_action_decision in varchar2 default hr_api.g_varchar2
194: ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date
195: ,p_fa_decision_forwd_legal in date default hr_api.g_date
196: ,p_fa_decision_recvd_legal in date default hr_api.g_date
197: ,p_civil_action_filed in date default hr_api.g_date
198: ,p_agency_closure_confirmed in date default hr_api.g_date
199: ,p_consolidated_complaint_id in number default hr_api.g_number

Line 196: ,p_fa_decision_recvd_legal in date default hr_api.g_date

192: ,p_final_action_decision_date in date default hr_api.g_date
193: ,p_final_action_decision in varchar2 default hr_api.g_varchar2
194: ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date
195: ,p_fa_decision_forwd_legal in date default hr_api.g_date
196: ,p_fa_decision_recvd_legal in date default hr_api.g_date
197: ,p_civil_action_filed in date default hr_api.g_date
198: ,p_agency_closure_confirmed in date default hr_api.g_date
199: ,p_consolidated_complaint_id in number default hr_api.g_number
200: ,p_consolidated in date default hr_api.g_date

Line 197: ,p_civil_action_filed in date default hr_api.g_date

193: ,p_final_action_decision in varchar2 default hr_api.g_varchar2
194: ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date
195: ,p_fa_decision_forwd_legal in date default hr_api.g_date
196: ,p_fa_decision_recvd_legal in date default hr_api.g_date
197: ,p_civil_action_filed in date default hr_api.g_date
198: ,p_agency_closure_confirmed in date default hr_api.g_date
199: ,p_consolidated_complaint_id in number default hr_api.g_number
200: ,p_consolidated in date default hr_api.g_date
201: ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2

Line 198: ,p_agency_closure_confirmed in date default hr_api.g_date

194: ,p_fa_imp_ltr_forwd_to_org in date default hr_api.g_date
195: ,p_fa_decision_forwd_legal in date default hr_api.g_date
196: ,p_fa_decision_recvd_legal in date default hr_api.g_date
197: ,p_civil_action_filed in date default hr_api.g_date
198: ,p_agency_closure_confirmed in date default hr_api.g_date
199: ,p_consolidated_complaint_id in number default hr_api.g_number
200: ,p_consolidated in date default hr_api.g_date
201: ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2
202: ,p_comrep_notif_consolidation in date default hr_api.g_date

Line 199: ,p_consolidated_complaint_id in number default hr_api.g_number

195: ,p_fa_decision_forwd_legal in date default hr_api.g_date
196: ,p_fa_decision_recvd_legal in date default hr_api.g_date
197: ,p_civil_action_filed in date default hr_api.g_date
198: ,p_agency_closure_confirmed in date default hr_api.g_date
199: ,p_consolidated_complaint_id in number default hr_api.g_number
200: ,p_consolidated in date default hr_api.g_date
201: ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2
202: ,p_comrep_notif_consolidation in date default hr_api.g_date
203: ,p_consolidation_desc in varchar2 default hr_api.g_varchar2

Line 200: ,p_consolidated in date default hr_api.g_date

196: ,p_fa_decision_recvd_legal in date default hr_api.g_date
197: ,p_civil_action_filed in date default hr_api.g_date
198: ,p_agency_closure_confirmed in date default hr_api.g_date
199: ,p_consolidated_complaint_id in number default hr_api.g_number
200: ,p_consolidated in date default hr_api.g_date
201: ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2
202: ,p_comrep_notif_consolidation in date default hr_api.g_date
203: ,p_consolidation_desc in varchar2 default hr_api.g_varchar2
204: ,p_complaint_closed in date default hr_api.g_date

Line 201: ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2

197: ,p_civil_action_filed in date default hr_api.g_date
198: ,p_agency_closure_confirmed in date default hr_api.g_date
199: ,p_consolidated_complaint_id in number default hr_api.g_number
200: ,p_consolidated in date default hr_api.g_date
201: ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2
202: ,p_comrep_notif_consolidation in date default hr_api.g_date
203: ,p_consolidation_desc in varchar2 default hr_api.g_varchar2
204: ,p_complaint_closed in date default hr_api.g_date
205: ,p_nature_of_closure in varchar2 default hr_api.g_varchar2

Line 202: ,p_comrep_notif_consolidation in date default hr_api.g_date

198: ,p_agency_closure_confirmed in date default hr_api.g_date
199: ,p_consolidated_complaint_id in number default hr_api.g_number
200: ,p_consolidated in date default hr_api.g_date
201: ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2
202: ,p_comrep_notif_consolidation in date default hr_api.g_date
203: ,p_consolidation_desc in varchar2 default hr_api.g_varchar2
204: ,p_complaint_closed in date default hr_api.g_date
205: ,p_nature_of_closure in varchar2 default hr_api.g_varchar2
206: ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2

Line 203: ,p_consolidation_desc in varchar2 default hr_api.g_varchar2

199: ,p_consolidated_complaint_id in number default hr_api.g_number
200: ,p_consolidated in date default hr_api.g_date
201: ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2
202: ,p_comrep_notif_consolidation in date default hr_api.g_date
203: ,p_consolidation_desc in varchar2 default hr_api.g_varchar2
204: ,p_complaint_closed in date default hr_api.g_date
205: ,p_nature_of_closure in varchar2 default hr_api.g_varchar2
206: ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2
207: ,p_filed_formal_class in date default hr_api.g_date

Line 204: ,p_complaint_closed in date default hr_api.g_date

200: ,p_consolidated in date default hr_api.g_date
201: ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2
202: ,p_comrep_notif_consolidation in date default hr_api.g_date
203: ,p_consolidation_desc in varchar2 default hr_api.g_varchar2
204: ,p_complaint_closed in date default hr_api.g_date
205: ,p_nature_of_closure in varchar2 default hr_api.g_varchar2
206: ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2
207: ,p_filed_formal_class in date default hr_api.g_date
208: ,p_forwd_eeoc in date default hr_api.g_date

Line 205: ,p_nature_of_closure in varchar2 default hr_api.g_varchar2

201: ,p_stage_of_consolidation in varchar2 default hr_api.g_varchar2
202: ,p_comrep_notif_consolidation in date default hr_api.g_date
203: ,p_consolidation_desc in varchar2 default hr_api.g_varchar2
204: ,p_complaint_closed in date default hr_api.g_date
205: ,p_nature_of_closure in varchar2 default hr_api.g_varchar2
206: ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2
207: ,p_filed_formal_class in date default hr_api.g_date
208: ,p_forwd_eeoc in date default hr_api.g_date
209: ,p_aj_cert_decision_date in date default hr_api.g_date

Line 206: ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2

202: ,p_comrep_notif_consolidation in date default hr_api.g_date
203: ,p_consolidation_desc in varchar2 default hr_api.g_varchar2
204: ,p_complaint_closed in date default hr_api.g_date
205: ,p_nature_of_closure in varchar2 default hr_api.g_varchar2
206: ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2
207: ,p_filed_formal_class in date default hr_api.g_date
208: ,p_forwd_eeoc in date default hr_api.g_date
209: ,p_aj_cert_decision_date in date default hr_api.g_date
210: ,p_aj_cert_decision_recvd in date default hr_api.g_date

Line 207: ,p_filed_formal_class in date default hr_api.g_date

203: ,p_consolidation_desc in varchar2 default hr_api.g_varchar2
204: ,p_complaint_closed in date default hr_api.g_date
205: ,p_nature_of_closure in varchar2 default hr_api.g_varchar2
206: ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2
207: ,p_filed_formal_class in date default hr_api.g_date
208: ,p_forwd_eeoc in date default hr_api.g_date
209: ,p_aj_cert_decision_date in date default hr_api.g_date
210: ,p_aj_cert_decision_recvd in date default hr_api.g_date
211: ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2

Line 208: ,p_forwd_eeoc in date default hr_api.g_date

204: ,p_complaint_closed in date default hr_api.g_date
205: ,p_nature_of_closure in varchar2 default hr_api.g_varchar2
206: ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2
207: ,p_filed_formal_class in date default hr_api.g_date
208: ,p_forwd_eeoc in date default hr_api.g_date
209: ,p_aj_cert_decision_date in date default hr_api.g_date
210: ,p_aj_cert_decision_recvd in date default hr_api.g_date
211: ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2
212: ,p_class_members_notified in date default hr_api.g_date

Line 209: ,p_aj_cert_decision_date in date default hr_api.g_date

205: ,p_nature_of_closure in varchar2 default hr_api.g_varchar2
206: ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2
207: ,p_filed_formal_class in date default hr_api.g_date
208: ,p_forwd_eeoc in date default hr_api.g_date
209: ,p_aj_cert_decision_date in date default hr_api.g_date
210: ,p_aj_cert_decision_recvd in date default hr_api.g_date
211: ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2
212: ,p_class_members_notified in date default hr_api.g_date
213: ,p_number_of_complaintants in number default hr_api.g_number

Line 210: ,p_aj_cert_decision_recvd in date default hr_api.g_date

206: ,p_complaint_closed_desc in varchar2 default hr_api.g_varchar2
207: ,p_filed_formal_class in date default hr_api.g_date
208: ,p_forwd_eeoc in date default hr_api.g_date
209: ,p_aj_cert_decision_date in date default hr_api.g_date
210: ,p_aj_cert_decision_recvd in date default hr_api.g_date
211: ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2
212: ,p_class_members_notified in date default hr_api.g_date
213: ,p_number_of_complaintants in number default hr_api.g_number
214: ,p_class_hearing in date default hr_api.g_date

Line 211: ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2

207: ,p_filed_formal_class in date default hr_api.g_date
208: ,p_forwd_eeoc in date default hr_api.g_date
209: ,p_aj_cert_decision_date in date default hr_api.g_date
210: ,p_aj_cert_decision_recvd in date default hr_api.g_date
211: ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2
212: ,p_class_members_notified in date default hr_api.g_date
213: ,p_number_of_complaintants in number default hr_api.g_number
214: ,p_class_hearing in date default hr_api.g_date
215: ,p_aj_dec in date default hr_api.g_date

Line 212: ,p_class_members_notified in date default hr_api.g_date

208: ,p_forwd_eeoc in date default hr_api.g_date
209: ,p_aj_cert_decision_date in date default hr_api.g_date
210: ,p_aj_cert_decision_recvd in date default hr_api.g_date
211: ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2
212: ,p_class_members_notified in date default hr_api.g_date
213: ,p_number_of_complaintants in number default hr_api.g_number
214: ,p_class_hearing in date default hr_api.g_date
215: ,p_aj_dec in date default hr_api.g_date
216: ,p_agency_recvd_aj_dec in date default hr_api.g_date

Line 213: ,p_number_of_complaintants in number default hr_api.g_number

209: ,p_aj_cert_decision_date in date default hr_api.g_date
210: ,p_aj_cert_decision_recvd in date default hr_api.g_date
211: ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2
212: ,p_class_members_notified in date default hr_api.g_date
213: ,p_number_of_complaintants in number default hr_api.g_number
214: ,p_class_hearing in date default hr_api.g_date
215: ,p_aj_dec in date default hr_api.g_date
216: ,p_agency_recvd_aj_dec in date default hr_api.g_date
217: ,p_aj_decision in varchar2 default hr_api.g_varchar2

Line 214: ,p_class_hearing in date default hr_api.g_date

210: ,p_aj_cert_decision_recvd in date default hr_api.g_date
211: ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2
212: ,p_class_members_notified in date default hr_api.g_date
213: ,p_number_of_complaintants in number default hr_api.g_number
214: ,p_class_hearing in date default hr_api.g_date
215: ,p_aj_dec in date default hr_api.g_date
216: ,p_agency_recvd_aj_dec in date default hr_api.g_date
217: ,p_aj_decision in varchar2 default hr_api.g_varchar2
218: ,p_agency_brief_eeoc in date default hr_api.g_date

Line 215: ,p_aj_dec in date default hr_api.g_date

211: ,p_aj_cert_decision in varchar2 default hr_api.g_varchar2
212: ,p_class_members_notified in date default hr_api.g_date
213: ,p_number_of_complaintants in number default hr_api.g_number
214: ,p_class_hearing in date default hr_api.g_date
215: ,p_aj_dec in date default hr_api.g_date
216: ,p_agency_recvd_aj_dec in date default hr_api.g_date
217: ,p_aj_decision in varchar2 default hr_api.g_varchar2
218: ,p_agency_brief_eeoc in date default hr_api.g_date
219: ,p_agency_notif_of_civil_action in date default hr_api.g_date

Line 216: ,p_agency_recvd_aj_dec in date default hr_api.g_date

212: ,p_class_members_notified in date default hr_api.g_date
213: ,p_number_of_complaintants in number default hr_api.g_number
214: ,p_class_hearing in date default hr_api.g_date
215: ,p_aj_dec in date default hr_api.g_date
216: ,p_agency_recvd_aj_dec in date default hr_api.g_date
217: ,p_aj_decision in varchar2 default hr_api.g_varchar2
218: ,p_agency_brief_eeoc in date default hr_api.g_date
219: ,p_agency_notif_of_civil_action in date default hr_api.g_date
220: ,p_fad_source in varchar2 default hr_api.g_varchar2

Line 217: ,p_aj_decision in varchar2 default hr_api.g_varchar2

213: ,p_number_of_complaintants in number default hr_api.g_number
214: ,p_class_hearing in date default hr_api.g_date
215: ,p_aj_dec in date default hr_api.g_date
216: ,p_agency_recvd_aj_dec in date default hr_api.g_date
217: ,p_aj_decision in varchar2 default hr_api.g_varchar2
218: ,p_agency_brief_eeoc in date default hr_api.g_date
219: ,p_agency_notif_of_civil_action in date default hr_api.g_date
220: ,p_fad_source in varchar2 default hr_api.g_varchar2
221: ,p_agency_files_forwarded_eeoc in date default hr_api.g_date

Line 218: ,p_agency_brief_eeoc in date default hr_api.g_date

214: ,p_class_hearing in date default hr_api.g_date
215: ,p_aj_dec in date default hr_api.g_date
216: ,p_agency_recvd_aj_dec in date default hr_api.g_date
217: ,p_aj_decision in varchar2 default hr_api.g_varchar2
218: ,p_agency_brief_eeoc in date default hr_api.g_date
219: ,p_agency_notif_of_civil_action in date default hr_api.g_date
220: ,p_fad_source in varchar2 default hr_api.g_varchar2
221: ,p_agency_files_forwarded_eeoc in date default hr_api.g_date
222: ,p_hearing_req in date default hr_api.g_date

Line 219: ,p_agency_notif_of_civil_action in date default hr_api.g_date

215: ,p_aj_dec in date default hr_api.g_date
216: ,p_agency_recvd_aj_dec in date default hr_api.g_date
217: ,p_aj_decision in varchar2 default hr_api.g_varchar2
218: ,p_agency_brief_eeoc in date default hr_api.g_date
219: ,p_agency_notif_of_civil_action in date default hr_api.g_date
220: ,p_fad_source in varchar2 default hr_api.g_varchar2
221: ,p_agency_files_forwarded_eeoc in date default hr_api.g_date
222: ,p_hearing_req in date default hr_api.g_date
223: ,p_agency_code in varchar2 default hr_api.g_varchar2

Line 220: ,p_fad_source in varchar2 default hr_api.g_varchar2

216: ,p_agency_recvd_aj_dec in date default hr_api.g_date
217: ,p_aj_decision in varchar2 default hr_api.g_varchar2
218: ,p_agency_brief_eeoc in date default hr_api.g_date
219: ,p_agency_notif_of_civil_action in date default hr_api.g_date
220: ,p_fad_source in varchar2 default hr_api.g_varchar2
221: ,p_agency_files_forwarded_eeoc in date default hr_api.g_date
222: ,p_hearing_req in date default hr_api.g_date
223: ,p_agency_code in varchar2 default hr_api.g_varchar2
224: ,p_audited_by in varchar2 default hr_api.g_varchar2

Line 221: ,p_agency_files_forwarded_eeoc in date default hr_api.g_date

217: ,p_aj_decision in varchar2 default hr_api.g_varchar2
218: ,p_agency_brief_eeoc in date default hr_api.g_date
219: ,p_agency_notif_of_civil_action in date default hr_api.g_date
220: ,p_fad_source in varchar2 default hr_api.g_varchar2
221: ,p_agency_files_forwarded_eeoc in date default hr_api.g_date
222: ,p_hearing_req in date default hr_api.g_date
223: ,p_agency_code in varchar2 default hr_api.g_varchar2
224: ,p_audited_by in varchar2 default hr_api.g_varchar2
225: ,p_record_received in date default hr_api.g_date

Line 222: ,p_hearing_req in date default hr_api.g_date

218: ,p_agency_brief_eeoc in date default hr_api.g_date
219: ,p_agency_notif_of_civil_action in date default hr_api.g_date
220: ,p_fad_source in varchar2 default hr_api.g_varchar2
221: ,p_agency_files_forwarded_eeoc in date default hr_api.g_date
222: ,p_hearing_req in date default hr_api.g_date
223: ,p_agency_code in varchar2 default hr_api.g_varchar2
224: ,p_audited_by in varchar2 default hr_api.g_varchar2
225: ,p_record_received in date default hr_api.g_date
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 223: ,p_agency_code in varchar2 default hr_api.g_varchar2

219: ,p_agency_notif_of_civil_action in date default hr_api.g_date
220: ,p_fad_source in varchar2 default hr_api.g_varchar2
221: ,p_agency_files_forwarded_eeoc in date default hr_api.g_date
222: ,p_hearing_req in date default hr_api.g_date
223: ,p_agency_code in varchar2 default hr_api.g_varchar2
224: ,p_audited_by in varchar2 default hr_api.g_varchar2
225: ,p_record_received in date default hr_api.g_date
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 224: ,p_audited_by in varchar2 default hr_api.g_varchar2

220: ,p_fad_source in varchar2 default hr_api.g_varchar2
221: ,p_agency_files_forwarded_eeoc in date default hr_api.g_date
222: ,p_hearing_req in date default hr_api.g_date
223: ,p_agency_code in varchar2 default hr_api.g_varchar2
224: ,p_audited_by in varchar2 default hr_api.g_varchar2
225: ,p_record_received in date default hr_api.g_date
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 225: ,p_record_received in date default hr_api.g_date

221: ,p_agency_files_forwarded_eeoc in date default hr_api.g_date
222: ,p_hearing_req in date default hr_api.g_date
223: ,p_agency_code in varchar2 default hr_api.g_varchar2
224: ,p_audited_by in varchar2 default hr_api.g_varchar2
225: ,p_record_received in date default hr_api.g_date
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 226: ,p_attribute_category in varchar2 default hr_api.g_varchar2

222: ,p_hearing_req in date default hr_api.g_date
223: ,p_agency_code in varchar2 default hr_api.g_varchar2
224: ,p_audited_by in varchar2 default hr_api.g_varchar2
225: ,p_record_received in date default hr_api.g_date
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 227: ,p_attribute1 in varchar2 default hr_api.g_varchar2

223: ,p_agency_code in varchar2 default hr_api.g_varchar2
224: ,p_audited_by in varchar2 default hr_api.g_varchar2
225: ,p_record_received in date default hr_api.g_date
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 228: ,p_attribute2 in varchar2 default hr_api.g_varchar2

224: ,p_audited_by in varchar2 default hr_api.g_varchar2
225: ,p_record_received in date default hr_api.g_date
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 229: ,p_attribute3 in varchar2 default hr_api.g_varchar2

225: ,p_record_received in date default hr_api.g_date
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 230: ,p_attribute4 in varchar2 default hr_api.g_varchar2

226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 231: ,p_attribute5 in varchar2 default hr_api.g_varchar2

227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 232: ,p_attribute6 in varchar2 default hr_api.g_varchar2

228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 233: ,p_attribute7 in varchar2 default hr_api.g_varchar2

229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 234: ,p_attribute8 in varchar2 default hr_api.g_varchar2

230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 235: ,p_attribute9 in varchar2 default hr_api.g_varchar2

231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 236: ,p_attribute10 in varchar2 default hr_api.g_varchar2

232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 237: ,p_attribute11 in varchar2 default hr_api.g_varchar2

233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 238: ,p_attribute12 in varchar2 default hr_api.g_varchar2

234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 239: ,p_attribute13 in varchar2 default hr_api.g_varchar2

235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 240: ,p_attribute14 in varchar2 default hr_api.g_varchar2

236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 241: ,p_attribute15 in varchar2 default hr_api.g_varchar2

237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 242: ,p_attribute16 in varchar2 default hr_api.g_varchar2

238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 243: ,p_attribute17 in varchar2 default hr_api.g_varchar2

239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 244: ,p_attribute18 in varchar2 default hr_api.g_varchar2

240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 245: ,p_attribute19 in varchar2 default hr_api.g_varchar2

241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 246: ,p_attribute20 in varchar2 default hr_api.g_varchar2

242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 247: ,p_attribute21 in varchar2 default hr_api.g_varchar2

243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 248: ,p_attribute22 in varchar2 default hr_api.g_varchar2

244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 249: ,p_attribute23 in varchar2 default hr_api.g_varchar2

245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 250: ,p_attribute24 in varchar2 default hr_api.g_varchar2

246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 251: ,p_attribute25 in varchar2 default hr_api.g_varchar2

247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 252: ,p_attribute26 in varchar2 default hr_api.g_varchar2

248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 253: ,p_attribute27 in varchar2 default hr_api.g_varchar2

249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: );

Line 254: ,p_attribute28 in varchar2 default hr_api.g_varchar2

250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: );
258: --

Line 255: ,p_attribute29 in varchar2 default hr_api.g_varchar2

251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: );
258: --
259: end ghr_cmp_upd;

Line 256: ,p_attribute30 in varchar2 default hr_api.g_varchar2

252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: );
258: --
259: end ghr_cmp_upd;