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_ASR_UPD dependencies on PER_ASR_SHD

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

Line 96: per_asr_shd.constraint_error

92: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: per_asr_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: per_asr_shd.constraint_error

Line 100: per_asr_shd.constraint_error

96: per_asr_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: per_asr_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: per_asr_shd.constraint_error

Line 104: per_asr_shd.constraint_error

100: per_asr_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: per_asr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then
107: Raise;
108: End update_dml;

Line 142: Procedure pre_update(p_rec in per_asr_shd.g_rec_type) is

138: -- Internal Table Handler Use Only.
139: --
140: -- {End Of Comments}
141: -- ----------------------------------------------------------------------------
142: Procedure pre_update(p_rec in per_asr_shd.g_rec_type) is
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --
146: Begin

Line 184: Procedure post_update(p_rec in per_asr_shd.g_rec_type) is

180: -- Internal Table Handler Use Only.
181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure post_update(p_rec in per_asr_shd.g_rec_type) is
185: --
186: l_proc varchar2(72) := g_package||'post_update';
187: --
188: Begin

Line 222: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,

218: p_attribute17 => p_rec.attribute17 ,
219: p_attribute18 => p_rec.attribute18 ,
220: p_attribute19 => p_rec.attribute19 ,
221: p_attribute20 => p_rec.attribute20 ,
222: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,
223: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
224: p_name_o => per_asr_shd.g_old_rec.name ,
225: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
226: p_comments_o => per_asr_shd.g_old_rec.comments ,

Line 223: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,

219: p_attribute18 => p_rec.attribute18 ,
220: p_attribute19 => p_rec.attribute19 ,
221: p_attribute20 => p_rec.attribute20 ,
222: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,
223: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
224: p_name_o => per_asr_shd.g_old_rec.name ,
225: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
226: p_comments_o => per_asr_shd.g_old_rec.comments ,
227: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,

Line 224: p_name_o => per_asr_shd.g_old_rec.name ,

220: p_attribute19 => p_rec.attribute19 ,
221: p_attribute20 => p_rec.attribute20 ,
222: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,
223: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
224: p_name_o => per_asr_shd.g_old_rec.name ,
225: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
226: p_comments_o => per_asr_shd.g_old_rec.comments ,
227: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
228: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,

Line 225: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,

221: p_attribute20 => p_rec.attribute20 ,
222: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,
223: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
224: p_name_o => per_asr_shd.g_old_rec.name ,
225: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
226: p_comments_o => per_asr_shd.g_old_rec.comments ,
227: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
228: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
229: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,

Line 226: p_comments_o => per_asr_shd.g_old_rec.comments ,

222: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,
223: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
224: p_name_o => per_asr_shd.g_old_rec.name ,
225: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
226: p_comments_o => per_asr_shd.g_old_rec.comments ,
227: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
228: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
229: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
230: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,

Line 227: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,

223: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
224: p_name_o => per_asr_shd.g_old_rec.name ,
225: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
226: p_comments_o => per_asr_shd.g_old_rec.comments ,
227: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
228: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
229: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
230: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
231: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,

Line 228: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,

224: p_name_o => per_asr_shd.g_old_rec.name ,
225: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
226: p_comments_o => per_asr_shd.g_old_rec.comments ,
227: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
228: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
229: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
230: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
231: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
232: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,

Line 229: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,

225: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
226: p_comments_o => per_asr_shd.g_old_rec.comments ,
227: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
228: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
229: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
230: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
231: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
232: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
233: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,

Line 230: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,

226: p_comments_o => per_asr_shd.g_old_rec.comments ,
227: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
228: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
229: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
230: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
231: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
232: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
233: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
234: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,

Line 231: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,

227: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
228: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
229: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
230: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
231: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
232: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
233: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
234: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
235: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,

Line 232: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,

228: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
229: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
230: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
231: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
232: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
233: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
234: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
235: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
236: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,

