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 834: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)

830: ,p_pgm_id => l_envpgm_id
831: ,p_opt_id => l_oipl_rec.opt_id
832: ,p_ler_id => p_pil_row.ler_id
833: ,p_param1 => 'BEN_IV_RT_STRT_DT'
834: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
835: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
836: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
837: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
838: ,p_param3_value => to_char(p_person_id)

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

832: ,p_ler_id => p_pil_row.ler_id
833: ,p_param1 => 'BEN_IV_RT_STRT_DT'
834: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
835: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
836: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
837: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
838: ,p_param3_value => to_char(p_person_id)
839: ,p_jurisdiction_code => l_jurisdiction_code
840: );

Line 846: p_prtn_eff_strt_dt := fnd_date.canonical_to_date

842: -- Formula will return a date but code defensively in case the
843: -- date can not be typecast.
844: --
845: begin
846: p_prtn_eff_strt_dt := fnd_date.canonical_to_date
847: (l_outputs(l_outputs.first).value);
848: exception
849: when others then
850: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');

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

1039: ,p_pgm_id => l_envpgm_id
1040: ,p_opt_id => l_oipl_rec.opt_id
1041: ,p_ler_id => p_pil_row.ler_id
1042: ,p_param1 => 'BEN_IV_RT_STRT_DT'
1043: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
1044: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
1045: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
1046: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
1047: ,p_param3_value => to_char(p_person_id)

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

1041: ,p_ler_id => p_pil_row.ler_id
1042: ,p_param1 => 'BEN_IV_RT_STRT_DT'
1043: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
1044: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
1045: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
1046: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
1047: ,p_param3_value => to_char(p_person_id)
1048: ,p_jurisdiction_code => l_jurisdiction_code
1049: );

Line 1055: p_prtn_eff_end_dt := fnd_date.canonical_to_date

1051: -- Formula will return a date but code defensively in case the
1052: -- date can not be typecast.
1053: --
1054: begin
1055: p_prtn_eff_end_dt := fnd_date.canonical_to_date
1056: (l_outputs(l_outputs.first).value);
1057: exception
1058: when others then
1059: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');