DBA Data[Home] [Help]

APPS.PER_AST_UPD dependencies on PER_AST_SHD

Line 48: Procedure update_dml(p_rec in out nocopy per_ast_shd.g_rec_type) is

44: -- Internal Table Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy per_ast_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 114: per_ast_shd.constraint_error

110: --
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: per_ast_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: per_ast_shd.constraint_error

Line 118: per_ast_shd.constraint_error

114: per_ast_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: per_ast_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: per_ast_shd.constraint_error

Line 122: per_ast_shd.constraint_error

118: per_ast_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: per_ast_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: Raise;
126: End update_dml;

Line 160: Procedure pre_update(p_rec in per_ast_shd.g_rec_type) is

156: -- Internal Table Handler Use Only.
157: --
158: -- {End Of Comments}
159: -- ----------------------------------------------------------------------------
160: Procedure pre_update(p_rec in per_ast_shd.g_rec_type) is
161: --
162: l_proc varchar2(72) := g_package||'pre_update';
163: --
164: Begin

Line 202: Procedure post_update(p_rec in per_ast_shd.g_rec_type) is

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

Line 256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,

252: p_type => p_rec.type ,
253: p_line_score_formula_id => p_rec.line_score_formula_id,
254: p_default_job_competencies => p_rec.default_job_competencies,
255: p_available_flag => p_rec.available_flag,
256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,

Line 257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,

253: p_line_score_formula_id => p_rec.line_score_formula_id,
254: p_default_job_competencies => p_rec.default_job_competencies,
255: p_available_flag => p_rec.available_flag,
256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>

Line 258: p_name_o => per_ast_shd.g_old_rec.name ,

254: p_default_job_competencies => p_rec.default_job_competencies,
255: p_available_flag => p_rec.available_flag,
256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,

Line 259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,

255: p_available_flag => p_rec.available_flag,
256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>

Line 260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,

256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
264: per_ast_shd.g_old_rec.display_assessment_comments ,

Line 262: per_ast_shd.g_old_rec.assessment_classification ,

258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
264: per_ast_shd.g_old_rec.display_assessment_comments ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,

Line 264: per_ast_shd.g_old_rec.display_assessment_comments ,

260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
264: per_ast_shd.g_old_rec.display_assessment_comments ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,

Line 265: p_description_o => per_ast_shd.g_old_rec.description ,

261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
264: per_ast_shd.g_old_rec.display_assessment_comments ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,

Line 266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,

262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
264: per_ast_shd.g_old_rec.display_assessment_comments ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,

Line 268: per_ast_shd.g_old_rec.weighting_scale_comment ,

264: per_ast_shd.g_old_rec.display_assessment_comments ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,

Line 269: p_comments_o => per_ast_shd.g_old_rec.comments ,

265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>

Line 270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,

266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,

Line 271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,

267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,

Line 272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,

268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,

Line 274: per_ast_shd.g_old_rec.weighting_classification ,

270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,

Line 275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,

271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,

Line 276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,

272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,

Line 277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,

273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,

Line 278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,

274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,

Line 279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,

275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,

Line 280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,

276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,

Line 281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,

277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,

Line 282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,

278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,

Line 283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,

279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,

Line 284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,

280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,

Line 285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,

281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,

Line 286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,

282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,

Line 287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,

283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,

Line 288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,

284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,

Line 289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,

285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,

Line 290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,

286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,

Line 291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,

287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,

Line 292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,

288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,

Line 293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,

289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,

Line 294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,

290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,

Line 295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,

291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,

Line 296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,

292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,

Line 297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,

293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag

Line 298: p_type_o => per_ast_shd.g_old_rec.type,

294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag
302: );

Line 299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,

295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag
302: );
303:

Line 300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,

296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag
302: );
303:
304: exception

Line 301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag

297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag
302: );
303:
304: exception
305: when hr_api.cannot_find_prog_unit then

Line 361: Procedure convert_defs(p_rec in out nocopy per_ast_shd.g_rec_type) is

357: -- Internal Table Handler Use Only.
358: --
359: -- {End Of Comments}
360: -- ----------------------------------------------------------------------------
361: Procedure convert_defs(p_rec in out nocopy per_ast_shd.g_rec_type) is
362: --
363: l_proc varchar2(72) := g_package||'convert_defs';
364: --
365: Begin

