DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ELIGIBILITY2 dependencies on FND_DATE

Line 184: fnd_date.canonical_to_date.

180: 03-AUG-99 jcarpent 115.41 - changed prev_elig_check cursor to
181: weed out nocopy backed out nocopy pils.
182: 10-AUG-99 Gperry 115.42 Removed references to g_cache_person.
183: Fix all date formula calls to use
184: fnd_date.canonical_to_date.
185: 19-AUG-99 Shdas 115.43 Added pl_ordr_num,plip_ordr_num,ptip_ordr_num
186: in create_eligible_person and oipl_ordr_num
187: in create_elig_person_option.
188: GPerry Added call to get benefits assignment if no

Line 821: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)

817: ,p_pgm_id => l_envpgm_id
818: ,p_opt_id => l_oipl_rec.opt_id
819: ,p_ler_id => p_pil_row.ler_id
820: ,p_param1 => 'BEN_IV_RT_STRT_DT'
821: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
822: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
823: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
824: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
825: ,p_param3_value => to_char(p_person_id)

Line 823: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)

819: ,p_ler_id => p_pil_row.ler_id
820: ,p_param1 => 'BEN_IV_RT_STRT_DT'
821: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
822: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
823: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
824: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
825: ,p_param3_value => to_char(p_person_id)
826: ,p_jurisdiction_code => l_jurisdiction_code
827: );

Line 833: p_prtn_eff_strt_dt := fnd_date.canonical_to_date

829: -- Formula will return a date but code defensively in case the
830: -- date can not be typecast.
831: --
832: begin
833: p_prtn_eff_strt_dt := fnd_date.canonical_to_date
834: (l_outputs(l_outputs.first).value);
835: exception
836: when others then
837: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');

Line 1030: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)

1026: ,p_pgm_id => l_envpgm_id
1027: ,p_opt_id => l_oipl_rec.opt_id
1028: ,p_ler_id => p_pil_row.ler_id
1029: ,p_param1 => 'BEN_IV_RT_STRT_DT'
1030: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
1031: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
1032: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
1033: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
1034: ,p_param3_value => to_char(p_person_id)

Line 1032: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)

1028: ,p_ler_id => p_pil_row.ler_id
1029: ,p_param1 => 'BEN_IV_RT_STRT_DT'
1030: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
1031: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
1032: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
1033: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
1034: ,p_param3_value => to_char(p_person_id)
1035: ,p_jurisdiction_code => l_jurisdiction_code
1036: );

Line 1042: p_prtn_eff_end_dt := fnd_date.canonical_to_date

1038: -- Formula will return a date but code defensively in case the
1039: -- date can not be typecast.
1040: --
1041: begin
1042: p_prtn_eff_end_dt := fnd_date.canonical_to_date
1043: (l_outputs(l_outputs.first).value);
1044: exception
1045: when others then
1046: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');