eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QUA_UPD dependencies on PER_QUA_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_qua_shd.g_rec_type) is

50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_qua_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: per_qua_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_qua_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_qualifications Row
68: --
69: update per_qualifications

Line 146: per_qua_shd.g_api_dml := false; -- Unset the api dml status

142: subscription_payment_method = p_rec.subscription_payment_method,
143: party_id = p_rec.party_id
144: where qualification_id = p_rec.qualification_id;
145: --
146: per_qua_shd.g_api_dml := false; -- Unset the api dml status
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: --
150: Exception

Line 153: per_qua_shd.g_api_dml := false; -- Unset the api dml status

149: --
150: Exception
151: When hr_api.check_integrity_violated Then
152: -- A check constraint has been violated
153: per_qua_shd.g_api_dml := false; -- Unset the api dml status
154: per_qua_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.parent_integrity_violated Then
157: -- Parent integrity has been violated

Line 154: per_qua_shd.constraint_error

150: Exception
151: When hr_api.check_integrity_violated Then
152: -- A check constraint has been violated
153: per_qua_shd.g_api_dml := false; -- Unset the api dml status
154: per_qua_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.parent_integrity_violated Then
157: -- Parent integrity has been violated
158: per_qua_shd.g_api_dml := false; -- Unset the api dml status

Line 158: per_qua_shd.g_api_dml := false; -- Unset the api dml status

154: per_qua_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.parent_integrity_violated Then
157: -- Parent integrity has been violated
158: per_qua_shd.g_api_dml := false; -- Unset the api dml status
159: per_qua_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated

Line 159: per_qua_shd.constraint_error

155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.parent_integrity_violated Then
157: -- Parent integrity has been violated
158: per_qua_shd.g_api_dml := false; -- Unset the api dml status
159: per_qua_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: per_qua_shd.g_api_dml := false; -- Unset the api dml status

Line 163: per_qua_shd.g_api_dml := false; -- Unset the api dml status

159: per_qua_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: per_qua_shd.g_api_dml := false; -- Unset the api dml status
164: per_qua_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: per_qua_shd.g_api_dml := false; -- Unset the api dml status

Line 164: per_qua_shd.constraint_error

160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: per_qua_shd.g_api_dml := false; -- Unset the api dml status
164: per_qua_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: per_qua_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;

Line 167: per_qua_shd.g_api_dml := false; -- Unset the api dml status

163: per_qua_shd.g_api_dml := false; -- Unset the api dml status
164: per_qua_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: per_qua_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;
169: End update_dml;
170: --
171: -- ----------------------------------------------------------------------------

Line 203: Procedure pre_update(p_rec in per_qua_shd.g_rec_type) is

199: -- Internal Table Handler Use Only.
200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
203: Procedure pre_update(p_rec in per_qua_shd.g_rec_type) is
204: --
205: l_proc varchar2(72) := g_package||'pre_update';
206: --
207: Begin

