APPS.PER_SSM_DEL dependencies on PER_SSM_SHD

Line 51: Procedure delete_dml(p_rec in per_ssm_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in per_ssm_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: per_ssm_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: per_ssm_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the per_salary_survey_mappings row.
61: --
62: delete from per_salary_survey_mappings

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

61: --
62: delete from per_salary_survey_mappings
63: where salary_survey_mapping_id = p_rec.salary_survey_mapping_id;
64: --
65: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

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

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
73: per_ssm_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_ssm_shd.g_api_dml := false; -- Unset the api dml status

Line 73: per_ssm_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
73: per_ssm_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

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

72: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
73: per_ssm_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in per_ssm_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in per_ssm_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 154: Procedure post_delete(p_rec in per_ssm_shd.g_rec_type) is

150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in per_ssm_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

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

162: per_ssm_rkd.after_delete
163: (
164: p_object_version_number => p_rec.object_version_number,
165: p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id,
166: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,
167: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
168: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
169: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
170: p_location_id_o => per_ssm_shd.g_old_rec.location_id,

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

163: (
164: p_object_version_number => p_rec.object_version_number,
165: p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id,
166: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,
167: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
168: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
169: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
170: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
171: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,

Line 168: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,

164: p_object_version_number => p_rec.object_version_number,
165: p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id,
166: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,
167: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
168: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
169: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
170: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
171: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
172: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,

Line 169: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,

165: p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id,
166: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,
167: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
168: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
169: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
170: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
171: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
172: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
173: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,

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

166: p_parent_id_o => per_ssm_shd.g_old_rec.parent_id,
167: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
168: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
169: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
170: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
171: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
172: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
173: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
174: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,

Line 171: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,

167: p_parent_table_name_o => per_ssm_shd.g_old_rec.parent_table_name,
168: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
169: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
170: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
171: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
172: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
173: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
174: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
175: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,

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

168: p_salary_survey_line_id_o => per_ssm_shd.g_old_rec.salary_survey_line_id,
169: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
170: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
171: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
172: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
173: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
174: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
175: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
176: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,

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

169: p_business_group_id_o => per_ssm_shd.g_old_rec.business_group_id,
170: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
171: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
172: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
173: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
174: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
175: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
176: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
177: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,

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

170: p_location_id_o => per_ssm_shd.g_old_rec.location_id,
171: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
172: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
173: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
174: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
175: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
176: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
177: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
178: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,

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

171: p_grade_id_o => per_ssm_shd.g_old_rec.grade_id,
172: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
173: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
174: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
175: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
176: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
177: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
178: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
179: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,

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

172: p_company_organization_id_o => per_ssm_shd.g_old_rec.company_organization_id,
173: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
174: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
175: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
176: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
177: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
178: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
179: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
180: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,

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

173: p_company_age_code_o => per_ssm_shd.g_old_rec.company_age_code,
174: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
175: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
176: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
177: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
178: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
179: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
180: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
181: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,

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

174: p_attribute_category_o => per_ssm_shd.g_old_rec.attribute_category,
175: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
176: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
177: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
178: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
179: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
180: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
181: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
182: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,

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

175: p_attribute1_o => per_ssm_shd.g_old_rec.attribute1,
176: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
177: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
178: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
179: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
180: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
181: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
182: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
183: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,

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

176: p_attribute2_o => per_ssm_shd.g_old_rec.attribute2,
177: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
178: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
179: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
180: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
181: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
182: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
183: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
184: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,

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

177: p_attribute3_o => per_ssm_shd.g_old_rec.attribute3,
178: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
179: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
180: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
181: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
182: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
183: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
184: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
185: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,

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

178: p_attribute4_o => per_ssm_shd.g_old_rec.attribute4,
179: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
180: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
181: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
182: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
183: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
184: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
185: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
186: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,

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

179: p_attribute5_o => per_ssm_shd.g_old_rec.attribute5,
180: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
181: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
182: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
183: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
184: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
185: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
186: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
187: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,

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

180: p_attribute6_o => per_ssm_shd.g_old_rec.attribute6,
181: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
182: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
183: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
184: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
185: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
186: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
187: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
188: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,

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

181: p_attribute7_o => per_ssm_shd.g_old_rec.attribute7,
182: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
183: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
184: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
185: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
186: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
187: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
188: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
189: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,

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

182: p_attribute8_o => per_ssm_shd.g_old_rec.attribute8,
183: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
184: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
185: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
186: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
187: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
188: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
189: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
190: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,

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

183: p_attribute9_o => per_ssm_shd.g_old_rec.attribute9,
184: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
185: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
186: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
187: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
188: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
189: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
190: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
191: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,

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

184: p_attribute10_o => per_ssm_shd.g_old_rec.attribute10,
185: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
186: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
187: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
188: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
189: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
190: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
191: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
192: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,

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

185: p_attribute11_o => per_ssm_shd.g_old_rec.attribute11,
186: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
187: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
188: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
189: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
190: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
191: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
192: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
193: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,

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

186: p_attribute12_o => per_ssm_shd.g_old_rec.attribute12,
187: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
188: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
189: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
190: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
191: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
192: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
193: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
194: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20

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

187: p_attribute13_o => per_ssm_shd.g_old_rec.attribute13,
188: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
189: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
190: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
191: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
192: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
193: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
194: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20
195: );

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

188: p_attribute14_o => per_ssm_shd.g_old_rec.attribute14,
189: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
190: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
191: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
192: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
193: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
194: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20
195: );
196: end;

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

189: p_attribute15_o => per_ssm_shd.g_old_rec.attribute15,
190: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
191: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
192: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
193: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
194: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20
195: );
196: end;
197: --

Line 194: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20

190: p_attribute16_o => per_ssm_shd.g_old_rec.attribute16,
191: p_attribute17_o => per_ssm_shd.g_old_rec.attribute17,
192: p_attribute18_o => per_ssm_shd.g_old_rec.attribute18,
193: p_attribute19_o => per_ssm_shd.g_old_rec.attribute19,
194: p_attribute20_o => per_ssm_shd.g_old_rec.attribute20
195: );
196: end;
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 206: p_rec in per_ssm_shd.g_rec_type

202: -- |---------------------------------< del >----------------------------------|
203: -- ----------------------------------------------------------------------------
204: Procedure del
205: (
206: p_rec in per_ssm_shd.g_rec_type
207: ) is
208: --
209: l_proc varchar2(72) := g_package||'del';
210: --

Line 216: per_ssm_shd.lck

212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: -- We must lock the row which we need to delete.
215: --
216: per_ssm_shd.lck
217: (
218: p_rec.salary_survey_mapping_id,
219: p_rec.object_version_number
220: );

Line 248: l_rec per_ssm_shd.g_rec_type;

244: p_salary_survey_mapping_id in number,
245: p_object_version_number in number
246: ) is
247: --
248: l_rec per_ssm_shd.g_rec_type;
249: l_proc varchar2(72) := g_package||'del';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);