APPS.PER_PRT_UPD dependencies on PER_PRT_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_prt_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_prt_shd.g_rec_type) is
55:
56: l_proc varchar2(72) := g_package||'update_dml';
57:
58: Begin

Line 104: per_prt_shd.constraint_error

100:
101: Exception
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: per_prt_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_prt_shd.constraint_error

Line 108: per_prt_shd.constraint_error

104: per_prt_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_prt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: per_prt_shd.constraint_error

Line 112: per_prt_shd.constraint_error

108: per_prt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: per_prt_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
115: Raise;
116: End update_dml;

Line 150: Procedure pre_update(p_rec in per_prt_shd.g_rec_type) is

146: -- Internal Table Handler Use Only.
147:
148: -- {End Of Comments}
149: -- ---------------------------------------------------------------------------+
150: Procedure pre_update(p_rec in per_prt_shd.g_rec_type) is
151:
152: l_proc varchar2(72) := g_package||'pre_update';
153:
154: Begin

Line 192: Procedure post_update(p_rec in per_prt_shd.g_rec_type) is

188: -- Internal Table Handler Use Only.
189:
190: -- {End Of Comments}
191: -- ---------------------------------------------------------------------------+
192: Procedure post_update(p_rec in per_prt_shd.g_rec_type) is
193:
194: l_proc varchar2(72) := g_package||'post_update';
195:
196: Begin

Line 232: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,

228: p_attribute18 => p_rec.attribute18 ,
229: p_attribute19 => p_rec.attribute19 ,
230: p_attribute20 => p_rec.attribute20 ,
231: p_appr_line_score => p_rec.appr_line_score ,
232: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,
233: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
234: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
235: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
236: p_comments_o => per_prt_shd.g_old_rec.comments ,

Line 233: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,

229: p_attribute19 => p_rec.attribute19 ,
230: p_attribute20 => p_rec.attribute20 ,
231: p_appr_line_score => p_rec.appr_line_score ,
232: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,
233: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
234: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
235: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
236: p_comments_o => per_prt_shd.g_old_rec.comments ,
237: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,

Line 234: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,

230: p_attribute20 => p_rec.attribute20 ,
231: p_appr_line_score => p_rec.appr_line_score ,
232: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,
233: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
234: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
235: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
236: p_comments_o => per_prt_shd.g_old_rec.comments ,
237: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,

Line 235: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,

231: p_appr_line_score => p_rec.appr_line_score ,
232: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,
233: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
234: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
235: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
236: p_comments_o => per_prt_shd.g_old_rec.comments ,
237: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,

Line 236: p_comments_o => per_prt_shd.g_old_rec.comments ,

232: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,
233: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
234: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
235: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
236: p_comments_o => per_prt_shd.g_old_rec.comments ,
237: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,

Line 237: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,

233: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
234: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
235: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
236: p_comments_o => per_prt_shd.g_old_rec.comments ,
237: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,

Line 238: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,

234: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
235: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
236: p_comments_o => per_prt_shd.g_old_rec.comments ,
237: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,

Line 239: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,

235: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
236: p_comments_o => per_prt_shd.g_old_rec.comments ,
237: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,

Line 240: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,

236: p_comments_o => per_prt_shd.g_old_rec.comments ,
237: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,

Line 241: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,

237: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,

Line 242: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,

238: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,

Line 243: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,

239: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,

Line 244: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,

240: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,

Line 245: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,

241: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,

Line 246: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,

242: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,

Line 247: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,

243: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,

Line 248: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,

244: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,

Line 249: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,

245: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,

Line 250: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,

246: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,

Line 251: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,

247: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,

Line 252: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,

248: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,

Line 253: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,

249: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,

Line 254: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,

250: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
258: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);

Line 255: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,

251: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
258: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
259: exception

Line 256: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,

252: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
258: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
259: exception
260: when hr_api.cannot_find_prog_unit then

Line 257: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,

253: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
258: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error

Line 258: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);

