APPS.PER_DIS_DEL dependencies on PER_DIS_SHD

Line 54: (p_rec in out nocopy per_dis_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy per_dis_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 97: (p_rec in out nocopy per_dis_shd.g_rec_type

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy per_dis_shd.g_rec_type
98: ,p_effective_date in date
99: ,p_datetrack_mode in varchar2
100: ,p_validation_start_date in date
101: ,p_validation_end_date in date

Line 154: (p_rec in out nocopy per_dis_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy per_dis_shd.g_rec_type
155: ,p_effective_date in date
156: ,p_datetrack_mode in varchar2
157: ,p_validation_start_date in date
158: ,p_validation_end_date in date

Line 169: := per_dis_shd.g_old_rec.effective_start_date;

165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date
169: := per_dis_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: per_dis_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: per_dis_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_base_key_value => p_rec.disability_id
182: ,p_new_effective_end_date => p_rec.effective_end_date
183: ,p_validation_start_date => p_validation_start_date

Line 228: (p_rec in out nocopy per_dis_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy per_dis_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date

Line 288: (p_rec in per_dis_shd.g_rec_type

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in per_dis_shd.g_rec_type
289: ,p_effective_date in date
290: ,p_datetrack_mode in varchar2
291: ,p_validation_start_date in date
292: ,p_validation_end_date in date

Line 317: => per_dis_shd.g_old_rec.effective_start_date

313: => p_rec.effective_start_date
314: ,p_effective_end_date
315: => p_rec.effective_end_date
316: ,p_effective_start_date_o
317: => per_dis_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => per_dis_shd.g_old_rec.effective_end_date
320: ,p_person_id_o
321: => per_dis_shd.g_old_rec.person_id

Line 319: => per_dis_shd.g_old_rec.effective_end_date

315: => p_rec.effective_end_date
316: ,p_effective_start_date_o
317: => per_dis_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => per_dis_shd.g_old_rec.effective_end_date
320: ,p_person_id_o
321: => per_dis_shd.g_old_rec.person_id
322: ,p_incident_id_o
323: => per_dis_shd.g_old_rec.incident_id

Line 321: => per_dis_shd.g_old_rec.person_id

317: => per_dis_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => per_dis_shd.g_old_rec.effective_end_date
320: ,p_person_id_o
321: => per_dis_shd.g_old_rec.person_id
322: ,p_incident_id_o
323: => per_dis_shd.g_old_rec.incident_id
324: ,p_organization_id_o
325: => per_dis_shd.g_old_rec.organization_id

Line 323: => per_dis_shd.g_old_rec.incident_id

319: => per_dis_shd.g_old_rec.effective_end_date
320: ,p_person_id_o
321: => per_dis_shd.g_old_rec.person_id
322: ,p_incident_id_o
323: => per_dis_shd.g_old_rec.incident_id
324: ,p_organization_id_o
325: => per_dis_shd.g_old_rec.organization_id
326: ,p_registration_id_o
327: => per_dis_shd.g_old_rec.registration_id

Line 325: => per_dis_shd.g_old_rec.organization_id

321: => per_dis_shd.g_old_rec.person_id
322: ,p_incident_id_o
323: => per_dis_shd.g_old_rec.incident_id
324: ,p_organization_id_o
325: => per_dis_shd.g_old_rec.organization_id
326: ,p_registration_id_o
327: => per_dis_shd.g_old_rec.registration_id
328: ,p_registration_date_o
329: => per_dis_shd.g_old_rec.registration_date

Line 327: => per_dis_shd.g_old_rec.registration_id

323: => per_dis_shd.g_old_rec.incident_id
324: ,p_organization_id_o
325: => per_dis_shd.g_old_rec.organization_id
326: ,p_registration_id_o
327: => per_dis_shd.g_old_rec.registration_id
328: ,p_registration_date_o
329: => per_dis_shd.g_old_rec.registration_date
330: ,p_registration_exp_date_o
331: => per_dis_shd.g_old_rec.registration_exp_date

Line 329: => per_dis_shd.g_old_rec.registration_date

325: => per_dis_shd.g_old_rec.organization_id
326: ,p_registration_id_o
327: => per_dis_shd.g_old_rec.registration_id
328: ,p_registration_date_o
329: => per_dis_shd.g_old_rec.registration_date
330: ,p_registration_exp_date_o
331: => per_dis_shd.g_old_rec.registration_exp_date
332: ,p_category_o
333: => per_dis_shd.g_old_rec.category

Line 331: => per_dis_shd.g_old_rec.registration_exp_date

327: => per_dis_shd.g_old_rec.registration_id
328: ,p_registration_date_o
329: => per_dis_shd.g_old_rec.registration_date
330: ,p_registration_exp_date_o
331: => per_dis_shd.g_old_rec.registration_exp_date
332: ,p_category_o
333: => per_dis_shd.g_old_rec.category
334: ,p_status_o
335: => per_dis_shd.g_old_rec.status

Line 333: => per_dis_shd.g_old_rec.category

329: => per_dis_shd.g_old_rec.registration_date
330: ,p_registration_exp_date_o
331: => per_dis_shd.g_old_rec.registration_exp_date
332: ,p_category_o
333: => per_dis_shd.g_old_rec.category
334: ,p_status_o
335: => per_dis_shd.g_old_rec.status
336: ,p_description_o
337: => per_dis_shd.g_old_rec.description

Line 335: => per_dis_shd.g_old_rec.status

331: => per_dis_shd.g_old_rec.registration_exp_date
332: ,p_category_o
333: => per_dis_shd.g_old_rec.category
334: ,p_status_o
335: => per_dis_shd.g_old_rec.status
336: ,p_description_o
337: => per_dis_shd.g_old_rec.description
338: ,p_degree_o
339: => per_dis_shd.g_old_rec.degree

Line 337: => per_dis_shd.g_old_rec.description

333: => per_dis_shd.g_old_rec.category
334: ,p_status_o
335: => per_dis_shd.g_old_rec.status
336: ,p_description_o
337: => per_dis_shd.g_old_rec.description
338: ,p_degree_o
339: => per_dis_shd.g_old_rec.degree
340: ,p_quota_fte_o
341: => per_dis_shd.g_old_rec.quota_fte

Line 339: => per_dis_shd.g_old_rec.degree

335: => per_dis_shd.g_old_rec.status
336: ,p_description_o
337: => per_dis_shd.g_old_rec.description
338: ,p_degree_o
339: => per_dis_shd.g_old_rec.degree
340: ,p_quota_fte_o
341: => per_dis_shd.g_old_rec.quota_fte
342: ,p_reason_o
343: => per_dis_shd.g_old_rec.reason

Line 341: => per_dis_shd.g_old_rec.quota_fte

337: => per_dis_shd.g_old_rec.description
338: ,p_degree_o
339: => per_dis_shd.g_old_rec.degree
340: ,p_quota_fte_o
341: => per_dis_shd.g_old_rec.quota_fte
342: ,p_reason_o
343: => per_dis_shd.g_old_rec.reason
344: ,p_pre_registration_job_o
345: => per_dis_shd.g_old_rec.pre_registration_job

Line 343: => per_dis_shd.g_old_rec.reason

339: => per_dis_shd.g_old_rec.degree
340: ,p_quota_fte_o
341: => per_dis_shd.g_old_rec.quota_fte
342: ,p_reason_o
343: => per_dis_shd.g_old_rec.reason
344: ,p_pre_registration_job_o
345: => per_dis_shd.g_old_rec.pre_registration_job
346: ,p_work_restriction_o
347: => per_dis_shd.g_old_rec.work_restriction

Line 345: => per_dis_shd.g_old_rec.pre_registration_job

341: => per_dis_shd.g_old_rec.quota_fte
342: ,p_reason_o
343: => per_dis_shd.g_old_rec.reason
344: ,p_pre_registration_job_o
345: => per_dis_shd.g_old_rec.pre_registration_job
346: ,p_work_restriction_o
347: => per_dis_shd.g_old_rec.work_restriction
348: ,p_attribute_category_o
349: => per_dis_shd.g_old_rec.attribute_category

Line 347: => per_dis_shd.g_old_rec.work_restriction

343: => per_dis_shd.g_old_rec.reason
344: ,p_pre_registration_job_o
345: => per_dis_shd.g_old_rec.pre_registration_job
346: ,p_work_restriction_o
347: => per_dis_shd.g_old_rec.work_restriction
348: ,p_attribute_category_o
349: => per_dis_shd.g_old_rec.attribute_category
350: ,p_attribute1_o
351: => per_dis_shd.g_old_rec.attribute1

Line 349: => per_dis_shd.g_old_rec.attribute_category

345: => per_dis_shd.g_old_rec.pre_registration_job
346: ,p_work_restriction_o
347: => per_dis_shd.g_old_rec.work_restriction
348: ,p_attribute_category_o
349: => per_dis_shd.g_old_rec.attribute_category
350: ,p_attribute1_o
351: => per_dis_shd.g_old_rec.attribute1
352: ,p_attribute2_o
353: => per_dis_shd.g_old_rec.attribute2

Line 351: => per_dis_shd.g_old_rec.attribute1

347: => per_dis_shd.g_old_rec.work_restriction
348: ,p_attribute_category_o
349: => per_dis_shd.g_old_rec.attribute_category
350: ,p_attribute1_o
351: => per_dis_shd.g_old_rec.attribute1
352: ,p_attribute2_o
353: => per_dis_shd.g_old_rec.attribute2
354: ,p_attribute3_o
355: => per_dis_shd.g_old_rec.attribute3

Line 353: => per_dis_shd.g_old_rec.attribute2

349: => per_dis_shd.g_old_rec.attribute_category
350: ,p_attribute1_o
351: => per_dis_shd.g_old_rec.attribute1
352: ,p_attribute2_o
353: => per_dis_shd.g_old_rec.attribute2
354: ,p_attribute3_o
355: => per_dis_shd.g_old_rec.attribute3
356: ,p_attribute4_o
357: => per_dis_shd.g_old_rec.attribute4

Line 355: => per_dis_shd.g_old_rec.attribute3

351: => per_dis_shd.g_old_rec.attribute1
352: ,p_attribute2_o
353: => per_dis_shd.g_old_rec.attribute2
354: ,p_attribute3_o
355: => per_dis_shd.g_old_rec.attribute3
356: ,p_attribute4_o
357: => per_dis_shd.g_old_rec.attribute4
358: ,p_attribute5_o
359: => per_dis_shd.g_old_rec.attribute5

Line 357: => per_dis_shd.g_old_rec.attribute4

353: => per_dis_shd.g_old_rec.attribute2
354: ,p_attribute3_o
355: => per_dis_shd.g_old_rec.attribute3
356: ,p_attribute4_o
357: => per_dis_shd.g_old_rec.attribute4
358: ,p_attribute5_o
359: => per_dis_shd.g_old_rec.attribute5
360: ,p_attribute6_o
361: => per_dis_shd.g_old_rec.attribute6

Line 359: => per_dis_shd.g_old_rec.attribute5

355: => per_dis_shd.g_old_rec.attribute3
356: ,p_attribute4_o
357: => per_dis_shd.g_old_rec.attribute4
358: ,p_attribute5_o
359: => per_dis_shd.g_old_rec.attribute5
360: ,p_attribute6_o
361: => per_dis_shd.g_old_rec.attribute6
362: ,p_attribute7_o
363: => per_dis_shd.g_old_rec.attribute7

Line 361: => per_dis_shd.g_old_rec.attribute6

357: => per_dis_shd.g_old_rec.attribute4
358: ,p_attribute5_o
359: => per_dis_shd.g_old_rec.attribute5
360: ,p_attribute6_o
361: => per_dis_shd.g_old_rec.attribute6
362: ,p_attribute7_o
363: => per_dis_shd.g_old_rec.attribute7
364: ,p_attribute8_o
365: => per_dis_shd.g_old_rec.attribute8

Line 363: => per_dis_shd.g_old_rec.attribute7

359: => per_dis_shd.g_old_rec.attribute5
360: ,p_attribute6_o
361: => per_dis_shd.g_old_rec.attribute6
362: ,p_attribute7_o
363: => per_dis_shd.g_old_rec.attribute7
364: ,p_attribute8_o
365: => per_dis_shd.g_old_rec.attribute8
366: ,p_attribute9_o
367: => per_dis_shd.g_old_rec.attribute9

Line 365: => per_dis_shd.g_old_rec.attribute8

361: => per_dis_shd.g_old_rec.attribute6
362: ,p_attribute7_o
363: => per_dis_shd.g_old_rec.attribute7
364: ,p_attribute8_o
365: => per_dis_shd.g_old_rec.attribute8
366: ,p_attribute9_o
367: => per_dis_shd.g_old_rec.attribute9
368: ,p_attribute10_o
369: => per_dis_shd.g_old_rec.attribute10

Line 367: => per_dis_shd.g_old_rec.attribute9

363: => per_dis_shd.g_old_rec.attribute7
364: ,p_attribute8_o
365: => per_dis_shd.g_old_rec.attribute8
366: ,p_attribute9_o
367: => per_dis_shd.g_old_rec.attribute9
368: ,p_attribute10_o
369: => per_dis_shd.g_old_rec.attribute10
370: ,p_attribute11_o
371: => per_dis_shd.g_old_rec.attribute11

Line 369: => per_dis_shd.g_old_rec.attribute10

365: => per_dis_shd.g_old_rec.attribute8
366: ,p_attribute9_o
367: => per_dis_shd.g_old_rec.attribute9
368: ,p_attribute10_o
369: => per_dis_shd.g_old_rec.attribute10
370: ,p_attribute11_o
371: => per_dis_shd.g_old_rec.attribute11
372: ,p_attribute12_o
373: => per_dis_shd.g_old_rec.attribute12

Line 371: => per_dis_shd.g_old_rec.attribute11

367: => per_dis_shd.g_old_rec.attribute9
368: ,p_attribute10_o
369: => per_dis_shd.g_old_rec.attribute10
370: ,p_attribute11_o
371: => per_dis_shd.g_old_rec.attribute11
372: ,p_attribute12_o
373: => per_dis_shd.g_old_rec.attribute12
374: ,p_attribute13_o
375: => per_dis_shd.g_old_rec.attribute13

Line 373: => per_dis_shd.g_old_rec.attribute12

369: => per_dis_shd.g_old_rec.attribute10
370: ,p_attribute11_o
371: => per_dis_shd.g_old_rec.attribute11
372: ,p_attribute12_o
373: => per_dis_shd.g_old_rec.attribute12
374: ,p_attribute13_o
375: => per_dis_shd.g_old_rec.attribute13
376: ,p_attribute14_o
377: => per_dis_shd.g_old_rec.attribute14

Line 375: => per_dis_shd.g_old_rec.attribute13

371: => per_dis_shd.g_old_rec.attribute11
372: ,p_attribute12_o
373: => per_dis_shd.g_old_rec.attribute12
374: ,p_attribute13_o
375: => per_dis_shd.g_old_rec.attribute13
376: ,p_attribute14_o
377: => per_dis_shd.g_old_rec.attribute14
378: ,p_attribute15_o
379: => per_dis_shd.g_old_rec.attribute15

Line 377: => per_dis_shd.g_old_rec.attribute14

373: => per_dis_shd.g_old_rec.attribute12
374: ,p_attribute13_o
375: => per_dis_shd.g_old_rec.attribute13
376: ,p_attribute14_o
377: => per_dis_shd.g_old_rec.attribute14
378: ,p_attribute15_o
379: => per_dis_shd.g_old_rec.attribute15
380: ,p_attribute16_o
381: => per_dis_shd.g_old_rec.attribute16

Line 379: => per_dis_shd.g_old_rec.attribute15

375: => per_dis_shd.g_old_rec.attribute13
376: ,p_attribute14_o
377: => per_dis_shd.g_old_rec.attribute14
378: ,p_attribute15_o
379: => per_dis_shd.g_old_rec.attribute15
380: ,p_attribute16_o
381: => per_dis_shd.g_old_rec.attribute16
382: ,p_attribute17_o
383: => per_dis_shd.g_old_rec.attribute17

Line 381: => per_dis_shd.g_old_rec.attribute16

377: => per_dis_shd.g_old_rec.attribute14
378: ,p_attribute15_o
379: => per_dis_shd.g_old_rec.attribute15
380: ,p_attribute16_o
381: => per_dis_shd.g_old_rec.attribute16
382: ,p_attribute17_o
383: => per_dis_shd.g_old_rec.attribute17
384: ,p_attribute18_o
385: => per_dis_shd.g_old_rec.attribute18

Line 383: => per_dis_shd.g_old_rec.attribute17

379: => per_dis_shd.g_old_rec.attribute15
380: ,p_attribute16_o
381: => per_dis_shd.g_old_rec.attribute16
382: ,p_attribute17_o
383: => per_dis_shd.g_old_rec.attribute17
384: ,p_attribute18_o
385: => per_dis_shd.g_old_rec.attribute18
386: ,p_attribute19_o
387: => per_dis_shd.g_old_rec.attribute19

Line 385: => per_dis_shd.g_old_rec.attribute18

381: => per_dis_shd.g_old_rec.attribute16
382: ,p_attribute17_o
383: => per_dis_shd.g_old_rec.attribute17
384: ,p_attribute18_o
385: => per_dis_shd.g_old_rec.attribute18
386: ,p_attribute19_o
387: => per_dis_shd.g_old_rec.attribute19
388: ,p_attribute20_o
389: => per_dis_shd.g_old_rec.attribute20

Line 387: => per_dis_shd.g_old_rec.attribute19

383: => per_dis_shd.g_old_rec.attribute17
384: ,p_attribute18_o
385: => per_dis_shd.g_old_rec.attribute18
386: ,p_attribute19_o
387: => per_dis_shd.g_old_rec.attribute19
388: ,p_attribute20_o
389: => per_dis_shd.g_old_rec.attribute20
390: ,p_attribute21_o
391: => per_dis_shd.g_old_rec.attribute21

Line 389: => per_dis_shd.g_old_rec.attribute20

385: => per_dis_shd.g_old_rec.attribute18
386: ,p_attribute19_o
387: => per_dis_shd.g_old_rec.attribute19
388: ,p_attribute20_o
389: => per_dis_shd.g_old_rec.attribute20
390: ,p_attribute21_o
391: => per_dis_shd.g_old_rec.attribute21
392: ,p_attribute22_o
393: => per_dis_shd.g_old_rec.attribute22

Line 391: => per_dis_shd.g_old_rec.attribute21

387: => per_dis_shd.g_old_rec.attribute19
388: ,p_attribute20_o
389: => per_dis_shd.g_old_rec.attribute20
390: ,p_attribute21_o
391: => per_dis_shd.g_old_rec.attribute21
392: ,p_attribute22_o
393: => per_dis_shd.g_old_rec.attribute22
394: ,p_attribute23_o
395: => per_dis_shd.g_old_rec.attribute23

Line 393: => per_dis_shd.g_old_rec.attribute22

389: => per_dis_shd.g_old_rec.attribute20
390: ,p_attribute21_o
391: => per_dis_shd.g_old_rec.attribute21
392: ,p_attribute22_o
393: => per_dis_shd.g_old_rec.attribute22
394: ,p_attribute23_o
395: => per_dis_shd.g_old_rec.attribute23
396: ,p_attribute24_o
397: => per_dis_shd.g_old_rec.attribute24

Line 395: => per_dis_shd.g_old_rec.attribute23

391: => per_dis_shd.g_old_rec.attribute21
392: ,p_attribute22_o
393: => per_dis_shd.g_old_rec.attribute22
394: ,p_attribute23_o
395: => per_dis_shd.g_old_rec.attribute23
396: ,p_attribute24_o
397: => per_dis_shd.g_old_rec.attribute24
398: ,p_attribute25_o
399: => per_dis_shd.g_old_rec.attribute25

Line 397: => per_dis_shd.g_old_rec.attribute24

393: => per_dis_shd.g_old_rec.attribute22
394: ,p_attribute23_o
395: => per_dis_shd.g_old_rec.attribute23
396: ,p_attribute24_o
397: => per_dis_shd.g_old_rec.attribute24
398: ,p_attribute25_o
399: => per_dis_shd.g_old_rec.attribute25
400: ,p_attribute26_o
401: => per_dis_shd.g_old_rec.attribute26

Line 399: => per_dis_shd.g_old_rec.attribute25

395: => per_dis_shd.g_old_rec.attribute23
396: ,p_attribute24_o
397: => per_dis_shd.g_old_rec.attribute24
398: ,p_attribute25_o
399: => per_dis_shd.g_old_rec.attribute25
400: ,p_attribute26_o
401: => per_dis_shd.g_old_rec.attribute26
402: ,p_attribute27_o
403: => per_dis_shd.g_old_rec.attribute27

Line 401: => per_dis_shd.g_old_rec.attribute26

397: => per_dis_shd.g_old_rec.attribute24
398: ,p_attribute25_o
399: => per_dis_shd.g_old_rec.attribute25
400: ,p_attribute26_o
401: => per_dis_shd.g_old_rec.attribute26
402: ,p_attribute27_o
403: => per_dis_shd.g_old_rec.attribute27
404: ,p_attribute28_o
405: => per_dis_shd.g_old_rec.attribute28

Line 403: => per_dis_shd.g_old_rec.attribute27

399: => per_dis_shd.g_old_rec.attribute25
400: ,p_attribute26_o
401: => per_dis_shd.g_old_rec.attribute26
402: ,p_attribute27_o
403: => per_dis_shd.g_old_rec.attribute27
404: ,p_attribute28_o
405: => per_dis_shd.g_old_rec.attribute28
406: ,p_attribute29_o
407: => per_dis_shd.g_old_rec.attribute29

Line 405: => per_dis_shd.g_old_rec.attribute28

401: => per_dis_shd.g_old_rec.attribute26
402: ,p_attribute27_o
403: => per_dis_shd.g_old_rec.attribute27
404: ,p_attribute28_o
405: => per_dis_shd.g_old_rec.attribute28
406: ,p_attribute29_o
407: => per_dis_shd.g_old_rec.attribute29
408: ,p_attribute30_o
409: => per_dis_shd.g_old_rec.attribute30

Line 407: => per_dis_shd.g_old_rec.attribute29

403: => per_dis_shd.g_old_rec.attribute27
404: ,p_attribute28_o
405: => per_dis_shd.g_old_rec.attribute28
406: ,p_attribute29_o
407: => per_dis_shd.g_old_rec.attribute29
408: ,p_attribute30_o
409: => per_dis_shd.g_old_rec.attribute30
410: ,p_dis_information_category_o
411: => per_dis_shd.g_old_rec.dis_information_category

Line 409: => per_dis_shd.g_old_rec.attribute30

405: => per_dis_shd.g_old_rec.attribute28
406: ,p_attribute29_o
407: => per_dis_shd.g_old_rec.attribute29
408: ,p_attribute30_o
409: => per_dis_shd.g_old_rec.attribute30
410: ,p_dis_information_category_o
411: => per_dis_shd.g_old_rec.dis_information_category
412: ,p_dis_information1_o
413: => per_dis_shd.g_old_rec.dis_information1

Line 411: => per_dis_shd.g_old_rec.dis_information_category

407: => per_dis_shd.g_old_rec.attribute29
408: ,p_attribute30_o
409: => per_dis_shd.g_old_rec.attribute30
410: ,p_dis_information_category_o
411: => per_dis_shd.g_old_rec.dis_information_category
412: ,p_dis_information1_o
413: => per_dis_shd.g_old_rec.dis_information1
414: ,p_dis_information2_o
415: => per_dis_shd.g_old_rec.dis_information2

Line 413: => per_dis_shd.g_old_rec.dis_information1

409: => per_dis_shd.g_old_rec.attribute30
410: ,p_dis_information_category_o
411: => per_dis_shd.g_old_rec.dis_information_category
412: ,p_dis_information1_o
413: => per_dis_shd.g_old_rec.dis_information1
414: ,p_dis_information2_o
415: => per_dis_shd.g_old_rec.dis_information2
416: ,p_dis_information3_o
417: => per_dis_shd.g_old_rec.dis_information3

Line 415: => per_dis_shd.g_old_rec.dis_information2

411: => per_dis_shd.g_old_rec.dis_information_category
412: ,p_dis_information1_o
413: => per_dis_shd.g_old_rec.dis_information1
414: ,p_dis_information2_o
415: => per_dis_shd.g_old_rec.dis_information2
416: ,p_dis_information3_o
417: => per_dis_shd.g_old_rec.dis_information3
418: ,p_dis_information4_o
419: => per_dis_shd.g_old_rec.dis_information4

Line 417: => per_dis_shd.g_old_rec.dis_information3

413: => per_dis_shd.g_old_rec.dis_information1
414: ,p_dis_information2_o
415: => per_dis_shd.g_old_rec.dis_information2
416: ,p_dis_information3_o
417: => per_dis_shd.g_old_rec.dis_information3
418: ,p_dis_information4_o
419: => per_dis_shd.g_old_rec.dis_information4
420: ,p_dis_information5_o
421: => per_dis_shd.g_old_rec.dis_information5

Line 419: => per_dis_shd.g_old_rec.dis_information4

415: => per_dis_shd.g_old_rec.dis_information2
416: ,p_dis_information3_o
417: => per_dis_shd.g_old_rec.dis_information3
418: ,p_dis_information4_o
419: => per_dis_shd.g_old_rec.dis_information4
420: ,p_dis_information5_o
421: => per_dis_shd.g_old_rec.dis_information5
422: ,p_dis_information6_o
423: => per_dis_shd.g_old_rec.dis_information6

Line 421: => per_dis_shd.g_old_rec.dis_information5

417: => per_dis_shd.g_old_rec.dis_information3
418: ,p_dis_information4_o
419: => per_dis_shd.g_old_rec.dis_information4
420: ,p_dis_information5_o
421: => per_dis_shd.g_old_rec.dis_information5
422: ,p_dis_information6_o
423: => per_dis_shd.g_old_rec.dis_information6
424: ,p_dis_information7_o
425: => per_dis_shd.g_old_rec.dis_information7

Line 423: => per_dis_shd.g_old_rec.dis_information6

419: => per_dis_shd.g_old_rec.dis_information4
420: ,p_dis_information5_o
421: => per_dis_shd.g_old_rec.dis_information5
422: ,p_dis_information6_o
423: => per_dis_shd.g_old_rec.dis_information6
424: ,p_dis_information7_o
425: => per_dis_shd.g_old_rec.dis_information7
426: ,p_dis_information8_o
427: => per_dis_shd.g_old_rec.dis_information8

Line 425: => per_dis_shd.g_old_rec.dis_information7

421: => per_dis_shd.g_old_rec.dis_information5
422: ,p_dis_information6_o
423: => per_dis_shd.g_old_rec.dis_information6
424: ,p_dis_information7_o
425: => per_dis_shd.g_old_rec.dis_information7
426: ,p_dis_information8_o
427: => per_dis_shd.g_old_rec.dis_information8
428: ,p_dis_information9_o
429: => per_dis_shd.g_old_rec.dis_information9

Line 427: => per_dis_shd.g_old_rec.dis_information8

423: => per_dis_shd.g_old_rec.dis_information6
424: ,p_dis_information7_o
425: => per_dis_shd.g_old_rec.dis_information7
426: ,p_dis_information8_o
427: => per_dis_shd.g_old_rec.dis_information8
428: ,p_dis_information9_o
429: => per_dis_shd.g_old_rec.dis_information9
430: ,p_dis_information10_o
431: => per_dis_shd.g_old_rec.dis_information10

Line 429: => per_dis_shd.g_old_rec.dis_information9

425: => per_dis_shd.g_old_rec.dis_information7
426: ,p_dis_information8_o
427: => per_dis_shd.g_old_rec.dis_information8
428: ,p_dis_information9_o
429: => per_dis_shd.g_old_rec.dis_information9
430: ,p_dis_information10_o
431: => per_dis_shd.g_old_rec.dis_information10
432: ,p_dis_information11_o
433: => per_dis_shd.g_old_rec.dis_information11

Line 431: => per_dis_shd.g_old_rec.dis_information10

427: => per_dis_shd.g_old_rec.dis_information8
428: ,p_dis_information9_o
429: => per_dis_shd.g_old_rec.dis_information9
430: ,p_dis_information10_o
431: => per_dis_shd.g_old_rec.dis_information10
432: ,p_dis_information11_o
433: => per_dis_shd.g_old_rec.dis_information11
434: ,p_dis_information12_o
435: => per_dis_shd.g_old_rec.dis_information12

Line 433: => per_dis_shd.g_old_rec.dis_information11

429: => per_dis_shd.g_old_rec.dis_information9
430: ,p_dis_information10_o
431: => per_dis_shd.g_old_rec.dis_information10
432: ,p_dis_information11_o
433: => per_dis_shd.g_old_rec.dis_information11
434: ,p_dis_information12_o
435: => per_dis_shd.g_old_rec.dis_information12
436: ,p_dis_information13_o
437: => per_dis_shd.g_old_rec.dis_information13

Line 435: => per_dis_shd.g_old_rec.dis_information12

431: => per_dis_shd.g_old_rec.dis_information10
432: ,p_dis_information11_o
433: => per_dis_shd.g_old_rec.dis_information11
434: ,p_dis_information12_o
435: => per_dis_shd.g_old_rec.dis_information12
436: ,p_dis_information13_o
437: => per_dis_shd.g_old_rec.dis_information13
438: ,p_dis_information14_o
439: => per_dis_shd.g_old_rec.dis_information14

Line 437: => per_dis_shd.g_old_rec.dis_information13

433: => per_dis_shd.g_old_rec.dis_information11
434: ,p_dis_information12_o
435: => per_dis_shd.g_old_rec.dis_information12
436: ,p_dis_information13_o
437: => per_dis_shd.g_old_rec.dis_information13
438: ,p_dis_information14_o
439: => per_dis_shd.g_old_rec.dis_information14
440: ,p_dis_information15_o
441: => per_dis_shd.g_old_rec.dis_information15

Line 439: => per_dis_shd.g_old_rec.dis_information14

435: => per_dis_shd.g_old_rec.dis_information12
436: ,p_dis_information13_o
437: => per_dis_shd.g_old_rec.dis_information13
438: ,p_dis_information14_o
439: => per_dis_shd.g_old_rec.dis_information14
440: ,p_dis_information15_o
441: => per_dis_shd.g_old_rec.dis_information15
442: ,p_dis_information16_o
443: => per_dis_shd.g_old_rec.dis_information16

Line 441: => per_dis_shd.g_old_rec.dis_information15

437: => per_dis_shd.g_old_rec.dis_information13
438: ,p_dis_information14_o
439: => per_dis_shd.g_old_rec.dis_information14
440: ,p_dis_information15_o
441: => per_dis_shd.g_old_rec.dis_information15
442: ,p_dis_information16_o
443: => per_dis_shd.g_old_rec.dis_information16
444: ,p_dis_information17_o
445: => per_dis_shd.g_old_rec.dis_information17

Line 443: => per_dis_shd.g_old_rec.dis_information16

439: => per_dis_shd.g_old_rec.dis_information14
440: ,p_dis_information15_o
441: => per_dis_shd.g_old_rec.dis_information15
442: ,p_dis_information16_o
443: => per_dis_shd.g_old_rec.dis_information16
444: ,p_dis_information17_o
445: => per_dis_shd.g_old_rec.dis_information17
446: ,p_dis_information18_o
447: => per_dis_shd.g_old_rec.dis_information18

Line 445: => per_dis_shd.g_old_rec.dis_information17

441: => per_dis_shd.g_old_rec.dis_information15
442: ,p_dis_information16_o
443: => per_dis_shd.g_old_rec.dis_information16
444: ,p_dis_information17_o
445: => per_dis_shd.g_old_rec.dis_information17
446: ,p_dis_information18_o
447: => per_dis_shd.g_old_rec.dis_information18
448: ,p_dis_information19_o
449: => per_dis_shd.g_old_rec.dis_information19

Line 447: => per_dis_shd.g_old_rec.dis_information18

443: => per_dis_shd.g_old_rec.dis_information16
444: ,p_dis_information17_o
445: => per_dis_shd.g_old_rec.dis_information17
446: ,p_dis_information18_o
447: => per_dis_shd.g_old_rec.dis_information18
448: ,p_dis_information19_o
449: => per_dis_shd.g_old_rec.dis_information19
450: ,p_dis_information20_o
451: => per_dis_shd.g_old_rec.dis_information20

Line 449: => per_dis_shd.g_old_rec.dis_information19

445: => per_dis_shd.g_old_rec.dis_information17
446: ,p_dis_information18_o
447: => per_dis_shd.g_old_rec.dis_information18
448: ,p_dis_information19_o
449: => per_dis_shd.g_old_rec.dis_information19
450: ,p_dis_information20_o
451: => per_dis_shd.g_old_rec.dis_information20
452: ,p_dis_information21_o
453: => per_dis_shd.g_old_rec.dis_information21

Line 451: => per_dis_shd.g_old_rec.dis_information20

447: => per_dis_shd.g_old_rec.dis_information18
448: ,p_dis_information19_o
449: => per_dis_shd.g_old_rec.dis_information19
450: ,p_dis_information20_o
451: => per_dis_shd.g_old_rec.dis_information20
452: ,p_dis_information21_o
453: => per_dis_shd.g_old_rec.dis_information21
454: ,p_dis_information22_o
455: => per_dis_shd.g_old_rec.dis_information22

Line 453: => per_dis_shd.g_old_rec.dis_information21

449: => per_dis_shd.g_old_rec.dis_information19
450: ,p_dis_information20_o
451: => per_dis_shd.g_old_rec.dis_information20
452: ,p_dis_information21_o
453: => per_dis_shd.g_old_rec.dis_information21
454: ,p_dis_information22_o
455: => per_dis_shd.g_old_rec.dis_information22
456: ,p_dis_information23_o
457: => per_dis_shd.g_old_rec.dis_information23

Line 455: => per_dis_shd.g_old_rec.dis_information22

451: => per_dis_shd.g_old_rec.dis_information20
452: ,p_dis_information21_o
453: => per_dis_shd.g_old_rec.dis_information21
454: ,p_dis_information22_o
455: => per_dis_shd.g_old_rec.dis_information22
456: ,p_dis_information23_o
457: => per_dis_shd.g_old_rec.dis_information23
458: ,p_dis_information24_o
459: => per_dis_shd.g_old_rec.dis_information24

Line 457: => per_dis_shd.g_old_rec.dis_information23

453: => per_dis_shd.g_old_rec.dis_information21
454: ,p_dis_information22_o
455: => per_dis_shd.g_old_rec.dis_information22
456: ,p_dis_information23_o
457: => per_dis_shd.g_old_rec.dis_information23
458: ,p_dis_information24_o
459: => per_dis_shd.g_old_rec.dis_information24
460: ,p_dis_information25_o
461: => per_dis_shd.g_old_rec.dis_information25

Line 459: => per_dis_shd.g_old_rec.dis_information24

455: => per_dis_shd.g_old_rec.dis_information22
456: ,p_dis_information23_o
457: => per_dis_shd.g_old_rec.dis_information23
458: ,p_dis_information24_o
459: => per_dis_shd.g_old_rec.dis_information24
460: ,p_dis_information25_o
461: => per_dis_shd.g_old_rec.dis_information25
462: ,p_dis_information26_o
463: => per_dis_shd.g_old_rec.dis_information26

Line 461: => per_dis_shd.g_old_rec.dis_information25

457: => per_dis_shd.g_old_rec.dis_information23
458: ,p_dis_information24_o
459: => per_dis_shd.g_old_rec.dis_information24
460: ,p_dis_information25_o
461: => per_dis_shd.g_old_rec.dis_information25
462: ,p_dis_information26_o
463: => per_dis_shd.g_old_rec.dis_information26
464: ,p_dis_information27_o
465: => per_dis_shd.g_old_rec.dis_information27

Line 463: => per_dis_shd.g_old_rec.dis_information26

459: => per_dis_shd.g_old_rec.dis_information24
460: ,p_dis_information25_o
461: => per_dis_shd.g_old_rec.dis_information25
462: ,p_dis_information26_o
463: => per_dis_shd.g_old_rec.dis_information26
464: ,p_dis_information27_o
465: => per_dis_shd.g_old_rec.dis_information27
466: ,p_dis_information28_o
467: => per_dis_shd.g_old_rec.dis_information28

Line 465: => per_dis_shd.g_old_rec.dis_information27

461: => per_dis_shd.g_old_rec.dis_information25
462: ,p_dis_information26_o
463: => per_dis_shd.g_old_rec.dis_information26
464: ,p_dis_information27_o
465: => per_dis_shd.g_old_rec.dis_information27
466: ,p_dis_information28_o
467: => per_dis_shd.g_old_rec.dis_information28
468: ,p_dis_information29_o
469: => per_dis_shd.g_old_rec.dis_information29

Line 467: => per_dis_shd.g_old_rec.dis_information28

463: => per_dis_shd.g_old_rec.dis_information26
464: ,p_dis_information27_o
465: => per_dis_shd.g_old_rec.dis_information27
466: ,p_dis_information28_o
467: => per_dis_shd.g_old_rec.dis_information28
468: ,p_dis_information29_o
469: => per_dis_shd.g_old_rec.dis_information29
470: ,p_dis_information30_o
471: => per_dis_shd.g_old_rec.dis_information30

Line 469: => per_dis_shd.g_old_rec.dis_information29

465: => per_dis_shd.g_old_rec.dis_information27
466: ,p_dis_information28_o
467: => per_dis_shd.g_old_rec.dis_information28
468: ,p_dis_information29_o
469: => per_dis_shd.g_old_rec.dis_information29
470: ,p_dis_information30_o
471: => per_dis_shd.g_old_rec.dis_information30
472: ,p_object_version_number_o
473: => per_dis_shd.g_old_rec.object_version_number

Line 471: => per_dis_shd.g_old_rec.dis_information30

467: => per_dis_shd.g_old_rec.dis_information28
468: ,p_dis_information29_o
469: => per_dis_shd.g_old_rec.dis_information29
470: ,p_dis_information30_o
471: => per_dis_shd.g_old_rec.dis_information30
472: ,p_object_version_number_o
473: => per_dis_shd.g_old_rec.object_version_number
474: );
475: --

Line 473: => per_dis_shd.g_old_rec.object_version_number

469: => per_dis_shd.g_old_rec.dis_information29
470: ,p_dis_information30_o
471: => per_dis_shd.g_old_rec.dis_information30
472: ,p_object_version_number_o
473: => per_dis_shd.g_old_rec.object_version_number
474: );
475: --
476: exception
477: --

Line 495: ,p_rec in out nocopy per_dis_shd.g_rec_type

491: -- ----------------------------------------------------------------------------
492: Procedure del
493: (p_effective_date in date
494: ,p_datetrack_mode in varchar2
495: ,p_rec in out nocopy per_dis_shd.g_rec_type
496: ) is
497: --
498: l_proc varchar2(72) := g_package||'del';
499: l_validation_start_date date;

Line 511: per_dis_shd.lck

507: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
508: --
509: -- We must lock the row which we need to delete.
510: --
511: per_dis_shd.lck
512: (p_effective_date => p_effective_date
513: ,p_datetrack_mode => p_datetrack_mode
514: ,p_disability_id => p_rec.disability_id
515: ,p_object_version_number => p_rec.object_version_number

Line 574: l_rec per_dis_shd.g_rec_type;

570: ,p_effective_start_date out nocopy date
571: ,p_effective_end_date out nocopy date
572: ) is
573: --
574: l_rec per_dis_shd.g_rec_type;
575: l_proc varchar2(72) := g_package||'del';
576: --
577: Begin
578: hr_utility.set_location('Entering:'||l_proc, 5);