Line 245: Procedure post_update(p_rec in per_qua_shd.g_rec_type,

241: -- Internal Table Handler Use Only.
242: --
243: -- {End Of Comments}
244: -- ----------------------------------------------------------------------------
245: Procedure post_update(p_rec in per_qua_shd.g_rec_type,
246: p_effective_date in date) is
247: --
248: l_proc varchar2(72) := g_package||'post_update';
249: --

Line 332: p_business_group_id_o => per_qua_shd.g_old_rec.business_group_id,

328: p_membership_category => p_rec.membership_category,
329: p_subscription_payment_method => p_rec.subscription_payment_method,
330: p_party_id => p_rec.party_id,
331: p_effective_date => p_effective_date,
332: p_business_group_id_o => per_qua_shd.g_old_rec.business_group_id,
333: p_person_id_o => per_qua_shd.g_old_rec.person_id,
334: p_object_version_number_o => per_qua_shd.g_old_rec.object_version_number,
335: p_title_o => per_qua_shd.g_old_rec.title,
336: p_grade_attained_o => per_qua_shd.g_old_rec.grade_attained,

Line 333: p_person_id_o => per_qua_shd.g_old_rec.person_id,

329: p_subscription_payment_method => p_rec.subscription_payment_method,
330: p_party_id => p_rec.party_id,
331: p_effective_date => p_effective_date,
332: p_business_group_id_o => per_qua_shd.g_old_rec.business_group_id,
333: p_person_id_o => per_qua_shd.g_old_rec.person_id,
334: p_object_version_number_o => per_qua_shd.g_old_rec.object_version_number,
335: p_title_o => per_qua_shd.g_old_rec.title,
336: p_grade_attained_o => per_qua_shd.g_old_rec.grade_attained,
337: p_status_o => per_qua_shd.g_old_rec.status,

Line 334: p_object_version_number_o => per_qua_shd.g_old_rec.object_version_number,

330: p_party_id => p_rec.party_id,
331: p_effective_date => p_effective_date,
332: p_business_group_id_o => per_qua_shd.g_old_rec.business_group_id,
333: p_person_id_o => per_qua_shd.g_old_rec.person_id,
334: p_object_version_number_o => per_qua_shd.g_old_rec.object_version_number,
335: p_title_o => per_qua_shd.g_old_rec.title,
336: p_grade_attained_o => per_qua_shd.g_old_rec.grade_attained,
337: p_status_o => per_qua_shd.g_old_rec.status,
338: p_awarded_date_o => per_qua_shd.g_old_rec.awarded_date,

Line 335: p_title_o => per_qua_shd.g_old_rec.title,

331: p_effective_date => p_effective_date,
332: p_business_group_id_o => per_qua_shd.g_old_rec.business_group_id,
333: p_person_id_o => per_qua_shd.g_old_rec.person_id,
334: p_object_version_number_o => per_qua_shd.g_old_rec.object_version_number,
335: p_title_o => per_qua_shd.g_old_rec.title,
336: p_grade_attained_o => per_qua_shd.g_old_rec.grade_attained,
337: p_status_o => per_qua_shd.g_old_rec.status,
338: p_awarded_date_o => per_qua_shd.g_old_rec.awarded_date,
339: p_fee_o => per_qua_shd.g_old_rec.fee,

Line 336: p_grade_attained_o => per_qua_shd.g_old_rec.grade_attained,

332: p_business_group_id_o => per_qua_shd.g_old_rec.business_group_id,
333: p_person_id_o => per_qua_shd.g_old_rec.person_id,
334: p_object_version_number_o => per_qua_shd.g_old_rec.object_version_number,
335: p_title_o => per_qua_shd.g_old_rec.title,
336: p_grade_attained_o => per_qua_shd.g_old_rec.grade_attained,
337: p_status_o => per_qua_shd.g_old_rec.status,
338: p_awarded_date_o => per_qua_shd.g_old_rec.awarded_date,
339: p_fee_o => per_qua_shd.g_old_rec.fee,
340: p_fee_currency_o => per_qua_shd.g_old_rec.fee_currency,

Line 337: p_status_o => per_qua_shd.g_old_rec.status,

333: p_person_id_o => per_qua_shd.g_old_rec.person_id,
334: p_object_version_number_o => per_qua_shd.g_old_rec.object_version_number,
335: p_title_o => per_qua_shd.g_old_rec.title,
336: p_grade_attained_o => per_qua_shd.g_old_rec.grade_attained,
337: p_status_o => per_qua_shd.g_old_rec.status,
338: p_awarded_date_o => per_qua_shd.g_old_rec.awarded_date,
339: p_fee_o => per_qua_shd.g_old_rec.fee,
340: p_fee_currency_o => per_qua_shd.g_old_rec.fee_currency,
341: p_training_completed_amount_o => per_qua_shd.g_old_rec.training_completed_amount,

Line 338: p_awarded_date_o => per_qua_shd.g_old_rec.awarded_date,

334: p_object_version_number_o => per_qua_shd.g_old_rec.object_version_number,
335: p_title_o => per_qua_shd.g_old_rec.title,
336: p_grade_attained_o => per_qua_shd.g_old_rec.grade_attained,
337: p_status_o => per_qua_shd.g_old_rec.status,
338: p_awarded_date_o => per_qua_shd.g_old_rec.awarded_date,
339: p_fee_o => per_qua_shd.g_old_rec.fee,
340: p_fee_currency_o => per_qua_shd.g_old_rec.fee_currency,
341: p_training_completed_amount_o => per_qua_shd.g_old_rec.training_completed_amount,
342: p_reimbursement_arrangements_o => per_qua_shd.g_old_rec.reimbursement_arrangements,

Line 339: p_fee_o => per_qua_shd.g_old_rec.fee,

335: p_title_o => per_qua_shd.g_old_rec.title,
336: p_grade_attained_o => per_qua_shd.g_old_rec.grade_attained,
337: p_status_o => per_qua_shd.g_old_rec.status,
338: p_awarded_date_o => per_qua_shd.g_old_rec.awarded_date,
339: p_fee_o => per_qua_shd.g_old_rec.fee,
340: p_fee_currency_o => per_qua_shd.g_old_rec.fee_currency,
341: p_training_completed_amount_o => per_qua_shd.g_old_rec.training_completed_amount,
342: p_reimbursement_arrangements_o => per_qua_shd.g_old_rec.reimbursement_arrangements,
343: p_training_completed_units_o => per_qua_shd.g_old_rec.training_completed_units,

Line 340: p_fee_currency_o => per_qua_shd.g_old_rec.fee_currency,

336: p_grade_attained_o => per_qua_shd.g_old_rec.grade_attained,
337: p_status_o => per_qua_shd.g_old_rec.status,
338: p_awarded_date_o => per_qua_shd.g_old_rec.awarded_date,
339: p_fee_o => per_qua_shd.g_old_rec.fee,
340: p_fee_currency_o => per_qua_shd.g_old_rec.fee_currency,
341: p_training_completed_amount_o => per_qua_shd.g_old_rec.training_completed_amount,
342: p_reimbursement_arrangements_o => per_qua_shd.g_old_rec.reimbursement_arrangements,
343: p_training_completed_units_o => per_qua_shd.g_old_rec.training_completed_units,
344: p_total_training_amount_o => per_qua_shd.g_old_rec.total_training_amount,

Line 341: p_training_completed_amount_o => per_qua_shd.g_old_rec.training_completed_amount,

337: p_status_o => per_qua_shd.g_old_rec.status,
338: p_awarded_date_o => per_qua_shd.g_old_rec.awarded_date,
339: p_fee_o => per_qua_shd.g_old_rec.fee,
340: p_fee_currency_o => per_qua_shd.g_old_rec.fee_currency,
341: p_training_completed_amount_o => per_qua_shd.g_old_rec.training_completed_amount,
342: p_reimbursement_arrangements_o => per_qua_shd.g_old_rec.reimbursement_arrangements,
343: p_training_completed_units_o => per_qua_shd.g_old_rec.training_completed_units,
344: p_total_training_amount_o => per_qua_shd.g_old_rec.total_training_amount,
345: p_start_date_o => per_qua_shd.g_old_rec.start_date,

Line 342: p_reimbursement_arrangements_o => per_qua_shd.g_old_rec.reimbursement_arrangements,

338: p_awarded_date_o => per_qua_shd.g_old_rec.awarded_date,
339: p_fee_o => per_qua_shd.g_old_rec.fee,
340: p_fee_currency_o => per_qua_shd.g_old_rec.fee_currency,
341: p_training_completed_amount_o => per_qua_shd.g_old_rec.training_completed_amount,
342: p_reimbursement_arrangements_o => per_qua_shd.g_old_rec.reimbursement_arrangements,
343: p_training_completed_units_o => per_qua_shd.g_old_rec.training_completed_units,
344: p_total_training_amount_o => per_qua_shd.g_old_rec.total_training_amount,
345: p_start_date_o => per_qua_shd.g_old_rec.start_date,
346: p_end_date_o => per_qua_shd.g_old_rec.end_date,

Line 343: p_training_completed_units_o => per_qua_shd.g_old_rec.training_completed_units,

339: p_fee_o => per_qua_shd.g_old_rec.fee,
340: p_fee_currency_o => per_qua_shd.g_old_rec.fee_currency,
341: p_training_completed_amount_o => per_qua_shd.g_old_rec.training_completed_amount,
342: p_reimbursement_arrangements_o => per_qua_shd.g_old_rec.reimbursement_arrangements,
343: p_training_completed_units_o => per_qua_shd.g_old_rec.training_completed_units,
344: p_total_training_amount_o => per_qua_shd.g_old_rec.total_training_amount,
345: p_start_date_o => per_qua_shd.g_old_rec.start_date,
346: p_end_date_o => per_qua_shd.g_old_rec.end_date,
347: p_license_number_o => per_qua_shd.g_old_rec.license_number,

Line 344: p_total_training_amount_o => per_qua_shd.g_old_rec.total_training_amount,

340: p_fee_currency_o => per_qua_shd.g_old_rec.fee_currency,
341: p_training_completed_amount_o => per_qua_shd.g_old_rec.training_completed_amount,
342: p_reimbursement_arrangements_o => per_qua_shd.g_old_rec.reimbursement_arrangements,
343: p_training_completed_units_o => per_qua_shd.g_old_rec.training_completed_units,
344: p_total_training_amount_o => per_qua_shd.g_old_rec.total_training_amount,
345: p_start_date_o => per_qua_shd.g_old_rec.start_date,
346: p_end_date_o => per_qua_shd.g_old_rec.end_date,
347: p_license_number_o => per_qua_shd.g_old_rec.license_number,
348: p_expiry_date_o => per_qua_shd.g_old_rec.expiry_date,

Line 345: p_start_date_o => per_qua_shd.g_old_rec.start_date,

341: p_training_completed_amount_o => per_qua_shd.g_old_rec.training_completed_amount,
342: p_reimbursement_arrangements_o => per_qua_shd.g_old_rec.reimbursement_arrangements,
343: p_training_completed_units_o => per_qua_shd.g_old_rec.training_completed_units,
344: p_total_training_amount_o => per_qua_shd.g_old_rec.total_training_amount,
345: p_start_date_o => per_qua_shd.g_old_rec.start_date,
346: p_end_date_o => per_qua_shd.g_old_rec.end_date,
347: p_license_number_o => per_qua_shd.g_old_rec.license_number,
348: p_expiry_date_o => per_qua_shd.g_old_rec.expiry_date,
349: p_license_restrictions_o => per_qua_shd.g_old_rec.license_restrictions,

Line 346: p_end_date_o => per_qua_shd.g_old_rec.end_date,

342: p_reimbursement_arrangements_o => per_qua_shd.g_old_rec.reimbursement_arrangements,
343: p_training_completed_units_o => per_qua_shd.g_old_rec.training_completed_units,
344: p_total_training_amount_o => per_qua_shd.g_old_rec.total_training_amount,
345: p_start_date_o => per_qua_shd.g_old_rec.start_date,
346: p_end_date_o => per_qua_shd.g_old_rec.end_date,
347: p_license_number_o => per_qua_shd.g_old_rec.license_number,
348: p_expiry_date_o => per_qua_shd.g_old_rec.expiry_date,
349: p_license_restrictions_o => per_qua_shd.g_old_rec.license_restrictions,
350: p_projected_completion_date_o => per_qua_shd.g_old_rec.projected_completion_date,

Line 347: p_license_number_o => per_qua_shd.g_old_rec.license_number,

343: p_training_completed_units_o => per_qua_shd.g_old_rec.training_completed_units,
344: p_total_training_amount_o => per_qua_shd.g_old_rec.total_training_amount,
345: p_start_date_o => per_qua_shd.g_old_rec.start_date,
346: p_end_date_o => per_qua_shd.g_old_rec.end_date,
347: p_license_number_o => per_qua_shd.g_old_rec.license_number,
348: p_expiry_date_o => per_qua_shd.g_old_rec.expiry_date,
349: p_license_restrictions_o => per_qua_shd.g_old_rec.license_restrictions,
350: p_projected_completion_date_o => per_qua_shd.g_old_rec.projected_completion_date,
351: p_awarding_body_o => per_qua_shd.g_old_rec.awarding_body,

Line 348: p_expiry_date_o => per_qua_shd.g_old_rec.expiry_date,

344: p_total_training_amount_o => per_qua_shd.g_old_rec.total_training_amount,
345: p_start_date_o => per_qua_shd.g_old_rec.start_date,
346: p_end_date_o => per_qua_shd.g_old_rec.end_date,
347: p_license_number_o => per_qua_shd.g_old_rec.license_number,
348: p_expiry_date_o => per_qua_shd.g_old_rec.expiry_date,
349: p_license_restrictions_o => per_qua_shd.g_old_rec.license_restrictions,
350: p_projected_completion_date_o => per_qua_shd.g_old_rec.projected_completion_date,
351: p_awarding_body_o => per_qua_shd.g_old_rec.awarding_body,
352: p_tuition_method_o => per_qua_shd.g_old_rec.tuition_method,

Line 349: p_license_restrictions_o => per_qua_shd.g_old_rec.license_restrictions,

345: p_start_date_o => per_qua_shd.g_old_rec.start_date,
346: p_end_date_o => per_qua_shd.g_old_rec.end_date,
347: p_license_number_o => per_qua_shd.g_old_rec.license_number,
348: p_expiry_date_o => per_qua_shd.g_old_rec.expiry_date,
349: p_license_restrictions_o => per_qua_shd.g_old_rec.license_restrictions,
350: p_projected_completion_date_o => per_qua_shd.g_old_rec.projected_completion_date,
351: p_awarding_body_o => per_qua_shd.g_old_rec.awarding_body,
352: p_tuition_method_o => per_qua_shd.g_old_rec.tuition_method,
353: p_group_ranking_o => per_qua_shd.g_old_rec.group_ranking,

Line 350: p_projected_completion_date_o => per_qua_shd.g_old_rec.projected_completion_date,

346: p_end_date_o => per_qua_shd.g_old_rec.end_date,
347: p_license_number_o => per_qua_shd.g_old_rec.license_number,
348: p_expiry_date_o => per_qua_shd.g_old_rec.expiry_date,
349: p_license_restrictions_o => per_qua_shd.g_old_rec.license_restrictions,
350: p_projected_completion_date_o => per_qua_shd.g_old_rec.projected_completion_date,
351: p_awarding_body_o => per_qua_shd.g_old_rec.awarding_body,
352: p_tuition_method_o => per_qua_shd.g_old_rec.tuition_method,
353: p_group_ranking_o => per_qua_shd.g_old_rec.group_ranking,
354: p_comments_o => per_qua_shd.g_old_rec.comments,

Line 351: p_awarding_body_o => per_qua_shd.g_old_rec.awarding_body,

347: p_license_number_o => per_qua_shd.g_old_rec.license_number,
348: p_expiry_date_o => per_qua_shd.g_old_rec.expiry_date,
349: p_license_restrictions_o => per_qua_shd.g_old_rec.license_restrictions,
350: p_projected_completion_date_o => per_qua_shd.g_old_rec.projected_completion_date,
351: p_awarding_body_o => per_qua_shd.g_old_rec.awarding_body,
352: p_tuition_method_o => per_qua_shd.g_old_rec.tuition_method,
353: p_group_ranking_o => per_qua_shd.g_old_rec.group_ranking,
354: p_comments_o => per_qua_shd.g_old_rec.comments,
355: p_qualification_type_id_o => per_qua_shd.g_old_rec.qualification_type_id,

Line 352: p_tuition_method_o => per_qua_shd.g_old_rec.tuition_method,

348: p_expiry_date_o => per_qua_shd.g_old_rec.expiry_date,
349: p_license_restrictions_o => per_qua_shd.g_old_rec.license_restrictions,
350: p_projected_completion_date_o => per_qua_shd.g_old_rec.projected_completion_date,
351: p_awarding_body_o => per_qua_shd.g_old_rec.awarding_body,
352: p_tuition_method_o => per_qua_shd.g_old_rec.tuition_method,
353: p_group_ranking_o => per_qua_shd.g_old_rec.group_ranking,
354: p_comments_o => per_qua_shd.g_old_rec.comments,
355: p_qualification_type_id_o => per_qua_shd.g_old_rec.qualification_type_id,
356: p_attendance_id_o => per_qua_shd.g_old_rec.attendance_id,

Line 353: p_group_ranking_o => per_qua_shd.g_old_rec.group_ranking,

349: p_license_restrictions_o => per_qua_shd.g_old_rec.license_restrictions,
350: p_projected_completion_date_o => per_qua_shd.g_old_rec.projected_completion_date,
351: p_awarding_body_o => per_qua_shd.g_old_rec.awarding_body,
352: p_tuition_method_o => per_qua_shd.g_old_rec.tuition_method,
353: p_group_ranking_o => per_qua_shd.g_old_rec.group_ranking,
354: p_comments_o => per_qua_shd.g_old_rec.comments,
355: p_qualification_type_id_o => per_qua_shd.g_old_rec.qualification_type_id,
356: p_attendance_id_o => per_qua_shd.g_old_rec.attendance_id,
357: p_attribute_category_o => per_qua_shd.g_old_rec.attribute_category,

Line 354: p_comments_o => per_qua_shd.g_old_rec.comments,

350: p_projected_completion_date_o => per_qua_shd.g_old_rec.projected_completion_date,
351: p_awarding_body_o => per_qua_shd.g_old_rec.awarding_body,
352: p_tuition_method_o => per_qua_shd.g_old_rec.tuition_method,
353: p_group_ranking_o => per_qua_shd.g_old_rec.group_ranking,
354: p_comments_o => per_qua_shd.g_old_rec.comments,
355: p_qualification_type_id_o => per_qua_shd.g_old_rec.qualification_type_id,
356: p_attendance_id_o => per_qua_shd.g_old_rec.attendance_id,
357: p_attribute_category_o => per_qua_shd.g_old_rec.attribute_category,
358: p_attribute1_o => per_qua_shd.g_old_rec.attribute1,

Line 355: p_qualification_type_id_o => per_qua_shd.g_old_rec.qualification_type_id,

351: p_awarding_body_o => per_qua_shd.g_old_rec.awarding_body,
352: p_tuition_method_o => per_qua_shd.g_old_rec.tuition_method,
353: p_group_ranking_o => per_qua_shd.g_old_rec.group_ranking,
354: p_comments_o => per_qua_shd.g_old_rec.comments,
355: p_qualification_type_id_o => per_qua_shd.g_old_rec.qualification_type_id,
356: p_attendance_id_o => per_qua_shd.g_old_rec.attendance_id,
357: p_attribute_category_o => per_qua_shd.g_old_rec.attribute_category,
358: p_attribute1_o => per_qua_shd.g_old_rec.attribute1,
359: p_attribute2_o => per_qua_shd.g_old_rec.attribute2,

Line 356: p_attendance_id_o => per_qua_shd.g_old_rec.attendance_id,

352: p_tuition_method_o => per_qua_shd.g_old_rec.tuition_method,
353: p_group_ranking_o => per_qua_shd.g_old_rec.group_ranking,
354: p_comments_o => per_qua_shd.g_old_rec.comments,
355: p_qualification_type_id_o => per_qua_shd.g_old_rec.qualification_type_id,
356: p_attendance_id_o => per_qua_shd.g_old_rec.attendance_id,
357: p_attribute_category_o => per_qua_shd.g_old_rec.attribute_category,
358: p_attribute1_o => per_qua_shd.g_old_rec.attribute1,
359: p_attribute2_o => per_qua_shd.g_old_rec.attribute2,
360: p_attribute3_o => per_qua_shd.g_old_rec.attribute3,

Line 357: p_attribute_category_o => per_qua_shd.g_old_rec.attribute_category,

353: p_group_ranking_o => per_qua_shd.g_old_rec.group_ranking,
354: p_comments_o => per_qua_shd.g_old_rec.comments,
355: p_qualification_type_id_o => per_qua_shd.g_old_rec.qualification_type_id,
356: p_attendance_id_o => per_qua_shd.g_old_rec.attendance_id,
357: p_attribute_category_o => per_qua_shd.g_old_rec.attribute_category,
358: p_attribute1_o => per_qua_shd.g_old_rec.attribute1,
359: p_attribute2_o => per_qua_shd.g_old_rec.attribute2,
360: p_attribute3_o => per_qua_shd.g_old_rec.attribute3,
361: p_attribute4_o => per_qua_shd.g_old_rec.attribute4,

Line 358: p_attribute1_o => per_qua_shd.g_old_rec.attribute1,

354: p_comments_o => per_qua_shd.g_old_rec.comments,
355: p_qualification_type_id_o => per_qua_shd.g_old_rec.qualification_type_id,
356: p_attendance_id_o => per_qua_shd.g_old_rec.attendance_id,
357: p_attribute_category_o => per_qua_shd.g_old_rec.attribute_category,
358: p_attribute1_o => per_qua_shd.g_old_rec.attribute1,
359: p_attribute2_o => per_qua_shd.g_old_rec.attribute2,
360: p_attribute3_o => per_qua_shd.g_old_rec.attribute3,
361: p_attribute4_o => per_qua_shd.g_old_rec.attribute4,
362: p_attribute5_o => per_qua_shd.g_old_rec.attribute5,

Line 359: p_attribute2_o => per_qua_shd.g_old_rec.attribute2,

355: p_qualification_type_id_o => per_qua_shd.g_old_rec.qualification_type_id,
356: p_attendance_id_o => per_qua_shd.g_old_rec.attendance_id,
357: p_attribute_category_o => per_qua_shd.g_old_rec.attribute_category,
358: p_attribute1_o => per_qua_shd.g_old_rec.attribute1,
359: p_attribute2_o => per_qua_shd.g_old_rec.attribute2,
360: p_attribute3_o => per_qua_shd.g_old_rec.attribute3,
361: p_attribute4_o => per_qua_shd.g_old_rec.attribute4,
362: p_attribute5_o => per_qua_shd.g_old_rec.attribute5,
363: p_attribute6_o => per_qua_shd.g_old_rec.attribute6,

Line 360: p_attribute3_o => per_qua_shd.g_old_rec.attribute3,

356: p_attendance_id_o => per_qua_shd.g_old_rec.attendance_id,
357: p_attribute_category_o => per_qua_shd.g_old_rec.attribute_category,
358: p_attribute1_o => per_qua_shd.g_old_rec.attribute1,
359: p_attribute2_o => per_qua_shd.g_old_rec.attribute2,
360: p_attribute3_o => per_qua_shd.g_old_rec.attribute3,
361: p_attribute4_o => per_qua_shd.g_old_rec.attribute4,
362: p_attribute5_o => per_qua_shd.g_old_rec.attribute5,
363: p_attribute6_o => per_qua_shd.g_old_rec.attribute6,
364: p_attribute7_o => per_qua_shd.g_old_rec.attribute7,

Line 361: p_attribute4_o => per_qua_shd.g_old_rec.attribute4,

357: p_attribute_category_o => per_qua_shd.g_old_rec.attribute_category,
358: p_attribute1_o => per_qua_shd.g_old_rec.attribute1,
359: p_attribute2_o => per_qua_shd.g_old_rec.attribute2,
360: p_attribute3_o => per_qua_shd.g_old_rec.attribute3,
361: p_attribute4_o => per_qua_shd.g_old_rec.attribute4,
362: p_attribute5_o => per_qua_shd.g_old_rec.attribute5,
363: p_attribute6_o => per_qua_shd.g_old_rec.attribute6,
364: p_attribute7_o => per_qua_shd.g_old_rec.attribute7,
365: p_attribute8_o => per_qua_shd.g_old_rec.attribute8,

Line 362: p_attribute5_o => per_qua_shd.g_old_rec.attribute5,

358: p_attribute1_o => per_qua_shd.g_old_rec.attribute1,
359: p_attribute2_o => per_qua_shd.g_old_rec.attribute2,
360: p_attribute3_o => per_qua_shd.g_old_rec.attribute3,
361: p_attribute4_o => per_qua_shd.g_old_rec.attribute4,
362: p_attribute5_o => per_qua_shd.g_old_rec.attribute5,
363: p_attribute6_o => per_qua_shd.g_old_rec.attribute6,
364: p_attribute7_o => per_qua_shd.g_old_rec.attribute7,
365: p_attribute8_o => per_qua_shd.g_old_rec.attribute8,
366: p_attribute9_o => per_qua_shd.g_old_rec.attribute9,

Line 363: p_attribute6_o => per_qua_shd.g_old_rec.attribute6,

359: p_attribute2_o => per_qua_shd.g_old_rec.attribute2,
360: p_attribute3_o => per_qua_shd.g_old_rec.attribute3,
361: p_attribute4_o => per_qua_shd.g_old_rec.attribute4,
362: p_attribute5_o => per_qua_shd.g_old_rec.attribute5,
363: p_attribute6_o => per_qua_shd.g_old_rec.attribute6,
364: p_attribute7_o => per_qua_shd.g_old_rec.attribute7,
365: p_attribute8_o => per_qua_shd.g_old_rec.attribute8,
366: p_attribute9_o => per_qua_shd.g_old_rec.attribute9,
367: p_attribute10_o => per_qua_shd.g_old_rec.attribute10,

Line 364: p_attribute7_o => per_qua_shd.g_old_rec.attribute7,

360: p_attribute3_o => per_qua_shd.g_old_rec.attribute3,
361: p_attribute4_o => per_qua_shd.g_old_rec.attribute4,
362: p_attribute5_o => per_qua_shd.g_old_rec.attribute5,
363: p_attribute6_o => per_qua_shd.g_old_rec.attribute6,
364: p_attribute7_o => per_qua_shd.g_old_rec.attribute7,
365: p_attribute8_o => per_qua_shd.g_old_rec.attribute8,
366: p_attribute9_o => per_qua_shd.g_old_rec.attribute9,
367: p_attribute10_o => per_qua_shd.g_old_rec.attribute10,
368: p_attribute11_o => per_qua_shd.g_old_rec.attribute11,

Line 365: p_attribute8_o => per_qua_shd.g_old_rec.attribute8,

361: p_attribute4_o => per_qua_shd.g_old_rec.attribute4,
362: p_attribute5_o => per_qua_shd.g_old_rec.attribute5,
363: p_attribute6_o => per_qua_shd.g_old_rec.attribute6,
364: p_attribute7_o => per_qua_shd.g_old_rec.attribute7,
365: p_attribute8_o => per_qua_shd.g_old_rec.attribute8,
366: p_attribute9_o => per_qua_shd.g_old_rec.attribute9,
367: p_attribute10_o => per_qua_shd.g_old_rec.attribute10,
368: p_attribute11_o => per_qua_shd.g_old_rec.attribute11,
369: p_attribute12_o => per_qua_shd.g_old_rec.attribute12,

Line 366: p_attribute9_o => per_qua_shd.g_old_rec.attribute9,

362: p_attribute5_o => per_qua_shd.g_old_rec.attribute5,
363: p_attribute6_o => per_qua_shd.g_old_rec.attribute6,
364: p_attribute7_o => per_qua_shd.g_old_rec.attribute7,
365: p_attribute8_o => per_qua_shd.g_old_rec.attribute8,
366: p_attribute9_o => per_qua_shd.g_old_rec.attribute9,
367: p_attribute10_o => per_qua_shd.g_old_rec.attribute10,
368: p_attribute11_o => per_qua_shd.g_old_rec.attribute11,
369: p_attribute12_o => per_qua_shd.g_old_rec.attribute12,
370: p_attribute13_o => per_qua_shd.g_old_rec.attribute13,

Line 367: p_attribute10_o => per_qua_shd.g_old_rec.attribute10,

363: p_attribute6_o => per_qua_shd.g_old_rec.attribute6,
364: p_attribute7_o => per_qua_shd.g_old_rec.attribute7,
365: p_attribute8_o => per_qua_shd.g_old_rec.attribute8,
366: p_attribute9_o => per_qua_shd.g_old_rec.attribute9,
367: p_attribute10_o => per_qua_shd.g_old_rec.attribute10,
368: p_attribute11_o => per_qua_shd.g_old_rec.attribute11,
369: p_attribute12_o => per_qua_shd.g_old_rec.attribute12,
370: p_attribute13_o => per_qua_shd.g_old_rec.attribute13,
371: p_attribute14_o => per_qua_shd.g_old_rec.attribute14,

Line 368: p_attribute11_o => per_qua_shd.g_old_rec.attribute11,

364: p_attribute7_o => per_qua_shd.g_old_rec.attribute7,
365: p_attribute8_o => per_qua_shd.g_old_rec.attribute8,
366: p_attribute9_o => per_qua_shd.g_old_rec.attribute9,
367: p_attribute10_o => per_qua_shd.g_old_rec.attribute10,
368: p_attribute11_o => per_qua_shd.g_old_rec.attribute11,
369: p_attribute12_o => per_qua_shd.g_old_rec.attribute12,
370: p_attribute13_o => per_qua_shd.g_old_rec.attribute13,
371: p_attribute14_o => per_qua_shd.g_old_rec.attribute14,
372: p_attribute15_o => per_qua_shd.g_old_rec.attribute15,

Line 369: p_attribute12_o => per_qua_shd.g_old_rec.attribute12,

365: p_attribute8_o => per_qua_shd.g_old_rec.attribute8,
366: p_attribute9_o => per_qua_shd.g_old_rec.attribute9,
367: p_attribute10_o => per_qua_shd.g_old_rec.attribute10,
368: p_attribute11_o => per_qua_shd.g_old_rec.attribute11,
369: p_attribute12_o => per_qua_shd.g_old_rec.attribute12,
370: p_attribute13_o => per_qua_shd.g_old_rec.attribute13,
371: p_attribute14_o => per_qua_shd.g_old_rec.attribute14,
372: p_attribute15_o => per_qua_shd.g_old_rec.attribute15,
373: p_attribute16_o => per_qua_shd.g_old_rec.attribute16,

Line 370: p_attribute13_o => per_qua_shd.g_old_rec.attribute13,

366: p_attribute9_o => per_qua_shd.g_old_rec.attribute9,
367: p_attribute10_o => per_qua_shd.g_old_rec.attribute10,
368: p_attribute11_o => per_qua_shd.g_old_rec.attribute11,
369: p_attribute12_o => per_qua_shd.g_old_rec.attribute12,
370: p_attribute13_o => per_qua_shd.g_old_rec.attribute13,
371: p_attribute14_o => per_qua_shd.g_old_rec.attribute14,
372: p_attribute15_o => per_qua_shd.g_old_rec.attribute15,
373: p_attribute16_o => per_qua_shd.g_old_rec.attribute16,
374: p_attribute17_o => per_qua_shd.g_old_rec.attribute17,

Line 371: p_attribute14_o => per_qua_shd.g_old_rec.attribute14,

367: p_attribute10_o => per_qua_shd.g_old_rec.attribute10,
368: p_attribute11_o => per_qua_shd.g_old_rec.attribute11,
369: p_attribute12_o => per_qua_shd.g_old_rec.attribute12,
370: p_attribute13_o => per_qua_shd.g_old_rec.attribute13,
371: p_attribute14_o => per_qua_shd.g_old_rec.attribute14,
372: p_attribute15_o => per_qua_shd.g_old_rec.attribute15,
373: p_attribute16_o => per_qua_shd.g_old_rec.attribute16,
374: p_attribute17_o => per_qua_shd.g_old_rec.attribute17,
375: p_attribute18_o => per_qua_shd.g_old_rec.attribute18,

Line 372: p_attribute15_o => per_qua_shd.g_old_rec.attribute15,

368: p_attribute11_o => per_qua_shd.g_old_rec.attribute11,
369: p_attribute12_o => per_qua_shd.g_old_rec.attribute12,
370: p_attribute13_o => per_qua_shd.g_old_rec.attribute13,
371: p_attribute14_o => per_qua_shd.g_old_rec.attribute14,
372: p_attribute15_o => per_qua_shd.g_old_rec.attribute15,
373: p_attribute16_o => per_qua_shd.g_old_rec.attribute16,
374: p_attribute17_o => per_qua_shd.g_old_rec.attribute17,
375: p_attribute18_o => per_qua_shd.g_old_rec.attribute18,
376: p_attribute19_o => per_qua_shd.g_old_rec.attribute19,

Line 373: p_attribute16_o => per_qua_shd.g_old_rec.attribute16,

369: p_attribute12_o => per_qua_shd.g_old_rec.attribute12,
370: p_attribute13_o => per_qua_shd.g_old_rec.attribute13,
371: p_attribute14_o => per_qua_shd.g_old_rec.attribute14,
372: p_attribute15_o => per_qua_shd.g_old_rec.attribute15,
373: p_attribute16_o => per_qua_shd.g_old_rec.attribute16,
374: p_attribute17_o => per_qua_shd.g_old_rec.attribute17,
375: p_attribute18_o => per_qua_shd.g_old_rec.attribute18,
376: p_attribute19_o => per_qua_shd.g_old_rec.attribute19,
377: p_attribute20_o => per_qua_shd.g_old_rec.attribute20,

Line 374: p_attribute17_o => per_qua_shd.g_old_rec.attribute17,

370: p_attribute13_o => per_qua_shd.g_old_rec.attribute13,
371: p_attribute14_o => per_qua_shd.g_old_rec.attribute14,
372: p_attribute15_o => per_qua_shd.g_old_rec.attribute15,
373: p_attribute16_o => per_qua_shd.g_old_rec.attribute16,
374: p_attribute17_o => per_qua_shd.g_old_rec.attribute17,
375: p_attribute18_o => per_qua_shd.g_old_rec.attribute18,
376: p_attribute19_o => per_qua_shd.g_old_rec.attribute19,
377: p_attribute20_o => per_qua_shd.g_old_rec.attribute20,
378: p_qua_information_category_o => per_qua_shd.g_old_rec.qua_information_category,

Line 375: p_attribute18_o => per_qua_shd.g_old_rec.attribute18,

371: p_attribute14_o => per_qua_shd.g_old_rec.attribute14,
372: p_attribute15_o => per_qua_shd.g_old_rec.attribute15,
373: p_attribute16_o => per_qua_shd.g_old_rec.attribute16,
374: p_attribute17_o => per_qua_shd.g_old_rec.attribute17,
375: p_attribute18_o => per_qua_shd.g_old_rec.attribute18,
376: p_attribute19_o => per_qua_shd.g_old_rec.attribute19,
377: p_attribute20_o => per_qua_shd.g_old_rec.attribute20,
378: p_qua_information_category_o => per_qua_shd.g_old_rec.qua_information_category,
379: p_qua_information1_o => per_qua_shd.g_old_rec.qua_information1,

Line 376: p_attribute19_o => per_qua_shd.g_old_rec.attribute19,

372: p_attribute15_o => per_qua_shd.g_old_rec.attribute15,
373: p_attribute16_o => per_qua_shd.g_old_rec.attribute16,
374: p_attribute17_o => per_qua_shd.g_old_rec.attribute17,
375: p_attribute18_o => per_qua_shd.g_old_rec.attribute18,
376: p_attribute19_o => per_qua_shd.g_old_rec.attribute19,
377: p_attribute20_o => per_qua_shd.g_old_rec.attribute20,
378: p_qua_information_category_o => per_qua_shd.g_old_rec.qua_information_category,
379: p_qua_information1_o => per_qua_shd.g_old_rec.qua_information1,
380: p_qua_information2_o => per_qua_shd.g_old_rec.qua_information2,

Line 377: p_attribute20_o => per_qua_shd.g_old_rec.attribute20,

373: p_attribute16_o => per_qua_shd.g_old_rec.attribute16,
374: p_attribute17_o => per_qua_shd.g_old_rec.attribute17,
375: p_attribute18_o => per_qua_shd.g_old_rec.attribute18,
376: p_attribute19_o => per_qua_shd.g_old_rec.attribute19,
377: p_attribute20_o => per_qua_shd.g_old_rec.attribute20,
378: p_qua_information_category_o => per_qua_shd.g_old_rec.qua_information_category,
379: p_qua_information1_o => per_qua_shd.g_old_rec.qua_information1,
380: p_qua_information2_o => per_qua_shd.g_old_rec.qua_information2,
381: p_qua_information3_o => per_qua_shd.g_old_rec.qua_information3,

Line 378: p_qua_information_category_o => per_qua_shd.g_old_rec.qua_information_category,

374: p_attribute17_o => per_qua_shd.g_old_rec.attribute17,
375: p_attribute18_o => per_qua_shd.g_old_rec.attribute18,
376: p_attribute19_o => per_qua_shd.g_old_rec.attribute19,
377: p_attribute20_o => per_qua_shd.g_old_rec.attribute20,
378: p_qua_information_category_o => per_qua_shd.g_old_rec.qua_information_category,
379: p_qua_information1_o => per_qua_shd.g_old_rec.qua_information1,
380: p_qua_information2_o => per_qua_shd.g_old_rec.qua_information2,
381: p_qua_information3_o => per_qua_shd.g_old_rec.qua_information3,
382: p_qua_information4_o => per_qua_shd.g_old_rec.qua_information4,

Line 379: p_qua_information1_o => per_qua_shd.g_old_rec.qua_information1,

375: p_attribute18_o => per_qua_shd.g_old_rec.attribute18,
376: p_attribute19_o => per_qua_shd.g_old_rec.attribute19,
377: p_attribute20_o => per_qua_shd.g_old_rec.attribute20,
378: p_qua_information_category_o => per_qua_shd.g_old_rec.qua_information_category,
379: p_qua_information1_o => per_qua_shd.g_old_rec.qua_information1,
380: p_qua_information2_o => per_qua_shd.g_old_rec.qua_information2,
381: p_qua_information3_o => per_qua_shd.g_old_rec.qua_information3,
382: p_qua_information4_o => per_qua_shd.g_old_rec.qua_information4,
383: p_qua_information5_o => per_qua_shd.g_old_rec.qua_information5,

Line 380: p_qua_information2_o => per_qua_shd.g_old_rec.qua_information2,

376: p_attribute19_o => per_qua_shd.g_old_rec.attribute19,
377: p_attribute20_o => per_qua_shd.g_old_rec.attribute20,
378: p_qua_information_category_o => per_qua_shd.g_old_rec.qua_information_category,
379: p_qua_information1_o => per_qua_shd.g_old_rec.qua_information1,
380: p_qua_information2_o => per_qua_shd.g_old_rec.qua_information2,
381: p_qua_information3_o => per_qua_shd.g_old_rec.qua_information3,
382: p_qua_information4_o => per_qua_shd.g_old_rec.qua_information4,
383: p_qua_information5_o => per_qua_shd.g_old_rec.qua_information5,
384: p_qua_information6_o => per_qua_shd.g_old_rec.qua_information6,

Line 381: p_qua_information3_o => per_qua_shd.g_old_rec.qua_information3,

377: p_attribute20_o => per_qua_shd.g_old_rec.attribute20,
378: p_qua_information_category_o => per_qua_shd.g_old_rec.qua_information_category,
379: p_qua_information1_o => per_qua_shd.g_old_rec.qua_information1,
380: p_qua_information2_o => per_qua_shd.g_old_rec.qua_information2,
381: p_qua_information3_o => per_qua_shd.g_old_rec.qua_information3,
382: p_qua_information4_o => per_qua_shd.g_old_rec.qua_information4,
383: p_qua_information5_o => per_qua_shd.g_old_rec.qua_information5,
384: p_qua_information6_o => per_qua_shd.g_old_rec.qua_information6,
385: p_qua_information7_o => per_qua_shd.g_old_rec.qua_information7,

Line 382: p_qua_information4_o => per_qua_shd.g_old_rec.qua_information4,

378: p_qua_information_category_o => per_qua_shd.g_old_rec.qua_information_category,
379: p_qua_information1_o => per_qua_shd.g_old_rec.qua_information1,
380: p_qua_information2_o => per_qua_shd.g_old_rec.qua_information2,
381: p_qua_information3_o => per_qua_shd.g_old_rec.qua_information3,
382: p_qua_information4_o => per_qua_shd.g_old_rec.qua_information4,
383: p_qua_information5_o => per_qua_shd.g_old_rec.qua_information5,
384: p_qua_information6_o => per_qua_shd.g_old_rec.qua_information6,
385: p_qua_information7_o => per_qua_shd.g_old_rec.qua_information7,
386: p_qua_information8_o => per_qua_shd.g_old_rec.qua_information8,

Line 383: p_qua_information5_o => per_qua_shd.g_old_rec.qua_information5,

379: p_qua_information1_o => per_qua_shd.g_old_rec.qua_information1,
380: p_qua_information2_o => per_qua_shd.g_old_rec.qua_information2,
381: p_qua_information3_o => per_qua_shd.g_old_rec.qua_information3,
382: p_qua_information4_o => per_qua_shd.g_old_rec.qua_information4,
383: p_qua_information5_o => per_qua_shd.g_old_rec.qua_information5,
384: p_qua_information6_o => per_qua_shd.g_old_rec.qua_information6,
385: p_qua_information7_o => per_qua_shd.g_old_rec.qua_information7,
386: p_qua_information8_o => per_qua_shd.g_old_rec.qua_information8,
387: p_qua_information9_o => per_qua_shd.g_old_rec.qua_information9,

Line 384: p_qua_information6_o => per_qua_shd.g_old_rec.qua_information6,

380: p_qua_information2_o => per_qua_shd.g_old_rec.qua_information2,
381: p_qua_information3_o => per_qua_shd.g_old_rec.qua_information3,
382: p_qua_information4_o => per_qua_shd.g_old_rec.qua_information4,
383: p_qua_information5_o => per_qua_shd.g_old_rec.qua_information5,
384: p_qua_information6_o => per_qua_shd.g_old_rec.qua_information6,
385: p_qua_information7_o => per_qua_shd.g_old_rec.qua_information7,
386: p_qua_information8_o => per_qua_shd.g_old_rec.qua_information8,
387: p_qua_information9_o => per_qua_shd.g_old_rec.qua_information9,
388: p_qua_information10_o => per_qua_shd.g_old_rec.qua_information10,

Line 385: p_qua_information7_o => per_qua_shd.g_old_rec.qua_information7,

381: p_qua_information3_o => per_qua_shd.g_old_rec.qua_information3,
382: p_qua_information4_o => per_qua_shd.g_old_rec.qua_information4,
383: p_qua_information5_o => per_qua_shd.g_old_rec.qua_information5,
384: p_qua_information6_o => per_qua_shd.g_old_rec.qua_information6,
385: p_qua_information7_o => per_qua_shd.g_old_rec.qua_information7,
386: p_qua_information8_o => per_qua_shd.g_old_rec.qua_information8,
387: p_qua_information9_o => per_qua_shd.g_old_rec.qua_information9,
388: p_qua_information10_o => per_qua_shd.g_old_rec.qua_information10,
389: p_qua_information11_o => per_qua_shd.g_old_rec.qua_information11,

Line 386: p_qua_information8_o => per_qua_shd.g_old_rec.qua_information8,

382: p_qua_information4_o => per_qua_shd.g_old_rec.qua_information4,
383: p_qua_information5_o => per_qua_shd.g_old_rec.qua_information5,
384: p_qua_information6_o => per_qua_shd.g_old_rec.qua_information6,
385: p_qua_information7_o => per_qua_shd.g_old_rec.qua_information7,
386: p_qua_information8_o => per_qua_shd.g_old_rec.qua_information8,
387: p_qua_information9_o => per_qua_shd.g_old_rec.qua_information9,
388: p_qua_information10_o => per_qua_shd.g_old_rec.qua_information10,
389: p_qua_information11_o => per_qua_shd.g_old_rec.qua_information11,
390: p_qua_information12_o => per_qua_shd.g_old_rec.qua_information12,

Line 387: p_qua_information9_o => per_qua_shd.g_old_rec.qua_information9,

383: p_qua_information5_o => per_qua_shd.g_old_rec.qua_information5,
384: p_qua_information6_o => per_qua_shd.g_old_rec.qua_information6,
385: p_qua_information7_o => per_qua_shd.g_old_rec.qua_information7,
386: p_qua_information8_o => per_qua_shd.g_old_rec.qua_information8,
387: p_qua_information9_o => per_qua_shd.g_old_rec.qua_information9,
388: p_qua_information10_o => per_qua_shd.g_old_rec.qua_information10,
389: p_qua_information11_o => per_qua_shd.g_old_rec.qua_information11,
390: p_qua_information12_o => per_qua_shd.g_old_rec.qua_information12,
391: p_qua_information13_o => per_qua_shd.g_old_rec.qua_information13,

Line 388: p_qua_information10_o => per_qua_shd.g_old_rec.qua_information10,

384: p_qua_information6_o => per_qua_shd.g_old_rec.qua_information6,
385: p_qua_information7_o => per_qua_shd.g_old_rec.qua_information7,
386: p_qua_information8_o => per_qua_shd.g_old_rec.qua_information8,
387: p_qua_information9_o => per_qua_shd.g_old_rec.qua_information9,
388: p_qua_information10_o => per_qua_shd.g_old_rec.qua_information10,
389: p_qua_information11_o => per_qua_shd.g_old_rec.qua_information11,
390: p_qua_information12_o => per_qua_shd.g_old_rec.qua_information12,
391: p_qua_information13_o => per_qua_shd.g_old_rec.qua_information13,
392: p_qua_information14_o => per_qua_shd.g_old_rec.qua_information14,

Line 389: p_qua_information11_o => per_qua_shd.g_old_rec.qua_information11,

385: p_qua_information7_o => per_qua_shd.g_old_rec.qua_information7,
386: p_qua_information8_o => per_qua_shd.g_old_rec.qua_information8,
387: p_qua_information9_o => per_qua_shd.g_old_rec.qua_information9,
388: p_qua_information10_o => per_qua_shd.g_old_rec.qua_information10,
389: p_qua_information11_o => per_qua_shd.g_old_rec.qua_information11,
390: p_qua_information12_o => per_qua_shd.g_old_rec.qua_information12,
391: p_qua_information13_o => per_qua_shd.g_old_rec.qua_information13,
392: p_qua_information14_o => per_qua_shd.g_old_rec.qua_information14,
393: p_qua_information15_o => per_qua_shd.g_old_rec.qua_information15,

Line 390: p_qua_information12_o => per_qua_shd.g_old_rec.qua_information12,

386: p_qua_information8_o => per_qua_shd.g_old_rec.qua_information8,
387: p_qua_information9_o => per_qua_shd.g_old_rec.qua_information9,
388: p_qua_information10_o => per_qua_shd.g_old_rec.qua_information10,
389: p_qua_information11_o => per_qua_shd.g_old_rec.qua_information11,
390: p_qua_information12_o => per_qua_shd.g_old_rec.qua_information12,
391: p_qua_information13_o => per_qua_shd.g_old_rec.qua_information13,
392: p_qua_information14_o => per_qua_shd.g_old_rec.qua_information14,
393: p_qua_information15_o => per_qua_shd.g_old_rec.qua_information15,
394: p_qua_information16_o => per_qua_shd.g_old_rec.qua_information16,

Line 391: p_qua_information13_o => per_qua_shd.g_old_rec.qua_information13,

387: p_qua_information9_o => per_qua_shd.g_old_rec.qua_information9,
388: p_qua_information10_o => per_qua_shd.g_old_rec.qua_information10,
389: p_qua_information11_o => per_qua_shd.g_old_rec.qua_information11,
390: p_qua_information12_o => per_qua_shd.g_old_rec.qua_information12,
391: p_qua_information13_o => per_qua_shd.g_old_rec.qua_information13,
392: p_qua_information14_o => per_qua_shd.g_old_rec.qua_information14,
393: p_qua_information15_o => per_qua_shd.g_old_rec.qua_information15,
394: p_qua_information16_o => per_qua_shd.g_old_rec.qua_information16,
395: p_qua_information17_o => per_qua_shd.g_old_rec.qua_information17,

Line 392: p_qua_information14_o => per_qua_shd.g_old_rec.qua_information14,

388: p_qua_information10_o => per_qua_shd.g_old_rec.qua_information10,
389: p_qua_information11_o => per_qua_shd.g_old_rec.qua_information11,
390: p_qua_information12_o => per_qua_shd.g_old_rec.qua_information12,
391: p_qua_information13_o => per_qua_shd.g_old_rec.qua_information13,
392: p_qua_information14_o => per_qua_shd.g_old_rec.qua_information14,
393: p_qua_information15_o => per_qua_shd.g_old_rec.qua_information15,
394: p_qua_information16_o => per_qua_shd.g_old_rec.qua_information16,
395: p_qua_information17_o => per_qua_shd.g_old_rec.qua_information17,
396: p_qua_information18_o => per_qua_shd.g_old_rec.qua_information18,

Line 393: p_qua_information15_o => per_qua_shd.g_old_rec.qua_information15,

389: p_qua_information11_o => per_qua_shd.g_old_rec.qua_information11,
390: p_qua_information12_o => per_qua_shd.g_old_rec.qua_information12,
391: p_qua_information13_o => per_qua_shd.g_old_rec.qua_information13,
392: p_qua_information14_o => per_qua_shd.g_old_rec.qua_information14,
393: p_qua_information15_o => per_qua_shd.g_old_rec.qua_information15,
394: p_qua_information16_o => per_qua_shd.g_old_rec.qua_information16,
395: p_qua_information17_o => per_qua_shd.g_old_rec.qua_information17,
396: p_qua_information18_o => per_qua_shd.g_old_rec.qua_information18,
397: p_qua_information19_o => per_qua_shd.g_old_rec.qua_information19,

Line 394: p_qua_information16_o => per_qua_shd.g_old_rec.qua_information16,

390: p_qua_information12_o => per_qua_shd.g_old_rec.qua_information12,
391: p_qua_information13_o => per_qua_shd.g_old_rec.qua_information13,
392: p_qua_information14_o => per_qua_shd.g_old_rec.qua_information14,
393: p_qua_information15_o => per_qua_shd.g_old_rec.qua_information15,
394: p_qua_information16_o => per_qua_shd.g_old_rec.qua_information16,
395: p_qua_information17_o => per_qua_shd.g_old_rec.qua_information17,
396: p_qua_information18_o => per_qua_shd.g_old_rec.qua_information18,
397: p_qua_information19_o => per_qua_shd.g_old_rec.qua_information19,
398: p_qua_information20_o => per_qua_shd.g_old_rec.qua_information20,

Line 395: p_qua_information17_o => per_qua_shd.g_old_rec.qua_information17,

391: p_qua_information13_o => per_qua_shd.g_old_rec.qua_information13,
392: p_qua_information14_o => per_qua_shd.g_old_rec.qua_information14,
393: p_qua_information15_o => per_qua_shd.g_old_rec.qua_information15,
394: p_qua_information16_o => per_qua_shd.g_old_rec.qua_information16,
395: p_qua_information17_o => per_qua_shd.g_old_rec.qua_information17,
396: p_qua_information18_o => per_qua_shd.g_old_rec.qua_information18,
397: p_qua_information19_o => per_qua_shd.g_old_rec.qua_information19,
398: p_qua_information20_o => per_qua_shd.g_old_rec.qua_information20,
399: p_professional_body_name_o => per_qua_shd.g_old_rec.professional_body_name,

Line 396: p_qua_information18_o => per_qua_shd.g_old_rec.qua_information18,

392: p_qua_information14_o => per_qua_shd.g_old_rec.qua_information14,
393: p_qua_information15_o => per_qua_shd.g_old_rec.qua_information15,
394: p_qua_information16_o => per_qua_shd.g_old_rec.qua_information16,
395: p_qua_information17_o => per_qua_shd.g_old_rec.qua_information17,
396: p_qua_information18_o => per_qua_shd.g_old_rec.qua_information18,
397: p_qua_information19_o => per_qua_shd.g_old_rec.qua_information19,
398: p_qua_information20_o => per_qua_shd.g_old_rec.qua_information20,
399: p_professional_body_name_o => per_qua_shd.g_old_rec.professional_body_name,
400: p_membership_number_o => per_qua_shd.g_old_rec.membership_number,

Line 397: p_qua_information19_o => per_qua_shd.g_old_rec.qua_information19,

393: p_qua_information15_o => per_qua_shd.g_old_rec.qua_information15,
394: p_qua_information16_o => per_qua_shd.g_old_rec.qua_information16,
395: p_qua_information17_o => per_qua_shd.g_old_rec.qua_information17,
396: p_qua_information18_o => per_qua_shd.g_old_rec.qua_information18,
397: p_qua_information19_o => per_qua_shd.g_old_rec.qua_information19,
398: p_qua_information20_o => per_qua_shd.g_old_rec.qua_information20,
399: p_professional_body_name_o => per_qua_shd.g_old_rec.professional_body_name,
400: p_membership_number_o => per_qua_shd.g_old_rec.membership_number,
401: p_membership_category_o => per_qua_shd.g_old_rec.membership_category,

Line 398: p_qua_information20_o => per_qua_shd.g_old_rec.qua_information20,

394: p_qua_information16_o => per_qua_shd.g_old_rec.qua_information16,
395: p_qua_information17_o => per_qua_shd.g_old_rec.qua_information17,
396: p_qua_information18_o => per_qua_shd.g_old_rec.qua_information18,
397: p_qua_information19_o => per_qua_shd.g_old_rec.qua_information19,
398: p_qua_information20_o => per_qua_shd.g_old_rec.qua_information20,
399: p_professional_body_name_o => per_qua_shd.g_old_rec.professional_body_name,
400: p_membership_number_o => per_qua_shd.g_old_rec.membership_number,
401: p_membership_category_o => per_qua_shd.g_old_rec.membership_category,
402: p_subscription_payment_meth_o => per_qua_shd.g_old_rec.subscription_payment_method,

Line 399: p_professional_body_name_o => per_qua_shd.g_old_rec.professional_body_name,

395: p_qua_information17_o => per_qua_shd.g_old_rec.qua_information17,
396: p_qua_information18_o => per_qua_shd.g_old_rec.qua_information18,
397: p_qua_information19_o => per_qua_shd.g_old_rec.qua_information19,
398: p_qua_information20_o => per_qua_shd.g_old_rec.qua_information20,
399: p_professional_body_name_o => per_qua_shd.g_old_rec.professional_body_name,
400: p_membership_number_o => per_qua_shd.g_old_rec.membership_number,
401: p_membership_category_o => per_qua_shd.g_old_rec.membership_category,
402: p_subscription_payment_meth_o => per_qua_shd.g_old_rec.subscription_payment_method,
403: p_party_id_o => per_qua_shd.g_old_rec.party_id

Line 400: p_membership_number_o => per_qua_shd.g_old_rec.membership_number,

396: p_qua_information18_o => per_qua_shd.g_old_rec.qua_information18,
397: p_qua_information19_o => per_qua_shd.g_old_rec.qua_information19,
398: p_qua_information20_o => per_qua_shd.g_old_rec.qua_information20,
399: p_professional_body_name_o => per_qua_shd.g_old_rec.professional_body_name,
400: p_membership_number_o => per_qua_shd.g_old_rec.membership_number,
401: p_membership_category_o => per_qua_shd.g_old_rec.membership_category,
402: p_subscription_payment_meth_o => per_qua_shd.g_old_rec.subscription_payment_method,
403: p_party_id_o => per_qua_shd.g_old_rec.party_id
404: );

