DBA Data[Home] [Help]

APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on FND_DATE

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

1224: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1225: p_jurisdiction_code => l_jurisdiction_code,
1226: -- FONM
1227: p_param1 => 'BEN_IV_RT_STRT_DT',
1228: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1229: p_param2 => 'BEN_IV_CVG_STRT_DT',
1230: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1231: --
1232: p_val := l_outputs(l_outputs.first).value;

Line 1230: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1226: -- FONM
1227: p_param1 => 'BEN_IV_RT_STRT_DT',
1228: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1229: p_param2 => 'BEN_IV_CVG_STRT_DT',
1230: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1231: --
1232: p_val := l_outputs(l_outputs.first).value;
1233: --
1234: else

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

1319: p_acty_base_rt_id => p_acty_base_rt_id,
1320: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1321: p_jurisdiction_code => l_jurisdiction_code,
1322: p_param1 => 'BEN_IV_RT_STRT_DT',
1323: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1324: p_param2 => 'BEN_IV_CVG_STRT_DT',
1325: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1326: --
1327: if l_outputs(l_outputs.first).value is not null then

Line 1325: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1321: p_jurisdiction_code => l_jurisdiction_code,
1322: p_param1 => 'BEN_IV_RT_STRT_DT',
1323: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1324: p_param2 => 'BEN_IV_CVG_STRT_DT',
1325: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1326: --
1327: if l_outputs(l_outputs.first).value is not null then
1328: --
1329: p_val := l_outputs(l_outputs.first).value;

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

1354: p_ler_id => l_epe.ler_id,
1355: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1356: p_jurisdiction_code => l_jurisdiction_code,
1357: p_param1 => 'BEN_IV_RT_STRT_DT',
1358: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1359: p_param2 => 'BEN_IV_CVG_STRT_DT',
1360: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1361:
1362: if l_outputs(l_outputs.first).value is not null then

Line 1360: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1356: p_jurisdiction_code => l_jurisdiction_code,
1357: p_param1 => 'BEN_IV_RT_STRT_DT',
1358: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1359: p_param2 => 'BEN_IV_CVG_STRT_DT',
1360: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1361:
1362: if l_outputs(l_outputs.first).value is not null then
1363: p_val := l_outputs(l_outputs.first).value;
1364: end if;

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

1384: p_ler_id => l_epe.ler_id,
1385: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1386: p_jurisdiction_code => l_jurisdiction_code,
1387: p_param1 => 'BEN_IV_RT_STRT_DT',
1388: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1389: p_param2 => 'BEN_IV_CVG_STRT_DT',
1390: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1391:
1392: if l_outputs(l_outputs.first).value is not null then

Line 1390: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1386: p_jurisdiction_code => l_jurisdiction_code,
1387: p_param1 => 'BEN_IV_RT_STRT_DT',
1388: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1389: p_param2 => 'BEN_IV_CVG_STRT_DT',
1390: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1391:
1392: if l_outputs(l_outputs.first).value is not null then
1393: p_val := fnd_number.canonical_to_number(l_outputs(l_outputs.first).value);
1394: p_vrbl_rt_trtmt_cd := l_avrl.rt_trtmt_cd ;

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

1417: p_ler_id => l_epe.ler_id,
1418: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1419: p_jurisdiction_code => l_jurisdiction_code,
1420: p_param1 => 'BEN_IV_RT_STRT_DT',
1421: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1422: p_param2 => 'BEN_IV_CVG_STRT_DT',
1423: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1424: --
1425: if l_outputs(l_outputs.first).value is not null then

Line 1423: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1419: p_jurisdiction_code => l_jurisdiction_code,
1420: p_param1 => 'BEN_IV_RT_STRT_DT',
1421: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1422: p_param2 => 'BEN_IV_CVG_STRT_DT',
1423: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1424: --
1425: if l_outputs(l_outputs.first).value is not null then
1426: --
1427: p_val := l_outputs(l_outputs.first).value;