Line 376: per_ast_shd.g_old_rec.name;

372: -- is being used then we must set to the 'current' argument value.
373: --
374: If (p_rec.name = hr_api.g_varchar2) then
375: p_rec.name :=
376: per_ast_shd.g_old_rec.name;
377: End If;
378: If (p_rec.business_group_id = hr_api.g_number) then
379: p_rec.business_group_id :=
380: per_ast_shd.g_old_rec.business_group_id;

Line 380: per_ast_shd.g_old_rec.business_group_id;

376: per_ast_shd.g_old_rec.name;
377: End If;
378: If (p_rec.business_group_id = hr_api.g_number) then
379: p_rec.business_group_id :=
380: per_ast_shd.g_old_rec.business_group_id;
381: End If;
382: If (p_rec.description = hr_api.g_varchar2) then
383: p_rec.description :=
384: per_ast_shd.g_old_rec.description;

Line 384: per_ast_shd.g_old_rec.description;

380: per_ast_shd.g_old_rec.business_group_id;
381: End If;
382: If (p_rec.description = hr_api.g_varchar2) then
383: p_rec.description :=
384: per_ast_shd.g_old_rec.description;
385: End If;
386: If (p_rec.rating_scale_id = hr_api.g_number) then
387: p_rec.rating_scale_id :=
388: per_ast_shd.g_old_rec.rating_scale_id;

Line 388: per_ast_shd.g_old_rec.rating_scale_id;

384: per_ast_shd.g_old_rec.description;
385: End If;
386: If (p_rec.rating_scale_id = hr_api.g_number) then
387: p_rec.rating_scale_id :=
388: per_ast_shd.g_old_rec.rating_scale_id;
389: End If;
390: If (p_rec.weighting_scale_id = hr_api.g_number) then
391: p_rec.weighting_scale_id :=
392: per_ast_shd.g_old_rec.weighting_scale_id;

Line 392: per_ast_shd.g_old_rec.weighting_scale_id;

388: per_ast_shd.g_old_rec.rating_scale_id;
389: End If;
390: If (p_rec.weighting_scale_id = hr_api.g_number) then
391: p_rec.weighting_scale_id :=
392: per_ast_shd.g_old_rec.weighting_scale_id;
393: End If;
394: If (p_rec.rating_scale_comment = hr_api.g_varchar2) then
395: p_rec.rating_scale_comment :=
396: per_ast_shd.g_old_rec.rating_scale_comment;

Line 396: per_ast_shd.g_old_rec.rating_scale_comment;

392: per_ast_shd.g_old_rec.weighting_scale_id;
393: End If;
394: If (p_rec.rating_scale_comment = hr_api.g_varchar2) then
395: p_rec.rating_scale_comment :=
396: per_ast_shd.g_old_rec.rating_scale_comment;
397: End If;
398: If (p_rec.weighting_scale_comment = hr_api.g_varchar2) then
399: p_rec.weighting_scale_comment :=
400: per_ast_shd.g_old_rec.weighting_scale_comment;

Line 400: per_ast_shd.g_old_rec.weighting_scale_comment;

396: per_ast_shd.g_old_rec.rating_scale_comment;
397: End If;
398: If (p_rec.weighting_scale_comment = hr_api.g_varchar2) then
399: p_rec.weighting_scale_comment :=
400: per_ast_shd.g_old_rec.weighting_scale_comment;
401: End If;
402: If (p_rec.assessment_classification = hr_api.g_varchar2) then
403: p_rec.assessment_classification :=
404: per_ast_shd.g_old_rec.assessment_classification;

Line 404: per_ast_shd.g_old_rec.assessment_classification;

400: per_ast_shd.g_old_rec.weighting_scale_comment;
401: End If;
402: If (p_rec.assessment_classification = hr_api.g_varchar2) then
403: p_rec.assessment_classification :=
404: per_ast_shd.g_old_rec.assessment_classification;
405: End If;
406: If (p_rec.display_assessment_comments = hr_api.g_varchar2) then
407: p_rec.display_assessment_comments :=
408: per_ast_shd.g_old_rec.display_assessment_comments;

Line 408: per_ast_shd.g_old_rec.display_assessment_comments;

