50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_ssm_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_ssm_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_salary_survey_mappings Row
68: --
69: update per_salary_survey_mappings
96: attribute19 = p_rec.attribute19,
97: attribute20 = p_rec.attribute20
98: where salary_survey_mapping_id = p_rec.salary_survey_mapping_id;
99: --
100: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception
103: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
108: per_ssm_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
108: per_ssm_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
108: per_ssm_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
113: per_ssm_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
113: per_ssm_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
113: per_ssm_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
118: per_ssm_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
118: per_ssm_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;
117: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
118: per_ssm_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;
123: End update_dml;
124: --
125: -- ----------------------------------------------------------------------------
153: -- Internal Row Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure pre_update(p_rec in per_ssm_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'pre_update';
160: --
161: Begin
195: -- Internal Row Handler Use Only.
196: --
197: -- {End Of Comments}
198: -- ----------------------------------------------------------------------------
199: Procedure post_update(p_rec in per_ssm_shd.g_rec_type
200: ,p_effective_date in date) is
201: --
202: l_proc varchar2(72) := g_package||'post_update';
203: --
233: p_attribute17 => p_rec.attribute17,
234: p_attribute18 => p_rec.attribute18,
235: p_attribute19 => p_rec.attribute19,
236: p_attribute20 => p_rec.attribute20,
237: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,
238: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
239: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
240: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
241: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
234: p_attribute18 => p_rec.attribute18,
235: p_attribute19 => p_rec.attribute19,
236: p_attribute20 => p_rec.attribute20,
237: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,
238: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
239: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
240: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
241: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
242: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
235: p_attribute19 => p_rec.attribute19,
236: p_attribute20 => p_rec.attribute20,
237: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,
238: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
239: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
240: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
241: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
242: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
243: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
236: p_attribute20 => p_rec.attribute20,
237: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,
238: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
239: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
240: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
241: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
242: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
243: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
244: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
237: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,
238: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
239: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
240: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
241: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
242: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
243: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
244: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
245: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
238: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
239: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
240: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
241: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
242: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
243: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
244: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
245: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
239: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
240: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
241: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
242: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
243: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
244: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
245: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
247: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
240: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
241: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
242: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
243: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
244: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
245: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
247: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
248: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
241: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
242: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
243: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
244: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
245: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
247: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
248: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
249: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
242: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
243: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
244: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
245: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
247: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
248: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
249: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
250: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
243: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
244: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
245: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
247: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
248: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
249: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
250: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
251: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
244: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
245: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
247: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
248: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
249: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
250: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
251: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
252: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
245: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
247: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
248: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
249: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
250: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
251: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
252: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
253: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
247: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
248: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
249: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
250: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
251: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
252: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
253: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
254: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
247: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
248: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
249: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
250: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
251: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
252: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
253: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
254: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
255: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
248: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
249: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
250: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
251: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
252: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
253: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
254: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
255: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
256: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
249: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
250: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
251: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
252: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
253: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
254: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
255: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
256: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
257: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
250: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
251: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
252: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
253: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
254: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
255: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
256: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
257: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
258: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
251: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
252: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
253: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
254: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
255: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
256: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
257: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
258: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
259: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
252: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
253: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
254: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
255: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
256: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
257: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
258: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
259: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
260: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
253: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
254: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
255: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
256: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
257: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
258: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
259: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
260: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
261: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
254: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
255: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
256: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
257: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
258: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
259: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
260: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
261: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
262: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
255: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
256: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
257: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
258: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
259: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
260: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
261: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
262: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
263: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
256: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
257: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
258: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
259: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
260: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
261: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
262: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
263: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
264: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
257: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
258: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
259: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
260: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
261: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
262: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
263: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
264: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
265: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20,
258: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
259: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
260: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
261: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
262: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
263: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
264: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
265: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20,
266: p_effective_date => p_effective_date
259: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
260: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
261: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
262: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
263: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
264: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
265: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20,
266: p_effective_date => p_effective_date
267: );
260: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
261: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
262: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
263: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
264: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
265: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20,
266: p_effective_date => p_effective_date
267: );
268: --
261: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
262: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
263: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
264: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
265: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20,
266: p_effective_date => p_effective_date
267: );
268: --
269: exception
322: -- Internal Row Handler Use Only.
323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure convert_defs(p_rec in out nocopy per_ssm_shd.g_rec_type) is
327: --
328: l_proc varchar2(72) := g_package||'convert_defs';
329: --
330: Begin
337: -- is being used then we must set to the 'current' argument value.
338: --
339: If (p_rec.parent_id = hr_api.g_number) then
340: p_rec.parent_id :=
341: per_ssm_shd.g_old_rec.parent_id;
342: End If;
343: If (p_rec.parent_table_name = hr_api.g_varchar2) then
344: p_rec.parent_table_name :=
345: per_ssm_shd.g_old_rec.parent_table_name;
341: per_ssm_shd.g_old_rec.parent_id;
342: End If;
343: If (p_rec.parent_table_name = hr_api.g_varchar2) then
344: p_rec.parent_table_name :=
345: per_ssm_shd.g_old_rec.parent_table_name;
346: End If;
347: If (p_rec.salary_survey_line_id = hr_api.g_number) then
348: p_rec.salary_survey_line_id :=
349: per_ssm_shd.g_old_rec.salary_survey_line_id;
345: per_ssm_shd.g_old_rec.parent_table_name;
346: End If;
347: If (p_rec.salary_survey_line_id = hr_api.g_number) then
348: p_rec.salary_survey_line_id :=
349: per_ssm_shd.g_old_rec.salary_survey_line_id;
350: End If;
351: If (p_rec.business_group_id = hr_api.g_number) then
352: p_rec.business_group_id :=
353: per_ssm_shd.g_old_rec.business_group_id;
349: per_ssm_shd.g_old_rec.salary_survey_line_id;
350: End If;
351: If (p_rec.business_group_id = hr_api.g_number) then
352: p_rec.business_group_id :=
353: per_ssm_shd.g_old_rec.business_group_id;
354: End If;
355: If (p_rec.location_id = hr_api.g_number) then
356: p_rec.location_id :=
357: per_ssm_shd.g_old_rec.location_id;
353: per_ssm_shd.g_old_rec.business_group_id;
354: End If;
355: If (p_rec.location_id = hr_api.g_number) then
356: p_rec.location_id :=
357: per_ssm_shd.g_old_rec.location_id;
358: End If;
359: If (p_rec.grade_id = hr_api.g_number) then
360: p_rec.grade_id :=
361: per_ssm_shd.g_old_rec.grade_id;
357: per_ssm_shd.g_old_rec.location_id;
358: End If;
359: If (p_rec.grade_id = hr_api.g_number) then
360: p_rec.grade_id :=
361: per_ssm_shd.g_old_rec.grade_id;
362: End If;
363: If (p_rec.company_organization_id = hr_api.g_number) then
364: p_rec.company_organization_id :=
365: per_ssm_shd.g_old_rec.company_organization_id;
361: per_ssm_shd.g_old_rec.grade_id;
362: End If;
363: If (p_rec.company_organization_id = hr_api.g_number) then
364: p_rec.company_organization_id :=
365: per_ssm_shd.g_old_rec.company_organization_id;
366: End If;
367: If (p_rec.company_age_code = hr_api.g_varchar2) then
368: p_rec.company_age_code :=
369: per_ssm_shd.g_old_rec.company_age_code;
365: per_ssm_shd.g_old_rec.company_organization_id;
366: End If;
367: If (p_rec.company_age_code = hr_api.g_varchar2) then
368: p_rec.company_age_code :=
369: per_ssm_shd.g_old_rec.company_age_code;
370: End If;
371: If (p_rec.attribute_category = hr_api.g_varchar2) then
372: p_rec.attribute_category :=
373: per_ssm_shd.g_old_rec.attribute_category;
369: per_ssm_shd.g_old_rec.company_age_code;
370: End If;
371: If (p_rec.attribute_category = hr_api.g_varchar2) then
372: p_rec.attribute_category :=
373: per_ssm_shd.g_old_rec.attribute_category;
374: End If;
375: If (p_rec.attribute1 = hr_api.g_varchar2) then
376: p_rec.attribute1 :=
377: per_ssm_shd.g_old_rec.attribute1;
373: per_ssm_shd.g_old_rec.attribute_category;
374: End If;
375: If (p_rec.attribute1 = hr_api.g_varchar2) then
376: p_rec.attribute1 :=
377: per_ssm_shd.g_old_rec.attribute1;
378: End If;
379: If (p_rec.attribute2 = hr_api.g_varchar2) then
380: p_rec.attribute2 :=
381: per_ssm_shd.g_old_rec.attribute2;
377: per_ssm_shd.g_old_rec.attribute1;
378: End If;
379: If (p_rec.attribute2 = hr_api.g_varchar2) then
380: p_rec.attribute2 :=
381: per_ssm_shd.g_old_rec.attribute2;
382: End If;
383: If (p_rec.attribute3 = hr_api.g_varchar2) then
384: p_rec.attribute3 :=
385: per_ssm_shd.g_old_rec.attribute3;
381: per_ssm_shd.g_old_rec.attribute2;
382: End If;
383: If (p_rec.attribute3 = hr_api.g_varchar2) then
384: p_rec.attribute3 :=
385: per_ssm_shd.g_old_rec.attribute3;
386: End If;
387: If (p_rec.attribute4 = hr_api.g_varchar2) then
388: p_rec.attribute4 :=
389: per_ssm_shd.g_old_rec.attribute4;
385: per_ssm_shd.g_old_rec.attribute3;
386: End If;
387: If (p_rec.attribute4 = hr_api.g_varchar2) then
388: p_rec.attribute4 :=
389: per_ssm_shd.g_old_rec.attribute4;
390: End If;
391: If (p_rec.attribute5 = hr_api.g_varchar2) then
392: p_rec.attribute5 :=
393: per_ssm_shd.g_old_rec.attribute5;
389: per_ssm_shd.g_old_rec.attribute4;
390: End If;
391: If (p_rec.attribute5 = hr_api.g_varchar2) then
392: p_rec.attribute5 :=
393: per_ssm_shd.g_old_rec.attribute5;
394: End If;
395: If (p_rec.attribute6 = hr_api.g_varchar2) then
396: p_rec.attribute6 :=
397: per_ssm_shd.g_old_rec.attribute6;
393: per_ssm_shd.g_old_rec.attribute5;
394: End If;
395: If (p_rec.attribute6 = hr_api.g_varchar2) then
396: p_rec.attribute6 :=
397: per_ssm_shd.g_old_rec.attribute6;
398: End If;
399: If (p_rec.attribute7 = hr_api.g_varchar2) then
400: p_rec.attribute7 :=
401: per_ssm_shd.g_old_rec.attribute7;
397: per_ssm_shd.g_old_rec.attribute6;
398: End If;
399: If (p_rec.attribute7 = hr_api.g_varchar2) then
400: p_rec.attribute7 :=
401: per_ssm_shd.g_old_rec.attribute7;
402: End If;
403: If (p_rec.attribute8 = hr_api.g_varchar2) then
404: p_rec.attribute8 :=
405: per_ssm_shd.g_old_rec.attribute8;
401: per_ssm_shd.g_old_rec.attribute7;
402: End If;
403: If (p_rec.attribute8 = hr_api.g_varchar2) then
404: p_rec.attribute8 :=
405: per_ssm_shd.g_old_rec.attribute8;
406: End If;
407: If (p_rec.attribute9 = hr_api.g_varchar2) then
408: p_rec.attribute9 :=
409: per_ssm_shd.g_old_rec.attribute9;
405: per_ssm_shd.g_old_rec.attribute8;
406: End If;
407: If (p_rec.attribute9 = hr_api.g_varchar2) then
408: p_rec.attribute9 :=
409: per_ssm_shd.g_old_rec.attribute9;
410: End If;
411: If (p_rec.attribute10 = hr_api.g_varchar2) then
412: p_rec.attribute10 :=
413: per_ssm_shd.g_old_rec.attribute10;
409: per_ssm_shd.g_old_rec.attribute9;
410: End If;
411: If (p_rec.attribute10 = hr_api.g_varchar2) then
412: p_rec.attribute10 :=
413: per_ssm_shd.g_old_rec.attribute10;
414: End If;
415: If (p_rec.attribute11 = hr_api.g_varchar2) then
416: p_rec.attribute11 :=
417: per_ssm_shd.g_old_rec.attribute11;
413: per_ssm_shd.g_old_rec.attribute10;
414: End If;
415: If (p_rec.attribute11 = hr_api.g_varchar2) then
416: p_rec.attribute11 :=
417: per_ssm_shd.g_old_rec.attribute11;
418: End If;
419: If (p_rec.attribute12 = hr_api.g_varchar2) then
420: p_rec.attribute12 :=
421: per_ssm_shd.g_old_rec.attribute12;
417: per_ssm_shd.g_old_rec.attribute11;
418: End If;
419: If (p_rec.attribute12 = hr_api.g_varchar2) then
420: p_rec.attribute12 :=
421: per_ssm_shd.g_old_rec.attribute12;
422: End If;
423: If (p_rec.attribute13 = hr_api.g_varchar2) then
424: p_rec.attribute13 :=
425: per_ssm_shd.g_old_rec.attribute13;
421: per_ssm_shd.g_old_rec.attribute12;
422: End If;
423: If (p_rec.attribute13 = hr_api.g_varchar2) then
424: p_rec.attribute13 :=
425: per_ssm_shd.g_old_rec.attribute13;
426: End If;
427: If (p_rec.attribute14 = hr_api.g_varchar2) then
428: p_rec.attribute14 :=
429: per_ssm_shd.g_old_rec.attribute14;
425: per_ssm_shd.g_old_rec.attribute13;
426: End If;
427: If (p_rec.attribute14 = hr_api.g_varchar2) then
428: p_rec.attribute14 :=
429: per_ssm_shd.g_old_rec.attribute14;
430: End If;
431: If (p_rec.attribute15 = hr_api.g_varchar2) then
432: p_rec.attribute15 :=
433: per_ssm_shd.g_old_rec.attribute15;
429: per_ssm_shd.g_old_rec.attribute14;
430: End If;
431: If (p_rec.attribute15 = hr_api.g_varchar2) then
432: p_rec.attribute15 :=
433: per_ssm_shd.g_old_rec.attribute15;
434: End If;
435: If (p_rec.attribute16 = hr_api.g_varchar2) then
436: p_rec.attribute16 :=
437: per_ssm_shd.g_old_rec.attribute16;
433: per_ssm_shd.g_old_rec.attribute15;
434: End If;
435: If (p_rec.attribute16 = hr_api.g_varchar2) then
436: p_rec.attribute16 :=
437: per_ssm_shd.g_old_rec.attribute16;
438: End If;
439: If (p_rec.attribute17 = hr_api.g_varchar2) then
440: p_rec.attribute17 :=
441: per_ssm_shd.g_old_rec.attribute17;
437: per_ssm_shd.g_old_rec.attribute16;
438: End If;
439: If (p_rec.attribute17 = hr_api.g_varchar2) then
440: p_rec.attribute17 :=
441: per_ssm_shd.g_old_rec.attribute17;
442: End If;
443: If (p_rec.attribute18 = hr_api.g_varchar2) then
444: p_rec.attribute18 :=
445: per_ssm_shd.g_old_rec.attribute18;
441: per_ssm_shd.g_old_rec.attribute17;
442: End If;
443: If (p_rec.attribute18 = hr_api.g_varchar2) then
444: p_rec.attribute18 :=
445: per_ssm_shd.g_old_rec.attribute18;
446: End If;
447: If (p_rec.attribute19 = hr_api.g_varchar2) then
448: p_rec.attribute19 :=
449: per_ssm_shd.g_old_rec.attribute19;
445: per_ssm_shd.g_old_rec.attribute18;
446: End If;
447: If (p_rec.attribute19 = hr_api.g_varchar2) then
448: p_rec.attribute19 :=
449: per_ssm_shd.g_old_rec.attribute19;
450: End If;
451: If (p_rec.attribute20 = hr_api.g_varchar2) then
452: p_rec.attribute20 :=
453: per_ssm_shd.g_old_rec.attribute20;
449: per_ssm_shd.g_old_rec.attribute19;
450: End If;
451: If (p_rec.attribute20 = hr_api.g_varchar2) then
452: p_rec.attribute20 :=
453: per_ssm_shd.g_old_rec.attribute20;
454: End If;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: --
461: -- |---------------------------------< upd >----------------------------------|
462: -- ----------------------------------------------------------------------------
463: Procedure upd
464: (
465: p_rec in out nocopy per_ssm_shd.g_rec_type,
466: p_effective_date in date
467: ) is
468: --
469: l_proc varchar2(72) := g_package||'upd';
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- We must lock the row which we need to update.
475: --
476: per_ssm_shd.lck
477: (
478: p_rec.salary_survey_mapping_id,
479: p_rec.object_version_number
480: );
535: p_attribute20 in varchar2 default hr_api.g_varchar2,
536: p_effective_date in date
537: ) is
538: --
539: l_rec per_ssm_shd.g_rec_type;
540: l_proc varchar2(72) := g_package||'upd';
541: --
542: Begin
543: hr_utility.set_location('Entering:'||l_proc, 5);
545: -- Call conversion function to turn arguments into the
546: -- l_rec structure.
547: --
548: l_rec :=
549: per_ssm_shd.convert_args
550: (
551: p_object_version_number,
552: p_salary_survey_mapping_id,
553: hr_api.g_number,