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.

[Home] [Help]

APPS.BEN_ELIG_CVRD_DPNT_API dependencies on HR_API

Line 117: l_cvg_thru_dt := hr_api.g_eot;

113: l_cvg_thru_dt := p_cvg_thru_dt;
114: --
115: if l_cvg_thru_dt is null then
116: --
117: l_cvg_thru_dt := hr_api.g_eot;
118: --
119: end if;
120: --
121: --

Line 179: when hr_api.cannot_find_prog_unit then

175: ,p_ovrdn_thru_dt => p_ovrdn_thru_dt
176: ,p_effective_date => trunc(p_effective_date)
177: );
178: exception
179: when hr_api.cannot_find_prog_unit then
180: hr_api.cannot_find_prog_unit_error
181: (
182: p_module_name => 'CREATE_ELIG_CVRD_DPNT'
183: ,p_hook_type => 'BP'

Line 180: hr_api.cannot_find_prog_unit_error

176: ,p_effective_date => trunc(p_effective_date)
177: );
178: exception
179: when hr_api.cannot_find_prog_unit then
180: hr_api.cannot_find_prog_unit_error
181: (
182: p_module_name => 'CREATE_ELIG_CVRD_DPNT'
183: ,p_hook_type => 'BP'
184: );

Line 247: if p_cvg_strt_dt is not null and l_cvg_thru_dt = hr_api.g_eot then

243: -- dbms_output.put_line('after rhi');
244: --
245: -- create person type usage, if needed
246: --
247: if p_cvg_strt_dt is not null and l_cvg_thru_dt = hr_api.g_eot then
248: --
249: add_usage( p_validate => p_validate
250: ,p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id
251: ,p_effective_date => p_effective_date

Line 260: p_cvg_strt_dt is not null and l_cvg_thru_dt = hr_api.g_eot) then

256: --
257: -- Call Action item RCO if p_multi_row_actn = TRUE
258: --
259: if (p_multi_row_actn and
260: p_cvg_strt_dt is not null and l_cvg_thru_dt = hr_api.g_eot) then
261: --
262: dpnt_actn_items(
263: p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
264: ,p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id

Line 383: when hr_api.cannot_find_prog_unit then

379: ,p_ovrdn_thru_dt => p_ovrdn_thru_dt
380: ,p_effective_date => trunc(p_effective_date)
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'CREATE_ELIG_CVRD_DPNT'
386: ,p_hook_type => 'AP'
387: );

Line 384: hr_api.cannot_find_prog_unit_error

380: ,p_effective_date => trunc(p_effective_date)
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'CREATE_ELIG_CVRD_DPNT'
386: ,p_hook_type => 'AP'
387: );
388: --

Line 398: raise hr_api.validate_enabled;

394: --
395: -- When in validation only mode raise the Validate_Enabled exception
396: --
397: if p_validate then
398: raise hr_api.validate_enabled;
399: end if;
400: --
401: -- Set all output arguments
402: --

Line 412: when hr_api.validate_enabled then

408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: --
410: exception
411: --
412: when hr_api.validate_enabled then
413: --
414: -- As the Validate_Enabled exception has been raised
415: -- we must rollback to the savepoint
416: --

Line 446: ,p_business_group_id in number default hr_api.g_number