404: per_ast_shd.g_old_rec.assessment_classification;
405: End If;
406: If (p_rec.display_assessment_comments = hr_api.g_varchar2) then
407: p_rec.display_assessment_comments :=
408: per_ast_shd.g_old_rec.display_assessment_comments;
409: End If;
410: If (p_rec.date_from = hr_api.g_date) then
411: p_rec.date_from :=
412: per_ast_shd.g_old_rec.date_from;

Line 412: per_ast_shd.g_old_rec.date_from;

408: per_ast_shd.g_old_rec.display_assessment_comments;
409: End If;
410: If (p_rec.date_from = hr_api.g_date) then
411: p_rec.date_from :=
412: per_ast_shd.g_old_rec.date_from;
413: End If;
414: If (p_rec.date_to = hr_api.g_date) then
415: p_rec.date_to :=
416: per_ast_shd.g_old_rec.date_to;

Line 416: per_ast_shd.g_old_rec.date_to;

412: per_ast_shd.g_old_rec.date_from;
413: End If;
414: If (p_rec.date_to = hr_api.g_date) then
415: p_rec.date_to :=
416: per_ast_shd.g_old_rec.date_to;
417: End If;
418: If (p_rec.comments = hr_api.g_varchar2) then
419: p_rec.comments :=
420: per_ast_shd.g_old_rec.comments;

Line 420: per_ast_shd.g_old_rec.comments;

416: per_ast_shd.g_old_rec.date_to;
417: End If;
418: If (p_rec.comments = hr_api.g_varchar2) then
419: p_rec.comments :=
420: per_ast_shd.g_old_rec.comments;
421: End If;
422: If (p_rec.instructions = hr_api.g_varchar2) then
423: p_rec.instructions :=
424: per_ast_shd.g_old_rec.instructions;

Line 424: per_ast_shd.g_old_rec.instructions;

420: per_ast_shd.g_old_rec.comments;
421: End If;
422: If (p_rec.instructions = hr_api.g_varchar2) then
423: p_rec.instructions :=
424: per_ast_shd.g_old_rec.instructions;
425: End If;
426: If (p_rec.weighting_classification = hr_api.g_varchar2) then
427: p_rec.weighting_classification :=
428: per_ast_shd.g_old_rec.weighting_classification;

Line 428: per_ast_shd.g_old_rec.weighting_classification;

424: per_ast_shd.g_old_rec.instructions;
425: End If;
426: If (p_rec.weighting_classification = hr_api.g_varchar2) then
427: p_rec.weighting_classification :=
428: per_ast_shd.g_old_rec.weighting_classification;
429: End If;
430: If (p_rec.line_score_formula = hr_api.g_varchar2) then
431: p_rec.line_score_formula :=
432: per_ast_shd.g_old_rec.line_score_formula;

Line 432: per_ast_shd.g_old_rec.line_score_formula;

428: per_ast_shd.g_old_rec.weighting_classification;
429: End If;
430: If (p_rec.line_score_formula = hr_api.g_varchar2) then
431: p_rec.line_score_formula :=
432: per_ast_shd.g_old_rec.line_score_formula;
433: End If;
434: If (p_rec.total_score_formula = hr_api.g_varchar2) then
435: p_rec.total_score_formula :=
436: per_ast_shd.g_old_rec.total_score_formula;

Line 436: per_ast_shd.g_old_rec.total_score_formula;

432: per_ast_shd.g_old_rec.line_score_formula;
433: End If;
434: If (p_rec.total_score_formula = hr_api.g_varchar2) then
435: p_rec.total_score_formula :=
436: per_ast_shd.g_old_rec.total_score_formula;
437: End If;
438: If (p_rec.attribute_category = hr_api.g_varchar2) then
439: p_rec.attribute_category :=
440: per_ast_shd.g_old_rec.attribute_category;

Line 440: per_ast_shd.g_old_rec.attribute_category;

436: per_ast_shd.g_old_rec.total_score_formula;
437: End If;
438: If (p_rec.attribute_category = hr_api.g_varchar2) then
439: p_rec.attribute_category :=
440: per_ast_shd.g_old_rec.attribute_category;
441: End If;
442: If (p_rec.attribute1 = hr_api.g_varchar2) then
443: p_rec.attribute1 :=
444: per_ast_shd.g_old_rec.attribute1;

Line 444: per_ast_shd.g_old_rec.attribute1;