Line 401: p_membership_category_o => per_qua_shd.g_old_rec.membership_category,

397: p_qua_information19_o => per_qua_shd.g_old_rec.qua_information19,
398: p_qua_information20_o => per_qua_shd.g_old_rec.qua_information20,
399: p_professional_body_name_o => per_qua_shd.g_old_rec.professional_body_name,
400: p_membership_number_o => per_qua_shd.g_old_rec.membership_number,
401: p_membership_category_o => per_qua_shd.g_old_rec.membership_category,
402: p_subscription_payment_meth_o => per_qua_shd.g_old_rec.subscription_payment_method,
403: p_party_id_o => per_qua_shd.g_old_rec.party_id
404: );
405: exception

Line 402: p_subscription_payment_meth_o => per_qua_shd.g_old_rec.subscription_payment_method,

398: p_qua_information20_o => per_qua_shd.g_old_rec.qua_information20,
399: p_professional_body_name_o => per_qua_shd.g_old_rec.professional_body_name,
400: p_membership_number_o => per_qua_shd.g_old_rec.membership_number,
401: p_membership_category_o => per_qua_shd.g_old_rec.membership_category,
402: p_subscription_payment_meth_o => per_qua_shd.g_old_rec.subscription_payment_method,
403: p_party_id_o => per_qua_shd.g_old_rec.party_id
404: );
405: exception
406: when hr_api.cannot_find_prog_unit then