442: (p_validate in boolean default false
443: ,p_elig_cvrd_dpnt_id in number
444: ,p_effective_start_date out nocopy date
445: ,p_effective_end_date out nocopy date
446: ,p_business_group_id in number default hr_api.g_number
447: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
448: ,p_dpnt_person_id in number default hr_api.g_number
449: ,p_cvg_strt_dt in date default hr_api.g_date
450: ,p_cvg_thru_dt in date default hr_api.g_date

Line 447: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

443: ,p_elig_cvrd_dpnt_id in number
444: ,p_effective_start_date out nocopy date
445: ,p_effective_end_date out nocopy date
446: ,p_business_group_id in number default hr_api.g_number
447: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
448: ,p_dpnt_person_id in number default hr_api.g_number
449: ,p_cvg_strt_dt in date default hr_api.g_date
450: ,p_cvg_thru_dt in date default hr_api.g_date
451: ,p_cvg_pndg_flag in varchar2 default hr_api.g_varchar2

Line 448: ,p_dpnt_person_id in number default hr_api.g_number

444: ,p_effective_start_date out nocopy date
445: ,p_effective_end_date out nocopy date
446: ,p_business_group_id in number default hr_api.g_number
447: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
448: ,p_dpnt_person_id in number default hr_api.g_number
449: ,p_cvg_strt_dt in date default hr_api.g_date
450: ,p_cvg_thru_dt in date default hr_api.g_date
451: ,p_cvg_pndg_flag in varchar2 default hr_api.g_varchar2
452: ,p_pdp_attribute_category in varchar2 default hr_api.g_varchar2

Line 449: ,p_cvg_strt_dt in date default hr_api.g_date

445: ,p_effective_end_date out nocopy date
446: ,p_business_group_id in number default hr_api.g_number
447: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
448: ,p_dpnt_person_id in number default hr_api.g_number
449: ,p_cvg_strt_dt in date default hr_api.g_date
450: ,p_cvg_thru_dt in date default hr_api.g_date
451: ,p_cvg_pndg_flag in varchar2 default hr_api.g_varchar2
452: ,p_pdp_attribute_category in varchar2 default hr_api.g_varchar2
453: ,p_pdp_attribute1 in varchar2 default hr_api.g_varchar2

Line 450: ,p_cvg_thru_dt in date default hr_api.g_date

446: ,p_business_group_id in number default hr_api.g_number
447: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
448: ,p_dpnt_person_id in number default hr_api.g_number
449: ,p_cvg_strt_dt in date default hr_api.g_date
450: ,p_cvg_thru_dt in date default hr_api.g_date
451: ,p_cvg_pndg_flag in varchar2 default hr_api.g_varchar2
452: ,p_pdp_attribute_category in varchar2 default hr_api.g_varchar2
453: ,p_pdp_attribute1 in varchar2 default hr_api.g_varchar2
454: ,p_pdp_attribute2 in varchar2 default hr_api.g_varchar2

Line 451: ,p_cvg_pndg_flag in varchar2 default hr_api.g_varchar2

447: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
448: ,p_dpnt_person_id in number default hr_api.g_number
449: ,p_cvg_strt_dt in date default hr_api.g_date
450: ,p_cvg_thru_dt in date default hr_api.g_date
451: ,p_cvg_pndg_flag in varchar2 default hr_api.g_varchar2
452: ,p_pdp_attribute_category in varchar2 default hr_api.g_varchar2
453: ,p_pdp_attribute1 in varchar2 default hr_api.g_varchar2
454: ,p_pdp_attribute2 in varchar2 default hr_api.g_varchar2
455: ,p_pdp_attribute3 in varchar2 default hr_api.g_varchar2

Line 452: ,p_pdp_attribute_category in varchar2 default hr_api.g_varchar2

448: ,p_dpnt_person_id in number default hr_api.g_number
449: ,p_cvg_strt_dt in date default hr_api.g_date
450: ,p_cvg_thru_dt in date default hr_api.g_date
451: ,p_cvg_pndg_flag in varchar2 default hr_api.g_varchar2
452: ,p_pdp_attribute_category in varchar2 default hr_api.g_varchar2
453: ,p_pdp_attribute1 in varchar2 default hr_api.g_varchar2
454: ,p_pdp_attribute2 in varchar2 default hr_api.g_varchar2
455: ,p_pdp_attribute3 in varchar2 default hr_api.g_varchar2
456: ,p_pdp_attribute4 in varchar2 default hr_api.g_varchar2

Line 453: ,p_pdp_attribute1 in varchar2 default hr_api.g_varchar2

449: ,p_cvg_strt_dt in date default hr_api.g_date
450: ,p_cvg_thru_dt in date default hr_api.g_date
451: ,p_cvg_pndg_flag in varchar2 default hr_api.g_varchar2
452: ,p_pdp_attribute_category in varchar2 default hr_api.g_varchar2
453: ,p_pdp_attribute1 in varchar2 default hr_api.g_varchar2
454: ,p_pdp_attribute2 in varchar2 default hr_api.g_varchar2
455: ,p_pdp_attribute3 in varchar2 default hr_api.g_varchar2
456: ,p_pdp_attribute4 in varchar2 default hr_api.g_varchar2
457: ,p_pdp_attribute5 in varchar2 default hr_api.g_varchar2

Line 454: ,p_pdp_attribute2 in varchar2 default hr_api.g_varchar2

450: ,p_cvg_thru_dt in date default hr_api.g_date
451: ,p_cvg_pndg_flag in varchar2 default hr_api.g_varchar2
452: ,p_pdp_attribute_category in varchar2 default hr_api.g_varchar2
453: ,p_pdp_attribute1 in varchar2 default hr_api.g_varchar2
454: ,p_pdp_attribute2 in varchar2 default hr_api.g_varchar2
455: ,p_pdp_attribute3 in varchar2 default hr_api.g_varchar2
456: ,p_pdp_attribute4 in varchar2 default hr_api.g_varchar2
457: ,p_pdp_attribute5 in varchar2 default hr_api.g_varchar2
458: ,p_pdp_attribute6 in varchar2 default hr_api.g_varchar2

Line 455: ,p_pdp_attribute3 in varchar2 default hr_api.g_varchar2

451: ,p_cvg_pndg_flag in varchar2 default hr_api.g_varchar2
452: ,p_pdp_attribute_category in varchar2 default hr_api.g_varchar2
453: ,p_pdp_attribute1 in varchar2 default hr_api.g_varchar2
454: ,p_pdp_attribute2 in varchar2 default hr_api.g_varchar2
455: ,p_pdp_attribute3 in varchar2 default hr_api.g_varchar2
456: ,p_pdp_attribute4 in varchar2 default hr_api.g_varchar2
457: ,p_pdp_attribute5 in varchar2 default hr_api.g_varchar2
458: ,p_pdp_attribute6 in varchar2 default hr_api.g_varchar2
459: ,p_pdp_attribute7 in varchar2 default hr_api.g_varchar2

Line 456: ,p_pdp_attribute4 in varchar2 default hr_api.g_varchar2

452: ,p_pdp_attribute_category in varchar2 default hr_api.g_varchar2
453: ,p_pdp_attribute1 in varchar2 default hr_api.g_varchar2
454: ,p_pdp_attribute2 in varchar2 default hr_api.g_varchar2
455: ,p_pdp_attribute3 in varchar2 default hr_api.g_varchar2
456: ,p_pdp_attribute4 in varchar2 default hr_api.g_varchar2
457: ,p_pdp_attribute5 in varchar2 default hr_api.g_varchar2
458: ,p_pdp_attribute6 in varchar2 default hr_api.g_varchar2
459: ,p_pdp_attribute7 in varchar2 default hr_api.g_varchar2
460: ,p_pdp_attribute8 in varchar2 default hr_api.g_varchar2

Line 457: ,p_pdp_attribute5 in varchar2 default hr_api.g_varchar2

453: ,p_pdp_attribute1 in varchar2 default hr_api.g_varchar2
454: ,p_pdp_attribute2 in varchar2 default hr_api.g_varchar2
455: ,p_pdp_attribute3 in varchar2 default hr_api.g_varchar2
456: ,p_pdp_attribute4 in varchar2 default hr_api.g_varchar2
457: ,p_pdp_attribute5 in varchar2 default hr_api.g_varchar2
458: ,p_pdp_attribute6 in varchar2 default hr_api.g_varchar2
459: ,p_pdp_attribute7 in varchar2 default hr_api.g_varchar2
460: ,p_pdp_attribute8 in varchar2 default hr_api.g_varchar2
461: ,p_pdp_attribute9 in varchar2 default hr_api.g_varchar2

Line 458: ,p_pdp_attribute6 in varchar2 default hr_api.g_varchar2

454: ,p_pdp_attribute2 in varchar2 default hr_api.g_varchar2
455: ,p_pdp_attribute3 in varchar2 default hr_api.g_varchar2
456: ,p_pdp_attribute4 in varchar2 default hr_api.g_varchar2
457: ,p_pdp_attribute5 in varchar2 default hr_api.g_varchar2
458: ,p_pdp_attribute6 in varchar2 default hr_api.g_varchar2
459: ,p_pdp_attribute7 in varchar2 default hr_api.g_varchar2
460: ,p_pdp_attribute8 in varchar2 default hr_api.g_varchar2
461: ,p_pdp_attribute9 in varchar2 default hr_api.g_varchar2
462: ,p_pdp_attribute10 in varchar2 default hr_api.g_varchar2

Line 459: ,p_pdp_attribute7 in varchar2 default hr_api.g_varchar2

455: ,p_pdp_attribute3 in varchar2 default hr_api.g_varchar2
456: ,p_pdp_attribute4 in varchar2 default hr_api.g_varchar2
457: ,p_pdp_attribute5 in varchar2 default hr_api.g_varchar2
458: ,p_pdp_attribute6 in varchar2 default hr_api.g_varchar2
459: ,p_pdp_attribute7 in varchar2 default hr_api.g_varchar2
460: ,p_pdp_attribute8 in varchar2 default hr_api.g_varchar2
461: ,p_pdp_attribute9 in varchar2 default hr_api.g_varchar2
462: ,p_pdp_attribute10 in varchar2 default hr_api.g_varchar2
463: ,p_pdp_attribute11 in varchar2 default hr_api.g_varchar2

Line 460: ,p_pdp_attribute8 in varchar2 default hr_api.g_varchar2

456: ,p_pdp_attribute4 in varchar2 default hr_api.g_varchar2
457: ,p_pdp_attribute5 in varchar2 default hr_api.g_varchar2
458: ,p_pdp_attribute6 in varchar2 default hr_api.g_varchar2
459: ,p_pdp_attribute7 in varchar2 default hr_api.g_varchar2
460: ,p_pdp_attribute8 in varchar2 default hr_api.g_varchar2
461: ,p_pdp_attribute9 in varchar2 default hr_api.g_varchar2
462: ,p_pdp_attribute10 in varchar2 default hr_api.g_varchar2
463: ,p_pdp_attribute11 in varchar2 default hr_api.g_varchar2
464: ,p_pdp_attribute12 in varchar2 default hr_api.g_varchar2

Line 461: ,p_pdp_attribute9 in varchar2 default hr_api.g_varchar2

457: ,p_pdp_attribute5 in varchar2 default hr_api.g_varchar2
458: ,p_pdp_attribute6 in varchar2 default hr_api.g_varchar2
459: ,p_pdp_attribute7 in varchar2 default hr_api.g_varchar2
460: ,p_pdp_attribute8 in varchar2 default hr_api.g_varchar2
461: ,p_pdp_attribute9 in varchar2 default hr_api.g_varchar2
462: ,p_pdp_attribute10 in varchar2 default hr_api.g_varchar2
463: ,p_pdp_attribute11 in varchar2 default hr_api.g_varchar2
464: ,p_pdp_attribute12 in varchar2 default hr_api.g_varchar2
465: ,p_pdp_attribute13 in varchar2 default hr_api.g_varchar2

Line 462: ,p_pdp_attribute10 in varchar2 default hr_api.g_varchar2

458: ,p_pdp_attribute6 in varchar2 default hr_api.g_varchar2
459: ,p_pdp_attribute7 in varchar2 default hr_api.g_varchar2
460: ,p_pdp_attribute8 in varchar2 default hr_api.g_varchar2
461: ,p_pdp_attribute9 in varchar2 default hr_api.g_varchar2
462: ,p_pdp_attribute10 in varchar2 default hr_api.g_varchar2
463: ,p_pdp_attribute11 in varchar2 default hr_api.g_varchar2
464: ,p_pdp_attribute12 in varchar2 default hr_api.g_varchar2
465: ,p_pdp_attribute13 in varchar2 default hr_api.g_varchar2
466: ,p_pdp_attribute14 in varchar2 default hr_api.g_varchar2

Line 463: ,p_pdp_attribute11 in varchar2 default hr_api.g_varchar2

459: ,p_pdp_attribute7 in varchar2 default hr_api.g_varchar2
460: ,p_pdp_attribute8 in varchar2 default hr_api.g_varchar2
461: ,p_pdp_attribute9 in varchar2 default hr_api.g_varchar2
462: ,p_pdp_attribute10 in varchar2 default hr_api.g_varchar2
463: ,p_pdp_attribute11 in varchar2 default hr_api.g_varchar2
464: ,p_pdp_attribute12 in varchar2 default hr_api.g_varchar2
465: ,p_pdp_attribute13 in varchar2 default hr_api.g_varchar2
466: ,p_pdp_attribute14 in varchar2 default hr_api.g_varchar2
467: ,p_pdp_attribute15 in varchar2 default hr_api.g_varchar2

Line 464: ,p_pdp_attribute12 in varchar2 default hr_api.g_varchar2

460: ,p_pdp_attribute8 in varchar2 default hr_api.g_varchar2
461: ,p_pdp_attribute9 in varchar2 default hr_api.g_varchar2
462: ,p_pdp_attribute10 in varchar2 default hr_api.g_varchar2
463: ,p_pdp_attribute11 in varchar2 default hr_api.g_varchar2
464: ,p_pdp_attribute12 in varchar2 default hr_api.g_varchar2
465: ,p_pdp_attribute13 in varchar2 default hr_api.g_varchar2
466: ,p_pdp_attribute14 in varchar2 default hr_api.g_varchar2
467: ,p_pdp_attribute15 in varchar2 default hr_api.g_varchar2
468: ,p_pdp_attribute16 in varchar2 default hr_api.g_varchar2

Line 465: ,p_pdp_attribute13 in varchar2 default hr_api.g_varchar2

461: ,p_pdp_attribute9 in varchar2 default hr_api.g_varchar2
462: ,p_pdp_attribute10 in varchar2 default hr_api.g_varchar2
463: ,p_pdp_attribute11 in varchar2 default hr_api.g_varchar2
464: ,p_pdp_attribute12 in varchar2 default hr_api.g_varchar2
465: ,p_pdp_attribute13 in varchar2 default hr_api.g_varchar2
466: ,p_pdp_attribute14 in varchar2 default hr_api.g_varchar2
467: ,p_pdp_attribute15 in varchar2 default hr_api.g_varchar2
468: ,p_pdp_attribute16 in varchar2 default hr_api.g_varchar2
469: ,p_pdp_attribute17 in varchar2 default hr_api.g_varchar2

Line 466: ,p_pdp_attribute14 in varchar2 default hr_api.g_varchar2

462: ,p_pdp_attribute10 in varchar2 default hr_api.g_varchar2
463: ,p_pdp_attribute11 in varchar2 default hr_api.g_varchar2
464: ,p_pdp_attribute12 in varchar2 default hr_api.g_varchar2
465: ,p_pdp_attribute13 in varchar2 default hr_api.g_varchar2
466: ,p_pdp_attribute14 in varchar2 default hr_api.g_varchar2
467: ,p_pdp_attribute15 in varchar2 default hr_api.g_varchar2
468: ,p_pdp_attribute16 in varchar2 default hr_api.g_varchar2
469: ,p_pdp_attribute17 in varchar2 default hr_api.g_varchar2
470: ,p_pdp_attribute18 in varchar2 default hr_api.g_varchar2

Line 467: ,p_pdp_attribute15 in varchar2 default hr_api.g_varchar2

463: ,p_pdp_attribute11 in varchar2 default hr_api.g_varchar2
464: ,p_pdp_attribute12 in varchar2 default hr_api.g_varchar2
465: ,p_pdp_attribute13 in varchar2 default hr_api.g_varchar2
466: ,p_pdp_attribute14 in varchar2 default hr_api.g_varchar2
467: ,p_pdp_attribute15 in varchar2 default hr_api.g_varchar2
468: ,p_pdp_attribute16 in varchar2 default hr_api.g_varchar2
469: ,p_pdp_attribute17 in varchar2 default hr_api.g_varchar2
470: ,p_pdp_attribute18 in varchar2 default hr_api.g_varchar2
471: ,p_pdp_attribute19 in varchar2 default hr_api.g_varchar2

Line 468: ,p_pdp_attribute16 in varchar2 default hr_api.g_varchar2

464: ,p_pdp_attribute12 in varchar2 default hr_api.g_varchar2
465: ,p_pdp_attribute13 in varchar2 default hr_api.g_varchar2
466: ,p_pdp_attribute14 in varchar2 default hr_api.g_varchar2
467: ,p_pdp_attribute15 in varchar2 default hr_api.g_varchar2
468: ,p_pdp_attribute16 in varchar2 default hr_api.g_varchar2
469: ,p_pdp_attribute17 in varchar2 default hr_api.g_varchar2
470: ,p_pdp_attribute18 in varchar2 default hr_api.g_varchar2
471: ,p_pdp_attribute19 in varchar2 default hr_api.g_varchar2
472: ,p_pdp_attribute20 in varchar2 default hr_api.g_varchar2

Line 469: ,p_pdp_attribute17 in varchar2 default hr_api.g_varchar2

465: ,p_pdp_attribute13 in varchar2 default hr_api.g_varchar2
466: ,p_pdp_attribute14 in varchar2 default hr_api.g_varchar2
467: ,p_pdp_attribute15 in varchar2 default hr_api.g_varchar2
468: ,p_pdp_attribute16 in varchar2 default hr_api.g_varchar2
469: ,p_pdp_attribute17 in varchar2 default hr_api.g_varchar2
470: ,p_pdp_attribute18 in varchar2 default hr_api.g_varchar2
471: ,p_pdp_attribute19 in varchar2 default hr_api.g_varchar2
472: ,p_pdp_attribute20 in varchar2 default hr_api.g_varchar2
473: ,p_pdp_attribute21 in varchar2 default hr_api.g_varchar2

Line 470: ,p_pdp_attribute18 in varchar2 default hr_api.g_varchar2

466: ,p_pdp_attribute14 in varchar2 default hr_api.g_varchar2
467: ,p_pdp_attribute15 in varchar2 default hr_api.g_varchar2
468: ,p_pdp_attribute16 in varchar2 default hr_api.g_varchar2
469: ,p_pdp_attribute17 in varchar2 default hr_api.g_varchar2
470: ,p_pdp_attribute18 in varchar2 default hr_api.g_varchar2
471: ,p_pdp_attribute19 in varchar2 default hr_api.g_varchar2
472: ,p_pdp_attribute20 in varchar2 default hr_api.g_varchar2
473: ,p_pdp_attribute21 in varchar2 default hr_api.g_varchar2
474: ,p_pdp_attribute22 in varchar2 default hr_api.g_varchar2

Line 471: ,p_pdp_attribute19 in varchar2 default hr_api.g_varchar2

467: ,p_pdp_attribute15 in varchar2 default hr_api.g_varchar2
468: ,p_pdp_attribute16 in varchar2 default hr_api.g_varchar2
469: ,p_pdp_attribute17 in varchar2 default hr_api.g_varchar2
470: ,p_pdp_attribute18 in varchar2 default hr_api.g_varchar2
471: ,p_pdp_attribute19 in varchar2 default hr_api.g_varchar2
472: ,p_pdp_attribute20 in varchar2 default hr_api.g_varchar2
473: ,p_pdp_attribute21 in varchar2 default hr_api.g_varchar2
474: ,p_pdp_attribute22 in varchar2 default hr_api.g_varchar2
475: ,p_pdp_attribute23 in varchar2 default hr_api.g_varchar2

Line 472: ,p_pdp_attribute20 in varchar2 default hr_api.g_varchar2

468: ,p_pdp_attribute16 in varchar2 default hr_api.g_varchar2
469: ,p_pdp_attribute17 in varchar2 default hr_api.g_varchar2
470: ,p_pdp_attribute18 in varchar2 default hr_api.g_varchar2
471: ,p_pdp_attribute19 in varchar2 default hr_api.g_varchar2
472: ,p_pdp_attribute20 in varchar2 default hr_api.g_varchar2
473: ,p_pdp_attribute21 in varchar2 default hr_api.g_varchar2
474: ,p_pdp_attribute22 in varchar2 default hr_api.g_varchar2
475: ,p_pdp_attribute23 in varchar2 default hr_api.g_varchar2
476: ,p_pdp_attribute24 in varchar2 default hr_api.g_varchar2

Line 473: ,p_pdp_attribute21 in varchar2 default hr_api.g_varchar2

469: ,p_pdp_attribute17 in varchar2 default hr_api.g_varchar2
470: ,p_pdp_attribute18 in varchar2 default hr_api.g_varchar2
471: ,p_pdp_attribute19 in varchar2 default hr_api.g_varchar2
472: ,p_pdp_attribute20 in varchar2 default hr_api.g_varchar2
473: ,p_pdp_attribute21 in varchar2 default hr_api.g_varchar2
474: ,p_pdp_attribute22 in varchar2 default hr_api.g_varchar2
475: ,p_pdp_attribute23 in varchar2 default hr_api.g_varchar2
476: ,p_pdp_attribute24 in varchar2 default hr_api.g_varchar2
477: ,p_pdp_attribute25 in varchar2 default hr_api.g_varchar2

Line 474: ,p_pdp_attribute22 in varchar2 default hr_api.g_varchar2

470: ,p_pdp_attribute18 in varchar2 default hr_api.g_varchar2
471: ,p_pdp_attribute19 in varchar2 default hr_api.g_varchar2
472: ,p_pdp_attribute20 in varchar2 default hr_api.g_varchar2
473: ,p_pdp_attribute21 in varchar2 default hr_api.g_varchar2
474: ,p_pdp_attribute22 in varchar2 default hr_api.g_varchar2
475: ,p_pdp_attribute23 in varchar2 default hr_api.g_varchar2
476: ,p_pdp_attribute24 in varchar2 default hr_api.g_varchar2
477: ,p_pdp_attribute25 in varchar2 default hr_api.g_varchar2
478: ,p_pdp_attribute26 in varchar2 default hr_api.g_varchar2

Line 475: ,p_pdp_attribute23 in varchar2 default hr_api.g_varchar2

471: ,p_pdp_attribute19 in varchar2 default hr_api.g_varchar2
472: ,p_pdp_attribute20 in varchar2 default hr_api.g_varchar2
473: ,p_pdp_attribute21 in varchar2 default hr_api.g_varchar2
474: ,p_pdp_attribute22 in varchar2 default hr_api.g_varchar2
475: ,p_pdp_attribute23 in varchar2 default hr_api.g_varchar2
476: ,p_pdp_attribute24 in varchar2 default hr_api.g_varchar2
477: ,p_pdp_attribute25 in varchar2 default hr_api.g_varchar2
478: ,p_pdp_attribute26 in varchar2 default hr_api.g_varchar2
479: ,p_pdp_attribute27 in varchar2 default hr_api.g_varchar2

Line 476: ,p_pdp_attribute24 in varchar2 default hr_api.g_varchar2

472: ,p_pdp_attribute20 in varchar2 default hr_api.g_varchar2
473: ,p_pdp_attribute21 in varchar2 default hr_api.g_varchar2
474: ,p_pdp_attribute22 in varchar2 default hr_api.g_varchar2
475: ,p_pdp_attribute23 in varchar2 default hr_api.g_varchar2
476: ,p_pdp_attribute24 in varchar2 default hr_api.g_varchar2
477: ,p_pdp_attribute25 in varchar2 default hr_api.g_varchar2
478: ,p_pdp_attribute26 in varchar2 default hr_api.g_varchar2
479: ,p_pdp_attribute27 in varchar2 default hr_api.g_varchar2
480: ,p_pdp_attribute28 in varchar2 default hr_api.g_varchar2

Line 477: ,p_pdp_attribute25 in varchar2 default hr_api.g_varchar2

473: ,p_pdp_attribute21 in varchar2 default hr_api.g_varchar2
474: ,p_pdp_attribute22 in varchar2 default hr_api.g_varchar2
475: ,p_pdp_attribute23 in varchar2 default hr_api.g_varchar2
476: ,p_pdp_attribute24 in varchar2 default hr_api.g_varchar2
477: ,p_pdp_attribute25 in varchar2 default hr_api.g_varchar2
478: ,p_pdp_attribute26 in varchar2 default hr_api.g_varchar2
479: ,p_pdp_attribute27 in varchar2 default hr_api.g_varchar2
480: ,p_pdp_attribute28 in varchar2 default hr_api.g_varchar2
481: ,p_pdp_attribute29 in varchar2 default hr_api.g_varchar2

Line 478: ,p_pdp_attribute26 in varchar2 default hr_api.g_varchar2

474: ,p_pdp_attribute22 in varchar2 default hr_api.g_varchar2
475: ,p_pdp_attribute23 in varchar2 default hr_api.g_varchar2
476: ,p_pdp_attribute24 in varchar2 default hr_api.g_varchar2
477: ,p_pdp_attribute25 in varchar2 default hr_api.g_varchar2
478: ,p_pdp_attribute26 in varchar2 default hr_api.g_varchar2
479: ,p_pdp_attribute27 in varchar2 default hr_api.g_varchar2
480: ,p_pdp_attribute28 in varchar2 default hr_api.g_varchar2
481: ,p_pdp_attribute29 in varchar2 default hr_api.g_varchar2
482: ,p_pdp_attribute30 in varchar2 default hr_api.g_varchar2

Line 479: ,p_pdp_attribute27 in varchar2 default hr_api.g_varchar2

475: ,p_pdp_attribute23 in varchar2 default hr_api.g_varchar2
476: ,p_pdp_attribute24 in varchar2 default hr_api.g_varchar2
477: ,p_pdp_attribute25 in varchar2 default hr_api.g_varchar2
478: ,p_pdp_attribute26 in varchar2 default hr_api.g_varchar2
479: ,p_pdp_attribute27 in varchar2 default hr_api.g_varchar2
480: ,p_pdp_attribute28 in varchar2 default hr_api.g_varchar2
481: ,p_pdp_attribute29 in varchar2 default hr_api.g_varchar2
482: ,p_pdp_attribute30 in varchar2 default hr_api.g_varchar2
483: ,p_request_id in number default hr_api.g_number

Line 480: ,p_pdp_attribute28 in varchar2 default hr_api.g_varchar2

476: ,p_pdp_attribute24 in varchar2 default hr_api.g_varchar2
477: ,p_pdp_attribute25 in varchar2 default hr_api.g_varchar2
478: ,p_pdp_attribute26 in varchar2 default hr_api.g_varchar2
479: ,p_pdp_attribute27 in varchar2 default hr_api.g_varchar2
480: ,p_pdp_attribute28 in varchar2 default hr_api.g_varchar2
481: ,p_pdp_attribute29 in varchar2 default hr_api.g_varchar2
482: ,p_pdp_attribute30 in varchar2 default hr_api.g_varchar2
483: ,p_request_id in number default hr_api.g_number
484: ,p_program_application_id in number default hr_api.g_number

Line 481: ,p_pdp_attribute29 in varchar2 default hr_api.g_varchar2

477: ,p_pdp_attribute25 in varchar2 default hr_api.g_varchar2
478: ,p_pdp_attribute26 in varchar2 default hr_api.g_varchar2
479: ,p_pdp_attribute27 in varchar2 default hr_api.g_varchar2
480: ,p_pdp_attribute28 in varchar2 default hr_api.g_varchar2
481: ,p_pdp_attribute29 in varchar2 default hr_api.g_varchar2
482: ,p_pdp_attribute30 in varchar2 default hr_api.g_varchar2
483: ,p_request_id in number default hr_api.g_number
484: ,p_program_application_id in number default hr_api.g_number
485: ,p_program_id in number default hr_api.g_number

Line 482: ,p_pdp_attribute30 in varchar2 default hr_api.g_varchar2

478: ,p_pdp_attribute26 in varchar2 default hr_api.g_varchar2
479: ,p_pdp_attribute27 in varchar2 default hr_api.g_varchar2
480: ,p_pdp_attribute28 in varchar2 default hr_api.g_varchar2
481: ,p_pdp_attribute29 in varchar2 default hr_api.g_varchar2
482: ,p_pdp_attribute30 in varchar2 default hr_api.g_varchar2
483: ,p_request_id in number default hr_api.g_number
484: ,p_program_application_id in number default hr_api.g_number
485: ,p_program_id in number default hr_api.g_number
486: ,p_program_update_date in date default hr_api.g_date

Line 483: ,p_request_id in number default hr_api.g_number

479: ,p_pdp_attribute27 in varchar2 default hr_api.g_varchar2
480: ,p_pdp_attribute28 in varchar2 default hr_api.g_varchar2
481: ,p_pdp_attribute29 in varchar2 default hr_api.g_varchar2
482: ,p_pdp_attribute30 in varchar2 default hr_api.g_varchar2
483: ,p_request_id in number default hr_api.g_number
484: ,p_program_application_id in number default hr_api.g_number
485: ,p_program_id in number default hr_api.g_number
486: ,p_program_update_date in date default hr_api.g_date
487: ,p_object_version_number in out nocopy number

Line 484: ,p_program_application_id in number default hr_api.g_number

480: ,p_pdp_attribute28 in varchar2 default hr_api.g_varchar2
481: ,p_pdp_attribute29 in varchar2 default hr_api.g_varchar2
482: ,p_pdp_attribute30 in varchar2 default hr_api.g_varchar2
483: ,p_request_id in number default hr_api.g_number
484: ,p_program_application_id in number default hr_api.g_number
485: ,p_program_id in number default hr_api.g_number
486: ,p_program_update_date in date default hr_api.g_date
487: ,p_object_version_number in out nocopy number
488: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2

Line 485: ,p_program_id in number default hr_api.g_number

481: ,p_pdp_attribute29 in varchar2 default hr_api.g_varchar2
482: ,p_pdp_attribute30 in varchar2 default hr_api.g_varchar2
483: ,p_request_id in number default hr_api.g_number
484: ,p_program_application_id in number default hr_api.g_number
485: ,p_program_id in number default hr_api.g_number
486: ,p_program_update_date in date default hr_api.g_date
487: ,p_object_version_number in out nocopy number
488: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
489: ,p_per_in_ler_id in number default hr_api.g_number

Line 486: ,p_program_update_date in date default hr_api.g_date

482: ,p_pdp_attribute30 in varchar2 default hr_api.g_varchar2
483: ,p_request_id in number default hr_api.g_number
484: ,p_program_application_id in number default hr_api.g_number
485: ,p_program_id in number default hr_api.g_number
486: ,p_program_update_date in date default hr_api.g_date
487: ,p_object_version_number in out nocopy number
488: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
489: ,p_per_in_ler_id in number default hr_api.g_number
490: ,p_ovrdn_thru_dt in date default hr_api.g_date

Line 488: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2

484: ,p_program_application_id in number default hr_api.g_number
485: ,p_program_id in number default hr_api.g_number
486: ,p_program_update_date in date default hr_api.g_date
487: ,p_object_version_number in out nocopy number
488: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
489: ,p_per_in_ler_id in number default hr_api.g_number
490: ,p_ovrdn_thru_dt in date default hr_api.g_date
491: ,p_effective_date in date
492: ,p_datetrack_mode in varchar2

Line 489: ,p_per_in_ler_id in number default hr_api.g_number

485: ,p_program_id in number default hr_api.g_number
486: ,p_program_update_date in date default hr_api.g_date
487: ,p_object_version_number in out nocopy number
488: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
489: ,p_per_in_ler_id in number default hr_api.g_number
490: ,p_ovrdn_thru_dt in date default hr_api.g_date
491: ,p_effective_date in date
492: ,p_datetrack_mode in varchar2
493: ,p_multi_row_actn in boolean default TRUE

Line 490: ,p_ovrdn_thru_dt in date default hr_api.g_date

486: ,p_program_update_date in date default hr_api.g_date
487: ,p_object_version_number in out nocopy number
488: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
489: ,p_per_in_ler_id in number default hr_api.g_number
490: ,p_ovrdn_thru_dt in date default hr_api.g_date
491: ,p_effective_date in date
492: ,p_datetrack_mode in varchar2
493: ,p_multi_row_actn in boolean default TRUE
494: ) is

