eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ASN_UPD dependencies on PER_ASN_SHD

Line 48: Procedure update_dml(p_rec in out nocopy per_asn_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_asn_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 101: per_asn_shd.constraint_error

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

Line 105: per_asn_shd.constraint_error

101: per_asn_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_asn_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_asn_shd.constraint_error

Line 109: per_asn_shd.constraint_error

105: per_asn_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_asn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: Raise;
113: End update_dml;

Line 147: Procedure pre_update(p_rec in per_asn_shd.g_rec_type) is

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

Line 189: Procedure post_update(p_rec in per_asn_shd.g_rec_type) is

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

Line 237: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,

233: p_attribute17 => p_rec.attribute17 ,
234: p_attribute18 => p_rec.attribute18 ,
235: p_attribute19 => p_rec.attribute19 ,
236: p_attribute20 => p_rec.attribute20 ,
237: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,
238: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
239: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
240: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
241: p_group_date_o => per_asn_shd.g_old_rec.group_date ,

Line 238: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,

234: p_attribute18 => p_rec.attribute18 ,
235: p_attribute19 => p_rec.attribute19 ,
236: p_attribute20 => p_rec.attribute20 ,
237: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,
238: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
239: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
240: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
241: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
242: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,

Line 239: p_person_id_o => per_asn_shd.g_old_rec.person_id ,

235: p_attribute19 => p_rec.attribute19 ,
236: p_attribute20 => p_rec.attribute20 ,
237: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,
238: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
239: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
240: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
241: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
242: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
243: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,

Line 240: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,

236: p_attribute20 => p_rec.attribute20 ,
237: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,
238: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
239: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
240: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
241: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
242: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
243: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
244: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,

Line 241: p_group_date_o => per_asn_shd.g_old_rec.group_date ,

237: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,
238: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
239: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
240: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
241: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
242: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
243: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
244: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
245: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,

Line 242: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,

238: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
239: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
240: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
241: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
242: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
243: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
244: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
245: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
246: p_status_o => per_asn_shd.g_old_rec.status ,

Line 243: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,

239: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
240: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
241: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
242: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
243: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
244: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
245: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
246: p_status_o => per_asn_shd.g_old_rec.status ,
247: p_assessment_period_start_da_o =>

Line 244: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,

240: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
241: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
242: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
243: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
244: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
245: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
246: p_status_o => per_asn_shd.g_old_rec.status ,
247: p_assessment_period_start_da_o =>
248: per_asn_shd.g_old_rec.assessment_period_start_date ,

Line 245: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,

241: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
242: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
243: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
244: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
245: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
246: p_status_o => per_asn_shd.g_old_rec.status ,
247: p_assessment_period_start_da_o =>
248: per_asn_shd.g_old_rec.assessment_period_start_date ,
249: p_assessment_period_end_date_o =>

Line 246: p_status_o => per_asn_shd.g_old_rec.status ,

242: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
243: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
244: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
245: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
246: p_status_o => per_asn_shd.g_old_rec.status ,
247: p_assessment_period_start_da_o =>
248: per_asn_shd.g_old_rec.assessment_period_start_date ,
249: p_assessment_period_end_date_o =>
250: per_asn_shd.g_old_rec.assessment_period_end_date ,

Line 248: per_asn_shd.g_old_rec.assessment_period_start_date ,

244: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
245: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
246: p_status_o => per_asn_shd.g_old_rec.status ,
247: p_assessment_period_start_da_o =>
248: per_asn_shd.g_old_rec.assessment_period_start_date ,
249: p_assessment_period_end_date_o =>
250: per_asn_shd.g_old_rec.assessment_period_end_date ,
251: p_comments_o => per_asn_shd.g_old_rec.comments ,
252: p_total_score_o => per_asn_shd.g_old_rec.total_score ,

Line 250: per_asn_shd.g_old_rec.assessment_period_end_date ,

246: p_status_o => per_asn_shd.g_old_rec.status ,
247: p_assessment_period_start_da_o =>
248: per_asn_shd.g_old_rec.assessment_period_start_date ,
249: p_assessment_period_end_date_o =>
250: per_asn_shd.g_old_rec.assessment_period_end_date ,
251: p_comments_o => per_asn_shd.g_old_rec.comments ,
252: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
253: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
254: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,

Line 251: p_comments_o => per_asn_shd.g_old_rec.comments ,

247: p_assessment_period_start_da_o =>
248: per_asn_shd.g_old_rec.assessment_period_start_date ,
249: p_assessment_period_end_date_o =>
250: per_asn_shd.g_old_rec.assessment_period_end_date ,
251: p_comments_o => per_asn_shd.g_old_rec.comments ,
252: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
253: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
254: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
255: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,

Line 252: p_total_score_o => per_asn_shd.g_old_rec.total_score ,

248: per_asn_shd.g_old_rec.assessment_period_start_date ,
249: p_assessment_period_end_date_o =>
250: per_asn_shd.g_old_rec.assessment_period_end_date ,
251: p_comments_o => per_asn_shd.g_old_rec.comments ,
252: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
253: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
254: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
255: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
256: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,

Line 253: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,

249: p_assessment_period_end_date_o =>
250: per_asn_shd.g_old_rec.assessment_period_end_date ,
251: p_comments_o => per_asn_shd.g_old_rec.comments ,
252: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
253: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
254: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
255: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
256: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
257: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,

Line 254: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,

250: per_asn_shd.g_old_rec.assessment_period_end_date ,
251: p_comments_o => per_asn_shd.g_old_rec.comments ,
252: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
253: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
254: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
255: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
256: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
257: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
258: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,

Line 255: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,

251: p_comments_o => per_asn_shd.g_old_rec.comments ,
252: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
253: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
254: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
255: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
256: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
257: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
258: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
259: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,

Line 256: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,

252: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
253: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
254: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
255: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
256: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
257: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
258: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
259: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
260: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,

Line 257: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,

253: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
254: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
255: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
256: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
257: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
258: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
259: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
260: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
261: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,

Line 258: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,

254: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
255: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
256: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
257: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
258: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
259: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
260: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
261: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
262: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,

Line 259: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,

255: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
256: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
257: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
258: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
259: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
260: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
261: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
262: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
263: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,

Line 260: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,

256: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
257: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
258: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
259: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
260: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
261: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
262: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
263: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
264: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,

Line 261: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,

257: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
258: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
259: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
260: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
261: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
262: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
263: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
264: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
265: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,

Line 262: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,

258: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
259: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
260: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
261: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
262: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
263: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
264: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
265: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
266: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,

Line 263: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,

259: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
260: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
261: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
262: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
263: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
264: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
265: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
266: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
267: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,

Line 264: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,

260: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
261: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
262: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
263: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
264: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
265: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
266: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
267: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
268: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,

Line 265: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,

261: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
262: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
263: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
264: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
265: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
266: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
267: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
268: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
269: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,

Line 266: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,

262: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
263: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
264: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
265: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
266: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
267: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
268: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
269: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
270: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,

Line 267: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,

263: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
264: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
265: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
266: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
267: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
268: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
269: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
270: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
271: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,

Line 268: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,

264: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
265: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
266: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
267: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
268: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
269: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
270: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
271: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
272: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,

Line 269: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,

265: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
266: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
267: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
268: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
269: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
270: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
271: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
272: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
273: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,

Line 270: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,

266: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
267: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
268: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
269: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
270: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
271: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
272: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
273: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
274: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );

Line 271: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,

267: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
268: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
269: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
270: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
271: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
272: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
273: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
274: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
275:

Line 272: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,

268: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
269: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
270: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
271: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
272: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
273: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
274: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
275:
276: exception

Line 273: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,

269: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
270: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
271: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
272: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
273: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
274: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
275:
276: exception
277: when hr_api.cannot_find_prog_unit then

Line 274: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );

270: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
271: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
272: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
273: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
274: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
275:
276: exception
277: when hr_api.cannot_find_prog_unit then
278: hr_api.cannot_find_prog_unit_error

Line 332: Procedure convert_defs(p_rec in out nocopy per_asn_shd.g_rec_type) is

328: -- Internal Table Handler Use Only.
329: --
330: -- {End Of Comments}
331: -- ----------------------------------------------------------------------------
332: Procedure convert_defs(p_rec in out nocopy per_asn_shd.g_rec_type) is
333: --
334: l_proc varchar2(72) := g_package||'convert_defs';
335: --
336: Begin

Line 347: per_asn_shd.g_old_rec.assessment_type_id;

343: -- is being used then we must set to the 'current' argument value.
344: --
345: If (p_rec.assessment_type_id = hr_api.g_number) then
346: p_rec.assessment_type_id :=
347: per_asn_shd.g_old_rec.assessment_type_id;
348: End If;
349:
350: If (p_rec.business_group_id = hr_api.g_number) then
351: p_rec.business_group_id :=

