APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on FND_DATE

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

1710: ,p_param1_value => p_person_id
1711: ,p_param2 => 'BEN_IV_ACCESS_CD'
1712: ,p_param2_value => g_cache_group_plan_rec.access_cd
1713: ,p_param3 => 'BEN_IV_END_DT'
1714: ,p_param3_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.end_dt)
1715: ,p_param4 => 'BEN_IV_AUTO_DISTR_FLAG'
1716: ,p_param4_value => g_cache_group_plan_rec.auto_distr_flag
1717: ,p_param5 => 'BEN_IV_WS_UPD_STRT_DT'
1718: ,p_param5_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_strt_dt)

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

1714: ,p_param3_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.end_dt)
1715: ,p_param4 => 'BEN_IV_AUTO_DISTR_FLAG'
1716: ,p_param4_value => g_cache_group_plan_rec.auto_distr_flag
1717: ,p_param5 => 'BEN_IV_WS_UPD_STRT_DT'
1718: ,p_param5_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_strt_dt)
1719: ,p_param6 => 'BEN_IV_WS_UPD_END_DT'
1720: ,p_param6_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_end_dt)
1721: ,p_param7 => 'BEN_IV_USES_BDGT_FLAG'
1722: ,p_param7_value => g_cache_group_plan_rec.uses_bdgt_flag

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

1716: ,p_param4_value => g_cache_group_plan_rec.auto_distr_flag
1717: ,p_param5 => 'BEN_IV_WS_UPD_STRT_DT'
1718: ,p_param5_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_strt_dt)
1719: ,p_param6 => 'BEN_IV_WS_UPD_END_DT'
1720: ,p_param6_value => fnd_date.date_to_canonical(g_cache_group_plan_rec.ws_upd_end_dt)
1721: ,p_param7 => 'BEN_IV_USES_BDGT_FLAG'
1722: ,p_param7_value => g_cache_group_plan_rec.uses_bdgt_flag
1723: );
1724: --

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

2476: l_oipl_nip_count number;
2477:
2478: l_request_id number;
2479: l_slave_errored boolean ;
2480: l_lf_evt_ocrd_dt date := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);
2481: l_effective_date date := fnd_date.canonical_to_date(p_effective_date);
2482: --Build Hierarchy
2483: l_pl_id number := p_pl_id ;
2484: l_business_group_id number;

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

2477:
2478: l_request_id number;
2479: l_slave_errored boolean ;
2480: l_lf_evt_ocrd_dt date := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);
2481: l_effective_date date := fnd_date.canonical_to_date(p_effective_date);
2482: --Build Hierarchy
2483: l_pl_id number := p_pl_id ;
2484: l_business_group_id number;
2485: l_ler_id number;