440: per_ast_shd.g_old_rec.attribute_category;
441: End If;
442: If (p_rec.attribute1 = hr_api.g_varchar2) then
443: p_rec.attribute1 :=
444: per_ast_shd.g_old_rec.attribute1;
445: End If;
446: If (p_rec.attribute2 = hr_api.g_varchar2) then
447: p_rec.attribute2 :=
448: per_ast_shd.g_old_rec.attribute2;

Line 448: per_ast_shd.g_old_rec.attribute2;

444: per_ast_shd.g_old_rec.attribute1;
445: End If;
446: If (p_rec.attribute2 = hr_api.g_varchar2) then
447: p_rec.attribute2 :=
448: per_ast_shd.g_old_rec.attribute2;
449: End If;
450: If (p_rec.attribute3 = hr_api.g_varchar2) then
451: p_rec.attribute3 :=
452: per_ast_shd.g_old_rec.attribute3;

Line 452: per_ast_shd.g_old_rec.attribute3;

448: per_ast_shd.g_old_rec.attribute2;
449: End If;
450: If (p_rec.attribute3 = hr_api.g_varchar2) then
451: p_rec.attribute3 :=
452: per_ast_shd.g_old_rec.attribute3;
453: End If;
454: If (p_rec.attribute4 = hr_api.g_varchar2) then
455: p_rec.attribute4 :=
456: per_ast_shd.g_old_rec.attribute4;

Line 456: per_ast_shd.g_old_rec.attribute4;

452: per_ast_shd.g_old_rec.attribute3;
453: End If;
454: If (p_rec.attribute4 = hr_api.g_varchar2) then
455: p_rec.attribute4 :=
456: per_ast_shd.g_old_rec.attribute4;
457: End If;
458: If (p_rec.attribute5 = hr_api.g_varchar2) then
459: p_rec.attribute5 :=
460: per_ast_shd.g_old_rec.attribute5;

Line 460: per_ast_shd.g_old_rec.attribute5;

456: per_ast_shd.g_old_rec.attribute4;
457: End If;
458: If (p_rec.attribute5 = hr_api.g_varchar2) then
459: p_rec.attribute5 :=
460: per_ast_shd.g_old_rec.attribute5;
461: End If;
462: If (p_rec.attribute6 = hr_api.g_varchar2) then
463: p_rec.attribute6 :=
464: per_ast_shd.g_old_rec.attribute6;

Line 464: per_ast_shd.g_old_rec.attribute6;

460: per_ast_shd.g_old_rec.attribute5;
461: End If;
462: If (p_rec.attribute6 = hr_api.g_varchar2) then
463: p_rec.attribute6 :=
464: per_ast_shd.g_old_rec.attribute6;
465: End If;
466: If (p_rec.attribute7 = hr_api.g_varchar2) then
467: p_rec.attribute7 :=
468: per_ast_shd.g_old_rec.attribute7;

Line 468: per_ast_shd.g_old_rec.attribute7;

464: per_ast_shd.g_old_rec.attribute6;
465: End If;
466: If (p_rec.attribute7 = hr_api.g_varchar2) then
467: p_rec.attribute7 :=
468: per_ast_shd.g_old_rec.attribute7;
469: End If;
470: If (p_rec.attribute8 = hr_api.g_varchar2) then
471: p_rec.attribute8 :=
472: per_ast_shd.g_old_rec.attribute8;

Line 472: per_ast_shd.g_old_rec.attribute8;

468: per_ast_shd.g_old_rec.attribute7;
469: End If;
470: If (p_rec.attribute8 = hr_api.g_varchar2) then
471: p_rec.attribute8 :=
472: per_ast_shd.g_old_rec.attribute8;
473: End If;
474: If (p_rec.attribute9 = hr_api.g_varchar2) then
475: p_rec.attribute9 :=
476: per_ast_shd.g_old_rec.attribute9;

Line 476: per_ast_shd.g_old_rec.attribute9;

472: per_ast_shd.g_old_rec.attribute8;
473: End If;
474: If (p_rec.attribute9 = hr_api.g_varchar2) then
475: p_rec.attribute9 :=
476: per_ast_shd.g_old_rec.attribute9;
477: End If;
478: If (p_rec.attribute10 = hr_api.g_varchar2) then
479: p_rec.attribute10 :=
480: per_ast_shd.g_old_rec.attribute10;