Line 403: p_party_id_o => per_qua_shd.g_old_rec.party_id

399: p_professional_body_name_o => per_qua_shd.g_old_rec.professional_body_name,
400: p_membership_number_o => per_qua_shd.g_old_rec.membership_number,
401: p_membership_category_o => per_qua_shd.g_old_rec.membership_category,
402: p_subscription_payment_meth_o => per_qua_shd.g_old_rec.subscription_payment_method,
403: p_party_id_o => per_qua_shd.g_old_rec.party_id
404: );
405: exception
406: when hr_api.cannot_find_prog_unit then
407: hr_api.cannot_find_prog_unit_error

Line 462: Procedure convert_defs(p_rec in out nocopy per_qua_shd.g_rec_type) is

458: -- Internal Table Handler Use Only.
459: --
460: -- {End Of Comments}
461: -- ----------------------------------------------------------------------------
462: Procedure convert_defs(p_rec in out nocopy per_qua_shd.g_rec_type) is
463: --
464: l_proc varchar2(72) := g_package||'convert_defs';
465: --
466: Begin

Line 477: per_qua_shd.g_old_rec.business_group_id;

473: -- is being used then we must set to the 'current' argument value.
474: --
475: If (p_rec.business_group_id = hr_api.g_number) then
476: p_rec.business_group_id :=
477: per_qua_shd.g_old_rec.business_group_id;
478: End If;
479: If (p_rec.person_id = hr_api.g_number) then
480: p_rec.person_id :=
481: per_qua_shd.g_old_rec.person_id;

