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_SHA_UPD dependencies on PER_SHA_SHD

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

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

Line 99: per_sha_shd.constraint_error

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

Line 103: per_sha_shd.constraint_error

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

Line 107: per_sha_shd.constraint_error

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

Line 145: Procedure pre_update(p_rec in per_sha_shd.g_rec_type) is

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

Line 187: Procedure post_update(p_rec in per_sha_shd.g_rec_type) is

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

Line 227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken

223: ,p_attribute18 => p_rec.attribute18
224: ,p_attribute19 => p_rec.attribute19
225: ,p_attribute20 => p_rec.attribute20
226: ,p_object_version_number => p_rec.object_version_number
227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason

Line 228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id

224: ,p_attribute19 => p_rec.attribute19
225: ,p_attribute20 => p_rec.attribute20
226: ,p_object_version_number => p_rec.object_version_number
227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired

Line 229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id

225: ,p_attribute20 => p_rec.attribute20
226: ,p_object_version_number => p_rec.object_version_number
227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category

Line 230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken

226: ,p_object_version_number => p_rec.object_version_number
227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1

Line 231: ,p_reason_o => per_sha_shd.g_old_rec.reason

227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2

Line 232: ,p_expired_o => per_sha_shd.g_old_rec.expired

228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3

Line 233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category

229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4

Line 234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1

230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5

Line 235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2

231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6

Line 236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3

232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7

Line 237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4

233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8

Line 238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5

234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9

Line 239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6

235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10

Line 240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7

236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11

Line 241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8

237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12

Line 242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9

238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13

Line 243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10

239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14

Line 244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11

240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15

Line 245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12

241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16

Line 246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13

242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17

Line 247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14

243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18

Line 248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15

244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19

Line 249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16

245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20

Line 250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17

246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number

Line 251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18

247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );

Line 252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19

248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
256: exception

Line 253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20

249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
256: exception
257: when hr_api.cannot_find_prog_unit then

Line 254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number

250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
256: exception
257: when hr_api.cannot_find_prog_unit then
258: hr_api.cannot_find_prog_unit_error

Line 311: Procedure convert_defs(p_rec in out nocopy per_sha_shd.g_rec_type) is

307: -- Internal Row Handler Use Only.
308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure convert_defs(p_rec in out nocopy per_sha_shd.g_rec_type) is
312: --
313: l_proc varchar2(72) := g_package||'convert_defs';
314: --
315: Begin

Line 326: per_sha_shd.g_old_rec.date_not_taken;

322: -- is being used then we must set to the 'current' argument value.
323: --
324: If (p_rec.date_not_taken = hr_api.g_date) then
325: p_rec.date_not_taken :=
326: per_sha_shd.g_old_rec.date_not_taken;
327: End If;
328: If (p_rec.person_id = hr_api.g_number) then
329: p_rec.person_id :=
330: per_sha_shd.g_old_rec.person_id;

Line 330: per_sha_shd.g_old_rec.person_id;

326: per_sha_shd.g_old_rec.date_not_taken;
327: End If;
328: If (p_rec.person_id = hr_api.g_number) then
329: p_rec.person_id :=
330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;

Line 334: per_sha_shd.g_old_rec.standard_holiday_id;

330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then
337: p_rec.actual_date_taken :=
338: per_sha_shd.g_old_rec.actual_date_taken;

Line 338: per_sha_shd.g_old_rec.actual_date_taken;

334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then
337: p_rec.actual_date_taken :=
338: per_sha_shd.g_old_rec.actual_date_taken;
339: End If;
340: If (p_rec.reason = hr_api.g_varchar2) then
341: p_rec.reason :=
342: per_sha_shd.g_old_rec.reason;

Line 342: per_sha_shd.g_old_rec.reason;

338: per_sha_shd.g_old_rec.actual_date_taken;
339: End If;
340: If (p_rec.reason = hr_api.g_varchar2) then
341: p_rec.reason :=
342: per_sha_shd.g_old_rec.reason;
343: End If;
344: If (p_rec.expired = hr_api.g_varchar2) then
345: p_rec.expired :=
346: per_sha_shd.g_old_rec.expired;

