44: -- Internal Table Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy per_par_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
97: --
98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_par_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_par_shd.constraint_error
101: per_par_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_par_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_par_shd.constraint_error
105: per_par_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_par_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: Raise;
113: End update_dml;
143: -- Internal Table Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_update(p_rec in per_par_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'pre_update';
150: --
151: Begin
185: -- Internal Table Handler Use Only.
186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_update(p_rec in per_par_shd.g_rec_type) is
190: --
191: l_proc varchar2(72) := g_package||'post_update';
192: --
193: Begin
231: p_attribute18 => p_rec.attribute18 ,
232: p_attribute19 => p_rec.attribute19 ,
233: p_attribute20 => p_rec.attribute20 ,
234: p_participant_usage_status =>p_rec.participant_usage_status ,
235: p_business_group_id_o => per_par_shd.g_old_rec.business_group_id ,
236: p_object_version_number_o => per_par_shd.g_old_rec.object_version_number,
237: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,
238: p_participation_in_table_o =>
239: per_par_shd.g_old_rec.participation_in_table ,
232: p_attribute19 => p_rec.attribute19 ,
233: p_attribute20 => p_rec.attribute20 ,
234: p_participant_usage_status =>p_rec.participant_usage_status ,
235: p_business_group_id_o => per_par_shd.g_old_rec.business_group_id ,
236: p_object_version_number_o => per_par_shd.g_old_rec.object_version_number,
237: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,
238: p_participation_in_table_o =>
239: per_par_shd.g_old_rec.participation_in_table ,
240: p_participation_in_column_o =>
233: p_attribute20 => p_rec.attribute20 ,
234: p_participant_usage_status =>p_rec.participant_usage_status ,
235: p_business_group_id_o => per_par_shd.g_old_rec.business_group_id ,
236: p_object_version_number_o => per_par_shd.g_old_rec.object_version_number,
237: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,
238: p_participation_in_table_o =>
239: per_par_shd.g_old_rec.participation_in_table ,
240: p_participation_in_column_o =>
241: per_par_shd.g_old_rec.participation_in_column ,
235: p_business_group_id_o => per_par_shd.g_old_rec.business_group_id ,
236: p_object_version_number_o => per_par_shd.g_old_rec.object_version_number,
237: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,
238: p_participation_in_table_o =>
239: per_par_shd.g_old_rec.participation_in_table ,
240: p_participation_in_column_o =>
241: per_par_shd.g_old_rec.participation_in_column ,
242: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
243: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
237: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,
238: p_participation_in_table_o =>
239: per_par_shd.g_old_rec.participation_in_table ,
240: p_participation_in_column_o =>
241: per_par_shd.g_old_rec.participation_in_column ,
242: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
243: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
244: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
245: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
238: p_participation_in_table_o =>
239: per_par_shd.g_old_rec.participation_in_table ,
240: p_participation_in_column_o =>
241: per_par_shd.g_old_rec.participation_in_column ,
242: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
243: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
244: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
245: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
246: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
239: per_par_shd.g_old_rec.participation_in_table ,
240: p_participation_in_column_o =>
241: per_par_shd.g_old_rec.participation_in_column ,
242: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
243: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
244: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
245: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
246: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
247: p_comments_o => per_par_shd.g_old_rec.comments ,
240: p_participation_in_column_o =>
241: per_par_shd.g_old_rec.participation_in_column ,
242: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
243: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
244: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
245: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
246: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
247: p_comments_o => per_par_shd.g_old_rec.comments ,
248: p_person_id_o => per_par_shd.g_old_rec.person_id ,
241: per_par_shd.g_old_rec.participation_in_column ,
242: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
243: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
244: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
245: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
246: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
247: p_comments_o => per_par_shd.g_old_rec.comments ,
248: p_person_id_o => per_par_shd.g_old_rec.person_id ,
249: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
242: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
243: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
244: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
245: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
246: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
247: p_comments_o => per_par_shd.g_old_rec.comments ,
248: p_person_id_o => per_par_shd.g_old_rec.person_id ,
249: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
250: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
243: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
244: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
245: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
246: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
247: p_comments_o => per_par_shd.g_old_rec.comments ,
248: p_person_id_o => per_par_shd.g_old_rec.person_id ,
249: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
250: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
251: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
244: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
245: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
246: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
247: p_comments_o => per_par_shd.g_old_rec.comments ,
248: p_person_id_o => per_par_shd.g_old_rec.person_id ,
249: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
250: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
251: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
252: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
245: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
246: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
247: p_comments_o => per_par_shd.g_old_rec.comments ,
248: p_person_id_o => per_par_shd.g_old_rec.person_id ,
249: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
250: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
251: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
252: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
253: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
246: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
247: p_comments_o => per_par_shd.g_old_rec.comments ,
248: p_person_id_o => per_par_shd.g_old_rec.person_id ,
249: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
250: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
251: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
252: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
253: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
254: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
247: p_comments_o => per_par_shd.g_old_rec.comments ,
248: p_person_id_o => per_par_shd.g_old_rec.person_id ,
249: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
250: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
251: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
252: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
253: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
254: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
255: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,
248: p_person_id_o => per_par_shd.g_old_rec.person_id ,
249: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
250: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
251: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
252: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
253: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
254: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
255: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,
256: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,
249: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
250: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
251: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
252: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
253: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
254: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
255: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,
256: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,
257: p_attribute8_o => per_par_shd.g_old_rec.attribute8 ,
250: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
251: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
252: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
253: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
254: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
255: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,
256: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,
257: p_attribute8_o => per_par_shd.g_old_rec.attribute8 ,
258: p_attribute9_o => per_par_shd.g_old_rec.attribute9 ,
251: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
252: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
253: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
254: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
255: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,
256: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,
257: p_attribute8_o => per_par_shd.g_old_rec.attribute8 ,
258: p_attribute9_o => per_par_shd.g_old_rec.attribute9 ,
259: p_attribute10_o => per_par_shd.g_old_rec.attribute10 ,
252: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
253: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
254: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
255: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,
256: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,
257: p_attribute8_o => per_par_shd.g_old_rec.attribute8 ,
258: p_attribute9_o => per_par_shd.g_old_rec.attribute9 ,
259: p_attribute10_o => per_par_shd.g_old_rec.attribute10 ,
260: p_attribute11_o => per_par_shd.g_old_rec.attribute11 ,
253: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
254: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
255: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,
256: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,
257: p_attribute8_o => per_par_shd.g_old_rec.attribute8 ,
258: p_attribute9_o => per_par_shd.g_old_rec.attribute9 ,
259: p_attribute10_o => per_par_shd.g_old_rec.attribute10 ,
260: p_attribute11_o => per_par_shd.g_old_rec.attribute11 ,
261: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,
254: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
255: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,
256: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,
257: p_attribute8_o => per_par_shd.g_old_rec.attribute8 ,
258: p_attribute9_o => per_par_shd.g_old_rec.attribute9 ,
259: p_attribute10_o => per_par_shd.g_old_rec.attribute10 ,
260: p_attribute11_o => per_par_shd.g_old_rec.attribute11 ,
261: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,
262: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
255: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,
256: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,
257: p_attribute8_o => per_par_shd.g_old_rec.attribute8 ,
258: p_attribute9_o => per_par_shd.g_old_rec.attribute9 ,
259: p_attribute10_o => per_par_shd.g_old_rec.attribute10 ,
260: p_attribute11_o => per_par_shd.g_old_rec.attribute11 ,
261: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,
262: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
263: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
256: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,
257: p_attribute8_o => per_par_shd.g_old_rec.attribute8 ,
258: p_attribute9_o => per_par_shd.g_old_rec.attribute9 ,
259: p_attribute10_o => per_par_shd.g_old_rec.attribute10 ,
260: p_attribute11_o => per_par_shd.g_old_rec.attribute11 ,
261: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,
262: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
263: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
264: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
257: p_attribute8_o => per_par_shd.g_old_rec.attribute8 ,
258: p_attribute9_o => per_par_shd.g_old_rec.attribute9 ,
259: p_attribute10_o => per_par_shd.g_old_rec.attribute10 ,
260: p_attribute11_o => per_par_shd.g_old_rec.attribute11 ,
261: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,
262: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
263: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
264: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
265: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
258: p_attribute9_o => per_par_shd.g_old_rec.attribute9 ,
259: p_attribute10_o => per_par_shd.g_old_rec.attribute10 ,
260: p_attribute11_o => per_par_shd.g_old_rec.attribute11 ,
261: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,
262: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
263: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
264: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
265: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
266: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
259: p_attribute10_o => per_par_shd.g_old_rec.attribute10 ,
260: p_attribute11_o => per_par_shd.g_old_rec.attribute11 ,
261: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,
262: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
263: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
264: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
265: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
266: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
267: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
260: p_attribute11_o => per_par_shd.g_old_rec.attribute11 ,
261: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,
262: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
263: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
264: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
265: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
266: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
267: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
268: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
261: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,
262: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
263: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
264: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
265: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
266: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
267: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
268: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
269: p_attribute20_o => per_par_shd.g_old_rec.attribute20 ,
262: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
263: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
264: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
265: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
266: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
267: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
268: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
269: p_attribute20_o => per_par_shd.g_old_rec.attribute20 ,
270: p_participant_usage_status_o=> per_par_shd.g_old_rec.participant_usage_status);
263: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
264: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
265: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
266: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
267: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
268: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
269: p_attribute20_o => per_par_shd.g_old_rec.attribute20 ,
270: p_participant_usage_status_o=> per_par_shd.g_old_rec.participant_usage_status);
271:
264: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
265: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
266: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
267: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
268: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
269: p_attribute20_o => per_par_shd.g_old_rec.attribute20 ,
270: p_participant_usage_status_o=> per_par_shd.g_old_rec.participant_usage_status);
271:
272: exception
265: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
266: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
267: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
268: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
269: p_attribute20_o => per_par_shd.g_old_rec.attribute20 ,
270: p_participant_usage_status_o=> per_par_shd.g_old_rec.participant_usage_status);
271:
272: exception
273: when hr_api.cannot_find_prog_unit then
266: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
267: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
268: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
269: p_attribute20_o => per_par_shd.g_old_rec.attribute20 ,
270: p_participant_usage_status_o=> per_par_shd.g_old_rec.participant_usage_status);
271:
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
324: -- Internal Table Handler Use Only.
325: --
326: -- {End Of Comments}
327: -- ----------------------------------------------------------------------------
328: Procedure convert_defs(p_rec in out nocopy per_par_shd.g_rec_type) is
329: --
330: l_proc varchar2(72) := g_package||'convert_defs';
331: --
332: Begin
339: -- is being used then we must set to the 'current' argument value.
340: --
341: If (p_rec.business_group_id = hr_api.g_number) then
342: p_rec.business_group_id :=
343: per_par_shd.g_old_rec.business_group_id;
344: End If;
345:
346: If (p_rec.questionnaire_template_id = hr_api.g_number) then
347: p_rec.questionnaire_template_id :=
344: End If;
345:
346: If (p_rec.questionnaire_template_id = hr_api.g_number) then
347: p_rec.questionnaire_template_id :=
348: per_par_shd.g_old_rec.questionnaire_template_id;
349: End If;
350:
351: If (p_rec.participation_in_table = hr_api.g_varchar2) then
352: p_rec.participation_in_table :=
349: End If;
350:
351: If (p_rec.participation_in_table = hr_api.g_varchar2) then
352: p_rec.participation_in_table :=
353: per_par_shd.g_old_rec.participation_in_table;
354: End If;
355: If (p_rec.participation_in_column = hr_api.g_varchar2) then
356: p_rec.participation_in_column :=
357: per_par_shd.g_old_rec.participation_in_column;
353: per_par_shd.g_old_rec.participation_in_table;
354: End If;
355: If (p_rec.participation_in_column = hr_api.g_varchar2) then
356: p_rec.participation_in_column :=
357: per_par_shd.g_old_rec.participation_in_column;
358: End If;
359: If (p_rec.participation_in_id = hr_api.g_number) then
360: p_rec.participation_in_id :=
361: per_par_shd.g_old_rec.participation_in_id;
357: per_par_shd.g_old_rec.participation_in_column;
358: End If;
359: If (p_rec.participation_in_id = hr_api.g_number) then
360: p_rec.participation_in_id :=
361: per_par_shd.g_old_rec.participation_in_id;
362: End If;
363: If (p_rec.participation_status = hr_api.g_varchar2) then
364: p_rec.participation_status :=
365: per_par_shd.g_old_rec.participation_status;
361: per_par_shd.g_old_rec.participation_in_id;
362: End If;
363: If (p_rec.participation_status = hr_api.g_varchar2) then
364: p_rec.participation_status :=
365: per_par_shd.g_old_rec.participation_status;
366: End If;
367: If (p_rec.participation_type = hr_api.g_varchar2) then
368: p_rec.participation_type :=
369: per_par_shd.g_old_rec.participation_type;
365: per_par_shd.g_old_rec.participation_status;
366: End If;
367: If (p_rec.participation_type = hr_api.g_varchar2) then
368: p_rec.participation_type :=
369: per_par_shd.g_old_rec.participation_type;
370: End If;
371: If (p_rec.last_notified_date = hr_api.g_date) then
372: p_rec.last_notified_date :=
373: per_par_shd.g_old_rec.last_notified_date;
369: per_par_shd.g_old_rec.participation_type;
370: End If;
371: If (p_rec.last_notified_date = hr_api.g_date) then
372: p_rec.last_notified_date :=
373: per_par_shd.g_old_rec.last_notified_date;
374: End If;
375: If (p_rec.date_completed = hr_api.g_date) then
376: p_rec.date_completed :=
377: per_par_shd.g_old_rec.date_completed;
373: per_par_shd.g_old_rec.last_notified_date;
374: End If;
375: If (p_rec.date_completed = hr_api.g_date) then
376: p_rec.date_completed :=
377: per_par_shd.g_old_rec.date_completed;
378: End If;
379: If (p_rec.comments = hr_api.g_varchar2) then
380: p_rec.comments :=
381: per_par_shd.g_old_rec.comments;
377: per_par_shd.g_old_rec.date_completed;
378: End If;
379: If (p_rec.comments = hr_api.g_varchar2) then
380: p_rec.comments :=
381: per_par_shd.g_old_rec.comments;
382: End If;
383: If (p_rec.person_id = hr_api.g_number) then
384: p_rec.person_id :=
385: per_par_shd.g_old_rec.person_id;
381: per_par_shd.g_old_rec.comments;
382: End If;
383: If (p_rec.person_id = hr_api.g_number) then
384: p_rec.person_id :=
385: per_par_shd.g_old_rec.person_id;
386: End If;
387: If (p_rec.attribute_category = hr_api.g_varchar2) then
388: p_rec.attribute_category :=
389: per_par_shd.g_old_rec.attribute_category;
385: per_par_shd.g_old_rec.person_id;
386: End If;
387: If (p_rec.attribute_category = hr_api.g_varchar2) then
388: p_rec.attribute_category :=
389: per_par_shd.g_old_rec.attribute_category;
390: End If;
391: If (p_rec.attribute1 = hr_api.g_varchar2) then
392: p_rec.attribute1 :=
393: per_par_shd.g_old_rec.attribute1;
389: per_par_shd.g_old_rec.attribute_category;
390: End If;
391: If (p_rec.attribute1 = hr_api.g_varchar2) then
392: p_rec.attribute1 :=
393: per_par_shd.g_old_rec.attribute1;
394: End If;
395: If (p_rec.attribute2 = hr_api.g_varchar2) then
396: p_rec.attribute2 :=
397: per_par_shd.g_old_rec.attribute2;
393: per_par_shd.g_old_rec.attribute1;
394: End If;
395: If (p_rec.attribute2 = hr_api.g_varchar2) then
396: p_rec.attribute2 :=
397: per_par_shd.g_old_rec.attribute2;
398: End If;
399: If (p_rec.attribute3 = hr_api.g_varchar2) then
400: p_rec.attribute3 :=
401: per_par_shd.g_old_rec.attribute3;
397: per_par_shd.g_old_rec.attribute2;
398: End If;
399: If (p_rec.attribute3 = hr_api.g_varchar2) then
400: p_rec.attribute3 :=
401: per_par_shd.g_old_rec.attribute3;
402: End If;
403: If (p_rec.attribute4 = hr_api.g_varchar2) then
404: p_rec.attribute4 :=
405: per_par_shd.g_old_rec.attribute4;
401: per_par_shd.g_old_rec.attribute3;
402: End If;
403: If (p_rec.attribute4 = hr_api.g_varchar2) then
404: p_rec.attribute4 :=
405: per_par_shd.g_old_rec.attribute4;
406: End If;
407: If (p_rec.attribute5 = hr_api.g_varchar2) then
408: p_rec.attribute5 :=
409: per_par_shd.g_old_rec.attribute5;
405: per_par_shd.g_old_rec.attribute4;
406: End If;
407: If (p_rec.attribute5 = hr_api.g_varchar2) then
408: p_rec.attribute5 :=
409: per_par_shd.g_old_rec.attribute5;
410: End If;
411: If (p_rec.attribute6 = hr_api.g_varchar2) then
412: p_rec.attribute6 :=
413: per_par_shd.g_old_rec.attribute6;
409: per_par_shd.g_old_rec.attribute5;
410: End If;
411: If (p_rec.attribute6 = hr_api.g_varchar2) then
412: p_rec.attribute6 :=
413: per_par_shd.g_old_rec.attribute6;
414: End If;
415: If (p_rec.attribute7 = hr_api.g_varchar2) then
416: p_rec.attribute7 :=
417: per_par_shd.g_old_rec.attribute7;
413: per_par_shd.g_old_rec.attribute6;
414: End If;
415: If (p_rec.attribute7 = hr_api.g_varchar2) then
416: p_rec.attribute7 :=
417: per_par_shd.g_old_rec.attribute7;
418: End If;
419: If (p_rec.attribute8 = hr_api.g_varchar2) then
420: p_rec.attribute8 :=
421: per_par_shd.g_old_rec.attribute8;
417: per_par_shd.g_old_rec.attribute7;
418: End If;
419: If (p_rec.attribute8 = hr_api.g_varchar2) then
420: p_rec.attribute8 :=
421: per_par_shd.g_old_rec.attribute8;
422: End If;
423: If (p_rec.attribute9 = hr_api.g_varchar2) then
424: p_rec.attribute9 :=
425: per_par_shd.g_old_rec.attribute9;
421: per_par_shd.g_old_rec.attribute8;
422: End If;
423: If (p_rec.attribute9 = hr_api.g_varchar2) then
424: p_rec.attribute9 :=
425: per_par_shd.g_old_rec.attribute9;
426: End If;
427: If (p_rec.attribute10 = hr_api.g_varchar2) then
428: p_rec.attribute10 :=
429: per_par_shd.g_old_rec.attribute10;
425: per_par_shd.g_old_rec.attribute9;
426: End If;
427: If (p_rec.attribute10 = hr_api.g_varchar2) then
428: p_rec.attribute10 :=
429: per_par_shd.g_old_rec.attribute10;
430: End If;
431: If (p_rec.attribute11 = hr_api.g_varchar2) then
432: p_rec.attribute11 :=
433: per_par_shd.g_old_rec.attribute11;
429: per_par_shd.g_old_rec.attribute10;
430: End If;
431: If (p_rec.attribute11 = hr_api.g_varchar2) then
432: p_rec.attribute11 :=
433: per_par_shd.g_old_rec.attribute11;
434: End If;
435: If (p_rec.attribute12 = hr_api.g_varchar2) then
436: p_rec.attribute12 :=
437: per_par_shd.g_old_rec.attribute12;
433: per_par_shd.g_old_rec.attribute11;
434: End If;
435: If (p_rec.attribute12 = hr_api.g_varchar2) then
436: p_rec.attribute12 :=
437: per_par_shd.g_old_rec.attribute12;
438: End If;
439: If (p_rec.attribute13 = hr_api.g_varchar2) then
440: p_rec.attribute13 :=
441: per_par_shd.g_old_rec.attribute13;
437: per_par_shd.g_old_rec.attribute12;
438: End If;
439: If (p_rec.attribute13 = hr_api.g_varchar2) then
440: p_rec.attribute13 :=
441: per_par_shd.g_old_rec.attribute13;
442: End If;
443: If (p_rec.attribute14 = hr_api.g_varchar2) then
444: p_rec.attribute14 :=
445: per_par_shd.g_old_rec.attribute14;
441: per_par_shd.g_old_rec.attribute13;
442: End If;
443: If (p_rec.attribute14 = hr_api.g_varchar2) then
444: p_rec.attribute14 :=
445: per_par_shd.g_old_rec.attribute14;
446: End If;
447: If (p_rec.attribute15 = hr_api.g_varchar2) then
448: p_rec.attribute15 :=
449: per_par_shd.g_old_rec.attribute15;
445: per_par_shd.g_old_rec.attribute14;
446: End If;
447: If (p_rec.attribute15 = hr_api.g_varchar2) then
448: p_rec.attribute15 :=
449: per_par_shd.g_old_rec.attribute15;
450: End If;
451: If (p_rec.attribute16 = hr_api.g_varchar2) then
452: p_rec.attribute16 :=
453: per_par_shd.g_old_rec.attribute16;
449: per_par_shd.g_old_rec.attribute15;
450: End If;
451: If (p_rec.attribute16 = hr_api.g_varchar2) then
452: p_rec.attribute16 :=
453: per_par_shd.g_old_rec.attribute16;
454: End If;
455: If (p_rec.attribute17 = hr_api.g_varchar2) then
456: p_rec.attribute17 :=
457: per_par_shd.g_old_rec.attribute17;
453: per_par_shd.g_old_rec.attribute16;
454: End If;
455: If (p_rec.attribute17 = hr_api.g_varchar2) then
456: p_rec.attribute17 :=
457: per_par_shd.g_old_rec.attribute17;
458: End If;
459: If (p_rec.attribute18 = hr_api.g_varchar2) then
460: p_rec.attribute18 :=
461: per_par_shd.g_old_rec.attribute18;
457: per_par_shd.g_old_rec.attribute17;
458: End If;
459: If (p_rec.attribute18 = hr_api.g_varchar2) then
460: p_rec.attribute18 :=
461: per_par_shd.g_old_rec.attribute18;
462: End If;
463: If (p_rec.attribute19 = hr_api.g_varchar2) then
464: p_rec.attribute19 :=
465: per_par_shd.g_old_rec.attribute19;
461: per_par_shd.g_old_rec.attribute18;
462: End If;
463: If (p_rec.attribute19 = hr_api.g_varchar2) then
464: p_rec.attribute19 :=
465: per_par_shd.g_old_rec.attribute19;
466: End If;
467: If (p_rec.attribute20 = hr_api.g_varchar2) then
468: p_rec.attribute20 :=
469: per_par_shd.g_old_rec.attribute20;
465: per_par_shd.g_old_rec.attribute19;
466: End If;
467: If (p_rec.attribute20 = hr_api.g_varchar2) then
468: p_rec.attribute20 :=
469: per_par_shd.g_old_rec.attribute20;
470: End If;
471: If (p_rec.participant_usage_status = hr_api.g_varchar2) then
472: p_rec.participant_usage_status :=
473: per_par_shd.g_old_rec.participant_usage_status;
469: per_par_shd.g_old_rec.attribute20;
470: End If;
471: If (p_rec.participant_usage_status = hr_api.g_varchar2) then
472: p_rec.participant_usage_status :=
473: per_par_shd.g_old_rec.participant_usage_status;
474: End If;
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 10);
477: --
481: -- |---------------------------------< upd >----------------------------------|
482: -- ----------------------------------------------------------------------------
483: Procedure upd
484: (
485: p_rec in out nocopy per_par_shd.g_rec_type,
486: p_effective_date in date,
487: p_validate in boolean default false
488: ) is
489: --
502: End If;
503: --
504: -- We must lock the row which we need to update.
505: --
506: per_par_shd.lck
507: (
508: p_rec.participant_id,
509: p_rec.object_version_number
510: );
595: p_participant_usage_status in varchar2 default hr_api.g_varchar2,
596: p_validate in boolean default false
597: ) is
598: --
599: l_rec per_par_shd.g_rec_type;
600: l_proc varchar2(72) := g_package||'upd';
601: --
602: Begin
603: hr_utility.set_location('Entering:'||l_proc, 5);
605: -- Call conversion function to turn arguments into the
606: -- l_rec structure.
607: --
608: l_rec :=
609: per_par_shd.convert_args
610: (
611: p_participant_id,
612: hr_api.g_number,
613: p_object_version_number,