Line 481: per_qua_shd.g_old_rec.person_id;

477: per_qua_shd.g_old_rec.business_group_id;
478: End If;
479: If (p_rec.person_id = hr_api.g_number) then
480: p_rec.person_id :=
481: per_qua_shd.g_old_rec.person_id;
482: End If;
483: If (p_rec.title = hr_api.g_varchar2) then
484: p_rec.title :=
485: per_qua_shd.g_old_rec.title;

Line 485: per_qua_shd.g_old_rec.title;

481: per_qua_shd.g_old_rec.person_id;
482: End If;
483: If (p_rec.title = hr_api.g_varchar2) then
484: p_rec.title :=
485: per_qua_shd.g_old_rec.title;
486: End If;
487: If (p_rec.grade_attained = hr_api.g_varchar2) then
488: p_rec.grade_attained :=
489: per_qua_shd.g_old_rec.grade_attained;

Line 489: per_qua_shd.g_old_rec.grade_attained;

485: per_qua_shd.g_old_rec.title;
486: End If;
487: If (p_rec.grade_attained = hr_api.g_varchar2) then
488: p_rec.grade_attained :=
489: per_qua_shd.g_old_rec.grade_attained;
490: End If;
491: If (p_rec.status = hr_api.g_varchar2) then
492: p_rec.status :=
493: per_qua_shd.g_old_rec.status;