Line 233: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,

229: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
230: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
231: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
232: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
233: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
234: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
235: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
236: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
237: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,

Line 234: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,

230: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
231: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
232: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
233: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
234: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
235: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
236: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
237: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
238: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,

Line 235: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,

231: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
232: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
233: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
234: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
235: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
236: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
237: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
238: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
239: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,

Line 236: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,

232: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
233: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
234: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
235: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
236: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
237: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
238: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
239: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
240: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,

Line 237: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,

233: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
234: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
235: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
236: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
237: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
238: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
239: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
240: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
241: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,

Line 238: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,

234: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
235: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
236: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
237: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
238: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
239: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
240: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
241: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
242: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,

Line 239: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,

235: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
236: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
237: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
238: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
239: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
240: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
241: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
242: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
243: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,

Line 240: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,

236: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
237: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
238: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
239: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
240: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
241: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
242: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
243: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
244: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,

Line 241: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,

237: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
238: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
239: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
240: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
241: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
242: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
243: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
244: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
245: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,

Line 242: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,

238: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
239: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
240: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
241: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
242: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
243: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
244: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
245: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
246: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,

Line 243: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,

239: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
240: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
241: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
242: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
243: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
244: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
245: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
246: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
247: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );

Line 244: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,

240: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
241: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
242: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
243: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
244: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
245: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
246: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
247: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );
248: exception

Line 245: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,

241: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
242: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
243: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
244: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
245: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
246: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
247: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );
248: exception
249: when hr_api.cannot_find_prog_unit then

Line 246: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,

242: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
243: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
244: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
245: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
246: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
247: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );
248: exception
249: when hr_api.cannot_find_prog_unit then
250: hr_api.cannot_find_prog_unit_error

Line 247: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );

243: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
244: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
245: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
246: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
247: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );
248: exception
249: when hr_api.cannot_find_prog_unit then
250: hr_api.cannot_find_prog_unit_error
251: ( p_module_name => 'PER_ASSESSMENT_GROUPS'

Line 304: Procedure convert_defs(p_rec in out per_asr_shd.g_rec_type) is

300: -- Internal Table Handler Use Only.
301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure convert_defs(p_rec in out per_asr_shd.g_rec_type) is
305: --
306: l_proc varchar2(72) := g_package||'convert_defs';
307: --
308: Begin

Line 319: per_asr_shd.g_old_rec.name;

315: -- is being used then we must set to the 'current' argument value.
316: --
317: If (p_rec.name = hr_api.g_varchar2) then
318: p_rec.name :=
319: per_asr_shd.g_old_rec.name;
320: End If;
321: If (p_rec.business_group_id = hr_api.g_number) then
322: p_rec.business_group_id :=
323: per_asr_shd.g_old_rec.business_group_id;

Line 323: per_asr_shd.g_old_rec.business_group_id;

319: per_asr_shd.g_old_rec.name;
320: End If;
321: If (p_rec.business_group_id = hr_api.g_number) then
322: p_rec.business_group_id :=
323: per_asr_shd.g_old_rec.business_group_id;
324: End If;
325: If (p_rec.membership_list = hr_api.g_varchar2) then
326: p_rec.membership_list :=
327: per_asr_shd.g_old_rec.membership_list;

Line 327: per_asr_shd.g_old_rec.membership_list;

323: per_asr_shd.g_old_rec.business_group_id;
324: End If;
325: If (p_rec.membership_list = hr_api.g_varchar2) then
326: p_rec.membership_list :=
327: per_asr_shd.g_old_rec.membership_list;
328: End If;
329: If (p_rec.comments = hr_api.g_varchar2) then
330: p_rec.comments :=
331: per_asr_shd.g_old_rec.comments;

Line 331: per_asr_shd.g_old_rec.comments;

327: per_asr_shd.g_old_rec.membership_list;
328: End If;
329: If (p_rec.comments = hr_api.g_varchar2) then
330: p_rec.comments :=
331: per_asr_shd.g_old_rec.comments;
332: End If;
333: If (p_rec.attribute_category = hr_api.g_varchar2) then
334: p_rec.attribute_category :=
335: per_asr_shd.g_old_rec.attribute_category;

Line 335: per_asr_shd.g_old_rec.attribute_category;

331: per_asr_shd.g_old_rec.comments;
332: End If;
333: If (p_rec.attribute_category = hr_api.g_varchar2) then
334: p_rec.attribute_category :=
335: per_asr_shd.g_old_rec.attribute_category;
336: End If;
337: If (p_rec.attribute1 = hr_api.g_varchar2) then
338: p_rec.attribute1 :=
339: per_asr_shd.g_old_rec.attribute1;

Line 339: per_asr_shd.g_old_rec.attribute1;

335: per_asr_shd.g_old_rec.attribute_category;
336: End If;
337: If (p_rec.attribute1 = hr_api.g_varchar2) then
338: p_rec.attribute1 :=
339: per_asr_shd.g_old_rec.attribute1;
340: End If;
341: If (p_rec.attribute2 = hr_api.g_varchar2) then
342: p_rec.attribute2 :=
343: per_asr_shd.g_old_rec.attribute2;

Line 343: per_asr_shd.g_old_rec.attribute2;

339: per_asr_shd.g_old_rec.attribute1;
340: End If;
341: If (p_rec.attribute2 = hr_api.g_varchar2) then
342: p_rec.attribute2 :=
343: per_asr_shd.g_old_rec.attribute2;
344: End If;
345: If (p_rec.attribute3 = hr_api.g_varchar2) then
346: p_rec.attribute3 :=
347: per_asr_shd.g_old_rec.attribute3;

Line 347: per_asr_shd.g_old_rec.attribute3;

343: per_asr_shd.g_old_rec.attribute2;
344: End If;
345: If (p_rec.attribute3 = hr_api.g_varchar2) then
346: p_rec.attribute3 :=
347: per_asr_shd.g_old_rec.attribute3;
348: End If;
349: If (p_rec.attribute4 = hr_api.g_varchar2) then
350: p_rec.attribute4 :=
351: per_asr_shd.g_old_rec.attribute4;

Line 351: per_asr_shd.g_old_rec.attribute4;

347: per_asr_shd.g_old_rec.attribute3;
348: End If;
349: If (p_rec.attribute4 = hr_api.g_varchar2) then
350: p_rec.attribute4 :=
351: per_asr_shd.g_old_rec.attribute4;
352: End If;
353: If (p_rec.attribute5 = hr_api.g_varchar2) then
354: p_rec.attribute5 :=
355: per_asr_shd.g_old_rec.attribute5;

Line 355: per_asr_shd.g_old_rec.attribute5;

351: per_asr_shd.g_old_rec.attribute4;
352: End If;
353: If (p_rec.attribute5 = hr_api.g_varchar2) then
354: p_rec.attribute5 :=
355: per_asr_shd.g_old_rec.attribute5;
356: End If;
357: If (p_rec.attribute6 = hr_api.g_varchar2) then
358: p_rec.attribute6 :=
359: per_asr_shd.g_old_rec.attribute6;

Line 359: per_asr_shd.g_old_rec.attribute6;

355: per_asr_shd.g_old_rec.attribute5;
356: End If;
357: If (p_rec.attribute6 = hr_api.g_varchar2) then
358: p_rec.attribute6 :=
359: per_asr_shd.g_old_rec.attribute6;
360: End If;
361: If (p_rec.attribute7 = hr_api.g_varchar2) then
362: p_rec.attribute7 :=
363: per_asr_shd.g_old_rec.attribute7;

Line 363: per_asr_shd.g_old_rec.attribute7;

359: per_asr_shd.g_old_rec.attribute6;
360: End If;
361: If (p_rec.attribute7 = hr_api.g_varchar2) then
362: p_rec.attribute7 :=
363: per_asr_shd.g_old_rec.attribute7;
364: End If;
365: If (p_rec.attribute8 = hr_api.g_varchar2) then
366: p_rec.attribute8 :=
367: per_asr_shd.g_old_rec.attribute8;

Line 367: per_asr_shd.g_old_rec.attribute8;

363: per_asr_shd.g_old_rec.attribute7;
364: End If;
365: If (p_rec.attribute8 = hr_api.g_varchar2) then
366: p_rec.attribute8 :=
367: per_asr_shd.g_old_rec.attribute8;
368: End If;
369: If (p_rec.attribute9 = hr_api.g_varchar2) then
370: p_rec.attribute9 :=
371: per_asr_shd.g_old_rec.attribute9;

Line 371: per_asr_shd.g_old_rec.attribute9;

367: per_asr_shd.g_old_rec.attribute8;
368: End If;
369: If (p_rec.attribute9 = hr_api.g_varchar2) then
370: p_rec.attribute9 :=
371: per_asr_shd.g_old_rec.attribute9;
372: End If;
373: If (p_rec.attribute10 = hr_api.g_varchar2) then
374: p_rec.attribute10 :=
375: per_asr_shd.g_old_rec.attribute10;

Line 375: per_asr_shd.g_old_rec.attribute10;

371: per_asr_shd.g_old_rec.attribute9;
372: End If;
373: If (p_rec.attribute10 = hr_api.g_varchar2) then
374: p_rec.attribute10 :=
375: per_asr_shd.g_old_rec.attribute10;
376: End If;
377: If (p_rec.attribute11 = hr_api.g_varchar2) then
378: p_rec.attribute11 :=
379: per_asr_shd.g_old_rec.attribute11;

Line 379: per_asr_shd.g_old_rec.attribute11;

375: per_asr_shd.g_old_rec.attribute10;
376: End If;
377: If (p_rec.attribute11 = hr_api.g_varchar2) then
378: p_rec.attribute11 :=
379: per_asr_shd.g_old_rec.attribute11;
380: End If;
381: If (p_rec.attribute12 = hr_api.g_varchar2) then
382: p_rec.attribute12 :=
383: per_asr_shd.g_old_rec.attribute12;

Line 383: per_asr_shd.g_old_rec.attribute12;

379: per_asr_shd.g_old_rec.attribute11;
380: End If;
381: If (p_rec.attribute12 = hr_api.g_varchar2) then
382: p_rec.attribute12 :=
383: per_asr_shd.g_old_rec.attribute12;
384: End If;
385: If (p_rec.attribute13 = hr_api.g_varchar2) then
386: p_rec.attribute13 :=
387: per_asr_shd.g_old_rec.attribute13;

Line 387: per_asr_shd.g_old_rec.attribute13;

383: per_asr_shd.g_old_rec.attribute12;
384: End If;
385: If (p_rec.attribute13 = hr_api.g_varchar2) then
386: p_rec.attribute13 :=
387: per_asr_shd.g_old_rec.attribute13;
388: End If;
389: If (p_rec.attribute14 = hr_api.g_varchar2) then
390: p_rec.attribute14 :=
391: per_asr_shd.g_old_rec.attribute14;

Line 391: per_asr_shd.g_old_rec.attribute14;

387: per_asr_shd.g_old_rec.attribute13;
388: End If;
389: If (p_rec.attribute14 = hr_api.g_varchar2) then
390: p_rec.attribute14 :=
391: per_asr_shd.g_old_rec.attribute14;
392: End If;
393: If (p_rec.attribute15 = hr_api.g_varchar2) then
394: p_rec.attribute15 :=
395: per_asr_shd.g_old_rec.attribute15;

Line 395: per_asr_shd.g_old_rec.attribute15;

391: per_asr_shd.g_old_rec.attribute14;
392: End If;
393: If (p_rec.attribute15 = hr_api.g_varchar2) then
394: p_rec.attribute15 :=
395: per_asr_shd.g_old_rec.attribute15;
396: End If;
397: If (p_rec.attribute16 = hr_api.g_varchar2) then
398: p_rec.attribute16 :=
399: per_asr_shd.g_old_rec.attribute16;

Line 399: per_asr_shd.g_old_rec.attribute16;

395: per_asr_shd.g_old_rec.attribute15;
396: End If;
397: If (p_rec.attribute16 = hr_api.g_varchar2) then
398: p_rec.attribute16 :=
399: per_asr_shd.g_old_rec.attribute16;
400: End If;
401: If (p_rec.attribute17 = hr_api.g_varchar2) then
402: p_rec.attribute17 :=
403: per_asr_shd.g_old_rec.attribute17;

Line 403: per_asr_shd.g_old_rec.attribute17;

399: per_asr_shd.g_old_rec.attribute16;
400: End If;
401: If (p_rec.attribute17 = hr_api.g_varchar2) then
402: p_rec.attribute17 :=
403: per_asr_shd.g_old_rec.attribute17;
404: End If;
405: If (p_rec.attribute18 = hr_api.g_varchar2) then
406: p_rec.attribute18 :=
407: per_asr_shd.g_old_rec.attribute18;

Line 407: per_asr_shd.g_old_rec.attribute18;

403: per_asr_shd.g_old_rec.attribute17;
404: End If;
405: If (p_rec.attribute18 = hr_api.g_varchar2) then
406: p_rec.attribute18 :=
407: per_asr_shd.g_old_rec.attribute18;
408: End If;
409: If (p_rec.attribute19 = hr_api.g_varchar2) then
410: p_rec.attribute19 :=
411: per_asr_shd.g_old_rec.attribute19;

Line 411: per_asr_shd.g_old_rec.attribute19;

407: per_asr_shd.g_old_rec.attribute18;
408: End If;
409: If (p_rec.attribute19 = hr_api.g_varchar2) then
410: p_rec.attribute19 :=
411: per_asr_shd.g_old_rec.attribute19;
412: End If;
413: If (p_rec.attribute20 = hr_api.g_varchar2) then
414: p_rec.attribute20 :=
415: per_asr_shd.g_old_rec.attribute20;

Line 415: per_asr_shd.g_old_rec.attribute20;

411: per_asr_shd.g_old_rec.attribute19;
412: End If;
413: If (p_rec.attribute20 = hr_api.g_varchar2) then
414: p_rec.attribute20 :=
415: per_asr_shd.g_old_rec.attribute20;
416: End If;
417:
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 428: p_rec in out per_asr_shd.g_rec_type,

424: -- |---------------------------------< upd >----------------------------------|
425: -- ----------------------------------------------------------------------------
426: Procedure upd
427: (
428: p_rec in out per_asr_shd.g_rec_type,
429: p_validate in boolean default false,
430: p_effective_date in date
431: ) is
432: --

Line 449: per_asr_shd.lck

445: End If;
446: --
447: -- We must lock the row which we need to update.
448: --
449: per_asr_shd.lck
450: (
451: p_rec.assessment_group_id,
452: p_rec.object_version_number
453: );

Line 528: l_rec per_asr_shd.g_rec_type;

524: p_validate in boolean default false,
525: p_effective_date in date
526: ) is
527: --
528: l_rec per_asr_shd.g_rec_type;
529: l_proc varchar2(72) := g_package||'upd';
530: --
531: Begin
532: hr_utility.set_location('Entering:'||l_proc, 5);

Line 538: per_asr_shd.convert_args

534: -- Call conversion function to turn arguments into the
535: -- l_rec structure.
536: --
537: l_rec :=
538: per_asr_shd.convert_args
539: (
540: p_assessment_group_id,
541: p_name,
542: hr_api.g_number,