Line 346: per_sha_shd.g_old_rec.expired;

342: per_sha_shd.g_old_rec.reason;
343: End If;
344: If (p_rec.expired = hr_api.g_varchar2) then
345: p_rec.expired :=
346: per_sha_shd.g_old_rec.expired;
347: End If;
348: If (p_rec.attribute_category = hr_api.g_varchar2) then
349: p_rec.attribute_category :=
350: per_sha_shd.g_old_rec.attribute_category;

Line 350: per_sha_shd.g_old_rec.attribute_category;

346: per_sha_shd.g_old_rec.expired;
347: End If;
348: If (p_rec.attribute_category = hr_api.g_varchar2) then
349: p_rec.attribute_category :=
350: per_sha_shd.g_old_rec.attribute_category;
351: End If;
352: If (p_rec.attribute1 = hr_api.g_varchar2) then
353: p_rec.attribute1 :=
354: per_sha_shd.g_old_rec.attribute1;

Line 354: per_sha_shd.g_old_rec.attribute1;

350: per_sha_shd.g_old_rec.attribute_category;
351: End If;
352: If (p_rec.attribute1 = hr_api.g_varchar2) then
353: p_rec.attribute1 :=
354: per_sha_shd.g_old_rec.attribute1;
355: End If;
356: If (p_rec.attribute2 = hr_api.g_varchar2) then
357: p_rec.attribute2 :=
358: per_sha_shd.g_old_rec.attribute2;

Line 358: per_sha_shd.g_old_rec.attribute2;

354: per_sha_shd.g_old_rec.attribute1;
355: End If;
356: If (p_rec.attribute2 = hr_api.g_varchar2) then
357: p_rec.attribute2 :=
358: per_sha_shd.g_old_rec.attribute2;
359: End If;
360: If (p_rec.attribute3 = hr_api.g_varchar2) then
361: p_rec.attribute3 :=
362: per_sha_shd.g_old_rec.attribute3;

Line 362: per_sha_shd.g_old_rec.attribute3;

358: per_sha_shd.g_old_rec.attribute2;
359: End If;
360: If (p_rec.attribute3 = hr_api.g_varchar2) then
361: p_rec.attribute3 :=
362: per_sha_shd.g_old_rec.attribute3;
363: End If;
364: If (p_rec.attribute4 = hr_api.g_varchar2) then
365: p_rec.attribute4 :=
366: per_sha_shd.g_old_rec.attribute4;

Line 366: per_sha_shd.g_old_rec.attribute4;

362: per_sha_shd.g_old_rec.attribute3;
363: End If;
364: If (p_rec.attribute4 = hr_api.g_varchar2) then
365: p_rec.attribute4 :=
366: per_sha_shd.g_old_rec.attribute4;
367: End If;
368: If (p_rec.attribute5 = hr_api.g_varchar2) then
369: p_rec.attribute5 :=
370: per_sha_shd.g_old_rec.attribute5;

Line 370: per_sha_shd.g_old_rec.attribute5;

366: per_sha_shd.g_old_rec.attribute4;
367: End If;
368: If (p_rec.attribute5 = hr_api.g_varchar2) then
369: p_rec.attribute5 :=
370: per_sha_shd.g_old_rec.attribute5;
371: End If;
372: If (p_rec.attribute6 = hr_api.g_varchar2) then
373: p_rec.attribute6 :=
374: per_sha_shd.g_old_rec.attribute6;

Line 374: per_sha_shd.g_old_rec.attribute6;

370: per_sha_shd.g_old_rec.attribute5;
371: End If;
372: If (p_rec.attribute6 = hr_api.g_varchar2) then
373: p_rec.attribute6 :=
374: per_sha_shd.g_old_rec.attribute6;
375: End If;
376: If (p_rec.attribute7 = hr_api.g_varchar2) then
377: p_rec.attribute7 :=
378: per_sha_shd.g_old_rec.attribute7;