Line 523: and (x_datetrack_mode=hr_api.g_delete

519: and p_effective_date between bcc.effective_start_date
520: and bcc.effective_end_date
521: and p_effective_date between bpe.effective_start_date
522: and bpe.effective_end_date
523: and (x_datetrack_mode=hr_api.g_delete
524: and p_effective_date<>bcc.effective_end_date
525: or x_datetrack_mode=hr_api.g_zap)
526: ;
527: --

Line 525: or x_datetrack_mode=hr_api.g_zap)

521: and p_effective_date between bpe.effective_start_date
522: and bpe.effective_end_date
523: and (x_datetrack_mode=hr_api.g_delete
524: and p_effective_date<>bcc.effective_end_date
525: or x_datetrack_mode=hr_api.g_zap)
526: ;
527: --
528: cursor c_get_previous_values is
529: SELECT pdp.cvg_strt_dt,

Line 575: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot

571: from ben_prmry_care_prvdr_f pcp
572: where pcp.business_group_id = p_business_group_id
573: and pcp.elig_cvrd_dpnt_id = c_elig_cvrd_dpnt_id
574: and c_pcp_effective_date < pcp.effective_start_date ----3631067: Changed p_effective_date to c_pcp_effective_date
575: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot
576: ;
577: -- 3574168
578:
579: --

