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_SSM_UPD dependencies on PER_SSM_SHD

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

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

Line 65: per_ssm_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_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

Line 100: per_ssm_shd.g_api_dml := false; -- Unset the api dml status

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

Line 107: per_ssm_shd.g_api_dml := false; -- Unset the api dml status

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

Line 108: per_ssm_shd.constraint_error

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

Line 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

Line 113: 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
117: per_ssm_shd.g_api_dml := false; -- Unset the api dml status

Line 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

Line 118: 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
122: Raise;

Line 121: per_ssm_shd.g_api_dml := false; -- Unset the api dml status

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: -- ----------------------------------------------------------------------------

Line 157: Procedure pre_update(p_rec in per_ssm_shd.g_rec_type) is

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

Line 199: Procedure post_update(p_rec in per_ssm_shd.g_rec_type

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: --

Line 237: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,

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,

Line 238: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,

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,

Line 239: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_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,

Line 240: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_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,

Line 241: p_location_id_o => per_ssm_shd.g_old_rec.location_id,

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,

Line 242: p_grade_id_o => per_ssm_shd.g_old_rec.grade_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,
246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,

Line 243: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,

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,

Line 244: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,

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,

Line 245: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,

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,

Line 246: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,

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,

Line 247: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,

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,

Line 248: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,

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,

Line 249: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,

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,

Line 250: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,

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,

Line 251: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,

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,

Line 252: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,

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,

Line 253: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,

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,

Line 254: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,

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,

Line 255: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,

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,

Line 256: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,

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,

Line 257: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,

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,

Line 258: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,

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,

Line 259: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,

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,

Line 260: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,

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,

Line 261: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,

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,

Line 262: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,

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

Line 263: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,

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: );

Line 264: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,

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: --

Line 265: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20,

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

Line 326: Procedure convert_defs(p_rec in out nocopy per_ssm_shd.g_rec_type) is

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

Line 341: per_ssm_shd.g_old_rec.parent_id;

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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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: --

Line 465: p_rec in out nocopy per_ssm_shd.g_rec_type,

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';

Line 476: per_ssm_shd.lck

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: );

Line 539: l_rec per_ssm_shd.g_rec_type;

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);

Line 549: per_ssm_shd.convert_args

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,