APPS.PER_AST_DEL dependencies on PER_AST_SHD

Line 45: Procedure delete_dml(p_rec in per_ast_shd.g_rec_type) is

41: -- Internal Table Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in per_ast_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 89: per_ast_shd.constraint_error

85: --
86: Exception
87: When hr_api.child_integrity_violated then
88: -- Child integrity has been violated
89: per_ast_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then
92: Raise;
93: End delete_dml;

Line 127: Procedure pre_delete(p_rec in per_ast_shd.g_rec_type) is

123: -- Internal Table Handler Use Only.
124: --
125: -- {End Of Comments}
126: -- ----------------------------------------------------------------------------
127: Procedure pre_delete(p_rec in per_ast_shd.g_rec_type) is
128: --
129: l_proc varchar2(72) := g_package||'pre_delete';
130: --
131: Begin

Line 169: Procedure post_delete(p_rec in per_ast_shd.g_rec_type) is

165: -- Internal table Handler Use Only.
166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure post_delete(p_rec in per_ast_shd.g_rec_type) is
170: --
171: l_proc varchar2(72) := g_package||'post_delete';
172: --
173: Begin

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

177: --
178: begin
179: per_ast_rkd.after_delete (
180: p_assessment_type_id => p_rec.assessment_type_id ,
181: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
182: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number,
183: p_name_o => per_ast_shd.g_old_rec.name ,
184: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
185: p_date_from_o => per_ast_shd.g_old_rec.date_from ,

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

178: begin
179: per_ast_rkd.after_delete (
180: p_assessment_type_id => p_rec.assessment_type_id ,
181: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
182: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number,
183: p_name_o => per_ast_shd.g_old_rec.name ,
184: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
185: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
186: p_assessment_classification_o =>

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

179: per_ast_rkd.after_delete (
180: p_assessment_type_id => p_rec.assessment_type_id ,
181: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
182: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number,
183: p_name_o => per_ast_shd.g_old_rec.name ,
184: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
185: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
186: p_assessment_classification_o =>
187: per_ast_shd.g_old_rec.assessment_classification ,

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

180: p_assessment_type_id => p_rec.assessment_type_id ,
181: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
182: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number,
183: p_name_o => per_ast_shd.g_old_rec.name ,
184: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
185: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
186: p_assessment_classification_o =>
187: per_ast_shd.g_old_rec.assessment_classification ,
188: p_display_assessment_comment_o =>

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

181: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
182: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number,
183: p_name_o => per_ast_shd.g_old_rec.name ,
184: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
185: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
186: p_assessment_classification_o =>
187: per_ast_shd.g_old_rec.assessment_classification ,
188: p_display_assessment_comment_o =>
189: per_ast_shd.g_old_rec.display_assessment_comments,

Line 187: per_ast_shd.g_old_rec.assessment_classification ,

183: p_name_o => per_ast_shd.g_old_rec.name ,
184: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
185: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
186: p_assessment_classification_o =>
187: per_ast_shd.g_old_rec.assessment_classification ,
188: p_display_assessment_comment_o =>
189: per_ast_shd.g_old_rec.display_assessment_comments,
190: p_description_o => per_ast_shd.g_old_rec.description ,
191: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment,

Line 189: per_ast_shd.g_old_rec.display_assessment_comments,

185: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
186: p_assessment_classification_o =>
187: per_ast_shd.g_old_rec.assessment_classification ,
188: p_display_assessment_comment_o =>
189: per_ast_shd.g_old_rec.display_assessment_comments,
190: p_description_o => per_ast_shd.g_old_rec.description ,
191: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment,
192: p_weighting_scale_comment_o =>
193: per_ast_shd.g_old_rec.weighting_scale_comment ,

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

186: p_assessment_classification_o =>
187: per_ast_shd.g_old_rec.assessment_classification ,
188: p_display_assessment_comment_o =>
189: per_ast_shd.g_old_rec.display_assessment_comments,
190: p_description_o => per_ast_shd.g_old_rec.description ,
191: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment,
192: p_weighting_scale_comment_o =>
193: per_ast_shd.g_old_rec.weighting_scale_comment ,
194: p_comments_o => per_ast_shd.g_old_rec.comments ,

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

187: per_ast_shd.g_old_rec.assessment_classification ,
188: p_display_assessment_comment_o =>
189: per_ast_shd.g_old_rec.display_assessment_comments,
190: p_description_o => per_ast_shd.g_old_rec.description ,
191: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment,
192: p_weighting_scale_comment_o =>
193: per_ast_shd.g_old_rec.weighting_scale_comment ,
194: p_comments_o => per_ast_shd.g_old_rec.comments ,
195: p_instructions_o => per_ast_shd.g_old_rec.instructions ,

Line 193: per_ast_shd.g_old_rec.weighting_scale_comment ,

189: per_ast_shd.g_old_rec.display_assessment_comments,
190: p_description_o => per_ast_shd.g_old_rec.description ,
191: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment,
192: p_weighting_scale_comment_o =>
193: per_ast_shd.g_old_rec.weighting_scale_comment ,
194: p_comments_o => per_ast_shd.g_old_rec.comments ,
195: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
196: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
197: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,

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

190: p_description_o => per_ast_shd.g_old_rec.description ,
191: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment,
192: p_weighting_scale_comment_o =>
193: per_ast_shd.g_old_rec.weighting_scale_comment ,
194: p_comments_o => per_ast_shd.g_old_rec.comments ,
195: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
196: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
197: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
198: p_weighting_classification_o =>

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

191: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment,
192: p_weighting_scale_comment_o =>
193: per_ast_shd.g_old_rec.weighting_scale_comment ,
194: p_comments_o => per_ast_shd.g_old_rec.comments ,
195: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
196: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
197: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
198: p_weighting_classification_o =>
199: per_ast_shd.g_old_rec.weighting_classification ,

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

192: p_weighting_scale_comment_o =>
193: per_ast_shd.g_old_rec.weighting_scale_comment ,
194: p_comments_o => per_ast_shd.g_old_rec.comments ,
195: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
196: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
197: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
198: p_weighting_classification_o =>
199: per_ast_shd.g_old_rec.weighting_classification ,
200: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,

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

193: per_ast_shd.g_old_rec.weighting_scale_comment ,
194: p_comments_o => per_ast_shd.g_old_rec.comments ,
195: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
196: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
197: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
198: p_weighting_classification_o =>
199: per_ast_shd.g_old_rec.weighting_classification ,
200: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
201: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,

Line 199: per_ast_shd.g_old_rec.weighting_classification ,

195: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
196: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
197: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
198: p_weighting_classification_o =>
199: per_ast_shd.g_old_rec.weighting_classification ,
200: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
201: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
202: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
203: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,

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

196: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
197: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
198: p_weighting_classification_o =>
199: per_ast_shd.g_old_rec.weighting_classification ,
200: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
201: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
202: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
203: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
204: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,

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

197: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
198: p_weighting_classification_o =>
199: per_ast_shd.g_old_rec.weighting_classification ,
200: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
201: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
202: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
203: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
204: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
205: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,

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

198: p_weighting_classification_o =>
199: per_ast_shd.g_old_rec.weighting_classification ,
200: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
201: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
202: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
203: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
204: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
205: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
206: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,

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

199: per_ast_shd.g_old_rec.weighting_classification ,
200: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
201: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
202: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
203: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
204: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
205: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
206: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
207: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,

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

200: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
201: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
202: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
203: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
204: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
205: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
206: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
207: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
208: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,

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

201: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
202: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
203: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
204: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
205: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
206: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
207: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
208: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
209: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,

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

202: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
203: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
204: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
205: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
206: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
207: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
208: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
209: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
210: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,

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

203: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
204: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
205: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
206: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
207: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
208: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
209: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
210: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
211: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,

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

204: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
205: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
206: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
207: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
208: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
209: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
210: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
211: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
212: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,

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

205: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
206: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
207: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
208: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
209: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
210: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
211: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
212: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
213: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,

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

206: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
207: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
208: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
209: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
210: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
211: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
212: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
213: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
214: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,

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

207: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
208: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
209: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
210: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
211: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
212: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
213: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
214: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
215: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,

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

208: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
209: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
210: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
211: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
212: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
213: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
214: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
215: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
216: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,

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

209: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
210: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
211: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
212: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
213: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
214: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
215: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
216: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
217: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,

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

210: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
211: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
212: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
213: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
214: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
215: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
216: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
217: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
218: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,

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

211: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
212: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
213: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
214: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
215: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
216: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
217: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
218: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
219: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,

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

212: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
213: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
214: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
215: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
216: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
217: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
218: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
219: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
220: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,

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

213: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
214: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
215: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
216: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
217: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
218: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
219: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
220: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
221: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,

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

214: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
215: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
216: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
217: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
218: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
219: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
220: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
221: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
222: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,

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

215: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
216: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
217: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
218: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
219: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
220: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
221: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
222: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
223: p_type_o => per_ast_shd.g_old_rec.type,

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

216: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
217: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
218: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
219: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
220: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
221: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
222: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
223: p_type_o => per_ast_shd.g_old_rec.type,
224: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,

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

217: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
218: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
219: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
220: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
221: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
222: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
223: p_type_o => per_ast_shd.g_old_rec.type,
224: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
225: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,

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

218: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
219: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
220: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
221: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
222: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
223: p_type_o => per_ast_shd.g_old_rec.type,
224: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
225: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
226: p_available_flag_o => per_ast_shd.g_old_rec.available_flag);

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

219: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
220: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
221: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
222: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
223: p_type_o => per_ast_shd.g_old_rec.type,
224: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
225: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
226: p_available_flag_o => per_ast_shd.g_old_rec.available_flag);
227: exception

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

220: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
221: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
222: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
223: p_type_o => per_ast_shd.g_old_rec.type,
224: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
225: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
226: p_available_flag_o => per_ast_shd.g_old_rec.available_flag);
227: exception
228: when hr_api.cannot_find_prog_unit then

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