Line 493: per_qua_shd.g_old_rec.status;

489: per_qua_shd.g_old_rec.grade_attained;
490: End If;
491: If (p_rec.status = hr_api.g_varchar2) then
492: p_rec.status :=
493: per_qua_shd.g_old_rec.status;
494: End If;
495: If (p_rec.awarded_date = hr_api.g_date) then
496: p_rec.awarded_date :=
497: per_qua_shd.g_old_rec.awarded_date;

Line 497: per_qua_shd.g_old_rec.awarded_date;

493: per_qua_shd.g_old_rec.status;
494: End If;
495: If (p_rec.awarded_date = hr_api.g_date) then
496: p_rec.awarded_date :=
497: per_qua_shd.g_old_rec.awarded_date;
498: End If;
499: If (p_rec.fee = hr_api.g_number) then
500: p_rec.fee :=
501: per_qua_shd.g_old_rec.fee;

Line 501: per_qua_shd.g_old_rec.fee;

497: per_qua_shd.g_old_rec.awarded_date;
498: End If;
499: If (p_rec.fee = hr_api.g_number) then
500: p_rec.fee :=
501: per_qua_shd.g_old_rec.fee;
502: End If;
503: If (p_rec.fee_currency = hr_api.g_varchar2) then
504: p_rec.fee_currency :=
505: per_qua_shd.g_old_rec.fee_currency;

Line 505: per_qua_shd.g_old_rec.fee_currency;

501: per_qua_shd.g_old_rec.fee;
502: End If;
503: If (p_rec.fee_currency = hr_api.g_varchar2) then
504: p_rec.fee_currency :=
505: per_qua_shd.g_old_rec.fee_currency;
506: End If;
507: If (p_rec.training_completed_amount = hr_api.g_number) then
508: p_rec.training_completed_amount :=
509: per_qua_shd.g_old_rec.training_completed_amount;

Line 509: per_qua_shd.g_old_rec.training_completed_amount;

505: per_qua_shd.g_old_rec.fee_currency;
506: End If;
507: If (p_rec.training_completed_amount = hr_api.g_number) then
508: p_rec.training_completed_amount :=
509: per_qua_shd.g_old_rec.training_completed_amount;
510: End If;
511: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then
512: p_rec.reimbursement_arrangements :=
513: per_qua_shd.g_old_rec.reimbursement_arrangements;

Line 513: per_qua_shd.g_old_rec.reimbursement_arrangements;

509: per_qua_shd.g_old_rec.training_completed_amount;
510: End If;
511: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then
512: p_rec.reimbursement_arrangements :=
513: per_qua_shd.g_old_rec.reimbursement_arrangements;
514: End If;
515: If (p_rec.training_completed_units = hr_api.g_varchar2) then
516: p_rec.training_completed_units :=
517: per_qua_shd.g_old_rec.training_completed_units;

Line 517: per_qua_shd.g_old_rec.training_completed_units;

513: per_qua_shd.g_old_rec.reimbursement_arrangements;
514: End If;
515: If (p_rec.training_completed_units = hr_api.g_varchar2) then
516: p_rec.training_completed_units :=
517: per_qua_shd.g_old_rec.training_completed_units;
518: End If;
519: If (p_rec.total_training_amount = hr_api.g_number) then
520: p_rec.total_training_amount :=
521: per_qua_shd.g_old_rec.total_training_amount;

Line 521: per_qua_shd.g_old_rec.total_training_amount;

517: per_qua_shd.g_old_rec.training_completed_units;
518: End If;
519: If (p_rec.total_training_amount = hr_api.g_number) then
520: p_rec.total_training_amount :=
521: per_qua_shd.g_old_rec.total_training_amount;
522: End If;
523: If (p_rec.start_date = hr_api.g_date) then
524: p_rec.start_date :=
525: per_qua_shd.g_old_rec.start_date;

Line 525: per_qua_shd.g_old_rec.start_date;

521: per_qua_shd.g_old_rec.total_training_amount;
522: End If;
523: If (p_rec.start_date = hr_api.g_date) then
524: p_rec.start_date :=
525: per_qua_shd.g_old_rec.start_date;
526: End If;
527: If (p_rec.end_date = hr_api.g_date) then
528: p_rec.end_date :=
529: per_qua_shd.g_old_rec.end_date;

Line 529: per_qua_shd.g_old_rec.end_date;

525: per_qua_shd.g_old_rec.start_date;
526: End If;
527: If (p_rec.end_date = hr_api.g_date) then
528: p_rec.end_date :=
529: per_qua_shd.g_old_rec.end_date;
530: End If;
531: If (p_rec.license_number = hr_api.g_varchar2) then
532: p_rec.license_number :=
533: per_qua_shd.g_old_rec.license_number;

Line 533: per_qua_shd.g_old_rec.license_number;

529: per_qua_shd.g_old_rec.end_date;
530: End If;
531: If (p_rec.license_number = hr_api.g_varchar2) then
532: p_rec.license_number :=
533: per_qua_shd.g_old_rec.license_number;
534: End If;
535: If (p_rec.expiry_date = hr_api.g_date) then
536: p_rec.expiry_date :=
537: per_qua_shd.g_old_rec.expiry_date;

Line 537: per_qua_shd.g_old_rec.expiry_date;

533: per_qua_shd.g_old_rec.license_number;
534: End If;
535: If (p_rec.expiry_date = hr_api.g_date) then
536: p_rec.expiry_date :=
537: per_qua_shd.g_old_rec.expiry_date;
538: End If;
539: If (p_rec.license_restrictions = hr_api.g_varchar2) then
540: p_rec.license_restrictions :=
541: per_qua_shd.g_old_rec.license_restrictions;

Line 541: per_qua_shd.g_old_rec.license_restrictions;

537: per_qua_shd.g_old_rec.expiry_date;
538: End If;
539: If (p_rec.license_restrictions = hr_api.g_varchar2) then
540: p_rec.license_restrictions :=
541: per_qua_shd.g_old_rec.license_restrictions;
542: End If;
543: If (p_rec.projected_completion_date = hr_api.g_date) then
544: p_rec.projected_completion_date :=
545: per_qua_shd.g_old_rec.projected_completion_date;

Line 545: per_qua_shd.g_old_rec.projected_completion_date;

541: per_qua_shd.g_old_rec.license_restrictions;
542: End If;
543: If (p_rec.projected_completion_date = hr_api.g_date) then
544: p_rec.projected_completion_date :=
545: per_qua_shd.g_old_rec.projected_completion_date;
546: End If;
547: If (p_rec.awarding_body = hr_api.g_varchar2) then
548: p_rec.awarding_body :=
549: per_qua_shd.g_old_rec.awarding_body;

Line 549: per_qua_shd.g_old_rec.awarding_body;

545: per_qua_shd.g_old_rec.projected_completion_date;
546: End If;
547: If (p_rec.awarding_body = hr_api.g_varchar2) then
548: p_rec.awarding_body :=
549: per_qua_shd.g_old_rec.awarding_body;
550: End If;
551: If (p_rec.tuition_method = hr_api.g_varchar2) then
552: p_rec.tuition_method :=
553: per_qua_shd.g_old_rec.tuition_method;

Line 553: per_qua_shd.g_old_rec.tuition_method;

549: per_qua_shd.g_old_rec.awarding_body;
550: End If;
551: If (p_rec.tuition_method = hr_api.g_varchar2) then
552: p_rec.tuition_method :=
553: per_qua_shd.g_old_rec.tuition_method;
554: End If;
555: If (p_rec.group_ranking = hr_api.g_varchar2) then
556: p_rec.group_ranking :=
557: per_qua_shd.g_old_rec.group_ranking;

Line 557: per_qua_shd.g_old_rec.group_ranking;

553: per_qua_shd.g_old_rec.tuition_method;
554: End If;
555: If (p_rec.group_ranking = hr_api.g_varchar2) then
556: p_rec.group_ranking :=
557: per_qua_shd.g_old_rec.group_ranking;
558: End If;
559: If (p_rec.comments = hr_api.g_varchar2) then
560: p_rec.comments :=
561: per_qua_shd.g_old_rec.comments;

Line 561: per_qua_shd.g_old_rec.comments;

557: per_qua_shd.g_old_rec.group_ranking;
558: End If;
559: If (p_rec.comments = hr_api.g_varchar2) then
560: p_rec.comments :=
561: per_qua_shd.g_old_rec.comments;
562: End If;
563: If (p_rec.qualification_type_id = hr_api.g_number) then
564: p_rec.qualification_type_id :=
565: per_qua_shd.g_old_rec.qualification_type_id;

Line 565: per_qua_shd.g_old_rec.qualification_type_id;

561: per_qua_shd.g_old_rec.comments;
562: End If;
563: If (p_rec.qualification_type_id = hr_api.g_number) then
564: p_rec.qualification_type_id :=
565: per_qua_shd.g_old_rec.qualification_type_id;
566: End If;
567: If (p_rec.attendance_id = hr_api.g_number) then
568: p_rec.attendance_id :=
569: per_qua_shd.g_old_rec.attendance_id;

Line 569: per_qua_shd.g_old_rec.attendance_id;