Line 629: if l_previous_values.cvg_thru_dt = hr_api.g_eot

625: close c_get_previous_values;
626: --
627: -- Ending Benefit Coverage for Dependent.
628: --
629: if l_previous_values.cvg_thru_dt = hr_api.g_eot
630: and p_cvg_thru_dt <> hr_api.g_date
631: and p_cvg_thru_dt <> hr_api.g_eot then
632: --
633: -- Call the extract change event logging process.

Line 630: and p_cvg_thru_dt <> hr_api.g_date

626: --
627: -- Ending Benefit Coverage for Dependent.
628: --
629: if l_previous_values.cvg_thru_dt = hr_api.g_eot
630: and p_cvg_thru_dt <> hr_api.g_date
631: and p_cvg_thru_dt <> hr_api.g_eot then
632: --
633: -- Call the extract change event logging process.
634: --

Line 631: and p_cvg_thru_dt <> hr_api.g_eot then

627: -- Ending Benefit Coverage for Dependent.
628: --
629: if l_previous_values.cvg_thru_dt = hr_api.g_eot
630: and p_cvg_thru_dt <> hr_api.g_date
631: and p_cvg_thru_dt <> hr_api.g_eot then
632: --
633: -- Call the extract change event logging process.
634: --
635: ben_ext_chlg.log_dependent_chg