221: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
222: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
223: p_type_o => per_ast_shd.g_old_rec.type,
224: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
225: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
226: p_available_flag_o => per_ast_shd.g_old_rec.available_flag);
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error

Line 226: p_available_flag_o => per_ast_shd.g_old_rec.available_flag);

222: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
223: p_type_o => per_ast_shd.g_old_rec.type,
224: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
225: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
226: p_available_flag_o => per_ast_shd.g_old_rec.available_flag);
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: ( p_module_name => 'PER_ASSESSMENT_TYPES'

Line 244: p_rec in per_ast_shd.g_rec_type,

240: -- |---------------------------------< del >----------------------------------|
241: -- ----------------------------------------------------------------------------
242: Procedure del
243: (
244: p_rec in per_ast_shd.g_rec_type,
245: p_validate in boolean default false
246: ) is
247: --
248: l_proc varchar2(72) := g_package||'del';

Line 264: per_ast_shd.lck

260: End If;
261: --
262: -- We must lock the row which we need to delete.
263: --
264: per_ast_shd.lck
265: (
266: p_rec.assessment_type_id,
267: p_rec.object_version_number
268: );

Line 312: l_rec per_ast_shd.g_rec_type;

308: p_object_version_number in number,
309: p_validate in boolean default false
310: ) is
311: --
312: l_rec per_ast_shd.g_rec_type;
313: l_proc varchar2(72) := g_package||'del';
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);