Line 480: per_ast_shd.g_old_rec.attribute10;

476: per_ast_shd.g_old_rec.attribute9;
477: End If;
478: If (p_rec.attribute10 = hr_api.g_varchar2) then
479: p_rec.attribute10 :=
480: per_ast_shd.g_old_rec.attribute10;
481: End If;
482: If (p_rec.attribute11 = hr_api.g_varchar2) then
483: p_rec.attribute11 :=
484: per_ast_shd.g_old_rec.attribute11;

Line 484: per_ast_shd.g_old_rec.attribute11;

480: per_ast_shd.g_old_rec.attribute10;
481: End If;
482: If (p_rec.attribute11 = hr_api.g_varchar2) then
483: p_rec.attribute11 :=
484: per_ast_shd.g_old_rec.attribute11;
485: End If;
486: If (p_rec.attribute12 = hr_api.g_varchar2) then
487: p_rec.attribute12 :=
488: per_ast_shd.g_old_rec.attribute12;

Line 488: per_ast_shd.g_old_rec.attribute12;

484: per_ast_shd.g_old_rec.attribute11;
485: End If;
486: If (p_rec.attribute12 = hr_api.g_varchar2) then
487: p_rec.attribute12 :=
488: per_ast_shd.g_old_rec.attribute12;
489: End If;
490: If (p_rec.attribute13 = hr_api.g_varchar2) then
491: p_rec.attribute13 :=
492: per_ast_shd.g_old_rec.attribute13;

Line 492: per_ast_shd.g_old_rec.attribute13;

488: per_ast_shd.g_old_rec.attribute12;
489: End If;
490: If (p_rec.attribute13 = hr_api.g_varchar2) then
491: p_rec.attribute13 :=
492: per_ast_shd.g_old_rec.attribute13;
493: End If;
494: If (p_rec.attribute14 = hr_api.g_varchar2) then
495: p_rec.attribute14 :=
496: per_ast_shd.g_old_rec.attribute14;

Line 496: per_ast_shd.g_old_rec.attribute14;

492: per_ast_shd.g_old_rec.attribute13;
493: End If;
494: If (p_rec.attribute14 = hr_api.g_varchar2) then
495: p_rec.attribute14 :=
496: per_ast_shd.g_old_rec.attribute14;
497: End If;
498: If (p_rec.attribute15 = hr_api.g_varchar2) then
499: p_rec.attribute15 :=
500: per_ast_shd.g_old_rec.attribute15;

Line 500: per_ast_shd.g_old_rec.attribute15;

496: per_ast_shd.g_old_rec.attribute14;
497: End If;
498: If (p_rec.attribute15 = hr_api.g_varchar2) then
499: p_rec.attribute15 :=
500: per_ast_shd.g_old_rec.attribute15;
501: End If;
502: If (p_rec.attribute16 = hr_api.g_varchar2) then
503: p_rec.attribute16 :=
504: per_ast_shd.g_old_rec.attribute16;

Line 504: per_ast_shd.g_old_rec.attribute16;

500: per_ast_shd.g_old_rec.attribute15;
501: End If;
502: If (p_rec.attribute16 = hr_api.g_varchar2) then
503: p_rec.attribute16 :=
504: per_ast_shd.g_old_rec.attribute16;
505: End If;
506: If (p_rec.attribute17 = hr_api.g_varchar2) then
507: p_rec.attribute17 :=
508: per_ast_shd.g_old_rec.attribute17;

Line 508: per_ast_shd.g_old_rec.attribute17;

504: per_ast_shd.g_old_rec.attribute16;
505: End If;
506: If (p_rec.attribute17 = hr_api.g_varchar2) then
507: p_rec.attribute17 :=
508: per_ast_shd.g_old_rec.attribute17;
509: End If;
510: If (p_rec.attribute18 = hr_api.g_varchar2) then
511: p_rec.attribute18 :=
512: per_ast_shd.g_old_rec.attribute18;

Line 512: per_ast_shd.g_old_rec.attribute18;

508: per_ast_shd.g_old_rec.attribute17;
509: End If;
510: If (p_rec.attribute18 = hr_api.g_varchar2) then
511: p_rec.attribute18 :=
512: per_ast_shd.g_old_rec.attribute18;
513: End If;
514: If (p_rec.attribute19 = hr_api.g_varchar2) then
515: p_rec.attribute19 :=
516: per_ast_shd.g_old_rec.attribute19;