Line 656: elsif l_previous_values.cvg_thru_dt <> hr_api.g_eot

652: --
653: --
654: -- Benefit reinstatement for Dependent.
655: --
656: elsif l_previous_values.cvg_thru_dt <> hr_api.g_eot
657: and p_cvg_thru_dt = hr_api.g_eot then
658: --
659: --
660: ben_ext_chlg.log_dependent_chg

Line 657: and p_cvg_thru_dt = hr_api.g_eot then

653: --
654: -- Benefit reinstatement for Dependent.
655: --
656: elsif l_previous_values.cvg_thru_dt <> hr_api.g_eot
657: and p_cvg_thru_dt = hr_api.g_eot then
658: --
659: --
660: ben_ext_chlg.log_dependent_chg
661: (p_action => 'REINSTATE',

Line 738: when hr_api.cannot_find_prog_unit then

734: ,p_effective_date => trunc(p_effective_date)
735: ,p_datetrack_mode => p_datetrack_mode
736: );
737: exception
738: when hr_api.cannot_find_prog_unit then
739: hr_api.cannot_find_prog_unit_error
740: (p_module_name => 'UPDATE_ELIG_CVRD_DPNT'
741: ,p_hook_type => 'BP'
742: );

Line 739: hr_api.cannot_find_prog_unit_error

735: ,p_datetrack_mode => p_datetrack_mode
736: );
737: exception
738: when hr_api.cannot_find_prog_unit then
739: hr_api.cannot_find_prog_unit_error
740: (p_module_name => 'UPDATE_ELIG_CVRD_DPNT'
741: ,p_hook_type => 'BP'
742: );
743: --

Line 750: if not(p_cvg_strt_dt is not null and p_cvg_thru_dt = hr_api.g_eot) then

746: end;
747: --
748: -- If not covered, delete certifications provided.
749: --
750: if not(p_cvg_strt_dt is not null and p_cvg_thru_dt = hr_api.g_eot) then
751: --
752: --
753: -- delete certifications provided
754: if p_datetrack_mode = 'UPDATE' then

Line 831: ,P_DATETRACK_MODE => hr_api.g_zap

827: ,P_EFFECTIVE_START_DATE => l_pcp_future.effective_start_date
828: ,P_EFFECTIVE_END_DATE => l_pcp_future.effective_end_date
829: ,P_OBJECT_VERSION_NUMBER => l_pcp_future.object_version_number
830: ,P_EFFECTIVE_DATE => l_pcp_effective_start_date
831: ,P_DATETRACK_MODE => hr_api.g_zap
832: ,p_called_from => 'delete_enrollment'
833: );
834: End loop;
835: -- 3574168

Line 893: if p_prtt_enrt_rslt_id = hr_api.g_number then

889: ,p_effective_date => trunc(p_effective_date)
890: ,p_datetrack_mode => p_datetrack_mode
891: );
892: --
893: if p_prtt_enrt_rslt_id = hr_api.g_number then
894: l_prtt_enrt_rslt_id := l_previous_values.prtt_enrt_rslt_id;
895: else
896: l_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id;
897: end if;

Line 899: if p_cvg_strt_dt is not null and p_cvg_thru_dt = hr_api.g_eot then

895: else
896: l_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id;
897: end if;
898: --
899: if p_cvg_strt_dt is not null and p_cvg_thru_dt = hr_api.g_eot then
900: --
901: add_usage( p_validate => p_validate
902: ,p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id
903: ,p_effective_date => p_effective_date

Line 992: when hr_api.cannot_find_prog_unit then

988: ,p_effective_date => trunc(p_effective_date)
989: ,p_datetrack_mode => p_datetrack_mode
990: );
991: exception
992: when hr_api.cannot_find_prog_unit then
993: hr_api.cannot_find_prog_unit_error
994: (p_module_name => 'UPDATE_ELIG_CVRD_DPNT'
995: ,p_hook_type => 'AP'
996: );

Line 993: hr_api.cannot_find_prog_unit_error

989: ,p_datetrack_mode => p_datetrack_mode
990: );
991: exception
992: when hr_api.cannot_find_prog_unit then
993: hr_api.cannot_find_prog_unit_error
994: (p_module_name => 'UPDATE_ELIG_CVRD_DPNT'
995: ,p_hook_type => 'AP'
996: );
997: --

Line 1007: raise hr_api.validate_enabled;

1003: --
1004: -- When in validation only mode raise the Validate_Enabled exception
1005: --
1006: if p_validate then
1007: raise hr_api.validate_enabled;
1008: end if;
1009: --
1010: -- Set all output arguments
1011: --

Line 1020: when hr_api.validate_enabled then

1016: hr_utility.set_location(' Leaving:'||l_proc, 70);
1017: --
1018: exception
1019: --
1020: when hr_api.validate_enabled then
1021: --
1022: -- As the Validate_Enabled exception has been raised
1023: -- we must rollback to the savepoint
1024: --

Line 1118: and a.cvg_thru_dt = hr_api.g_eot

1114: ben_per_in_ler pil
1115: where a.dpnt_person_id = l_dpnt_person_id
1116: and a.elig_cvrd_dpnt_id <> p_elig_cvrd_dpnt_id
1117: and a.cvg_strt_dt is not null
1118: and a.cvg_thru_dt = hr_api.g_eot
1119: and l_end_dt between a.cvg_strt_dt
1120: and nvl(a.cvg_thru_dt, hr_api.g_date)
1121: and p_effective_date between a.effective_start_date
1122: and a.effective_end_date

Line 1120: and nvl(a.cvg_thru_dt, hr_api.g_date)

1116: and a.elig_cvrd_dpnt_id <> p_elig_cvrd_dpnt_id
1117: and a.cvg_strt_dt is not null
1118: and a.cvg_thru_dt = hr_api.g_eot
1119: and l_end_dt between a.cvg_strt_dt
1120: and nvl(a.cvg_thru_dt, hr_api.g_date)
1121: and p_effective_date between a.effective_start_date
1122: and a.effective_end_date
1123: and a.per_in_ler_id = pil.per_in_ler_id
1124: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');

Line 1192: l_datetrack_mode := hr_api.g_zap ;

1188: --
1189:
1190: -- delete all future ptu's of type 'DPNT', as this one extends to end-of-time
1191:
1192: l_datetrack_mode := hr_api.g_zap ;
1193:
1194: for del_rec in delete_c loop
1195: --- due to nocopy the p_effective date is nulifile because
1196: --- the same variable sent to p_effective_start_date

Line 1217: l_datetrack_mode := hr_api.g_correction;

1213:
1214: -- set the effective_end_date to end-of-time
1215: -- update table directly as this is not supported by row handler.
1216: for cur_rec in usage_c loop
1217: l_datetrack_mode := hr_api.g_correction;
1218: l_effective_end_date := hr_api.g_eot;
1219:
1220: update per_person_type_usages_f ptu
1221: set effective_end_date = l_effective_end_date

Line 1218: l_effective_end_date := hr_api.g_eot;

1214: -- set the effective_end_date to end-of-time
1215: -- update table directly as this is not supported by row handler.
1216: for cur_rec in usage_c loop
1217: l_datetrack_mode := hr_api.g_correction;
1218: l_effective_end_date := hr_api.g_eot;
1219:
1220: update per_person_type_usages_f ptu
1221: set effective_end_date = l_effective_end_date
1222: where ptu.person_type_usage_id = cur_rec.person_type_usage_id

Line 1338: if l_usage_pea.effective_end_date <> hr_api.g_eot then

1334: for l_usage_pea in c_pea(l_prtt_enrt_rslt_id)
1335: loop
1336: --
1337: l_effective_date := l_usage_pea.effective_start_date ;
1338: if l_usage_pea.effective_end_date <> hr_api.g_eot then
1339: --
1340: ben_PRTT_ENRT_ACTN_api.delete_PRTT_ENRT_ACTN
1341: (p_validate => FALSE,
1342: p_effective_date => l_effective_date,

Line 1344: p_datetrack_mode => hr_api.g_future_change,

1340: ben_PRTT_ENRT_ACTN_api.delete_PRTT_ENRT_ACTN
1341: (p_validate => FALSE,
1342: p_effective_date => l_effective_date,
1343: p_business_group_id => l_business_group_id,
1344: p_datetrack_mode => hr_api.g_future_change,
1345: p_object_version_number => l_usage_pea.object_version_number,
1346: p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id,
1347: p_rslt_object_version_number => l_usage_pea.rslt_object_version_number,
1348: p_effective_start_date => l_effective_start_date,

Line 1511: if p_datetrack_mode <> hr_api.g_future_change then

1507: -- open parent_c(ctfn_rec.prtt_enrt_actn_id,l_child_effective_date);
1508: -- fetch parent_c into l_parent_effective_end_date;
1509: -- close parent_c;
1510:
1511: if p_datetrack_mode <> hr_api.g_future_change then
1512: --and
1513: -- (ctfn_rec.effective_end_date = hr_api.g_eot or
1514: -- l_parent_effective_end_date = hr_api.g_eot)) then
1515: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd

Line 1513: -- (ctfn_rec.effective_end_date = hr_api.g_eot or

1509: -- close parent_c;
1510:
1511: if p_datetrack_mode <> hr_api.g_future_change then
1512: --and
1513: -- (ctfn_rec.effective_end_date = hr_api.g_eot or
1514: -- l_parent_effective_end_date = hr_api.g_eot)) then
1515: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
1516: (p_validate => FALSE
1517: ,p_cvrd_dpnt_ctfn_prvdd_id => ctfn_rec.cvrd_dpnt_ctfn_prvdd_id

Line 1514: -- l_parent_effective_end_date = hr_api.g_eot)) then