Line 378: per_sha_shd.g_old_rec.attribute7;

374: per_sha_shd.g_old_rec.attribute6;
375: End If;
376: If (p_rec.attribute7 = hr_api.g_varchar2) then
377: p_rec.attribute7 :=
378: per_sha_shd.g_old_rec.attribute7;
379: End If;
380: If (p_rec.attribute8 = hr_api.g_varchar2) then
381: p_rec.attribute8 :=
382: per_sha_shd.g_old_rec.attribute8;

Line 382: per_sha_shd.g_old_rec.attribute8;

378: per_sha_shd.g_old_rec.attribute7;
379: End If;
380: If (p_rec.attribute8 = hr_api.g_varchar2) then
381: p_rec.attribute8 :=
382: per_sha_shd.g_old_rec.attribute8;
383: End If;
384: If (p_rec.attribute9 = hr_api.g_varchar2) then
385: p_rec.attribute9 :=
386: per_sha_shd.g_old_rec.attribute9;

Line 386: per_sha_shd.g_old_rec.attribute9;

382: per_sha_shd.g_old_rec.attribute8;
383: End If;
384: If (p_rec.attribute9 = hr_api.g_varchar2) then
385: p_rec.attribute9 :=
386: per_sha_shd.g_old_rec.attribute9;
387: End If;
388: If (p_rec.attribute10 = hr_api.g_varchar2) then
389: p_rec.attribute10 :=
390: per_sha_shd.g_old_rec.attribute10;

Line 390: per_sha_shd.g_old_rec.attribute10;

386: per_sha_shd.g_old_rec.attribute9;
387: End If;
388: If (p_rec.attribute10 = hr_api.g_varchar2) then
389: p_rec.attribute10 :=
390: per_sha_shd.g_old_rec.attribute10;
391: End If;
392: If (p_rec.attribute11 = hr_api.g_varchar2) then
393: p_rec.attribute11 :=
394: per_sha_shd.g_old_rec.attribute11;

Line 394: per_sha_shd.g_old_rec.attribute11;

390: per_sha_shd.g_old_rec.attribute10;
391: End If;
392: If (p_rec.attribute11 = hr_api.g_varchar2) then
393: p_rec.attribute11 :=
394: per_sha_shd.g_old_rec.attribute11;
395: End If;
396: If (p_rec.attribute12 = hr_api.g_varchar2) then
397: p_rec.attribute12 :=
398: per_sha_shd.g_old_rec.attribute12;

Line 398: per_sha_shd.g_old_rec.attribute12;

394: per_sha_shd.g_old_rec.attribute11;
395: End If;
396: If (p_rec.attribute12 = hr_api.g_varchar2) then
397: p_rec.attribute12 :=
398: per_sha_shd.g_old_rec.attribute12;
399: End If;
400: If (p_rec.attribute13 = hr_api.g_varchar2) then
401: p_rec.attribute13 :=
402: per_sha_shd.g_old_rec.attribute13;

Line 402: per_sha_shd.g_old_rec.attribute13;

398: per_sha_shd.g_old_rec.attribute12;
399: End If;
400: If (p_rec.attribute13 = hr_api.g_varchar2) then
401: p_rec.attribute13 :=
402: per_sha_shd.g_old_rec.attribute13;
403: End If;
404: If (p_rec.attribute14 = hr_api.g_varchar2) then
405: p_rec.attribute14 :=
406: per_sha_shd.g_old_rec.attribute14;

Line 406: per_sha_shd.g_old_rec.attribute14;

402: per_sha_shd.g_old_rec.attribute13;
403: End If;
404: If (p_rec.attribute14 = hr_api.g_varchar2) then
405: p_rec.attribute14 :=
406: per_sha_shd.g_old_rec.attribute14;
407: End If;
408: If (p_rec.attribute15 = hr_api.g_varchar2) then
409: p_rec.attribute15 :=
410: per_sha_shd.g_old_rec.attribute15;

Line 410: per_sha_shd.g_old_rec.attribute15;