Line 516: per_ast_shd.g_old_rec.attribute19;

512: per_ast_shd.g_old_rec.attribute18;
513: End If;
514: If (p_rec.attribute19 = hr_api.g_varchar2) then
515: p_rec.attribute19 :=
516: per_ast_shd.g_old_rec.attribute19;
517: End If;
518: If (p_rec.attribute20 = hr_api.g_varchar2) then
519: p_rec.attribute20 :=
520: per_ast_shd.g_old_rec.attribute20;

Line 520: per_ast_shd.g_old_rec.attribute20;

516: per_ast_shd.g_old_rec.attribute19;
517: End If;
518: If (p_rec.attribute20 = hr_api.g_varchar2) then
519: p_rec.attribute20 :=
520: per_ast_shd.g_old_rec.attribute20;
521: End If;
522: If (p_rec.type = hr_api.g_varchar2) then
523: p_rec.type :=
524: per_ast_shd.g_old_rec.type;

Line 524: per_ast_shd.g_old_rec.type;

520: per_ast_shd.g_old_rec.attribute20;
521: End If;
522: If (p_rec.type = hr_api.g_varchar2) then
523: p_rec.type :=
524: per_ast_shd.g_old_rec.type;
525: End If;
526: If (p_rec.line_score_formula_id = hr_api.g_number) then
527: p_rec.line_score_formula_id :=
528: per_ast_shd.g_old_rec.line_score_formula_id;

Line 528: per_ast_shd.g_old_rec.line_score_formula_id;

524: per_ast_shd.g_old_rec.type;
525: End If;
526: If (p_rec.line_score_formula_id = hr_api.g_number) then
527: p_rec.line_score_formula_id :=
528: per_ast_shd.g_old_rec.line_score_formula_id;
529: End If;
530: If (p_rec.default_job_competencies = hr_api.g_varchar2) then
531: p_rec.default_job_competencies :=
532: per_ast_shd.g_old_rec.default_job_competencies;

Line 532: per_ast_shd.g_old_rec.default_job_competencies;

528: per_ast_shd.g_old_rec.line_score_formula_id;
529: End If;
530: If (p_rec.default_job_competencies = hr_api.g_varchar2) then
531: p_rec.default_job_competencies :=
532: per_ast_shd.g_old_rec.default_job_competencies;
533: End If;
534: If (p_rec.available_flag = hr_api.g_varchar2) then
535: p_rec.available_flag :=
536: per_ast_shd.g_old_rec.available_flag;

Line 536: per_ast_shd.g_old_rec.available_flag;

532: per_ast_shd.g_old_rec.default_job_competencies;
533: End If;
534: If (p_rec.available_flag = hr_api.g_varchar2) then
535: p_rec.available_flag :=
536: per_ast_shd.g_old_rec.available_flag;
537: End If;
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 10);
540: --

Line 548: p_rec in out nocopy per_ast_shd.g_rec_type,

544: -- |---------------------------------< upd >----------------------------------|
545: -- ----------------------------------------------------------------------------
546: Procedure upd
547: (
548: p_rec in out nocopy per_ast_shd.g_rec_type,
549: p_validate in boolean default false,
550: p_effective_date in date
551: ) is
552: --

Line 569: per_ast_shd.lck

565: End If;
566: --
567: -- We must lock the row which we need to update.
568: --
569: per_ast_shd.lck
570: (
571: p_rec.assessment_type_id,
572: p_rec.object_version_number
573: );

Line 664: l_rec per_ast_shd.g_rec_type;

660: p_validate in boolean default false,
661: p_effective_date in date
662: ) is
663: --
664: l_rec per_ast_shd.g_rec_type;
665: l_proc varchar2(72) := g_package||'upd';
666: --
667: Begin
668: hr_utility.set_location('Entering:'||l_proc, 5);

Line 677: per_ast_shd.convert_args

673: hr_utility.set_location('In Upd attrib, ass_class is :'||p_assessment_classification, 10);
674: hr_utility.set_location('In Upd attrib, comments is :'||p_comments, 10);
675: --
676: l_rec :=
677: per_ast_shd.convert_args
678: (
679: p_assessment_type_id,
680: p_name,
681: hr_api.g_number,