1510:
1511: if p_datetrack_mode <> hr_api.g_future_change then
1512: --and
1513: -- (ctfn_rec.effective_end_date = hr_api.g_eot or
1514: -- l_parent_effective_end_date = hr_api.g_eot)) then
1515: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
1516: (p_validate => FALSE
1517: ,p_cvrd_dpnt_ctfn_prvdd_id => ctfn_rec.cvrd_dpnt_ctfn_prvdd_id
1518: ,p_effective_start_date => l2_effective_start_date

Line 1568: if not ( p_datetrack_mode = hr_api.g_future_change and

1564: --
1565: l3_object_version_number := l_dpnt_pcp_actn_item_rec.object_version_number;
1566: --
1567: -- 5096675, If Only one record exist in PEA for future change mode, dont call delete api
1568: if not ( p_datetrack_mode = hr_api.g_future_change and
1569: l_dpnt_pcp_actn_item_rec.effective_end_date = hr_api.g_eot ) then --5096675 rbingi
1570: --
1571: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
1572: (p_validate => FALSE,

Line 1569: l_dpnt_pcp_actn_item_rec.effective_end_date = hr_api.g_eot ) then --5096675 rbingi

1565: l3_object_version_number := l_dpnt_pcp_actn_item_rec.object_version_number;
1566: --
1567: -- 5096675, If Only one record exist in PEA for future change mode, dont call delete api
1568: if not ( p_datetrack_mode = hr_api.g_future_change and
1569: l_dpnt_pcp_actn_item_rec.effective_end_date = hr_api.g_eot ) then --5096675 rbingi
1570: --
1571: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
1572: (p_validate => FALSE,
1573: p_effective_date => p_effective_date,

Line 1602: when hr_api.cannot_find_prog_unit then

1598: ,p_effective_date => trunc(p_effective_date)
1599: ,p_datetrack_mode => p_datetrack_mode
1600: );
1601: exception
1602: when hr_api.cannot_find_prog_unit then
1603: hr_api.cannot_find_prog_unit_error
1604: (p_module_name => 'DELETE_ELIG_CVRD_DPNT'
1605: ,p_hook_type => 'BP'
1606: );

Line 1603: hr_api.cannot_find_prog_unit_error

1599: ,p_datetrack_mode => p_datetrack_mode
1600: );
1601: exception
1602: when hr_api.cannot_find_prog_unit then
1603: hr_api.cannot_find_prog_unit_error
1604: (p_module_name => 'DELETE_ELIG_CVRD_DPNT'
1605: ,p_hook_type => 'BP'
1606: );
1607: --

Line 1616: if l_previous_values.cvg_strt_dt is not null and l_previous_values.cvg_thru_dt = hr_api.g_eot then

1612: open dpnt_info_c;
1613: fetch dpnt_info_c into l_previous_values;
1614: close dpnt_info_c;
1615: --
1616: if l_previous_values.cvg_strt_dt is not null and l_previous_values.cvg_thru_dt = hr_api.g_eot then
1617: --
1618: -- Added by pxdas for logging change event needed for extract.
1619: --
1620: open c_chg_info(l_previous_values.prtt_enrt_rslt_id);

Line 1690: if p_datetrack_mode=hr_api.g_future_change then

1686: --
1687: --
1688: -- Delete certifications
1689: --
1690: if p_datetrack_mode=hr_api.g_future_change then
1691: for ctfn_rec in dpnt_ctfn_c loop
1692: --
1693: l2_object_version_number := ctfn_rec.object_version_number;
1694:

Line 1699: if p_datetrack_mode = hr_api.g_future_change and

1695: open parent_c(ctfn_rec.prtt_enrt_actn_id,l_child_effective_date);
1696: fetch parent_c into l_parent_effective_end_date;
1697: close parent_c;
1698:
1699: if p_datetrack_mode = hr_api.g_future_change and
1700: ctfn_rec.effective_end_date<>hr_api.g_eot and
1701: l_parent_effective_end_date = hr_api.g_eot then
1702: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
1703: (p_validate => FALSE

Line 1700: ctfn_rec.effective_end_date<>hr_api.g_eot and

1696: fetch parent_c into l_parent_effective_end_date;
1697: close parent_c;
1698:
1699: if p_datetrack_mode = hr_api.g_future_change and
1700: ctfn_rec.effective_end_date<>hr_api.g_eot and
1701: l_parent_effective_end_date = hr_api.g_eot then
1702: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
1703: (p_validate => FALSE
1704: ,p_cvrd_dpnt_ctfn_prvdd_id => ctfn_rec.cvrd_dpnt_ctfn_prvdd_id

Line 1701: l_parent_effective_end_date = hr_api.g_eot then

1697: close parent_c;
1698:
1699: if p_datetrack_mode = hr_api.g_future_change and
1700: ctfn_rec.effective_end_date<>hr_api.g_eot and
1701: l_parent_effective_end_date = hr_api.g_eot then
1702: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
1703: (p_validate => FALSE
1704: ,p_cvrd_dpnt_ctfn_prvdd_id => ctfn_rec.cvrd_dpnt_ctfn_prvdd_id
1705: ,p_effective_start_date => l2_effective_start_date

Line 1732: when hr_api.cannot_find_prog_unit then

1728: ,p_effective_date => trunc(p_effective_date)
1729: ,p_datetrack_mode => p_datetrack_mode
1730: );
1731: exception
1732: when hr_api.cannot_find_prog_unit then
1733: hr_api.cannot_find_prog_unit_error
1734: (p_module_name => 'DELETE_ELIG_CVRD_DPNT'
1735: ,p_hook_type => 'AP'
1736: );

Line 1733: hr_api.cannot_find_prog_unit_error

1729: ,p_datetrack_mode => p_datetrack_mode
1730: );
1731: exception
1732: when hr_api.cannot_find_prog_unit then
1733: hr_api.cannot_find_prog_unit_error
1734: (p_module_name => 'DELETE_ELIG_CVRD_DPNT'
1735: ,p_hook_type => 'AP'
1736: );
1737: --

Line 1747: raise hr_api.validate_enabled;

1743: --
1744: -- When in validation only mode raise the Validate_Enabled exception
1745: --
1746: if p_validate then
1747: raise hr_api.validate_enabled;
1748: end if;
1749: --
1750: hr_utility.set_location(' Leaving:'||l_proc, 70);
1751: --

Line 1754: when hr_api.validate_enabled then

1750: hr_utility.set_location(' Leaving:'||l_proc, 70);
1751: --
1752: exception
1753: --
1754: when hr_api.validate_enabled then
1755: --
1756: -- As the Validate_Enabled exception has been raised
1757: -- we must rollback to the savepoint
1758: --

Line 1930: if p_datetrack_mode <> hr_api.g_future_change then

1926: -- open parent_c(ctfn_rec.prtt_enrt_actn_id,l_child_effective_date);
1927: -- fetch parent_c into l_parent_effective_end_date;
1928: -- close parent_c;
1929:
1930: if p_datetrack_mode <> hr_api.g_future_change then
1931: --and
1932: -- (ctfn_rec.effective_end_date = hr_api.g_eot or
1933: -- l_parent_effective_end_date = hr_api.g_eot)) then
1934: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd

Line 1932: -- (ctfn_rec.effective_end_date = hr_api.g_eot or

1928: -- close parent_c;
1929:
1930: if p_datetrack_mode <> hr_api.g_future_change then
1931: --and
1932: -- (ctfn_rec.effective_end_date = hr_api.g_eot or
1933: -- l_parent_effective_end_date = hr_api.g_eot)) then
1934: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
1935: (p_validate => FALSE
1936: ,p_cvrd_dpnt_ctfn_prvdd_id => ctfn_rec.cvrd_dpnt_ctfn_prvdd_id

Line 1933: -- l_parent_effective_end_date = hr_api.g_eot)) then