254: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
258: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: ( p_module_name => 'PER_PERFORMANCE_RATINGS'

Line 314: Procedure convert_defs(p_rec in out nocopy per_prt_shd.g_rec_type) is

310: -- Internal Table Handler Use Only.
311:
312: -- {End Of Comments}
313: -- ---------------------------------------------------------------------------+
314: Procedure convert_defs(p_rec in out nocopy per_prt_shd.g_rec_type) is
315:
316: l_proc varchar2(72) := g_package||'convert_defs';
317:
318: Begin

Line 329: per_prt_shd.g_old_rec.objective_id;

325: -- is being used then we must set to the 'current' argument value.
326:
327: If (p_rec.objective_id = hr_api.g_number) then
328: p_rec.objective_id :=
329: per_prt_shd.g_old_rec.objective_id;
330: End If;
331: If (p_rec.appraisal_id = hr_api.g_number) then
332: p_rec.appraisal_id :=
333: per_prt_shd.g_old_rec.appraisal_id;

Line 333: per_prt_shd.g_old_rec.appraisal_id;

329: per_prt_shd.g_old_rec.objective_id;
330: End If;
331: If (p_rec.appraisal_id = hr_api.g_number) then
332: p_rec.appraisal_id :=
333: per_prt_shd.g_old_rec.appraisal_id;
334: End If;
335: If (p_rec.performance_level_id = hr_api.g_number) then
336: p_rec.performance_level_id :=
337: per_prt_shd.g_old_rec.performance_level_id;

Line 337: per_prt_shd.g_old_rec.performance_level_id;

333: per_prt_shd.g_old_rec.appraisal_id;
334: End If;
335: If (p_rec.performance_level_id = hr_api.g_number) then
336: p_rec.performance_level_id :=
337: per_prt_shd.g_old_rec.performance_level_id;
338: End If;
339: If (p_rec.comments = hr_api.g_varchar2) then
340: p_rec.comments :=
341: per_prt_shd.g_old_rec.comments;

Line 341: per_prt_shd.g_old_rec.comments;

337: per_prt_shd.g_old_rec.performance_level_id;
338: End If;
339: If (p_rec.comments = hr_api.g_varchar2) then
340: p_rec.comments :=
341: per_prt_shd.g_old_rec.comments;
342: End If;
343: If (p_rec.attribute_category = hr_api.g_varchar2) then
344: p_rec.attribute_category :=
345: per_prt_shd.g_old_rec.attribute_category;

Line 345: per_prt_shd.g_old_rec.attribute_category;

341: per_prt_shd.g_old_rec.comments;
342: End If;
343: If (p_rec.attribute_category = hr_api.g_varchar2) then
344: p_rec.attribute_category :=
345: per_prt_shd.g_old_rec.attribute_category;
346: End If;
347: If (p_rec.attribute1 = hr_api.g_varchar2) then
348: p_rec.attribute1 :=
349: per_prt_shd.g_old_rec.attribute1;

Line 349: per_prt_shd.g_old_rec.attribute1;

345: per_prt_shd.g_old_rec.attribute_category;
346: End If;
347: If (p_rec.attribute1 = hr_api.g_varchar2) then
348: p_rec.attribute1 :=
349: per_prt_shd.g_old_rec.attribute1;
350: End If;
351: If (p_rec.attribute2 = hr_api.g_varchar2) then
352: p_rec.attribute2 :=
353: per_prt_shd.g_old_rec.attribute2;

Line 353: per_prt_shd.g_old_rec.attribute2;

349: per_prt_shd.g_old_rec.attribute1;
350: End If;
351: If (p_rec.attribute2 = hr_api.g_varchar2) then
352: p_rec.attribute2 :=
353: per_prt_shd.g_old_rec.attribute2;
354: End If;
355: If (p_rec.attribute3 = hr_api.g_varchar2) then
356: p_rec.attribute3 :=
357: per_prt_shd.g_old_rec.attribute3;

Line 357: per_prt_shd.g_old_rec.attribute3;

353: per_prt_shd.g_old_rec.attribute2;
354: End If;
355: If (p_rec.attribute3 = hr_api.g_varchar2) then
356: p_rec.attribute3 :=
357: per_prt_shd.g_old_rec.attribute3;
358: End If;
359: If (p_rec.attribute4 = hr_api.g_varchar2) then
360: p_rec.attribute4 :=
361: per_prt_shd.g_old_rec.attribute4;

Line 361: per_prt_shd.g_old_rec.attribute4;

357: per_prt_shd.g_old_rec.attribute3;
358: End If;
359: If (p_rec.attribute4 = hr_api.g_varchar2) then
360: p_rec.attribute4 :=
361: per_prt_shd.g_old_rec.attribute4;
362: End If;
363: If (p_rec.attribute5 = hr_api.g_varchar2) then
364: p_rec.attribute5 :=
365: per_prt_shd.g_old_rec.attribute5;

Line 365: per_prt_shd.g_old_rec.attribute5;

361: per_prt_shd.g_old_rec.attribute4;
362: End If;
363: If (p_rec.attribute5 = hr_api.g_varchar2) then
364: p_rec.attribute5 :=
365: per_prt_shd.g_old_rec.attribute5;
366: End If;
367: If (p_rec.attribute6 = hr_api.g_varchar2) then
368: p_rec.attribute6 :=
369: per_prt_shd.g_old_rec.attribute6;

Line 369: per_prt_shd.g_old_rec.attribute6;

365: per_prt_shd.g_old_rec.attribute5;
366: End If;
367: If (p_rec.attribute6 = hr_api.g_varchar2) then
368: p_rec.attribute6 :=
369: per_prt_shd.g_old_rec.attribute6;
370: End If;
371: If (p_rec.attribute7 = hr_api.g_varchar2) then
372: p_rec.attribute7 :=
373: per_prt_shd.g_old_rec.attribute7;

Line 373: per_prt_shd.g_old_rec.attribute7;

369: per_prt_shd.g_old_rec.attribute6;
370: End If;
371: If (p_rec.attribute7 = hr_api.g_varchar2) then
372: p_rec.attribute7 :=
373: per_prt_shd.g_old_rec.attribute7;
374: End If;
375: If (p_rec.attribute8 = hr_api.g_varchar2) then
376: p_rec.attribute8 :=
377: per_prt_shd.g_old_rec.attribute8;

Line 377: per_prt_shd.g_old_rec.attribute8;

373: per_prt_shd.g_old_rec.attribute7;
374: End If;
375: If (p_rec.attribute8 = hr_api.g_varchar2) then
376: p_rec.attribute8 :=
377: per_prt_shd.g_old_rec.attribute8;
378: End If;
379: If (p_rec.attribute9 = hr_api.g_varchar2) then
380: p_rec.attribute9 :=
381: per_prt_shd.g_old_rec.attribute9;

Line 381: per_prt_shd.g_old_rec.attribute9;

377: per_prt_shd.g_old_rec.attribute8;
378: End If;
379: If (p_rec.attribute9 = hr_api.g_varchar2) then
380: p_rec.attribute9 :=
381: per_prt_shd.g_old_rec.attribute9;
382: End If;
383: If (p_rec.attribute10 = hr_api.g_varchar2) then
384: p_rec.attribute10 :=
385: per_prt_shd.g_old_rec.attribute10;

Line 385: per_prt_shd.g_old_rec.attribute10;

381: per_prt_shd.g_old_rec.attribute9;
382: End If;
383: If (p_rec.attribute10 = hr_api.g_varchar2) then
384: p_rec.attribute10 :=
385: per_prt_shd.g_old_rec.attribute10;
386: End If;
387: If (p_rec.attribute11 = hr_api.g_varchar2) then
388: p_rec.attribute11 :=
389: per_prt_shd.g_old_rec.attribute11;

Line 389: per_prt_shd.g_old_rec.attribute11;

385: per_prt_shd.g_old_rec.attribute10;
386: End If;
387: If (p_rec.attribute11 = hr_api.g_varchar2) then
388: p_rec.attribute11 :=
389: per_prt_shd.g_old_rec.attribute11;
390: End If;
391: If (p_rec.attribute12 = hr_api.g_varchar2) then
392: p_rec.attribute12 :=
393: per_prt_shd.g_old_rec.attribute12;

Line 393: per_prt_shd.g_old_rec.attribute12;

389: per_prt_shd.g_old_rec.attribute11;
390: End If;
391: If (p_rec.attribute12 = hr_api.g_varchar2) then
392: p_rec.attribute12 :=
393: per_prt_shd.g_old_rec.attribute12;
394: End If;
395: If (p_rec.attribute13 = hr_api.g_varchar2) then
396: p_rec.attribute13 :=
397: per_prt_shd.g_old_rec.attribute13;

Line 397: per_prt_shd.g_old_rec.attribute13;

393: per_prt_shd.g_old_rec.attribute12;
394: End If;
395: If (p_rec.attribute13 = hr_api.g_varchar2) then
396: p_rec.attribute13 :=
397: per_prt_shd.g_old_rec.attribute13;
398: End If;
399: If (p_rec.attribute14 = hr_api.g_varchar2) then
400: p_rec.attribute14 :=
401: per_prt_shd.g_old_rec.attribute14;

Line 401: per_prt_shd.g_old_rec.attribute14;

397: per_prt_shd.g_old_rec.attribute13;
398: End If;
399: If (p_rec.attribute14 = hr_api.g_varchar2) then
400: p_rec.attribute14 :=
401: per_prt_shd.g_old_rec.attribute14;
402: End If;
403: If (p_rec.attribute15 = hr_api.g_varchar2) then
404: p_rec.attribute15 :=
405: per_prt_shd.g_old_rec.attribute15;

Line 405: per_prt_shd.g_old_rec.attribute15;

401: per_prt_shd.g_old_rec.attribute14;
402: End If;
403: If (p_rec.attribute15 = hr_api.g_varchar2) then
404: p_rec.attribute15 :=
405: per_prt_shd.g_old_rec.attribute15;
406: End If;
407: If (p_rec.attribute16 = hr_api.g_varchar2) then
408: p_rec.attribute16 :=
409: per_prt_shd.g_old_rec.attribute16;

Line 409: per_prt_shd.g_old_rec.attribute16;

405: per_prt_shd.g_old_rec.attribute15;
406: End If;
407: If (p_rec.attribute16 = hr_api.g_varchar2) then
408: p_rec.attribute16 :=
409: per_prt_shd.g_old_rec.attribute16;
410: End If;
411: If (p_rec.attribute17 = hr_api.g_varchar2) then
412: p_rec.attribute17 :=
413: per_prt_shd.g_old_rec.attribute17;

Line 413: per_prt_shd.g_old_rec.attribute17;

409: per_prt_shd.g_old_rec.attribute16;
410: End If;
411: If (p_rec.attribute17 = hr_api.g_varchar2) then
412: p_rec.attribute17 :=
413: per_prt_shd.g_old_rec.attribute17;
414: End If;
415: If (p_rec.attribute18 = hr_api.g_varchar2) then
416: p_rec.attribute18 :=
417: per_prt_shd.g_old_rec.attribute18;

Line 417: per_prt_shd.g_old_rec.attribute18;

413: per_prt_shd.g_old_rec.attribute17;
414: End If;
415: If (p_rec.attribute18 = hr_api.g_varchar2) then
416: p_rec.attribute18 :=
417: per_prt_shd.g_old_rec.attribute18;
418: End If;
419: If (p_rec.attribute19 = hr_api.g_varchar2) then
420: p_rec.attribute19 :=
421: per_prt_shd.g_old_rec.attribute19;

Line 421: per_prt_shd.g_old_rec.attribute19;

417: per_prt_shd.g_old_rec.attribute18;
418: End If;
419: If (p_rec.attribute19 = hr_api.g_varchar2) then
420: p_rec.attribute19 :=
421: per_prt_shd.g_old_rec.attribute19;
422: End If;
423: If (p_rec.attribute20 = hr_api.g_varchar2) then
424: p_rec.attribute20 :=
425: per_prt_shd.g_old_rec.attribute20;

Line 425: per_prt_shd.g_old_rec.attribute20;

421: per_prt_shd.g_old_rec.attribute19;
422: End If;
423: If (p_rec.attribute20 = hr_api.g_varchar2) then
424: p_rec.attribute20 :=
425: per_prt_shd.g_old_rec.attribute20;
426: End If;
427: If (p_rec.person_id = hr_api.g_number) then
428: p_rec.person_id :=
429: per_prt_shd.g_old_rec.person_id;

Line 429: per_prt_shd.g_old_rec.person_id;

425: per_prt_shd.g_old_rec.attribute20;
426: End If;
427: If (p_rec.person_id = hr_api.g_number) then
428: p_rec.person_id :=
429: per_prt_shd.g_old_rec.person_id;
430: End If;
431: If (p_rec.appr_line_score = hr_api.g_number) then
432: p_rec.appr_line_score :=
433: per_prt_shd.g_old_rec.appr_line_score;

Line 433: per_prt_shd.g_old_rec.appr_line_score;

429: per_prt_shd.g_old_rec.person_id;
430: End If;
431: If (p_rec.appr_line_score = hr_api.g_number) then
432: p_rec.appr_line_score :=
433: per_prt_shd.g_old_rec.appr_line_score;
434: End If;
435:
436: hr_utility.set_location(' Leaving:'||l_proc, 10);
437:

Line 445: p_rec in out nocopy per_prt_shd.g_rec_type,

441: -- |---------------------------------< upd >----------------------------------|
442: -- ---------------------------------------------------------------------------+
443: Procedure upd
444: (
445: p_rec in out nocopy per_prt_shd.g_rec_type,
446: p_validate in boolean default false,
447: p_effective_date in date
448: ) is
449:

Line 466: per_prt_shd.lck

462: End If;
463:
464: -- We must lock the row which we need to update.
465:
466: per_prt_shd.lck
467: (
468: p_rec.performance_rating_id,
469: p_rec.object_version_number
470: );

Line 557: l_rec per_prt_shd.g_rec_type;

553: p_effective_date in date,
554: p_appr_line_score in number default hr_api.g_number
555: ) is
556:
557: l_rec per_prt_shd.g_rec_type;
558: l_proc varchar2(72) := g_package||'upd';
559:
560: Begin
561: hr_utility.set_location('Entering:'||l_proc, 5);

Line 567: per_prt_shd.convert_args

563: -- Call conversion function to turn arguments into the
564: -- l_rec structure.
565:
566: l_rec :=
567: per_prt_shd.convert_args
568: (
569: p_performance_rating_id,
570: p_person_id,
571: hr_api.g_number,