Line 352: per_asn_shd.g_old_rec.business_group_id;

348: End If;
349:
350: If (p_rec.business_group_id = hr_api.g_number) then
351: p_rec.business_group_id :=
352: per_asn_shd.g_old_rec.business_group_id;
353: End If;
354: If (p_rec.person_id = hr_api.g_number) then
355: p_rec.person_id :=
356: per_asn_shd.g_old_rec.person_id;

Line 356: per_asn_shd.g_old_rec.person_id;

352: per_asn_shd.g_old_rec.business_group_id;
353: End If;
354: If (p_rec.person_id = hr_api.g_number) then
355: p_rec.person_id :=
356: per_asn_shd.g_old_rec.person_id;
357: End If;
358: If (p_rec.assessment_group_id = hr_api.g_number) then
359: p_rec.assessment_group_id :=
360: per_asn_shd.g_old_rec.assessment_group_id;

Line 360: per_asn_shd.g_old_rec.assessment_group_id;

356: per_asn_shd.g_old_rec.person_id;
357: End If;
358: If (p_rec.assessment_group_id = hr_api.g_number) then
359: p_rec.assessment_group_id :=
360: per_asn_shd.g_old_rec.assessment_group_id;
361: End If;
362: If (p_rec.assessment_period_start_date = hr_api.g_date) then
363: p_rec.assessment_period_start_date :=
364: per_asn_shd.g_old_rec.assessment_period_start_date;

Line 364: per_asn_shd.g_old_rec.assessment_period_start_date;

360: per_asn_shd.g_old_rec.assessment_group_id;
361: End If;
362: If (p_rec.assessment_period_start_date = hr_api.g_date) then
363: p_rec.assessment_period_start_date :=
364: per_asn_shd.g_old_rec.assessment_period_start_date;
365: End If;
366: If (p_rec.assessment_period_end_date = hr_api.g_date) then
367: p_rec.assessment_period_end_date :=
368: per_asn_shd.g_old_rec.assessment_period_end_date;

Line 368: per_asn_shd.g_old_rec.assessment_period_end_date;

364: per_asn_shd.g_old_rec.assessment_period_start_date;
365: End If;
366: If (p_rec.assessment_period_end_date = hr_api.g_date) then
367: p_rec.assessment_period_end_date :=
368: per_asn_shd.g_old_rec.assessment_period_end_date;
369: End If;
370: If (p_rec.assessment_date = hr_api.g_date) then
371: p_rec.assessment_date :=
372: per_asn_shd.g_old_rec.assessment_date;

Line 372: per_asn_shd.g_old_rec.assessment_date;

368: per_asn_shd.g_old_rec.assessment_period_end_date;
369: End If;
370: If (p_rec.assessment_date = hr_api.g_date) then
371: p_rec.assessment_date :=
372: per_asn_shd.g_old_rec.assessment_date;
373: End If;
374: If (p_rec.assessor_person_id = hr_api.g_number) then
375: p_rec.assessor_person_id :=
376: per_asn_shd.g_old_rec.assessor_person_id;

Line 376: per_asn_shd.g_old_rec.assessor_person_id;

372: per_asn_shd.g_old_rec.assessment_date;
373: End If;
374: If (p_rec.assessor_person_id = hr_api.g_number) then
375: p_rec.assessor_person_id :=
376: per_asn_shd.g_old_rec.assessor_person_id;
377: End If;
378: If (p_rec.comments = hr_api.g_varchar2) then
379: p_rec.comments :=
380: per_asn_shd.g_old_rec.comments;

Line 380: per_asn_shd.g_old_rec.comments;