1929:
1930: if p_datetrack_mode <> hr_api.g_future_change then
1931: --and
1932: -- (ctfn_rec.effective_end_date = hr_api.g_eot or
1933: -- l_parent_effective_end_date = hr_api.g_eot)) then
1934: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
1935: (p_validate => FALSE
1936: ,p_cvrd_dpnt_ctfn_prvdd_id => ctfn_rec.cvrd_dpnt_ctfn_prvdd_id
1937: ,p_effective_start_date => l2_effective_start_date

Line 1988: if not ( p_datetrack_mode = hr_api.g_future_change and

1984: --
1985: l3_object_version_number := l_dpnt_pcp_actn_item_rec.object_version_number;
1986: --
1987: -- 5096675, If Only one record exist in PEA for future change mode, dont call delete api
1988: if not ( p_datetrack_mode = hr_api.g_future_change and
1989: l_dpnt_pcp_actn_item_rec.effective_end_date = hr_api.g_eot ) then --5096675 rbingi
1990: --
1991: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
1992: (p_validate => FALSE,

Line 1989: l_dpnt_pcp_actn_item_rec.effective_end_date = hr_api.g_eot ) then --5096675 rbingi

1985: l3_object_version_number := l_dpnt_pcp_actn_item_rec.object_version_number;
1986: --
1987: -- 5096675, If Only one record exist in PEA for future change mode, dont call delete api
1988: if not ( p_datetrack_mode = hr_api.g_future_change and
1989: l_dpnt_pcp_actn_item_rec.effective_end_date = hr_api.g_eot ) then --5096675 rbingi
1990: --
1991: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
1992: (p_validate => FALSE,
1993: p_effective_date => p_effective_date,

Line 2022: when hr_api.cannot_find_prog_unit then

2018: ,p_effective_date => trunc(p_effective_date)
2019: ,p_datetrack_mode => p_datetrack_mode
2020: );
2021: exception
2022: when hr_api.cannot_find_prog_unit then
2023: hr_api.cannot_find_prog_unit_error
2024: (p_module_name => 'DELETE_ELIG_CVRD_DPNT'
2025: ,p_hook_type => 'BP'
2026: );

Line 2023: hr_api.cannot_find_prog_unit_error

2019: ,p_datetrack_mode => p_datetrack_mode
2020: );
2021: exception
2022: when hr_api.cannot_find_prog_unit then
2023: hr_api.cannot_find_prog_unit_error
2024: (p_module_name => 'DELETE_ELIG_CVRD_DPNT'
2025: ,p_hook_type => 'BP'
2026: );
2027: --

Line 2036: if l_previous_values.cvg_strt_dt is not null and l_previous_values.cvg_thru_dt = hr_api.g_eot then

2032: open dpnt_info_c;
2033: fetch dpnt_info_c into l_previous_values;
2034: close dpnt_info_c;
2035: --
2036: if l_previous_values.cvg_strt_dt is not null and l_previous_values.cvg_thru_dt = hr_api.g_eot then
2037: --
2038: -- Added by pxdas for logging change event needed for extract.
2039: --
2040: open c_chg_info(l_previous_values.prtt_enrt_rslt_id);

Line 2132: if p_datetrack_mode=hr_api.g_future_change then

2128: --
2129: --
2130: -- Delete certifications
2131: --
2132: if p_datetrack_mode=hr_api.g_future_change then
2133: for ctfn_rec in dpnt_ctfn_c loop
2134: --
2135: l2_object_version_number := ctfn_rec.object_version_number;
2136:

Line 2141: if p_datetrack_mode = hr_api.g_future_change and

2137: open parent_c(ctfn_rec.prtt_enrt_actn_id,l_child_effective_date);
2138: fetch parent_c into l_parent_effective_end_date;
2139: close parent_c;
2140:
2141: if p_datetrack_mode = hr_api.g_future_change and
2142: ctfn_rec.effective_end_date<>hr_api.g_eot and
2143: l_parent_effective_end_date = hr_api.g_eot then
2144: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
2145: (p_validate => FALSE

Line 2142: ctfn_rec.effective_end_date<>hr_api.g_eot and

2138: fetch parent_c into l_parent_effective_end_date;
2139: close parent_c;
2140:
2141: if p_datetrack_mode = hr_api.g_future_change and
2142: ctfn_rec.effective_end_date<>hr_api.g_eot and
2143: l_parent_effective_end_date = hr_api.g_eot then
2144: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
2145: (p_validate => FALSE
2146: ,p_cvrd_dpnt_ctfn_prvdd_id => ctfn_rec.cvrd_dpnt_ctfn_prvdd_id

Line 2143: l_parent_effective_end_date = hr_api.g_eot then

2139: close parent_c;
2140:
2141: if p_datetrack_mode = hr_api.g_future_change and
2142: ctfn_rec.effective_end_date<>hr_api.g_eot and
2143: l_parent_effective_end_date = hr_api.g_eot then
2144: ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
2145: (p_validate => FALSE
2146: ,p_cvrd_dpnt_ctfn_prvdd_id => ctfn_rec.cvrd_dpnt_ctfn_prvdd_id
2147: ,p_effective_start_date => l2_effective_start_date

Line 2175: when hr_api.cannot_find_prog_unit then

2171: ,p_effective_date => trunc(p_effective_date)
2172: ,p_datetrack_mode => p_datetrack_mode
2173: );
2174: exception
2175: when hr_api.cannot_find_prog_unit then
2176: hr_api.cannot_find_prog_unit_error
2177: (p_module_name => 'DELETE_ELIG_CVRD_DPNT'
2178: ,p_hook_type => 'AP'
2179: );

Line 2176: hr_api.cannot_find_prog_unit_error

2172: ,p_datetrack_mode => p_datetrack_mode
2173: );
2174: exception
2175: when hr_api.cannot_find_prog_unit then
2176: hr_api.cannot_find_prog_unit_error
2177: (p_module_name => 'DELETE_ELIG_CVRD_DPNT'
2178: ,p_hook_type => 'AP'
2179: );
2180: --

Line 2190: raise hr_api.validate_enabled;

2186: --
2187: -- When in validation only mode raise the Validate_Enabled exception
2188: --
2189: if p_validate then
2190: raise hr_api.validate_enabled;
2191: end if;
2192: --
2193: hr_utility.set_location(' Leaving:'||l_proc, 70);
2194: --

Line 2197: when hr_api.validate_enabled then

2193: hr_utility.set_location(' Leaving:'||l_proc, 70);
2194: --
2195: exception
2196: --
2197: when hr_api.validate_enabled then
2198: --
2199: -- As the Validate_Enabled exception has been raised
2200: -- we must rollback to the savepoint
2201: --

Line 2418: -- and a.effective_start_date <= hr_api.g_date

2414: a.person_type_usage_id
2415: from per_person_type_usages_f a
2416: where a.person_id = l_dpnt_person_id
2417: and a.person_type_id = l_person_type_id
2418: -- and a.effective_start_date <= hr_api.g_date
2419: and a.effective_end_date >= l_cvg_strt_dt
2420: order by a.effective_start_date -- 5604361
2421: ;
2422: --

Line 2484: l_effective_end_date >= hr_api.g_eot

2480: --
2481: -- changed all g_date to g_eot
2482: --
2483: if l_effective_start_date <= l_cvg_strt_dt and
2484: l_effective_end_date >= hr_api.g_eot
2485: then
2486: null;
2487: elsif l_effective_start_date <= l_cvg_strt_dt and
2488: l_effective_end_date < hr_api.g_eot

Line 2488: l_effective_end_date < hr_api.g_eot

2484: l_effective_end_date >= hr_api.g_eot
2485: then
2486: null;
2487: elsif l_effective_start_date <= l_cvg_strt_dt and
2488: l_effective_end_date < hr_api.g_eot
2489: then
2490: update per_person_type_usages_f
2491: set effective_end_date = hr_api.g_eot
2492: where person_type_usage_id = l_person_type_usage_id;

Line 2491: set effective_end_date = hr_api.g_eot

2487: elsif l_effective_start_date <= l_cvg_strt_dt and
2488: l_effective_end_date < hr_api.g_eot
2489: then
2490: update per_person_type_usages_f
2491: set effective_end_date = hr_api.g_eot
2492: where person_type_usage_id = l_person_type_usage_id;
2493: elsif l_effective_start_date > l_cvg_strt_dt and
2494: l_effective_end_date = hr_api.g_eot then
2495: --

Line 2494: l_effective_end_date = hr_api.g_eot then

2490: update per_person_type_usages_f
2491: set effective_end_date = hr_api.g_eot
2492: where person_type_usage_id = l_person_type_usage_id;
2493: elsif l_effective_start_date > l_cvg_strt_dt and
2494: l_effective_end_date = hr_api.g_eot then
2495: --
2496: update per_person_type_usages_f
2497: set effective_start_date = l_cvg_strt_dt
2498: where person_type_usage_id = l_person_type_usage_id;

Line 2501: l_effective_end_date < hr_api.g_eot then

2497: set effective_start_date = l_cvg_strt_dt
2498: where person_type_usage_id = l_person_type_usage_id;
2499: --
2500: elsif l_effective_start_date > l_cvg_strt_dt and
2501: l_effective_end_date < hr_api.g_eot then
2502: --
2503: update per_person_type_usages_f
2504: set effective_start_date = l_cvg_strt_dt,
2505: effective_end_date = hr_api.g_eot

Line 2505: effective_end_date = hr_api.g_eot

2501: l_effective_end_date < hr_api.g_eot then
2502: --
2503: update per_person_type_usages_f
2504: set effective_start_date = l_cvg_strt_dt,
2505: effective_end_date = hr_api.g_eot
2506: where person_type_usage_id = l_person_type_usage_id;
2507: --
2508: end if;
2509: --

Line 2570: and a.cvg_thru_dt = hr_api.g_eot

2566: ben_per_in_ler pil
2567: where a.dpnt_person_id = l_dpnt_person_id
2568: and a.elig_cvrd_dpnt_id <> p_elig_cvrd_dpnt_id
2569: and a.cvg_strt_dt is not null
2570: and a.cvg_thru_dt = hr_api.g_eot
2571: -- and a.cvrd_flag = 'Y'
2572: and l_end_dt + 1 between a.cvg_strt_dt -- Bug 5451726
2573: and nvl(a.cvg_thru_dt, hr_api.g_date)
2574: and p_effective_date between a.effective_start_date

Line 2573: and nvl(a.cvg_thru_dt, hr_api.g_date)

2569: and a.cvg_strt_dt is not null
2570: and a.cvg_thru_dt = hr_api.g_eot
2571: -- and a.cvrd_flag = 'Y'
2572: and l_end_dt + 1 between a.cvg_strt_dt -- Bug 5451726
2573: and nvl(a.cvg_thru_dt, hr_api.g_date)
2574: and p_effective_date between a.effective_start_date
2575: and a.effective_end_date
2576: and a.per_in_ler_id = pil.per_in_ler_id
2577: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');

Line 2641: elsif p_datetrack_mode=hr_api.g_delete and

2637: end if;
2638: --
2639: -- Check to see if the row is already end dated
2640: --
2641: elsif p_datetrack_mode=hr_api.g_delete and
2642: l_eff_end_date=l_end_dt then
2643: close usage_c;
2644: close other_dpnt_c;
2645: hr_utility.set_location(' Leaving:'||l_proc, 65);

Line 2737: and egd.cvg_thru_dt = hr_api.g_eot

2733: and o.business_group_id(+)= p_business_group_id
2734: and p_effective_date between o.effective_start_date(+)
2735: and o.effective_end_date(+)
2736: and egd.cvg_strt_dt is not null
2737: and egd.cvg_thru_dt = hr_api.g_eot
2738: -- bug#2151619
2739: and egd.effective_end_date = hr_api.g_eot;
2740: /*
2741: and p_effective_date between egd.effective_start_date

Line 2739: and egd.effective_end_date = hr_api.g_eot;

2735: and o.effective_end_date(+)
2736: and egd.cvg_strt_dt is not null
2737: and egd.cvg_thru_dt = hr_api.g_eot
2738: -- bug#2151619
2739: and egd.effective_end_date = hr_api.g_eot;
2740: /*
2741: and p_effective_date between egd.effective_start_date
2742: and egd.effective_end_date
2743: ;

Line 2770: ((nvl(pl_id, hr_api.g_number) = cv_pl_id)

2766: ,no_mx_num_dfnd_flag
2767: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
2768: from ben_dsgn_rqmt_f
2769: where
2770: ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2771: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2772: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2773: and dsgn_typ_cd = 'DPNT'
2774: and grp_rlshp_cd is null

Line 2771: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)

2767: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
2768: from ben_dsgn_rqmt_f
2769: where
2770: ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2771: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2772: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2773: and dsgn_typ_cd = 'DPNT'
2774: and grp_rlshp_cd is null
2775: and business_group_id + 0 = p_business_group_id

Line 2772: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))

2768: from ben_dsgn_rqmt_f
2769: where
2770: ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2771: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2772: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2773: and dsgn_typ_cd = 'DPNT'
2774: and grp_rlshp_cd is null
2775: and business_group_id + 0 = p_business_group_id
2776: and p_effective_date between effective_start_date

Line 2789: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)

2785: cv_oipl_id number,
2786: cv_opt_id number)is
2787: select 's'
2788: from ben_dsgn_rqmt_f r
2789: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2790: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2791: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2792: and r.dsgn_typ_cd = 'DPNT'
2793: and r.business_group_id = p_business_group_id

Line 2790: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)

2786: cv_opt_id number)is
2787: select 's'
2788: from ben_dsgn_rqmt_f r
2789: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2790: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2791: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2792: and r.dsgn_typ_cd = 'DPNT'
2793: and r.business_group_id = p_business_group_id
2794: and p_effective_date between nvl(r.effective_start_date, p_effective_date)

Line 2791: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))

2787: select 's'
2788: from ben_dsgn_rqmt_f r
2789: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2790: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2791: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2792: and r.dsgn_typ_cd = 'DPNT'
2793: and r.business_group_id = p_business_group_id
2794: and p_effective_date between nvl(r.effective_start_date, p_effective_date)
2795: and nvl(r.effective_end_date, p_effective_date)

Line 2813: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)

2809: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
2810: ,r.grp_rlshp_cd
2811: from ben_dsgn_rqmt_f r,
2812: ben_dsgn_rqmt_rlshp_typ dr
2813: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2814: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2815: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2816: and r.dsgn_typ_cd = 'DPNT'
2817: and r.business_group_id = p_business_group_id

Line 2814: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)

2810: ,r.grp_rlshp_cd
2811: from ben_dsgn_rqmt_f r,
2812: ben_dsgn_rqmt_rlshp_typ dr
2813: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2814: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2815: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2816: and r.dsgn_typ_cd = 'DPNT'
2817: and r.business_group_id = p_business_group_id
2818: and p_effective_date between nvl(r.effective_start_date, p_effective_date)

Line 2815: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))

2811: from ben_dsgn_rqmt_f r,
2812: ben_dsgn_rqmt_rlshp_typ dr
2813: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2814: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2815: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2816: and r.dsgn_typ_cd = 'DPNT'
2817: and r.business_group_id = p_business_group_id
2818: and p_effective_date between nvl(r.effective_start_date, p_effective_date)
2819: and nvl(r.effective_end_date, p_effective_date)

Line 2840: and ecd.cvg_thru_dt = hr_api.g_eot

2836: from ben_elig_cvrd_dpnt_f ecd ,
2837: ben_per_in_ler pil
2838: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2839: and ecd.cvg_strt_dt is not null
2840: and ecd.cvg_thru_dt = hr_api.g_eot
2841: -- and cvrd_flag = 'Y'
2842: and ecd.business_group_id + 0 = p_business_group_id
2843: and p_effective_date between ecd.effective_start_date
2844: and ecd.effective_end_date

Line 2845: and cv_cvg_strt_dt <= nvl(ecd.cvg_thru_dt, hr_api.g_date)

2841: -- and cvrd_flag = 'Y'
2842: and ecd.business_group_id + 0 = p_business_group_id
2843: and p_effective_date between ecd.effective_start_date
2844: and ecd.effective_end_date
2845: and cv_cvg_strt_dt <= nvl(ecd.cvg_thru_dt, hr_api.g_date)
2846: and nvl(cv_cvg_thru_dt, hr_api.g_date) >= ecd.cvg_strt_dt
2847: and ecd.per_in_ler_id = pil.per_in_ler_id
2848: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
2849: ;

Line 2846: and nvl(cv_cvg_thru_dt, hr_api.g_date) >= ecd.cvg_strt_dt

2842: and ecd.business_group_id + 0 = p_business_group_id
2843: and p_effective_date between ecd.effective_start_date
2844: and ecd.effective_end_date
2845: and cv_cvg_strt_dt <= nvl(ecd.cvg_thru_dt, hr_api.g_date)
2846: and nvl(cv_cvg_thru_dt, hr_api.g_date) >= ecd.cvg_strt_dt
2847: and ecd.per_in_ler_id = pil.per_in_ler_id
2848: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
2849: ;
2850: --

Line 2867: and d.cvg_thru_dt = hr_api.g_eot

2863: c.person_id = cv_person_id
2864: and c.contact_person_id = d.dpnt_person_id
2865: and d.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2866: and d.cvg_strt_dt is not null
2867: and d.cvg_thru_dt = hr_api.g_eot
2868: and cv_cvg_strt_dt <= nvl(d.cvg_thru_dt, hr_api.g_date)
2869: and nvl(cv_cvg_thru_dt, hr_api.g_date) >= d.cvg_strt_dt
2870: and c.business_group_id + 0 = p_business_group_id
2871: and p_effective_date between nvl(c.date_start, p_effective_date)

Line 2868: and cv_cvg_strt_dt <= nvl(d.cvg_thru_dt, hr_api.g_date)

2864: and c.contact_person_id = d.dpnt_person_id
2865: and d.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2866: and d.cvg_strt_dt is not null
2867: and d.cvg_thru_dt = hr_api.g_eot
2868: and cv_cvg_strt_dt <= nvl(d.cvg_thru_dt, hr_api.g_date)
2869: and nvl(cv_cvg_thru_dt, hr_api.g_date) >= d.cvg_strt_dt
2870: and c.business_group_id + 0 = p_business_group_id
2871: and p_effective_date between nvl(c.date_start, p_effective_date)
2872: and nvl(c.date_end, p_effective_date)

Line 2869: and nvl(cv_cvg_thru_dt, hr_api.g_date) >= d.cvg_strt_dt

2865: and d.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2866: and d.cvg_strt_dt is not null
2867: and d.cvg_thru_dt = hr_api.g_eot
2868: and cv_cvg_strt_dt <= nvl(d.cvg_thru_dt, hr_api.g_date)
2869: and nvl(cv_cvg_thru_dt, hr_api.g_date) >= d.cvg_strt_dt
2870: and c.business_group_id + 0 = p_business_group_id
2871: and p_effective_date between nvl(c.date_start, p_effective_date)
2872: and nvl(c.date_end, p_effective_date)
2873: and d.effective_end_date = hr_api.g_eot -- bug 1237204

Line 2873: and d.effective_end_date = hr_api.g_eot -- bug 1237204

2869: and nvl(cv_cvg_thru_dt, hr_api.g_date) >= d.cvg_strt_dt
2870: and c.business_group_id + 0 = p_business_group_id
2871: and p_effective_date between nvl(c.date_start, p_effective_date)
2872: and nvl(c.date_end, p_effective_date)
2873: and d.effective_end_date = hr_api.g_eot -- bug 1237204
2874: and d.business_group_id + 0 = p_business_group_id
2875: and c.contact_type in
2876: (select rlshp_typ_cd
2877: from ben_dsgn_rqmt_rlshp_typ