APPS.BEN_EXT_CHLG dependencies on PER_DISABILITIES_F

Line 328: -- added for bug 6517369 to audit changes to per_disabilities_f

324: ,uom ben_prtt_prem_by_mo_f.uom%type
325: ,update_mode varchar2(20)
326: );
327: --
328: -- added for bug 6517369 to audit changes to per_disabilities_f
329: Type per_dis_rec_type is RECORD
330: (person_id per_disabilities_f.person_id%type
331: ,effective_start_date per_disabilities_f.effective_start_date%type
332: ,effective_end_date per_disabilities_f.effective_end_date%type

Line 330: (person_id per_disabilities_f.person_id%type

326: );
327: --
328: -- added for bug 6517369 to audit changes to per_disabilities_f
329: Type per_dis_rec_type is RECORD
330: (person_id per_disabilities_f.person_id%type
331: ,effective_start_date per_disabilities_f.effective_start_date%type
332: ,effective_end_date per_disabilities_f.effective_end_date%type
333: ,business_group_id per_all_people_f.business_group_id%type
334: ,incident_id per_disabilities_f.incident_id%type

Line 331: ,effective_start_date per_disabilities_f.effective_start_date%type

327: --
328: -- added for bug 6517369 to audit changes to per_disabilities_f
329: Type per_dis_rec_type is RECORD
330: (person_id per_disabilities_f.person_id%type
331: ,effective_start_date per_disabilities_f.effective_start_date%type
332: ,effective_end_date per_disabilities_f.effective_end_date%type
333: ,business_group_id per_all_people_f.business_group_id%type
334: ,incident_id per_disabilities_f.incident_id%type
335: ,organization_id per_disabilities_f.organization_id%type

Line 332: ,effective_end_date per_disabilities_f.effective_end_date%type

328: -- added for bug 6517369 to audit changes to per_disabilities_f
329: Type per_dis_rec_type is RECORD
330: (person_id per_disabilities_f.person_id%type
331: ,effective_start_date per_disabilities_f.effective_start_date%type
332: ,effective_end_date per_disabilities_f.effective_end_date%type
333: ,business_group_id per_all_people_f.business_group_id%type
334: ,incident_id per_disabilities_f.incident_id%type
335: ,organization_id per_disabilities_f.organization_id%type
336: ,registration_id per_disabilities_f.registration_id%type

Line 334: ,incident_id per_disabilities_f.incident_id%type

330: (person_id per_disabilities_f.person_id%type
331: ,effective_start_date per_disabilities_f.effective_start_date%type
332: ,effective_end_date per_disabilities_f.effective_end_date%type
333: ,business_group_id per_all_people_f.business_group_id%type
334: ,incident_id per_disabilities_f.incident_id%type
335: ,organization_id per_disabilities_f.organization_id%type
336: ,registration_id per_disabilities_f.registration_id%type
337: ,registration_date per_disabilities_f.registration_date%type
338: ,registration_exp_date per_disabilities_f.registration_exp_date%type

Line 335: ,organization_id per_disabilities_f.organization_id%type

331: ,effective_start_date per_disabilities_f.effective_start_date%type
332: ,effective_end_date per_disabilities_f.effective_end_date%type
333: ,business_group_id per_all_people_f.business_group_id%type
334: ,incident_id per_disabilities_f.incident_id%type
335: ,organization_id per_disabilities_f.organization_id%type
336: ,registration_id per_disabilities_f.registration_id%type
337: ,registration_date per_disabilities_f.registration_date%type
338: ,registration_exp_date per_disabilities_f.registration_exp_date%type
339: ,categoryname per_disabilities_f.category%type

Line 336: ,registration_id per_disabilities_f.registration_id%type

332: ,effective_end_date per_disabilities_f.effective_end_date%type
333: ,business_group_id per_all_people_f.business_group_id%type
334: ,incident_id per_disabilities_f.incident_id%type
335: ,organization_id per_disabilities_f.organization_id%type
336: ,registration_id per_disabilities_f.registration_id%type
337: ,registration_date per_disabilities_f.registration_date%type
338: ,registration_exp_date per_disabilities_f.registration_exp_date%type
339: ,categoryname per_disabilities_f.category%type
340: ,description per_disabilities_f.description%type

Line 337: ,registration_date per_disabilities_f.registration_date%type

333: ,business_group_id per_all_people_f.business_group_id%type
334: ,incident_id per_disabilities_f.incident_id%type
335: ,organization_id per_disabilities_f.organization_id%type
336: ,registration_id per_disabilities_f.registration_id%type
337: ,registration_date per_disabilities_f.registration_date%type
338: ,registration_exp_date per_disabilities_f.registration_exp_date%type
339: ,categoryname per_disabilities_f.category%type
340: ,description per_disabilities_f.description%type
341: ,degree per_disabilities_f.degree%type

Line 338: ,registration_exp_date per_disabilities_f.registration_exp_date%type

334: ,incident_id per_disabilities_f.incident_id%type
335: ,organization_id per_disabilities_f.organization_id%type
336: ,registration_id per_disabilities_f.registration_id%type
337: ,registration_date per_disabilities_f.registration_date%type
338: ,registration_exp_date per_disabilities_f.registration_exp_date%type
339: ,categoryname per_disabilities_f.category%type
340: ,description per_disabilities_f.description%type
341: ,degree per_disabilities_f.degree%type
342: ,quota_fte per_disabilities_f.quota_fte%type

Line 339: ,categoryname per_disabilities_f.category%type

335: ,organization_id per_disabilities_f.organization_id%type
336: ,registration_id per_disabilities_f.registration_id%type
337: ,registration_date per_disabilities_f.registration_date%type
338: ,registration_exp_date per_disabilities_f.registration_exp_date%type
339: ,categoryname per_disabilities_f.category%type
340: ,description per_disabilities_f.description%type
341: ,degree per_disabilities_f.degree%type
342: ,quota_fte per_disabilities_f.quota_fte%type
343: ,reason per_disabilities_f.reason%type

Line 340: ,description per_disabilities_f.description%type

336: ,registration_id per_disabilities_f.registration_id%type
337: ,registration_date per_disabilities_f.registration_date%type
338: ,registration_exp_date per_disabilities_f.registration_exp_date%type
339: ,categoryname per_disabilities_f.category%type
340: ,description per_disabilities_f.description%type
341: ,degree per_disabilities_f.degree%type
342: ,quota_fte per_disabilities_f.quota_fte%type
343: ,reason per_disabilities_f.reason%type
344: ,pre_registration_job per_disabilities_f.pre_registration_job%type

Line 341: ,degree per_disabilities_f.degree%type

337: ,registration_date per_disabilities_f.registration_date%type
338: ,registration_exp_date per_disabilities_f.registration_exp_date%type
339: ,categoryname per_disabilities_f.category%type
340: ,description per_disabilities_f.description%type
341: ,degree per_disabilities_f.degree%type
342: ,quota_fte per_disabilities_f.quota_fte%type
343: ,reason per_disabilities_f.reason%type
344: ,pre_registration_job per_disabilities_f.pre_registration_job%type
345: ,work_restriction per_disabilities_f.work_restriction%type

Line 342: ,quota_fte per_disabilities_f.quota_fte%type

338: ,registration_exp_date per_disabilities_f.registration_exp_date%type
339: ,categoryname per_disabilities_f.category%type
340: ,description per_disabilities_f.description%type
341: ,degree per_disabilities_f.degree%type
342: ,quota_fte per_disabilities_f.quota_fte%type
343: ,reason per_disabilities_f.reason%type
344: ,pre_registration_job per_disabilities_f.pre_registration_job%type
345: ,work_restriction per_disabilities_f.work_restriction%type
346: ,object_version_number per_disabilities_f.object_version_number%type

Line 343: ,reason per_disabilities_f.reason%type

339: ,categoryname per_disabilities_f.category%type
340: ,description per_disabilities_f.description%type
341: ,degree per_disabilities_f.degree%type
342: ,quota_fte per_disabilities_f.quota_fte%type
343: ,reason per_disabilities_f.reason%type
344: ,pre_registration_job per_disabilities_f.pre_registration_job%type
345: ,work_restriction per_disabilities_f.work_restriction%type
346: ,object_version_number per_disabilities_f.object_version_number%type
347: ,status per_disabilities_f.status%type

Line 344: ,pre_registration_job per_disabilities_f.pre_registration_job%type

340: ,description per_disabilities_f.description%type
341: ,degree per_disabilities_f.degree%type
342: ,quota_fte per_disabilities_f.quota_fte%type
343: ,reason per_disabilities_f.reason%type
344: ,pre_registration_job per_disabilities_f.pre_registration_job%type
345: ,work_restriction per_disabilities_f.work_restriction%type
346: ,object_version_number per_disabilities_f.object_version_number%type
347: ,status per_disabilities_f.status%type
348: ,attribute1 per_disabilities_f.attribute1%type

Line 345: ,work_restriction per_disabilities_f.work_restriction%type

341: ,degree per_disabilities_f.degree%type
342: ,quota_fte per_disabilities_f.quota_fte%type
343: ,reason per_disabilities_f.reason%type
344: ,pre_registration_job per_disabilities_f.pre_registration_job%type
345: ,work_restriction per_disabilities_f.work_restriction%type
346: ,object_version_number per_disabilities_f.object_version_number%type
347: ,status per_disabilities_f.status%type
348: ,attribute1 per_disabilities_f.attribute1%type
349: ,attribute2 per_disabilities_f.attribute2%type

Line 346: ,object_version_number per_disabilities_f.object_version_number%type

342: ,quota_fte per_disabilities_f.quota_fte%type
343: ,reason per_disabilities_f.reason%type
344: ,pre_registration_job per_disabilities_f.pre_registration_job%type
345: ,work_restriction per_disabilities_f.work_restriction%type
346: ,object_version_number per_disabilities_f.object_version_number%type
347: ,status per_disabilities_f.status%type
348: ,attribute1 per_disabilities_f.attribute1%type
349: ,attribute2 per_disabilities_f.attribute2%type
350: ,attribute3 per_disabilities_f.attribute3%type

Line 347: ,status per_disabilities_f.status%type

343: ,reason per_disabilities_f.reason%type
344: ,pre_registration_job per_disabilities_f.pre_registration_job%type
345: ,work_restriction per_disabilities_f.work_restriction%type
346: ,object_version_number per_disabilities_f.object_version_number%type
347: ,status per_disabilities_f.status%type
348: ,attribute1 per_disabilities_f.attribute1%type
349: ,attribute2 per_disabilities_f.attribute2%type
350: ,attribute3 per_disabilities_f.attribute3%type
351: ,attribute4 per_disabilities_f.attribute4%type

Line 348: ,attribute1 per_disabilities_f.attribute1%type

344: ,pre_registration_job per_disabilities_f.pre_registration_job%type
345: ,work_restriction per_disabilities_f.work_restriction%type
346: ,object_version_number per_disabilities_f.object_version_number%type
347: ,status per_disabilities_f.status%type
348: ,attribute1 per_disabilities_f.attribute1%type
349: ,attribute2 per_disabilities_f.attribute2%type
350: ,attribute3 per_disabilities_f.attribute3%type
351: ,attribute4 per_disabilities_f.attribute4%type
352: ,attribute5 per_disabilities_f.attribute5%type

Line 349: ,attribute2 per_disabilities_f.attribute2%type

345: ,work_restriction per_disabilities_f.work_restriction%type
346: ,object_version_number per_disabilities_f.object_version_number%type
347: ,status per_disabilities_f.status%type
348: ,attribute1 per_disabilities_f.attribute1%type
349: ,attribute2 per_disabilities_f.attribute2%type
350: ,attribute3 per_disabilities_f.attribute3%type
351: ,attribute4 per_disabilities_f.attribute4%type
352: ,attribute5 per_disabilities_f.attribute5%type
353: ,attribute6 per_disabilities_f.attribute6%type

Line 350: ,attribute3 per_disabilities_f.attribute3%type

346: ,object_version_number per_disabilities_f.object_version_number%type
347: ,status per_disabilities_f.status%type
348: ,attribute1 per_disabilities_f.attribute1%type
349: ,attribute2 per_disabilities_f.attribute2%type
350: ,attribute3 per_disabilities_f.attribute3%type
351: ,attribute4 per_disabilities_f.attribute4%type
352: ,attribute5 per_disabilities_f.attribute5%type
353: ,attribute6 per_disabilities_f.attribute6%type
354: ,attribute7 per_disabilities_f.attribute7%type

Line 351: ,attribute4 per_disabilities_f.attribute4%type

347: ,status per_disabilities_f.status%type
348: ,attribute1 per_disabilities_f.attribute1%type
349: ,attribute2 per_disabilities_f.attribute2%type
350: ,attribute3 per_disabilities_f.attribute3%type
351: ,attribute4 per_disabilities_f.attribute4%type
352: ,attribute5 per_disabilities_f.attribute5%type
353: ,attribute6 per_disabilities_f.attribute6%type
354: ,attribute7 per_disabilities_f.attribute7%type
355: ,attribute8 per_disabilities_f.attribute8%type

Line 352: ,attribute5 per_disabilities_f.attribute5%type

348: ,attribute1 per_disabilities_f.attribute1%type
349: ,attribute2 per_disabilities_f.attribute2%type
350: ,attribute3 per_disabilities_f.attribute3%type
351: ,attribute4 per_disabilities_f.attribute4%type
352: ,attribute5 per_disabilities_f.attribute5%type
353: ,attribute6 per_disabilities_f.attribute6%type
354: ,attribute7 per_disabilities_f.attribute7%type
355: ,attribute8 per_disabilities_f.attribute8%type
356: ,attribute9 per_disabilities_f.attribute9%type

Line 353: ,attribute6 per_disabilities_f.attribute6%type

349: ,attribute2 per_disabilities_f.attribute2%type
350: ,attribute3 per_disabilities_f.attribute3%type
351: ,attribute4 per_disabilities_f.attribute4%type
352: ,attribute5 per_disabilities_f.attribute5%type
353: ,attribute6 per_disabilities_f.attribute6%type
354: ,attribute7 per_disabilities_f.attribute7%type
355: ,attribute8 per_disabilities_f.attribute8%type
356: ,attribute9 per_disabilities_f.attribute9%type
357: ,attribute10 per_disabilities_f.attribute10%type

Line 354: ,attribute7 per_disabilities_f.attribute7%type

350: ,attribute3 per_disabilities_f.attribute3%type
351: ,attribute4 per_disabilities_f.attribute4%type
352: ,attribute5 per_disabilities_f.attribute5%type
353: ,attribute6 per_disabilities_f.attribute6%type
354: ,attribute7 per_disabilities_f.attribute7%type
355: ,attribute8 per_disabilities_f.attribute8%type
356: ,attribute9 per_disabilities_f.attribute9%type
357: ,attribute10 per_disabilities_f.attribute10%type
358: ,dis_information1 per_disabilities_f.dis_information1%type

Line 355: ,attribute8 per_disabilities_f.attribute8%type

351: ,attribute4 per_disabilities_f.attribute4%type
352: ,attribute5 per_disabilities_f.attribute5%type
353: ,attribute6 per_disabilities_f.attribute6%type
354: ,attribute7 per_disabilities_f.attribute7%type
355: ,attribute8 per_disabilities_f.attribute8%type
356: ,attribute9 per_disabilities_f.attribute9%type
357: ,attribute10 per_disabilities_f.attribute10%type
358: ,dis_information1 per_disabilities_f.dis_information1%type
359: ,dis_information2 per_disabilities_f.dis_information2%type

Line 356: ,attribute9 per_disabilities_f.attribute9%type

352: ,attribute5 per_disabilities_f.attribute5%type
353: ,attribute6 per_disabilities_f.attribute6%type
354: ,attribute7 per_disabilities_f.attribute7%type
355: ,attribute8 per_disabilities_f.attribute8%type
356: ,attribute9 per_disabilities_f.attribute9%type
357: ,attribute10 per_disabilities_f.attribute10%type
358: ,dis_information1 per_disabilities_f.dis_information1%type
359: ,dis_information2 per_disabilities_f.dis_information2%type
360: ,dis_information3 per_disabilities_f.dis_information3%type

Line 357: ,attribute10 per_disabilities_f.attribute10%type

353: ,attribute6 per_disabilities_f.attribute6%type
354: ,attribute7 per_disabilities_f.attribute7%type
355: ,attribute8 per_disabilities_f.attribute8%type
356: ,attribute9 per_disabilities_f.attribute9%type
357: ,attribute10 per_disabilities_f.attribute10%type
358: ,dis_information1 per_disabilities_f.dis_information1%type
359: ,dis_information2 per_disabilities_f.dis_information2%type
360: ,dis_information3 per_disabilities_f.dis_information3%type
361: ,dis_information4 per_disabilities_f.dis_information4%type

Line 358: ,dis_information1 per_disabilities_f.dis_information1%type

354: ,attribute7 per_disabilities_f.attribute7%type
355: ,attribute8 per_disabilities_f.attribute8%type
356: ,attribute9 per_disabilities_f.attribute9%type
357: ,attribute10 per_disabilities_f.attribute10%type
358: ,dis_information1 per_disabilities_f.dis_information1%type
359: ,dis_information2 per_disabilities_f.dis_information2%type
360: ,dis_information3 per_disabilities_f.dis_information3%type
361: ,dis_information4 per_disabilities_f.dis_information4%type
362: ,dis_information5 per_disabilities_f.dis_information5%type

Line 359: ,dis_information2 per_disabilities_f.dis_information2%type

355: ,attribute8 per_disabilities_f.attribute8%type
356: ,attribute9 per_disabilities_f.attribute9%type
357: ,attribute10 per_disabilities_f.attribute10%type
358: ,dis_information1 per_disabilities_f.dis_information1%type
359: ,dis_information2 per_disabilities_f.dis_information2%type
360: ,dis_information3 per_disabilities_f.dis_information3%type
361: ,dis_information4 per_disabilities_f.dis_information4%type
362: ,dis_information5 per_disabilities_f.dis_information5%type
363: ,dis_information6 per_disabilities_f.dis_information6%type

Line 360: ,dis_information3 per_disabilities_f.dis_information3%type

356: ,attribute9 per_disabilities_f.attribute9%type
357: ,attribute10 per_disabilities_f.attribute10%type
358: ,dis_information1 per_disabilities_f.dis_information1%type
359: ,dis_information2 per_disabilities_f.dis_information2%type
360: ,dis_information3 per_disabilities_f.dis_information3%type
361: ,dis_information4 per_disabilities_f.dis_information4%type
362: ,dis_information5 per_disabilities_f.dis_information5%type
363: ,dis_information6 per_disabilities_f.dis_information6%type
364: ,dis_information7 per_disabilities_f.dis_information7%type

Line 361: ,dis_information4 per_disabilities_f.dis_information4%type

357: ,attribute10 per_disabilities_f.attribute10%type
358: ,dis_information1 per_disabilities_f.dis_information1%type
359: ,dis_information2 per_disabilities_f.dis_information2%type
360: ,dis_information3 per_disabilities_f.dis_information3%type
361: ,dis_information4 per_disabilities_f.dis_information4%type
362: ,dis_information5 per_disabilities_f.dis_information5%type
363: ,dis_information6 per_disabilities_f.dis_information6%type
364: ,dis_information7 per_disabilities_f.dis_information7%type
365: ,dis_information8 per_disabilities_f.dis_information8%type

Line 362: ,dis_information5 per_disabilities_f.dis_information5%type

358: ,dis_information1 per_disabilities_f.dis_information1%type
359: ,dis_information2 per_disabilities_f.dis_information2%type
360: ,dis_information3 per_disabilities_f.dis_information3%type
361: ,dis_information4 per_disabilities_f.dis_information4%type
362: ,dis_information5 per_disabilities_f.dis_information5%type
363: ,dis_information6 per_disabilities_f.dis_information6%type
364: ,dis_information7 per_disabilities_f.dis_information7%type
365: ,dis_information8 per_disabilities_f.dis_information8%type
366: ,dis_information9 per_disabilities_f.dis_information9%type

Line 363: ,dis_information6 per_disabilities_f.dis_information6%type

359: ,dis_information2 per_disabilities_f.dis_information2%type
360: ,dis_information3 per_disabilities_f.dis_information3%type
361: ,dis_information4 per_disabilities_f.dis_information4%type
362: ,dis_information5 per_disabilities_f.dis_information5%type
363: ,dis_information6 per_disabilities_f.dis_information6%type
364: ,dis_information7 per_disabilities_f.dis_information7%type
365: ,dis_information8 per_disabilities_f.dis_information8%type
366: ,dis_information9 per_disabilities_f.dis_information9%type
367: ,dis_information10 per_disabilities_f.dis_information10%type

Line 364: ,dis_information7 per_disabilities_f.dis_information7%type

360: ,dis_information3 per_disabilities_f.dis_information3%type
361: ,dis_information4 per_disabilities_f.dis_information4%type
362: ,dis_information5 per_disabilities_f.dis_information5%type
363: ,dis_information6 per_disabilities_f.dis_information6%type
364: ,dis_information7 per_disabilities_f.dis_information7%type
365: ,dis_information8 per_disabilities_f.dis_information8%type
366: ,dis_information9 per_disabilities_f.dis_information9%type
367: ,dis_information10 per_disabilities_f.dis_information10%type
368: ,update_mode varchar2(20)

Line 365: ,dis_information8 per_disabilities_f.dis_information8%type

361: ,dis_information4 per_disabilities_f.dis_information4%type
362: ,dis_information5 per_disabilities_f.dis_information5%type
363: ,dis_information6 per_disabilities_f.dis_information6%type
364: ,dis_information7 per_disabilities_f.dis_information7%type
365: ,dis_information8 per_disabilities_f.dis_information8%type
366: ,dis_information9 per_disabilities_f.dis_information9%type
367: ,dis_information10 per_disabilities_f.dis_information10%type
368: ,update_mode varchar2(20)
369: );

Line 366: ,dis_information9 per_disabilities_f.dis_information9%type

362: ,dis_information5 per_disabilities_f.dis_information5%type
363: ,dis_information6 per_disabilities_f.dis_information6%type
364: ,dis_information7 per_disabilities_f.dis_information7%type
365: ,dis_information8 per_disabilities_f.dis_information8%type
366: ,dis_information9 per_disabilities_f.dis_information9%type
367: ,dis_information10 per_disabilities_f.dis_information10%type
368: ,update_mode varchar2(20)
369: );
370:

Line 367: ,dis_information10 per_disabilities_f.dis_information10%type

363: ,dis_information6 per_disabilities_f.dis_information6%type
364: ,dis_information7 per_disabilities_f.dis_information7%type
365: ,dis_information8 per_disabilities_f.dis_information8%type
366: ,dis_information9 per_disabilities_f.dis_information9%type
367: ,dis_information10 per_disabilities_f.dis_information10%type
368: ,update_mode varchar2(20)
369: );
370:
371: --

Line 559: --procedure for logging changes to per_disabilities_f

555: p_effective_end_date in date default null,
556: p_business_group_id in number,
557: p_effective_date in date);
558:
559: --procedure for logging changes to per_disabilities_f
560: procedure log_per_dis_chg(
561: p_event in varchar2,
562: p_old_rec in per_dis_rec_type,
563: p_new_rec in per_dis_rec_type);