406: per_sha_shd.g_old_rec.attribute14;
407: End If;
408: If (p_rec.attribute15 = hr_api.g_varchar2) then
409: p_rec.attribute15 :=
410: per_sha_shd.g_old_rec.attribute15;
411: End If;
412: If (p_rec.attribute16 = hr_api.g_varchar2) then
413: p_rec.attribute16 :=
414: per_sha_shd.g_old_rec.attribute16;

Line 414: per_sha_shd.g_old_rec.attribute16;

410: per_sha_shd.g_old_rec.attribute15;
411: End If;
412: If (p_rec.attribute16 = hr_api.g_varchar2) then
413: p_rec.attribute16 :=
414: per_sha_shd.g_old_rec.attribute16;
415: End If;
416: If (p_rec.attribute17 = hr_api.g_varchar2) then
417: p_rec.attribute17 :=
418: per_sha_shd.g_old_rec.attribute17;

Line 418: per_sha_shd.g_old_rec.attribute17;

414: per_sha_shd.g_old_rec.attribute16;
415: End If;
416: If (p_rec.attribute17 = hr_api.g_varchar2) then
417: p_rec.attribute17 :=
418: per_sha_shd.g_old_rec.attribute17;
419: End If;
420: If (p_rec.attribute18 = hr_api.g_varchar2) then
421: p_rec.attribute18 :=
422: per_sha_shd.g_old_rec.attribute18;

Line 422: per_sha_shd.g_old_rec.attribute18;

418: per_sha_shd.g_old_rec.attribute17;
419: End If;
420: If (p_rec.attribute18 = hr_api.g_varchar2) then
421: p_rec.attribute18 :=
422: per_sha_shd.g_old_rec.attribute18;
423: End If;
424: If (p_rec.attribute19 = hr_api.g_varchar2) then
425: p_rec.attribute19 :=
426: per_sha_shd.g_old_rec.attribute19;

Line 426: per_sha_shd.g_old_rec.attribute19;

422: per_sha_shd.g_old_rec.attribute18;
423: End If;
424: If (p_rec.attribute19 = hr_api.g_varchar2) then
425: p_rec.attribute19 :=
426: per_sha_shd.g_old_rec.attribute19;
427: End If;
428: If (p_rec.attribute20 = hr_api.g_varchar2) then
429: p_rec.attribute20 :=
430: per_sha_shd.g_old_rec.attribute20;

Line 430: per_sha_shd.g_old_rec.attribute20;

426: per_sha_shd.g_old_rec.attribute19;
427: End If;
428: If (p_rec.attribute20 = hr_api.g_varchar2) then
429: p_rec.attribute20 :=
430: per_sha_shd.g_old_rec.attribute20;
431: End If;
432:
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 443: p_rec in out nocopy per_sha_shd.g_rec_type

439: -- |---------------------------------< upd >----------------------------------|
440: -- ----------------------------------------------------------------------------
441: Procedure upd
442: (
443: p_rec in out nocopy per_sha_shd.g_rec_type
444: ) is
445: --
446: l_proc varchar2(72) := g_package||'upd';
447: --

Line 453: per_sha_shd.lck

449: hr_utility.set_location('Entering:'||l_proc, 5);
450: --
451: -- We must lock the row which we need to update.
452: --
453: per_sha_shd.lck
454: (
455: p_rec.std_holiday_absences_id,
456: p_rec.object_version_number
457: );

Line 517: l_rec per_sha_shd.g_rec_type;

513: p_attribute20 in varchar2 default hr_api.g_varchar2,
514: p_object_version_number in out nocopy number
515: ) is
516: --
517: l_rec per_sha_shd.g_rec_type;
518: l_proc varchar2(72) := g_package||'upd';
519: --
520: Begin
521: hr_utility.set_location('Entering:'||l_proc, 5);

Line 527: per_sha_shd.convert_args

523: -- Call conversion function to turn arguments into the
524: -- l_rec structure.
525: --
526: l_rec :=
527: per_sha_shd.convert_args
528: (
529: p_std_holiday_absences_id,
530: p_date_not_taken,
531: p_person_id,