565: per_qua_shd.g_old_rec.qualification_type_id;
566: End If;
567: If (p_rec.attendance_id = hr_api.g_number) then
568: p_rec.attendance_id :=
569: per_qua_shd.g_old_rec.attendance_id;
570: End If;
571: If (p_rec.attribute_category = hr_api.g_varchar2) then
572: p_rec.attribute_category :=
573: per_qua_shd.g_old_rec.attribute_category;

Line 573: per_qua_shd.g_old_rec.attribute_category;

569: per_qua_shd.g_old_rec.attendance_id;
570: End If;
571: If (p_rec.attribute_category = hr_api.g_varchar2) then
572: p_rec.attribute_category :=
573: per_qua_shd.g_old_rec.attribute_category;
574: End If;
575: If (p_rec.attribute1 = hr_api.g_varchar2) then
576: p_rec.attribute1 :=
577: per_qua_shd.g_old_rec.attribute1;

Line 577: per_qua_shd.g_old_rec.attribute1;

573: per_qua_shd.g_old_rec.attribute_category;
574: End If;
575: If (p_rec.attribute1 = hr_api.g_varchar2) then
576: p_rec.attribute1 :=
577: per_qua_shd.g_old_rec.attribute1;
578: End If;
579: If (p_rec.attribute2 = hr_api.g_varchar2) then
580: p_rec.attribute2 :=
581: per_qua_shd.g_old_rec.attribute2;

Line 581: per_qua_shd.g_old_rec.attribute2;

577: per_qua_shd.g_old_rec.attribute1;
578: End If;
579: If (p_rec.attribute2 = hr_api.g_varchar2) then
580: p_rec.attribute2 :=
581: per_qua_shd.g_old_rec.attribute2;
582: End If;
583: If (p_rec.attribute3 = hr_api.g_varchar2) then
584: p_rec.attribute3 :=
585: per_qua_shd.g_old_rec.attribute3;

Line 585: per_qua_shd.g_old_rec.attribute3;

581: per_qua_shd.g_old_rec.attribute2;
582: End If;
583: If (p_rec.attribute3 = hr_api.g_varchar2) then
584: p_rec.attribute3 :=
585: per_qua_shd.g_old_rec.attribute3;
586: End If;
587: If (p_rec.attribute4 = hr_api.g_varchar2) then
588: p_rec.attribute4 :=
589: per_qua_shd.g_old_rec.attribute4;

Line 589: per_qua_shd.g_old_rec.attribute4;

585: per_qua_shd.g_old_rec.attribute3;
586: End If;
587: If (p_rec.attribute4 = hr_api.g_varchar2) then
588: p_rec.attribute4 :=
589: per_qua_shd.g_old_rec.attribute4;
590: End If;
591: If (p_rec.attribute5 = hr_api.g_varchar2) then
592: p_rec.attribute5 :=
593: per_qua_shd.g_old_rec.attribute5;

Line 593: per_qua_shd.g_old_rec.attribute5;

589: per_qua_shd.g_old_rec.attribute4;
590: End If;
591: If (p_rec.attribute5 = hr_api.g_varchar2) then
592: p_rec.attribute5 :=
593: per_qua_shd.g_old_rec.attribute5;
594: End If;
595: If (p_rec.attribute6 = hr_api.g_varchar2) then
596: p_rec.attribute6 :=
597: per_qua_shd.g_old_rec.attribute6;

Line 597: per_qua_shd.g_old_rec.attribute6;

593: per_qua_shd.g_old_rec.attribute5;
594: End If;
595: If (p_rec.attribute6 = hr_api.g_varchar2) then
596: p_rec.attribute6 :=
597: per_qua_shd.g_old_rec.attribute6;
598: End If;
599: If (p_rec.attribute7 = hr_api.g_varchar2) then
600: p_rec.attribute7 :=
601: per_qua_shd.g_old_rec.attribute7;

Line 601: per_qua_shd.g_old_rec.attribute7;

597: per_qua_shd.g_old_rec.attribute6;
598: End If;
599: If (p_rec.attribute7 = hr_api.g_varchar2) then
600: p_rec.attribute7 :=
601: per_qua_shd.g_old_rec.attribute7;
602: End If;
603: If (p_rec.attribute8 = hr_api.g_varchar2) then
604: p_rec.attribute8 :=
605: per_qua_shd.g_old_rec.attribute8;

Line 605: per_qua_shd.g_old_rec.attribute8;

601: per_qua_shd.g_old_rec.attribute7;
602: End If;
603: If (p_rec.attribute8 = hr_api.g_varchar2) then
604: p_rec.attribute8 :=
605: per_qua_shd.g_old_rec.attribute8;
606: End If;
607: If (p_rec.attribute9 = hr_api.g_varchar2) then
608: p_rec.attribute9 :=
609: per_qua_shd.g_old_rec.attribute9;

Line 609: per_qua_shd.g_old_rec.attribute9;

605: per_qua_shd.g_old_rec.attribute8;
606: End If;
607: If (p_rec.attribute9 = hr_api.g_varchar2) then
608: p_rec.attribute9 :=
609: per_qua_shd.g_old_rec.attribute9;
610: End If;
611: If (p_rec.attribute10 = hr_api.g_varchar2) then
612: p_rec.attribute10 :=
613: per_qua_shd.g_old_rec.attribute10;

Line 613: per_qua_shd.g_old_rec.attribute10;

609: per_qua_shd.g_old_rec.attribute9;
610: End If;
611: If (p_rec.attribute10 = hr_api.g_varchar2) then
612: p_rec.attribute10 :=
613: per_qua_shd.g_old_rec.attribute10;
614: End If;
615: If (p_rec.attribute11 = hr_api.g_varchar2) then
616: p_rec.attribute11 :=
617: per_qua_shd.g_old_rec.attribute11;

Line 617: per_qua_shd.g_old_rec.attribute11;

613: per_qua_shd.g_old_rec.attribute10;
614: End If;
615: If (p_rec.attribute11 = hr_api.g_varchar2) then
616: p_rec.attribute11 :=
617: per_qua_shd.g_old_rec.attribute11;
618: End If;
619: If (p_rec.attribute12 = hr_api.g_varchar2) then
620: p_rec.attribute12 :=
621: per_qua_shd.g_old_rec.attribute12;

Line 621: per_qua_shd.g_old_rec.attribute12;

617: per_qua_shd.g_old_rec.attribute11;
618: End If;
619: If (p_rec.attribute12 = hr_api.g_varchar2) then
620: p_rec.attribute12 :=
621: per_qua_shd.g_old_rec.attribute12;
622: End If;
623: If (p_rec.attribute13 = hr_api.g_varchar2) then
624: p_rec.attribute13 :=
625: per_qua_shd.g_old_rec.attribute13;

Line 625: per_qua_shd.g_old_rec.attribute13;

621: per_qua_shd.g_old_rec.attribute12;
622: End If;
623: If (p_rec.attribute13 = hr_api.g_varchar2) then
624: p_rec.attribute13 :=
625: per_qua_shd.g_old_rec.attribute13;
626: End If;
627: If (p_rec.attribute14 = hr_api.g_varchar2) then
628: p_rec.attribute14 :=
629: per_qua_shd.g_old_rec.attribute14;

Line 629: per_qua_shd.g_old_rec.attribute14;

625: per_qua_shd.g_old_rec.attribute13;
626: End If;
627: If (p_rec.attribute14 = hr_api.g_varchar2) then
628: p_rec.attribute14 :=
629: per_qua_shd.g_old_rec.attribute14;
630: End If;
631: If (p_rec.attribute15 = hr_api.g_varchar2) then
632: p_rec.attribute15 :=
633: per_qua_shd.g_old_rec.attribute15;

Line 633: per_qua_shd.g_old_rec.attribute15;

629: per_qua_shd.g_old_rec.attribute14;
630: End If;
631: If (p_rec.attribute15 = hr_api.g_varchar2) then
632: p_rec.attribute15 :=
633: per_qua_shd.g_old_rec.attribute15;
634: End If;
635: If (p_rec.attribute16 = hr_api.g_varchar2) then
636: p_rec.attribute16 :=
637: per_qua_shd.g_old_rec.attribute16;

Line 637: per_qua_shd.g_old_rec.attribute16;

633: per_qua_shd.g_old_rec.attribute15;
634: End If;
635: If (p_rec.attribute16 = hr_api.g_varchar2) then
636: p_rec.attribute16 :=
637: per_qua_shd.g_old_rec.attribute16;
638: End If;
639: If (p_rec.attribute17 = hr_api.g_varchar2) then
640: p_rec.attribute17 :=
641: per_qua_shd.g_old_rec.attribute17;

Line 641: per_qua_shd.g_old_rec.attribute17;

637: per_qua_shd.g_old_rec.attribute16;
638: End If;
639: If (p_rec.attribute17 = hr_api.g_varchar2) then
640: p_rec.attribute17 :=
641: per_qua_shd.g_old_rec.attribute17;
642: End If;
643: If (p_rec.attribute18 = hr_api.g_varchar2) then
644: p_rec.attribute18 :=
645: per_qua_shd.g_old_rec.attribute18;

Line 645: per_qua_shd.g_old_rec.attribute18;

641: per_qua_shd.g_old_rec.attribute17;
642: End If;
643: If (p_rec.attribute18 = hr_api.g_varchar2) then
644: p_rec.attribute18 :=
645: per_qua_shd.g_old_rec.attribute18;
646: End If;
647: If (p_rec.attribute19 = hr_api.g_varchar2) then
648: p_rec.attribute19 :=
649: per_qua_shd.g_old_rec.attribute19;

Line 649: per_qua_shd.g_old_rec.attribute19;

645: per_qua_shd.g_old_rec.attribute18;
646: End If;
647: If (p_rec.attribute19 = hr_api.g_varchar2) then
648: p_rec.attribute19 :=
649: per_qua_shd.g_old_rec.attribute19;
650: End If;
651: If (p_rec.attribute20 = hr_api.g_varchar2) then
652: p_rec.attribute20 :=
653: per_qua_shd.g_old_rec.attribute20;

Line 653: per_qua_shd.g_old_rec.attribute20;

649: per_qua_shd.g_old_rec.attribute19;
650: End If;
651: If (p_rec.attribute20 = hr_api.g_varchar2) then
652: p_rec.attribute20 :=
653: per_qua_shd.g_old_rec.attribute20;
654: End If;
655: If (p_rec.qua_information_category = hr_api.g_varchar2) then
656: p_rec.qua_information_category :=
657: per_qua_shd.g_old_rec.qua_information_category;

Line 657: per_qua_shd.g_old_rec.qua_information_category;

653: per_qua_shd.g_old_rec.attribute20;
654: End If;
655: If (p_rec.qua_information_category = hr_api.g_varchar2) then
656: p_rec.qua_information_category :=
657: per_qua_shd.g_old_rec.qua_information_category;
658: End If;
659: If (p_rec.qua_information1 = hr_api.g_varchar2) then
660: p_rec.qua_information1 :=
661: per_qua_shd.g_old_rec.qua_information1;

Line 661: per_qua_shd.g_old_rec.qua_information1;

657: per_qua_shd.g_old_rec.qua_information_category;
658: End If;
659: If (p_rec.qua_information1 = hr_api.g_varchar2) then
660: p_rec.qua_information1 :=
661: per_qua_shd.g_old_rec.qua_information1;
662: End If;
663: If (p_rec.qua_information2 = hr_api.g_varchar2) then
664: p_rec.qua_information2 :=
665: per_qua_shd.g_old_rec.qua_information2;

Line 665: per_qua_shd.g_old_rec.qua_information2;

661: per_qua_shd.g_old_rec.qua_information1;
662: End If;
663: If (p_rec.qua_information2 = hr_api.g_varchar2) then
664: p_rec.qua_information2 :=
665: per_qua_shd.g_old_rec.qua_information2;
666: End If;
667: If (p_rec.qua_information3 = hr_api.g_varchar2) then
668: p_rec.qua_information3 :=
669: per_qua_shd.g_old_rec.qua_information3;

Line 669: per_qua_shd.g_old_rec.qua_information3;

665: per_qua_shd.g_old_rec.qua_information2;
666: End If;
667: If (p_rec.qua_information3 = hr_api.g_varchar2) then
668: p_rec.qua_information3 :=
669: per_qua_shd.g_old_rec.qua_information3;
670: End If;
671: If (p_rec.qua_information4 = hr_api.g_varchar2) then
672: p_rec.qua_information4 :=
673: per_qua_shd.g_old_rec.qua_information4;