376: per_asn_shd.g_old_rec.assessor_person_id;
377: End If;
378: If (p_rec.comments = hr_api.g_varchar2) then
379: p_rec.comments :=
380: per_asn_shd.g_old_rec.comments;
381: End If;
382: If (p_rec.total_score = hr_api.g_number) then
383: p_rec.total_score :=
384: per_asn_shd.g_old_rec.total_score;

Line 384: per_asn_shd.g_old_rec.total_score;

380: per_asn_shd.g_old_rec.comments;
381: End If;
382: If (p_rec.total_score = hr_api.g_number) then
383: p_rec.total_score :=
384: per_asn_shd.g_old_rec.total_score;
385: End If;
386: If (p_rec.status = hr_api.g_varchar2) then
387: p_rec.status :=
388: per_asn_shd.g_old_rec.status;

Line 388: per_asn_shd.g_old_rec.status;

384: per_asn_shd.g_old_rec.total_score;
385: End If;
386: If (p_rec.status = hr_api.g_varchar2) then
387: p_rec.status :=
388: per_asn_shd.g_old_rec.status;
389: End If;
390: If (p_rec.attribute_category = hr_api.g_varchar2) then
391: p_rec.attribute_category :=
392: per_asn_shd.g_old_rec.attribute_category;

Line 392: per_asn_shd.g_old_rec.attribute_category;

388: per_asn_shd.g_old_rec.status;
389: End If;
390: If (p_rec.attribute_category = hr_api.g_varchar2) then
391: p_rec.attribute_category :=
392: per_asn_shd.g_old_rec.attribute_category;
393: End If;
394: If (p_rec.attribute1 = hr_api.g_varchar2) then
395: p_rec.attribute1 :=
396: per_asn_shd.g_old_rec.attribute1;

Line 396: per_asn_shd.g_old_rec.attribute1;

392: per_asn_shd.g_old_rec.attribute_category;
393: End If;
394: If (p_rec.attribute1 = hr_api.g_varchar2) then
395: p_rec.attribute1 :=
396: per_asn_shd.g_old_rec.attribute1;
397: End If;
398: If (p_rec.attribute2 = hr_api.g_varchar2) then
399: p_rec.attribute2 :=
400: per_asn_shd.g_old_rec.attribute2;

Line 400: per_asn_shd.g_old_rec.attribute2;

396: per_asn_shd.g_old_rec.attribute1;
397: End If;
398: If (p_rec.attribute2 = hr_api.g_varchar2) then
399: p_rec.attribute2 :=
400: per_asn_shd.g_old_rec.attribute2;
401: End If;
402: If (p_rec.attribute3 = hr_api.g_varchar2) then
403: p_rec.attribute3 :=
404: per_asn_shd.g_old_rec.attribute3;

Line 404: per_asn_shd.g_old_rec.attribute3;

400: per_asn_shd.g_old_rec.attribute2;
401: End If;
402: If (p_rec.attribute3 = hr_api.g_varchar2) then
403: p_rec.attribute3 :=
404: per_asn_shd.g_old_rec.attribute3;
405: End If;
406: If (p_rec.attribute4 = hr_api.g_varchar2) then
407: p_rec.attribute4 :=
408: per_asn_shd.g_old_rec.attribute4;

Line 408: per_asn_shd.g_old_rec.attribute4;

404: per_asn_shd.g_old_rec.attribute3;
405: End If;
406: If (p_rec.attribute4 = hr_api.g_varchar2) then
407: p_rec.attribute4 :=
408: per_asn_shd.g_old_rec.attribute4;
409: End If;
410: If (p_rec.attribute5 = hr_api.g_varchar2) then
411: p_rec.attribute5 :=
412: per_asn_shd.g_old_rec.attribute5;

Line 412: per_asn_shd.g_old_rec.attribute5;

408: per_asn_shd.g_old_rec.attribute4;
409: End If;
410: If (p_rec.attribute5 = hr_api.g_varchar2) then
411: p_rec.attribute5 :=
412: per_asn_shd.g_old_rec.attribute5;
413: End If;
414: If (p_rec.attribute6 = hr_api.g_varchar2) then
415: p_rec.attribute6 :=
416: per_asn_shd.g_old_rec.attribute6;

Line 416: per_asn_shd.g_old_rec.attribute6;

