46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- process and is rollbacked at the end of the process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- parameters being set.
54: --
121: -- ----------------------------------------------------------------------------
122: Procedure upd
123: (
124: p_contact_relationship_id in number,
125: p_contact_type in varchar2 default hr_api.g_varchar2,
126: p_comments in long default hr_api.g_varchar2,
127: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
128: p_request_id in number default hr_api.g_number,
129: p_program_application_id in number default hr_api.g_number,
122: Procedure upd
123: (
124: p_contact_relationship_id in number,
125: p_contact_type in varchar2 default hr_api.g_varchar2,
126: p_comments in long default hr_api.g_varchar2,
127: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
128: p_request_id in number default hr_api.g_number,
129: p_program_application_id in number default hr_api.g_number,
130: p_program_id in number default hr_api.g_number,
123: (
124: p_contact_relationship_id in number,
125: p_contact_type in varchar2 default hr_api.g_varchar2,
126: p_comments in long default hr_api.g_varchar2,
127: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
128: p_request_id in number default hr_api.g_number,
129: p_program_application_id in number default hr_api.g_number,
130: p_program_id in number default hr_api.g_number,
131: p_program_update_date in date default hr_api.g_date,
124: p_contact_relationship_id in number,
125: p_contact_type in varchar2 default hr_api.g_varchar2,
126: p_comments in long default hr_api.g_varchar2,
127: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
128: p_request_id in number default hr_api.g_number,
129: p_program_application_id in number default hr_api.g_number,
130: p_program_id in number default hr_api.g_number,
131: p_program_update_date in date default hr_api.g_date,
132: p_date_start in date default hr_api.g_date,
125: p_contact_type in varchar2 default hr_api.g_varchar2,
126: p_comments in long default hr_api.g_varchar2,
127: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
128: p_request_id in number default hr_api.g_number,
129: p_program_application_id in number default hr_api.g_number,
130: p_program_id in number default hr_api.g_number,
131: p_program_update_date in date default hr_api.g_date,
132: p_date_start in date default hr_api.g_date,
133: p_start_life_reason_id in number default hr_api.g_number,
126: p_comments in long default hr_api.g_varchar2,
127: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
128: p_request_id in number default hr_api.g_number,
129: p_program_application_id in number default hr_api.g_number,
130: p_program_id in number default hr_api.g_number,
131: p_program_update_date in date default hr_api.g_date,
132: p_date_start in date default hr_api.g_date,
133: p_start_life_reason_id in number default hr_api.g_number,
134: p_date_end in date default hr_api.g_date,
127: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
128: p_request_id in number default hr_api.g_number,
129: p_program_application_id in number default hr_api.g_number,
130: p_program_id in number default hr_api.g_number,
131: p_program_update_date in date default hr_api.g_date,
132: p_date_start in date default hr_api.g_date,
133: p_start_life_reason_id in number default hr_api.g_number,
134: p_date_end in date default hr_api.g_date,
135: p_end_life_reason_id in number default hr_api.g_number,
128: p_request_id in number default hr_api.g_number,
129: p_program_application_id in number default hr_api.g_number,
130: p_program_id in number default hr_api.g_number,
131: p_program_update_date in date default hr_api.g_date,
132: p_date_start in date default hr_api.g_date,
133: p_start_life_reason_id in number default hr_api.g_number,
134: p_date_end in date default hr_api.g_date,
135: p_end_life_reason_id in number default hr_api.g_number,
136: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
129: p_program_application_id in number default hr_api.g_number,
130: p_program_id in number default hr_api.g_number,
131: p_program_update_date in date default hr_api.g_date,
132: p_date_start in date default hr_api.g_date,
133: p_start_life_reason_id in number default hr_api.g_number,
134: p_date_end in date default hr_api.g_date,
135: p_end_life_reason_id in number default hr_api.g_number,
136: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
137: p_personal_flag in varchar2 default hr_api.g_varchar2,
130: p_program_id in number default hr_api.g_number,
131: p_program_update_date in date default hr_api.g_date,
132: p_date_start in date default hr_api.g_date,
133: p_start_life_reason_id in number default hr_api.g_number,
134: p_date_end in date default hr_api.g_date,
135: p_end_life_reason_id in number default hr_api.g_number,
136: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
137: p_personal_flag in varchar2 default hr_api.g_varchar2,
138: p_sequence_number in number default hr_api.g_number,
131: p_program_update_date in date default hr_api.g_date,
132: p_date_start in date default hr_api.g_date,
133: p_start_life_reason_id in number default hr_api.g_number,
134: p_date_end in date default hr_api.g_date,
135: p_end_life_reason_id in number default hr_api.g_number,
136: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
137: p_personal_flag in varchar2 default hr_api.g_varchar2,
138: p_sequence_number in number default hr_api.g_number,
139: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
132: p_date_start in date default hr_api.g_date,
133: p_start_life_reason_id in number default hr_api.g_number,
134: p_date_end in date default hr_api.g_date,
135: p_end_life_reason_id in number default hr_api.g_number,
136: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
137: p_personal_flag in varchar2 default hr_api.g_varchar2,
138: p_sequence_number in number default hr_api.g_number,
139: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
140: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
133: p_start_life_reason_id in number default hr_api.g_number,
134: p_date_end in date default hr_api.g_date,
135: p_end_life_reason_id in number default hr_api.g_number,
136: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
137: p_personal_flag in varchar2 default hr_api.g_varchar2,
138: p_sequence_number in number default hr_api.g_number,
139: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
140: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
141: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
134: p_date_end in date default hr_api.g_date,
135: p_end_life_reason_id in number default hr_api.g_number,
136: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
137: p_personal_flag in varchar2 default hr_api.g_varchar2,
138: p_sequence_number in number default hr_api.g_number,
139: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
140: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
141: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
142: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
135: p_end_life_reason_id in number default hr_api.g_number,
136: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
137: p_personal_flag in varchar2 default hr_api.g_varchar2,
138: p_sequence_number in number default hr_api.g_number,
139: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
140: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
141: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
142: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
143: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
136: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
137: p_personal_flag in varchar2 default hr_api.g_varchar2,
138: p_sequence_number in number default hr_api.g_number,
139: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
140: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
141: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
142: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
143: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
144: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
137: p_personal_flag in varchar2 default hr_api.g_varchar2,
138: p_sequence_number in number default hr_api.g_number,
139: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
140: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
141: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
142: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
143: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
144: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
145: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
138: p_sequence_number in number default hr_api.g_number,
139: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
140: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
141: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
142: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
143: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
144: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
145: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
146: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
139: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
140: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
141: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
142: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
143: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
144: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
145: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
146: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
147: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
140: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
141: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
142: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
143: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
144: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
145: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
146: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
147: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
148: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
141: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
142: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
143: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
144: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
145: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
146: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
147: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
148: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
149: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
142: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
143: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
144: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
145: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
146: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
147: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
148: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
149: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
150: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
143: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
144: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
145: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
146: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
147: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
148: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
149: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
150: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
151: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
144: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
145: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
146: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
147: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
148: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
149: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
150: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
151: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
152: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
145: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
146: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
147: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
148: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
149: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
150: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
151: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
152: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
153: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
146: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
147: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
148: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
149: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
150: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
151: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
152: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
153: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
154: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
147: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
148: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
149: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
150: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
151: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
152: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
153: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
154: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
155: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
148: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
149: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
150: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
151: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
152: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
153: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
154: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
155: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
156: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
149: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
150: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
151: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
152: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
153: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
154: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
155: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
156: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
157: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
150: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
151: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
152: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
153: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
154: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
155: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
156: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
157: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
158: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
151: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
152: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
153: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
154: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
155: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
156: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
157: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
158: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
159: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
152: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
153: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
154: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
155: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
156: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
157: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
158: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
159: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
160: p_cont_information_category in varchar2 default hr_api.g_varchar2,
153: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
154: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
155: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
156: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
157: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
158: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
159: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
160: p_cont_information_category in varchar2 default hr_api.g_varchar2,
161: p_cont_information1 in varchar2 default hr_api.g_varchar2,
154: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
155: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
156: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
157: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
158: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
159: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
160: p_cont_information_category in varchar2 default hr_api.g_varchar2,
161: p_cont_information1 in varchar2 default hr_api.g_varchar2,
162: p_cont_information2 in varchar2 default hr_api.g_varchar2,
155: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
156: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
157: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
158: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
159: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
160: p_cont_information_category in varchar2 default hr_api.g_varchar2,
161: p_cont_information1 in varchar2 default hr_api.g_varchar2,
162: p_cont_information2 in varchar2 default hr_api.g_varchar2,
163: p_cont_information3 in varchar2 default hr_api.g_varchar2,
156: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
157: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
158: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
159: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
160: p_cont_information_category in varchar2 default hr_api.g_varchar2,
161: p_cont_information1 in varchar2 default hr_api.g_varchar2,
162: p_cont_information2 in varchar2 default hr_api.g_varchar2,
163: p_cont_information3 in varchar2 default hr_api.g_varchar2,
164: p_cont_information4 in varchar2 default hr_api.g_varchar2,
157: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
158: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
159: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
160: p_cont_information_category in varchar2 default hr_api.g_varchar2,
161: p_cont_information1 in varchar2 default hr_api.g_varchar2,
162: p_cont_information2 in varchar2 default hr_api.g_varchar2,
163: p_cont_information3 in varchar2 default hr_api.g_varchar2,
164: p_cont_information4 in varchar2 default hr_api.g_varchar2,
165: p_cont_information5 in varchar2 default hr_api.g_varchar2,
158: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
159: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
160: p_cont_information_category in varchar2 default hr_api.g_varchar2,
161: p_cont_information1 in varchar2 default hr_api.g_varchar2,
162: p_cont_information2 in varchar2 default hr_api.g_varchar2,
163: p_cont_information3 in varchar2 default hr_api.g_varchar2,
164: p_cont_information4 in varchar2 default hr_api.g_varchar2,
165: p_cont_information5 in varchar2 default hr_api.g_varchar2,
166: p_cont_information6 in varchar2 default hr_api.g_varchar2,
159: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
160: p_cont_information_category in varchar2 default hr_api.g_varchar2,
161: p_cont_information1 in varchar2 default hr_api.g_varchar2,
162: p_cont_information2 in varchar2 default hr_api.g_varchar2,
163: p_cont_information3 in varchar2 default hr_api.g_varchar2,
164: p_cont_information4 in varchar2 default hr_api.g_varchar2,
165: p_cont_information5 in varchar2 default hr_api.g_varchar2,
166: p_cont_information6 in varchar2 default hr_api.g_varchar2,
167: p_cont_information7 in varchar2 default hr_api.g_varchar2,
160: p_cont_information_category in varchar2 default hr_api.g_varchar2,
161: p_cont_information1 in varchar2 default hr_api.g_varchar2,
162: p_cont_information2 in varchar2 default hr_api.g_varchar2,
163: p_cont_information3 in varchar2 default hr_api.g_varchar2,
164: p_cont_information4 in varchar2 default hr_api.g_varchar2,
165: p_cont_information5 in varchar2 default hr_api.g_varchar2,
166: p_cont_information6 in varchar2 default hr_api.g_varchar2,
167: p_cont_information7 in varchar2 default hr_api.g_varchar2,
168: p_cont_information8 in varchar2 default hr_api.g_varchar2,
161: p_cont_information1 in varchar2 default hr_api.g_varchar2,
162: p_cont_information2 in varchar2 default hr_api.g_varchar2,
163: p_cont_information3 in varchar2 default hr_api.g_varchar2,
164: p_cont_information4 in varchar2 default hr_api.g_varchar2,
165: p_cont_information5 in varchar2 default hr_api.g_varchar2,
166: p_cont_information6 in varchar2 default hr_api.g_varchar2,
167: p_cont_information7 in varchar2 default hr_api.g_varchar2,
168: p_cont_information8 in varchar2 default hr_api.g_varchar2,
169: p_cont_information9 in varchar2 default hr_api.g_varchar2,
162: p_cont_information2 in varchar2 default hr_api.g_varchar2,
163: p_cont_information3 in varchar2 default hr_api.g_varchar2,
164: p_cont_information4 in varchar2 default hr_api.g_varchar2,
165: p_cont_information5 in varchar2 default hr_api.g_varchar2,
166: p_cont_information6 in varchar2 default hr_api.g_varchar2,
167: p_cont_information7 in varchar2 default hr_api.g_varchar2,
168: p_cont_information8 in varchar2 default hr_api.g_varchar2,
169: p_cont_information9 in varchar2 default hr_api.g_varchar2,
170: p_cont_information10 in varchar2 default hr_api.g_varchar2,
163: p_cont_information3 in varchar2 default hr_api.g_varchar2,
164: p_cont_information4 in varchar2 default hr_api.g_varchar2,
165: p_cont_information5 in varchar2 default hr_api.g_varchar2,
166: p_cont_information6 in varchar2 default hr_api.g_varchar2,
167: p_cont_information7 in varchar2 default hr_api.g_varchar2,
168: p_cont_information8 in varchar2 default hr_api.g_varchar2,
169: p_cont_information9 in varchar2 default hr_api.g_varchar2,
170: p_cont_information10 in varchar2 default hr_api.g_varchar2,
171: p_cont_information11 in varchar2 default hr_api.g_varchar2,
164: p_cont_information4 in varchar2 default hr_api.g_varchar2,
165: p_cont_information5 in varchar2 default hr_api.g_varchar2,
166: p_cont_information6 in varchar2 default hr_api.g_varchar2,
167: p_cont_information7 in varchar2 default hr_api.g_varchar2,
168: p_cont_information8 in varchar2 default hr_api.g_varchar2,
169: p_cont_information9 in varchar2 default hr_api.g_varchar2,
170: p_cont_information10 in varchar2 default hr_api.g_varchar2,
171: p_cont_information11 in varchar2 default hr_api.g_varchar2,
172: p_cont_information12 in varchar2 default hr_api.g_varchar2,
165: p_cont_information5 in varchar2 default hr_api.g_varchar2,
166: p_cont_information6 in varchar2 default hr_api.g_varchar2,
167: p_cont_information7 in varchar2 default hr_api.g_varchar2,
168: p_cont_information8 in varchar2 default hr_api.g_varchar2,
169: p_cont_information9 in varchar2 default hr_api.g_varchar2,
170: p_cont_information10 in varchar2 default hr_api.g_varchar2,
171: p_cont_information11 in varchar2 default hr_api.g_varchar2,
172: p_cont_information12 in varchar2 default hr_api.g_varchar2,
173: p_cont_information13 in varchar2 default hr_api.g_varchar2,
166: p_cont_information6 in varchar2 default hr_api.g_varchar2,
167: p_cont_information7 in varchar2 default hr_api.g_varchar2,
168: p_cont_information8 in varchar2 default hr_api.g_varchar2,
169: p_cont_information9 in varchar2 default hr_api.g_varchar2,
170: p_cont_information10 in varchar2 default hr_api.g_varchar2,
171: p_cont_information11 in varchar2 default hr_api.g_varchar2,
172: p_cont_information12 in varchar2 default hr_api.g_varchar2,
173: p_cont_information13 in varchar2 default hr_api.g_varchar2,
174: p_cont_information14 in varchar2 default hr_api.g_varchar2,
167: p_cont_information7 in varchar2 default hr_api.g_varchar2,
168: p_cont_information8 in varchar2 default hr_api.g_varchar2,
169: p_cont_information9 in varchar2 default hr_api.g_varchar2,
170: p_cont_information10 in varchar2 default hr_api.g_varchar2,
171: p_cont_information11 in varchar2 default hr_api.g_varchar2,
172: p_cont_information12 in varchar2 default hr_api.g_varchar2,
173: p_cont_information13 in varchar2 default hr_api.g_varchar2,
174: p_cont_information14 in varchar2 default hr_api.g_varchar2,
175: p_cont_information15 in varchar2 default hr_api.g_varchar2,
168: p_cont_information8 in varchar2 default hr_api.g_varchar2,
169: p_cont_information9 in varchar2 default hr_api.g_varchar2,
170: p_cont_information10 in varchar2 default hr_api.g_varchar2,
171: p_cont_information11 in varchar2 default hr_api.g_varchar2,
172: p_cont_information12 in varchar2 default hr_api.g_varchar2,
173: p_cont_information13 in varchar2 default hr_api.g_varchar2,
174: p_cont_information14 in varchar2 default hr_api.g_varchar2,
175: p_cont_information15 in varchar2 default hr_api.g_varchar2,
176: p_cont_information16 in varchar2 default hr_api.g_varchar2,
169: p_cont_information9 in varchar2 default hr_api.g_varchar2,
170: p_cont_information10 in varchar2 default hr_api.g_varchar2,
171: p_cont_information11 in varchar2 default hr_api.g_varchar2,
172: p_cont_information12 in varchar2 default hr_api.g_varchar2,
173: p_cont_information13 in varchar2 default hr_api.g_varchar2,
174: p_cont_information14 in varchar2 default hr_api.g_varchar2,
175: p_cont_information15 in varchar2 default hr_api.g_varchar2,
176: p_cont_information16 in varchar2 default hr_api.g_varchar2,
177: p_cont_information17 in varchar2 default hr_api.g_varchar2,
170: p_cont_information10 in varchar2 default hr_api.g_varchar2,
171: p_cont_information11 in varchar2 default hr_api.g_varchar2,
172: p_cont_information12 in varchar2 default hr_api.g_varchar2,
173: p_cont_information13 in varchar2 default hr_api.g_varchar2,
174: p_cont_information14 in varchar2 default hr_api.g_varchar2,
175: p_cont_information15 in varchar2 default hr_api.g_varchar2,
176: p_cont_information16 in varchar2 default hr_api.g_varchar2,
177: p_cont_information17 in varchar2 default hr_api.g_varchar2,
178: p_cont_information18 in varchar2 default hr_api.g_varchar2,
171: p_cont_information11 in varchar2 default hr_api.g_varchar2,
172: p_cont_information12 in varchar2 default hr_api.g_varchar2,
173: p_cont_information13 in varchar2 default hr_api.g_varchar2,
174: p_cont_information14 in varchar2 default hr_api.g_varchar2,
175: p_cont_information15 in varchar2 default hr_api.g_varchar2,
176: p_cont_information16 in varchar2 default hr_api.g_varchar2,
177: p_cont_information17 in varchar2 default hr_api.g_varchar2,
178: p_cont_information18 in varchar2 default hr_api.g_varchar2,
179: p_cont_information19 in varchar2 default hr_api.g_varchar2,
172: p_cont_information12 in varchar2 default hr_api.g_varchar2,
173: p_cont_information13 in varchar2 default hr_api.g_varchar2,
174: p_cont_information14 in varchar2 default hr_api.g_varchar2,
175: p_cont_information15 in varchar2 default hr_api.g_varchar2,
176: p_cont_information16 in varchar2 default hr_api.g_varchar2,
177: p_cont_information17 in varchar2 default hr_api.g_varchar2,
178: p_cont_information18 in varchar2 default hr_api.g_varchar2,
179: p_cont_information19 in varchar2 default hr_api.g_varchar2,
180: p_cont_information20 in varchar2 default hr_api.g_varchar2,
173: p_cont_information13 in varchar2 default hr_api.g_varchar2,
174: p_cont_information14 in varchar2 default hr_api.g_varchar2,
175: p_cont_information15 in varchar2 default hr_api.g_varchar2,
176: p_cont_information16 in varchar2 default hr_api.g_varchar2,
177: p_cont_information17 in varchar2 default hr_api.g_varchar2,
178: p_cont_information18 in varchar2 default hr_api.g_varchar2,
179: p_cont_information19 in varchar2 default hr_api.g_varchar2,
180: p_cont_information20 in varchar2 default hr_api.g_varchar2,
181: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
174: p_cont_information14 in varchar2 default hr_api.g_varchar2,
175: p_cont_information15 in varchar2 default hr_api.g_varchar2,
176: p_cont_information16 in varchar2 default hr_api.g_varchar2,
177: p_cont_information17 in varchar2 default hr_api.g_varchar2,
178: p_cont_information18 in varchar2 default hr_api.g_varchar2,
179: p_cont_information19 in varchar2 default hr_api.g_varchar2,
180: p_cont_information20 in varchar2 default hr_api.g_varchar2,
181: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
182: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
175: p_cont_information15 in varchar2 default hr_api.g_varchar2,
176: p_cont_information16 in varchar2 default hr_api.g_varchar2,
177: p_cont_information17 in varchar2 default hr_api.g_varchar2,
178: p_cont_information18 in varchar2 default hr_api.g_varchar2,
179: p_cont_information19 in varchar2 default hr_api.g_varchar2,
180: p_cont_information20 in varchar2 default hr_api.g_varchar2,
181: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
182: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
183: p_dependent_flag in varchar2 default hr_api.g_varchar2,
176: p_cont_information16 in varchar2 default hr_api.g_varchar2,
177: p_cont_information17 in varchar2 default hr_api.g_varchar2,
178: p_cont_information18 in varchar2 default hr_api.g_varchar2,
179: p_cont_information19 in varchar2 default hr_api.g_varchar2,
180: p_cont_information20 in varchar2 default hr_api.g_varchar2,
181: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
182: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
183: p_dependent_flag in varchar2 default hr_api.g_varchar2,
184: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
177: p_cont_information17 in varchar2 default hr_api.g_varchar2,
178: p_cont_information18 in varchar2 default hr_api.g_varchar2,
179: p_cont_information19 in varchar2 default hr_api.g_varchar2,
180: p_cont_information20 in varchar2 default hr_api.g_varchar2,
181: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
182: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
183: p_dependent_flag in varchar2 default hr_api.g_varchar2,
184: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
185: p_object_version_number in out nocopy number,
178: p_cont_information18 in varchar2 default hr_api.g_varchar2,
179: p_cont_information19 in varchar2 default hr_api.g_varchar2,
180: p_cont_information20 in varchar2 default hr_api.g_varchar2,
181: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
182: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
183: p_dependent_flag in varchar2 default hr_api.g_varchar2,
184: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
185: p_object_version_number in out nocopy number,
186: p_effective_date in date,
179: p_cont_information19 in varchar2 default hr_api.g_varchar2,
180: p_cont_information20 in varchar2 default hr_api.g_varchar2,
181: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
182: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
183: p_dependent_flag in varchar2 default hr_api.g_varchar2,
184: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
185: p_object_version_number in out nocopy number,
186: p_effective_date in date,
187: p_validate in boolean default false
180: p_cont_information20 in varchar2 default hr_api.g_varchar2,
181: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
182: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
183: p_dependent_flag in varchar2 default hr_api.g_varchar2,
184: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
185: p_object_version_number in out nocopy number,
186: p_effective_date in date,
187: p_validate in boolean default false
188: );