Line 673: per_qua_shd.g_old_rec.qua_information4;

669: per_qua_shd.g_old_rec.qua_information3;
670: End If;
671: If (p_rec.qua_information4 = hr_api.g_varchar2) then
672: p_rec.qua_information4 :=
673: per_qua_shd.g_old_rec.qua_information4;
674: End If;
675: If (p_rec.qua_information5 = hr_api.g_varchar2) then
676: p_rec.qua_information5 :=
677: per_qua_shd.g_old_rec.qua_information5;

Line 677: per_qua_shd.g_old_rec.qua_information5;

673: per_qua_shd.g_old_rec.qua_information4;
674: End If;
675: If (p_rec.qua_information5 = hr_api.g_varchar2) then
676: p_rec.qua_information5 :=
677: per_qua_shd.g_old_rec.qua_information5;
678: End If;
679: If (p_rec.qua_information6 = hr_api.g_varchar2) then
680: p_rec.qua_information6 :=
681: per_qua_shd.g_old_rec.qua_information6;

Line 681: per_qua_shd.g_old_rec.qua_information6;

677: per_qua_shd.g_old_rec.qua_information5;
678: End If;
679: If (p_rec.qua_information6 = hr_api.g_varchar2) then
680: p_rec.qua_information6 :=
681: per_qua_shd.g_old_rec.qua_information6;
682: End If;
683: If (p_rec.qua_information7 = hr_api.g_varchar2) then
684: p_rec.qua_information7 :=
685: per_qua_shd.g_old_rec.qua_information7;

Line 685: per_qua_shd.g_old_rec.qua_information7;

681: per_qua_shd.g_old_rec.qua_information6;
682: End If;
683: If (p_rec.qua_information7 = hr_api.g_varchar2) then
684: p_rec.qua_information7 :=
685: per_qua_shd.g_old_rec.qua_information7;
686: End If;
687: If (p_rec.qua_information8 = hr_api.g_varchar2) then
688: p_rec.qua_information8 :=
689: per_qua_shd.g_old_rec.qua_information8;

Line 689: per_qua_shd.g_old_rec.qua_information8;

685: per_qua_shd.g_old_rec.qua_information7;
686: End If;
687: If (p_rec.qua_information8 = hr_api.g_varchar2) then
688: p_rec.qua_information8 :=
689: per_qua_shd.g_old_rec.qua_information8;
690: End If;
691: If (p_rec.qua_information9 = hr_api.g_varchar2) then
692: p_rec.qua_information9 :=
693: per_qua_shd.g_old_rec.qua_information9;

Line 693: per_qua_shd.g_old_rec.qua_information9;

689: per_qua_shd.g_old_rec.qua_information8;
690: End If;
691: If (p_rec.qua_information9 = hr_api.g_varchar2) then
692: p_rec.qua_information9 :=
693: per_qua_shd.g_old_rec.qua_information9;
694: End If;
695: If (p_rec.qua_information10 = hr_api.g_varchar2) then
696: p_rec.qua_information10 :=
697: per_qua_shd.g_old_rec.qua_information10;

Line 697: per_qua_shd.g_old_rec.qua_information10;

693: per_qua_shd.g_old_rec.qua_information9;
694: End If;
695: If (p_rec.qua_information10 = hr_api.g_varchar2) then
696: p_rec.qua_information10 :=
697: per_qua_shd.g_old_rec.qua_information10;
698: End If;
699: If (p_rec.qua_information11 = hr_api.g_varchar2) then
700: p_rec.qua_information11 :=
701: per_qua_shd.g_old_rec.qua_information11;

Line 701: per_qua_shd.g_old_rec.qua_information11;

697: per_qua_shd.g_old_rec.qua_information10;
698: End If;
699: If (p_rec.qua_information11 = hr_api.g_varchar2) then
700: p_rec.qua_information11 :=
701: per_qua_shd.g_old_rec.qua_information11;
702: End If;
703: If (p_rec.qua_information12 = hr_api.g_varchar2) then
704: p_rec.qua_information12 :=
705: per_qua_shd.g_old_rec.qua_information12;

Line 705: per_qua_shd.g_old_rec.qua_information12;

701: per_qua_shd.g_old_rec.qua_information11;
702: End If;
703: If (p_rec.qua_information12 = hr_api.g_varchar2) then
704: p_rec.qua_information12 :=
705: per_qua_shd.g_old_rec.qua_information12;
706: End If;
707: If (p_rec.qua_information13 = hr_api.g_varchar2) then
708: p_rec.qua_information13 :=
709: per_qua_shd.g_old_rec.qua_information13;

Line 709: per_qua_shd.g_old_rec.qua_information13;

705: per_qua_shd.g_old_rec.qua_information12;
706: End If;
707: If (p_rec.qua_information13 = hr_api.g_varchar2) then
708: p_rec.qua_information13 :=
709: per_qua_shd.g_old_rec.qua_information13;
710: End If;
711: If (p_rec.qua_information14 = hr_api.g_varchar2) then
712: p_rec.qua_information14 :=
713: per_qua_shd.g_old_rec.qua_information14;

Line 713: per_qua_shd.g_old_rec.qua_information14;

709: per_qua_shd.g_old_rec.qua_information13;
710: End If;
711: If (p_rec.qua_information14 = hr_api.g_varchar2) then
712: p_rec.qua_information14 :=
713: per_qua_shd.g_old_rec.qua_information14;
714: End If;
715: If (p_rec.qua_information15 = hr_api.g_varchar2) then
716: p_rec.qua_information15 :=
717: per_qua_shd.g_old_rec.qua_information15;

Line 717: per_qua_shd.g_old_rec.qua_information15;

713: per_qua_shd.g_old_rec.qua_information14;
714: End If;
715: If (p_rec.qua_information15 = hr_api.g_varchar2) then
716: p_rec.qua_information15 :=
717: per_qua_shd.g_old_rec.qua_information15;
718: End If;
719: If (p_rec.qua_information16 = hr_api.g_varchar2) then
720: p_rec.qua_information16 :=
721: per_qua_shd.g_old_rec.qua_information16;

Line 721: per_qua_shd.g_old_rec.qua_information16;

717: per_qua_shd.g_old_rec.qua_information15;
718: End If;
719: If (p_rec.qua_information16 = hr_api.g_varchar2) then
720: p_rec.qua_information16 :=
721: per_qua_shd.g_old_rec.qua_information16;
722: End If;
723: If (p_rec.qua_information17 = hr_api.g_varchar2) then
724: p_rec.qua_information17 :=
725: per_qua_shd.g_old_rec.qua_information17;

Line 725: per_qua_shd.g_old_rec.qua_information17;

721: per_qua_shd.g_old_rec.qua_information16;
722: End If;
723: If (p_rec.qua_information17 = hr_api.g_varchar2) then
724: p_rec.qua_information17 :=
725: per_qua_shd.g_old_rec.qua_information17;
726: End If;
727: If (p_rec.qua_information18 = hr_api.g_varchar2) then
728: p_rec.qua_information18 :=
729: per_qua_shd.g_old_rec.qua_information18;

Line 729: per_qua_shd.g_old_rec.qua_information18;

725: per_qua_shd.g_old_rec.qua_information17;
726: End If;
727: If (p_rec.qua_information18 = hr_api.g_varchar2) then
728: p_rec.qua_information18 :=
729: per_qua_shd.g_old_rec.qua_information18;
730: End If;
731: If (p_rec.qua_information19 = hr_api.g_varchar2) then
732: p_rec.qua_information19 :=
733: per_qua_shd.g_old_rec.qua_information19;

Line 733: per_qua_shd.g_old_rec.qua_information19;

729: per_qua_shd.g_old_rec.qua_information18;
730: End If;
731: If (p_rec.qua_information19 = hr_api.g_varchar2) then
732: p_rec.qua_information19 :=
733: per_qua_shd.g_old_rec.qua_information19;
734: End If;
735: If (p_rec.qua_information20 = hr_api.g_varchar2) then
736: p_rec.qua_information20 :=
737: per_qua_shd.g_old_rec.qua_information20;

Line 737: per_qua_shd.g_old_rec.qua_information20;

733: per_qua_shd.g_old_rec.qua_information19;
734: End If;
735: If (p_rec.qua_information20 = hr_api.g_varchar2) then
736: p_rec.qua_information20 :=
737: per_qua_shd.g_old_rec.qua_information20;
738: End If;
739: If (p_rec.professional_body_name = hr_api.g_varchar2) then
740: p_rec.professional_body_name :=
741: per_qua_shd.g_old_rec.professional_body_name;

Line 741: per_qua_shd.g_old_rec.professional_body_name;

737: per_qua_shd.g_old_rec.qua_information20;
738: End If;
739: If (p_rec.professional_body_name = hr_api.g_varchar2) then
740: p_rec.professional_body_name :=
741: per_qua_shd.g_old_rec.professional_body_name;
742: End If;
743: If (p_rec.membership_number = hr_api.g_varchar2) then
744: p_rec.membership_number :=
745: per_qua_shd.g_old_rec.membership_number;

Line 745: per_qua_shd.g_old_rec.membership_number;

741: per_qua_shd.g_old_rec.professional_body_name;
742: End If;
743: If (p_rec.membership_number = hr_api.g_varchar2) then
744: p_rec.membership_number :=
745: per_qua_shd.g_old_rec.membership_number;
746: End If;
747: If (p_rec.membership_category = hr_api.g_varchar2) then
748: p_rec.membership_category :=
749: per_qua_shd.g_old_rec.membership_category;

Line 749: per_qua_shd.g_old_rec.membership_category;

745: per_qua_shd.g_old_rec.membership_number;
746: End If;
747: If (p_rec.membership_category = hr_api.g_varchar2) then
748: p_rec.membership_category :=
749: per_qua_shd.g_old_rec.membership_category;
750: End If;
751: If (p_rec.subscription_payment_method = hr_api.g_varchar2) then
752: p_rec.subscription_payment_method :=
753: per_qua_shd.g_old_rec.subscription_payment_method;

Line 753: per_qua_shd.g_old_rec.subscription_payment_method;

749: per_qua_shd.g_old_rec.membership_category;
750: End If;
751: If (p_rec.subscription_payment_method = hr_api.g_varchar2) then
752: p_rec.subscription_payment_method :=
753: per_qua_shd.g_old_rec.subscription_payment_method;
754: End If;
755: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
756: p_rec.party_id :=
757: per_qua_shd.g_old_rec.party_id;

Line 757: per_qua_shd.g_old_rec.party_id;

753: per_qua_shd.g_old_rec.subscription_payment_method;
754: End If;
755: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
756: p_rec.party_id :=
757: per_qua_shd.g_old_rec.party_id;
758: End If;
759: --
760: hr_utility.set_location(' Leaving:'||l_proc, 10);
761: --

Line 769: p_rec in out nocopy per_qua_shd.g_rec_type,

765: -- |---------------------------------< upd >----------------------------------|
766: -- ----------------------------------------------------------------------------
767: Procedure upd
768: (
769: p_rec in out nocopy per_qua_shd.g_rec_type,
770: p_effective_date in date,
771: p_validate in boolean default false
772: ) is
773: --

Line 790: per_qua_shd.lck

786: End If;
787: --
788: -- We must lock the row which we need to update.
789: --
790: per_qua_shd.lck
791: (
792: p_rec.qualification_id,
793: p_rec.object_version_number
794: );

Line 923: l_rec per_qua_shd.g_rec_type;

919: p_subscription_payment_method in varchar2 default hr_api.g_varchar2,
920: p_party_id in number default hr_api.g_number
921: ) is
922: --
923: l_rec per_qua_shd.g_rec_type;
924: l_proc varchar2(72) := g_package||'upd';
925: --
926: Begin
927: hr_utility.set_location('Entering:'||l_proc, 5);

Line 933: per_qua_shd.convert_args

929: -- Call conversion function to turn arguments into the
930: -- l_rec structure.
931: --
932: l_rec :=
933: per_qua_shd.convert_args
934: (
935: p_qualification_id,
936: p_business_group_id,
937: p_object_version_number,