412: per_asn_shd.g_old_rec.attribute5;
413: End If;
414: If (p_rec.attribute6 = hr_api.g_varchar2) then
415: p_rec.attribute6 :=
416: per_asn_shd.g_old_rec.attribute6;
417: End If;
418: If (p_rec.attribute7 = hr_api.g_varchar2) then
419: p_rec.attribute7 :=
420: per_asn_shd.g_old_rec.attribute7;

Line 420: per_asn_shd.g_old_rec.attribute7;

416: per_asn_shd.g_old_rec.attribute6;
417: End If;
418: If (p_rec.attribute7 = hr_api.g_varchar2) then
419: p_rec.attribute7 :=
420: per_asn_shd.g_old_rec.attribute7;
421: End If;
422: If (p_rec.attribute8 = hr_api.g_varchar2) then
423: p_rec.attribute8 :=
424: per_asn_shd.g_old_rec.attribute8;

Line 424: per_asn_shd.g_old_rec.attribute8;

420: per_asn_shd.g_old_rec.attribute7;
421: End If;
422: If (p_rec.attribute8 = hr_api.g_varchar2) then
423: p_rec.attribute8 :=
424: per_asn_shd.g_old_rec.attribute8;
425: End If;
426: If (p_rec.attribute9 = hr_api.g_varchar2) then
427: p_rec.attribute9 :=
428: per_asn_shd.g_old_rec.attribute9;

Line 428: per_asn_shd.g_old_rec.attribute9;

424: per_asn_shd.g_old_rec.attribute8;
425: End If;
426: If (p_rec.attribute9 = hr_api.g_varchar2) then
427: p_rec.attribute9 :=
428: per_asn_shd.g_old_rec.attribute9;
429: End If;
430: If (p_rec.attribute10 = hr_api.g_varchar2) then
431: p_rec.attribute10 :=
432: per_asn_shd.g_old_rec.attribute10;

Line 432: per_asn_shd.g_old_rec.attribute10;

428: per_asn_shd.g_old_rec.attribute9;
429: End If;
430: If (p_rec.attribute10 = hr_api.g_varchar2) then
431: p_rec.attribute10 :=
432: per_asn_shd.g_old_rec.attribute10;
433: End If;
434: If (p_rec.attribute11 = hr_api.g_varchar2) then
435: p_rec.attribute11 :=
436: per_asn_shd.g_old_rec.attribute11;

Line 436: per_asn_shd.g_old_rec.attribute11;

432: per_asn_shd.g_old_rec.attribute10;
433: End If;
434: If (p_rec.attribute11 = hr_api.g_varchar2) then
435: p_rec.attribute11 :=
436: per_asn_shd.g_old_rec.attribute11;
437: End If;
438: If (p_rec.attribute12 = hr_api.g_varchar2) then
439: p_rec.attribute12 :=
440: per_asn_shd.g_old_rec.attribute12;

Line 440: per_asn_shd.g_old_rec.attribute12;

436: per_asn_shd.g_old_rec.attribute11;
437: End If;
438: If (p_rec.attribute12 = hr_api.g_varchar2) then
439: p_rec.attribute12 :=
440: per_asn_shd.g_old_rec.attribute12;
441: End If;
442: If (p_rec.attribute13 = hr_api.g_varchar2) then
443: p_rec.attribute13 :=
444: per_asn_shd.g_old_rec.attribute13;

Line 444: per_asn_shd.g_old_rec.attribute13;

440: per_asn_shd.g_old_rec.attribute12;
441: End If;
442: If (p_rec.attribute13 = hr_api.g_varchar2) then
443: p_rec.attribute13 :=
444: per_asn_shd.g_old_rec.attribute13;
445: End If;
446: If (p_rec.attribute14 = hr_api.g_varchar2) then
447: p_rec.attribute14 :=
448: per_asn_shd.g_old_rec.attribute14;

Line 448: per_asn_shd.g_old_rec.attribute14;

444: per_asn_shd.g_old_rec.attribute13;
445: End If;
446: If (p_rec.attribute14 = hr_api.g_varchar2) then
447: p_rec.attribute14 :=
448: per_asn_shd.g_old_rec.attribute14;
449: End If;
450: If (p_rec.attribute15 = hr_api.g_varchar2) then
451: p_rec.attribute15 :=
452: per_asn_shd.g_old_rec.attribute15;

