APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on FND_DATE

Line 1759: ,p_param3_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.end_dt)

1755: ,p_param1_value => p_person_id
1756: ,p_param2 => 'BEN_IV_ACCESS_CD'
1757: ,p_param2_value => g_cache_group_plan_rec.access_cd
1758: ,p_param3 => 'BEN_IV_END_DT'
1759: ,p_param3_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.end_dt)
1760: ,p_param4 => 'BEN_IV_AUTO_DISTR_FLAG'
1761: ,p_param4_value => g_cache_group_plan_rec.auto_distr_flag
1762: ,p_param5 => 'BEN_IV_WS_UPD_STRT_DT'
1763: ,p_param5_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_strt_dt)

Line 1763: ,p_param5_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_strt_dt)

1759: ,p_param3_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.end_dt)
1760: ,p_param4 => 'BEN_IV_AUTO_DISTR_FLAG'
1761: ,p_param4_value => g_cache_group_plan_rec.auto_distr_flag
1762: ,p_param5 => 'BEN_IV_WS_UPD_STRT_DT'
1763: ,p_param5_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_strt_dt)
1764: ,p_param6 => 'BEN_IV_WS_UPD_END_DT'
1765: ,p_param6_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_end_dt)
1766: ,p_param7 => 'BEN_IV_USES_BDGT_FLAG'
1767: ,p_param7_value => g_cache_group_plan_rec.uses_bdgt_flag

Line 1765: ,p_param6_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_end_dt)

1761: ,p_param4_value => g_cache_group_plan_rec.auto_distr_flag
1762: ,p_param5 => 'BEN_IV_WS_UPD_STRT_DT'
1763: ,p_param5_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_strt_dt)
1764: ,p_param6 => 'BEN_IV_WS_UPD_END_DT'
1765: ,p_param6_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_end_dt)
1766: ,p_param7 => 'BEN_IV_USES_BDGT_FLAG'
1767: ,p_param7_value => g_cache_group_plan_rec.uses_bdgt_flag
1768: );
1769: --

Line 2525: l_lf_evt_ocrd_dt date := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);

2521: l_oipl_nip_count number;
2522:
2523: l_request_id number;
2524: l_slave_errored boolean ;
2525: l_lf_evt_ocrd_dt date := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);
2526: l_effective_date date := fnd_date.canonical_to_date(p_effective_date);
2527: --Build Hierarchy
2528: l_pl_id number := p_pl_id ;
2529: l_business_group_id number;

Line 2526: l_effective_date date := fnd_date.canonical_to_date(p_effective_date);

2522:
2523: l_request_id number;
2524: l_slave_errored boolean ;
2525: l_lf_evt_ocrd_dt date := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);
2526: l_effective_date date := fnd_date.canonical_to_date(p_effective_date);
2527: --Build Hierarchy
2528: l_pl_id number := p_pl_id ;
2529: l_business_group_id number;
2530: l_ler_id number;