APPS.PER_PTU_DEL dependencies on PER_PTU_SHD

Line 48: (p_rec in out nocopy per_ptu_shd.g_rec_type,

44: --
45: -- {End Of Comments}
46: -- ----------------------------------------------------------------------------
47: Procedure dt_delete_dml
48: (p_rec in out nocopy per_ptu_shd.g_rec_type,
49: p_effective_date in date,
50: p_datetrack_mode in varchar2,
51: p_validation_start_date in date,
52: p_validation_end_date in date) is

Line 91: (p_rec in out nocopy per_ptu_shd.g_rec_type,

87: -- ----------------------------------------------------------------------------
88: -- |------------------------------< delete_dml >------------------------------|
89: -- ----------------------------------------------------------------------------
90: Procedure delete_dml
91: (p_rec in out nocopy per_ptu_shd.g_rec_type,
92: p_effective_date in date,
93: p_datetrack_mode in varchar2,
94: p_validation_start_date in date,
95: p_validation_end_date in date) is

Line 145: (p_rec in out nocopy per_ptu_shd.g_rec_type,

141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure dt_pre_delete
145: (p_rec in out nocopy per_ptu_shd.g_rec_type,
146: p_effective_date in date,
147: p_datetrack_mode in varchar2,
148: p_validation_start_date in date,
149: p_validation_end_date in date) is

Line 158: p_rec.effective_start_date := per_ptu_shd.g_old_rec.effective_start_date;

154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --
156: If (p_datetrack_mode <> 'ZAP') then
157: --
158: p_rec.effective_start_date := per_ptu_shd.g_old_rec.effective_start_date;
159: --
160: If (p_datetrack_mode = 'DELETE') then
161: p_rec.effective_end_date := p_validation_start_date - 1;
162: Else

Line 168: per_ptu_shd.upd_effective_end_date

164: End If;
165: --
166: -- Update the current effective end date record
167: --
168: per_ptu_shd.upd_effective_end_date
169: (p_effective_date => p_effective_date,
170: p_base_key_value => p_rec.person_type_usage_id,
171: p_new_effective_end_date => p_rec.effective_end_date,
172: p_validation_start_date => p_validation_start_date,

Line 216: (p_rec in out nocopy per_ptu_shd.g_rec_type,

212: --
213: -- {End Of Comments}
214: -- ----------------------------------------------------------------------------
215: Procedure pre_delete
216: (p_rec in out nocopy per_ptu_shd.g_rec_type,
217: p_effective_date in date,
218: p_datetrack_mode in varchar2,
219: p_validation_start_date in date,
220: p_validation_end_date in date) is

Line 274: (p_rec in per_ptu_shd.g_rec_type,

270: --
271: -- {End Of Comments}
272: -- ----------------------------------------------------------------------------
273: Procedure post_delete
274: (p_rec in per_ptu_shd.g_rec_type,
275: p_effective_date in date,
276: p_datetrack_mode in varchar2,
277: p_validation_start_date in date,
278: p_validation_end_date in date) is

Line 291: p_person_id_o => per_ptu_shd.g_old_rec.person_id,

287: begin
288: per_ptu_rkd.after_delete
289: (
290: p_person_type_usage_id => p_rec.person_type_usage_id,
291: p_person_id_o => per_ptu_shd.g_old_rec.person_id,
292: p_person_type_id_o => per_ptu_shd.g_old_rec.person_type_id,
293: p_effective_start_date_o
294: => per_ptu_shd.g_old_rec.effective_start_date,
295: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,

Line 292: p_person_type_id_o => per_ptu_shd.g_old_rec.person_type_id,

288: per_ptu_rkd.after_delete
289: (
290: p_person_type_usage_id => p_rec.person_type_usage_id,
291: p_person_id_o => per_ptu_shd.g_old_rec.person_id,
292: p_person_type_id_o => per_ptu_shd.g_old_rec.person_type_id,
293: p_effective_start_date_o
294: => per_ptu_shd.g_old_rec.effective_start_date,
295: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
296: p_object_version_number_o

Line 294: => per_ptu_shd.g_old_rec.effective_start_date,

290: p_person_type_usage_id => p_rec.person_type_usage_id,
291: p_person_id_o => per_ptu_shd.g_old_rec.person_id,
292: p_person_type_id_o => per_ptu_shd.g_old_rec.person_type_id,
293: p_effective_start_date_o
294: => per_ptu_shd.g_old_rec.effective_start_date,
295: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
296: p_object_version_number_o
297: => per_ptu_shd.g_old_rec.object_version_number,
298: p_request_id_o => per_ptu_shd.g_old_rec.request_id,

Line 295: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,

291: p_person_id_o => per_ptu_shd.g_old_rec.person_id,
292: p_person_type_id_o => per_ptu_shd.g_old_rec.person_type_id,
293: p_effective_start_date_o
294: => per_ptu_shd.g_old_rec.effective_start_date,
295: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
296: p_object_version_number_o
297: => per_ptu_shd.g_old_rec.object_version_number,
298: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
299: p_program_application_id_o

Line 297: => per_ptu_shd.g_old_rec.object_version_number,

293: p_effective_start_date_o
294: => per_ptu_shd.g_old_rec.effective_start_date,
295: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
296: p_object_version_number_o
297: => per_ptu_shd.g_old_rec.object_version_number,
298: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
299: p_program_application_id_o
300: => per_ptu_shd.g_old_rec.program_application_id,
301: p_program_id_o => per_ptu_shd.g_old_rec.program_id,

Line 298: p_request_id_o => per_ptu_shd.g_old_rec.request_id,

294: => per_ptu_shd.g_old_rec.effective_start_date,
295: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
296: p_object_version_number_o
297: => per_ptu_shd.g_old_rec.object_version_number,
298: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
299: p_program_application_id_o
300: => per_ptu_shd.g_old_rec.program_application_id,
301: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
302: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date

Line 300: => per_ptu_shd.g_old_rec.program_application_id,

296: p_object_version_number_o
297: => per_ptu_shd.g_old_rec.object_version_number,
298: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
299: p_program_application_id_o
300: => per_ptu_shd.g_old_rec.program_application_id,
301: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
302: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
303: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
304: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1

Line 301: p_program_id_o => per_ptu_shd.g_old_rec.program_id,

297: => per_ptu_shd.g_old_rec.object_version_number,
298: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
299: p_program_application_id_o
300: => per_ptu_shd.g_old_rec.program_application_id,
301: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
302: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
303: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
304: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
305: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2

Line 302: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date

298: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
299: p_program_application_id_o
300: => per_ptu_shd.g_old_rec.program_application_id,
301: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
302: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
303: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
304: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
305: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
306: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3

Line 303: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category

299: p_program_application_id_o
300: => per_ptu_shd.g_old_rec.program_application_id,
301: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
302: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
303: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
304: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
305: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
306: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
307: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4

Line 304: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1

300: => per_ptu_shd.g_old_rec.program_application_id,
301: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
302: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
303: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
304: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
305: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
306: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
307: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
308: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5

Line 305: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2

301: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
302: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
303: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
304: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
305: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
306: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
307: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
308: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
309: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6

Line 306: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3

302: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
303: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
304: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
305: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
306: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
307: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
308: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
309: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
310: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7

Line 307: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4

303: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
304: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
305: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
306: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
307: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
308: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
309: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
310: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
311: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8

Line 308: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5

304: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
305: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
306: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
307: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
308: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
309: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
310: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
311: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
312: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9

Line 309: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6

305: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
306: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
307: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
308: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
309: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
310: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
311: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
312: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
313: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10

Line 310: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7

306: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
307: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
308: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
309: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
310: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
311: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
312: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
313: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
314: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11

Line 311: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8

307: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
308: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
309: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
310: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
311: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
312: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
313: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
314: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
315: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12

Line 312: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9

308: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
309: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
310: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
311: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
312: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
313: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
314: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
315: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
316: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13

Line 313: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10

309: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
310: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
311: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
312: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
313: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
314: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
315: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
316: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
317: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14

Line 314: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11

310: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
311: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
312: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
313: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
314: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
315: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
316: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
317: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
318: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15

Line 315: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12

311: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
312: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
313: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
314: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
315: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
316: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
317: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
318: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
319: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16

Line 316: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13

312: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
313: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
314: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
315: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
316: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
317: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
318: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
319: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
320: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17

Line 317: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14

313: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
314: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
315: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
316: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
317: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
318: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
319: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
320: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
321: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18

Line 318: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15

314: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
315: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
316: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
317: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
318: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
319: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
320: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
321: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
322: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19

Line 319: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16

315: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
316: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
317: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
318: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
319: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
320: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
321: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
322: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
323: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20

Line 320: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17

316: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
317: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
318: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
319: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
320: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
321: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
322: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
323: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
324: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21

Line 321: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18

317: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
318: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
319: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
320: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
321: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
322: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
323: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
324: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
325: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22

Line 322: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19

318: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
319: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
320: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
321: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
322: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
323: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
324: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
325: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
326: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23

Line 323: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20

319: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
320: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
321: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
322: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
323: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
324: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
325: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
326: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
327: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24

Line 324: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21

320: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
321: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
322: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
323: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
324: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
325: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
326: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
327: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
328: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25

Line 325: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22

321: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
322: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
323: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
324: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
325: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
326: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
327: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
328: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
329: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26

Line 326: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23

322: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
323: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
324: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
325: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
326: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
327: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
328: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
329: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
330: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27

Line 327: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24

323: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
324: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
325: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
326: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
327: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
328: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
329: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
330: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
331: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28

Line 328: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25

324: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
325: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
326: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
327: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
328: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
329: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
330: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
331: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
332: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29

Line 329: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26

325: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
326: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
327: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
328: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
329: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
330: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
331: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
332: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29
333: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30,

Line 330: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27

326: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
327: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
328: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
329: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
330: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
331: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
332: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29
333: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30,
334: p_effective_date => p_effective_date,

Line 331: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28

327: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
328: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
329: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
330: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
331: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
332: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29
333: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30,
334: p_effective_date => p_effective_date,
335: p_datetrack_mode => p_datetrack_mode,

Line 332: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29

328: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
329: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
330: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
331: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
332: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29
333: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30,
334: p_effective_date => p_effective_date,
335: p_datetrack_mode => p_datetrack_mode,
336: p_validation_start_date => p_validation_start_date,

Line 333: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30,

329: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
330: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
331: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
332: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29
333: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30,
334: p_effective_date => p_effective_date,
335: p_datetrack_mode => p_datetrack_mode,
336: p_validation_start_date => p_validation_start_date,
337: p_validation_end_date => p_validation_end_date,

Line 359: p_rec in out nocopy per_ptu_shd.g_rec_type,

355: -- |---------------------------------< del >----------------------------------|
356: -- ----------------------------------------------------------------------------
357: Procedure del
358: (
359: p_rec in out nocopy per_ptu_shd.g_rec_type,
360: p_effective_date in date,
361: p_datetrack_mode in varchar2
362: ) is
363: --

Line 377: per_ptu_shd.lck

373: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
374: --
375: -- We must lock the row which we need to delete.
376: --
377: per_ptu_shd.lck
378: (p_effective_date => p_effective_date,
379: p_datetrack_mode => p_datetrack_mode,
380: p_person_type_usage_id => p_rec.person_type_usage_id,
381: p_object_version_number => p_rec.object_version_number,

Line 435: l_rec per_ptu_shd.g_rec_type;

431: p_effective_date in date,
432: p_datetrack_mode in varchar2
433: ) is
434: --
435: l_rec per_ptu_shd.g_rec_type;
436: l_proc varchar2(72) := g_package||'del';
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);