Line 452: per_asn_shd.g_old_rec.attribute15;

448: per_asn_shd.g_old_rec.attribute14;
449: End If;
450: If (p_rec.attribute15 = hr_api.g_varchar2) then
451: p_rec.attribute15 :=
452: per_asn_shd.g_old_rec.attribute15;
453: End If;
454: If (p_rec.attribute16 = hr_api.g_varchar2) then
455: p_rec.attribute16 :=
456: per_asn_shd.g_old_rec.attribute16;

Line 456: per_asn_shd.g_old_rec.attribute16;

452: per_asn_shd.g_old_rec.attribute15;
453: End If;
454: If (p_rec.attribute16 = hr_api.g_varchar2) then
455: p_rec.attribute16 :=
456: per_asn_shd.g_old_rec.attribute16;
457: End If;
458: If (p_rec.attribute17 = hr_api.g_varchar2) then
459: p_rec.attribute17 :=
460: per_asn_shd.g_old_rec.attribute17;

Line 460: per_asn_shd.g_old_rec.attribute17;

456: per_asn_shd.g_old_rec.attribute16;
457: End If;
458: If (p_rec.attribute17 = hr_api.g_varchar2) then
459: p_rec.attribute17 :=
460: per_asn_shd.g_old_rec.attribute17;
461: End If;
462: If (p_rec.attribute18 = hr_api.g_varchar2) then
463: p_rec.attribute18 :=
464: per_asn_shd.g_old_rec.attribute18;

Line 464: per_asn_shd.g_old_rec.attribute18;

460: per_asn_shd.g_old_rec.attribute17;
461: End If;
462: If (p_rec.attribute18 = hr_api.g_varchar2) then
463: p_rec.attribute18 :=
464: per_asn_shd.g_old_rec.attribute18;
465: End If;
466: If (p_rec.attribute19 = hr_api.g_varchar2) then
467: p_rec.attribute19 :=
468: per_asn_shd.g_old_rec.attribute19;

Line 468: per_asn_shd.g_old_rec.attribute19;

464: per_asn_shd.g_old_rec.attribute18;
465: End If;
466: If (p_rec.attribute19 = hr_api.g_varchar2) then
467: p_rec.attribute19 :=
468: per_asn_shd.g_old_rec.attribute19;
469: End If;
470: If (p_rec.attribute20 = hr_api.g_varchar2) then
471: p_rec.attribute20 :=
472: per_asn_shd.g_old_rec.attribute20;

Line 472: per_asn_shd.g_old_rec.attribute20;

468: per_asn_shd.g_old_rec.attribute19;
469: End If;
470: If (p_rec.attribute20 = hr_api.g_varchar2) then
471: p_rec.attribute20 :=
472: per_asn_shd.g_old_rec.attribute20;
473: End If;
474:
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 484: (p_rec in out nocopy per_asn_shd.g_rec_type

480: -- ----------------------------------------------------------------------------
481: -- |---------------------------------< upd >----------------------------------|
482: -- ----------------------------------------------------------------------------
483: Procedure upd
484: (p_rec in out nocopy per_asn_shd.g_rec_type
485: ,p_validate in boolean default false
486: ,p_effective_date in date
487: ) is
488: --

Line 505: per_asn_shd.lck

501: End If;
502: --
503: -- We must lock the row which we need to update.
504: --
505: per_asn_shd.lck
506: (
507: p_rec.assessment_id,
508: p_rec.object_version_number
509: );

Line 596: l_rec per_asn_shd.g_rec_type;

592: p_validate in boolean default false,
593: p_effective_date in date
594: ) is
595: --
596: l_rec per_asn_shd.g_rec_type;
597: l_proc varchar2(72) := g_package||'upd';
598: --
599: Begin
600: hr_utility.set_location('Entering:'||l_proc, 5);

Line 606: per_asn_shd.convert_args

602: -- Call conversion function to turn arguments into the
603: -- l_rec structure.
604: --
605: l_rec :=
606: per_asn_shd.convert_args
607: (
608: p_assessment_id,
609: p_assessment_type_id,
610: hr_api.g_number,