DBA Data[Home] [Help]

APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on FND_DATE

Line 227: fnd_date.canonical_to_date(l_parm.bft_attribute7),'DD/MM/YYYY')));

223: benutils.iftrue
224: (p_expression => l_parm.bft_attribute7 is null,
225: p_true => 'NONE',
226: p_false => to_char(
227: fnd_date.canonical_to_date(l_parm.bft_attribute7),'DD/MM/YYYY')));
228: --
229:
230: fnd_file.put_line(which => fnd_file.log,
231: buff => 'Organization ID :'||

Line 407: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));

403: hr_utility.set_location ('p_pgm_id is :'||p_pgm_id,10);
404: hr_utility.set_location ('p_pl_id is :'||p_pl_id,10);
405: end if;
406: --
407: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
408: l_lf_evt_ocrd_dt:=trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
409: --
410: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
411: fnd_message.set_token('PROC','dt_fndate.change_ses_date');

Line 408: l_lf_evt_ocrd_dt:=trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));

404: hr_utility.set_location ('p_pl_id is :'||p_pl_id,10);
405: end if;
406: --
407: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
408: l_lf_evt_ocrd_dt:=trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
409: --
410: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
411: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
412: dt_fndate.change_ses_date

Line 538: l_new_enrt_perd_end_dt := trunc(fnd_date.canonical_to_date(p_new_enrt_perd_end_dt));

534: l_new_dflt_enrt_dt := l_pel.dflt_enrt_dt;
535: --
536: if p_new_enrt_perd_end_dt is not null then
537: hr_utility.set_location('Replacing enrt end date...',10);
538: l_new_enrt_perd_end_dt := trunc(fnd_date.canonical_to_date(p_new_enrt_perd_end_dt));
539: end if;
540: if p_new_procg_end_dt is not null then
541: hr_utility.set_location('Replacing procg end date...',10);
542: l_new_procg_end_dt := trunc(fnd_date.canonical_to_date(p_new_procg_end_dt));

Line 542: l_new_procg_end_dt := trunc(fnd_date.canonical_to_date(p_new_procg_end_dt));

538: l_new_enrt_perd_end_dt := trunc(fnd_date.canonical_to_date(p_new_enrt_perd_end_dt));
539: end if;
540: if p_new_procg_end_dt is not null then
541: hr_utility.set_location('Replacing procg end date...',10);
542: l_new_procg_end_dt := trunc(fnd_date.canonical_to_date(p_new_procg_end_dt));
543: end if;
544: if p_new_dflt_enrt_dt is not null then
545: hr_utility.set_location('Replacing dflt enrt date...',10);
546: l_new_dflt_enrt_dt := trunc(fnd_date.canonical_to_date(p_new_dflt_enrt_dt));

Line 546: l_new_dflt_enrt_dt := trunc(fnd_date.canonical_to_date(p_new_dflt_enrt_dt));

542: l_new_procg_end_dt := trunc(fnd_date.canonical_to_date(p_new_procg_end_dt));
543: end if;
544: if p_new_dflt_enrt_dt is not null then
545: hr_utility.set_location('Replacing dflt enrt date...',10);
546: l_new_dflt_enrt_dt := trunc(fnd_date.canonical_to_date(p_new_dflt_enrt_dt));
547: end if;
548: --
549: end if;
550: --

Line 804: ,p_effective_date => fnd_date.date_to_canonical

800: --
801: /* process(errbuf => l_errbuf
802: ,retcode => l_retcode
803: ,p_benefit_action_id => p_benefit_action_id
804: ,p_effective_date => fnd_date.date_to_canonical
805: (l_parameters.process_date)
806: ,p_validate => l_parameters.validate_flag
807: ,p_business_group_id => l_parameters.business_group_id
808: ,p_ler_id => l_parameters.ler_id

Line 809: ,p_from_ocrd_date => fnd_date.date_to_canonical

805: (l_parameters.process_date)
806: ,p_validate => l_parameters.validate_flag
807: ,p_business_group_id => l_parameters.business_group_id
808: ,p_ler_id => l_parameters.ler_id
809: ,p_from_ocrd_date => fnd_date.date_to_canonical
810: (l_parameters.date_from)
811: ,p_to_ocrd_date => fnd_date.date_to_canonical
812: (l_parameters.uneai_effective_date)
813: ,p_organization_id => l_parameters.organization_id

Line 811: ,p_to_ocrd_date => fnd_date.date_to_canonical

807: ,p_business_group_id => l_parameters.business_group_id
808: ,p_ler_id => l_parameters.ler_id
809: ,p_from_ocrd_date => fnd_date.date_to_canonical
810: (l_parameters.date_from)
811: ,p_to_ocrd_date => fnd_date.date_to_canonical
812: (l_parameters.uneai_effective_date)
813: ,p_organization_id => l_parameters.organization_id
814: ,p_location_id => l_parameters.location_id
815: ,p_benfts_grp_id => l_parameters.benfts_grp_id

Line 1012: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));

1008: p_pgm_id => p_pgm_id,
1009: p_pl_id => p_pl_id
1010: );
1011: --
1012: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
1013: l_lf_evt_ocrd_dt:=trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
1014: --
1015: -- Put row in fnd_sessions
1016: --

Line 1013: l_lf_evt_ocrd_dt:=trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));

1009: p_pl_id => p_pl_id
1010: );
1011: --
1012: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
1013: l_lf_evt_ocrd_dt:=trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
1014: --
1015: -- Put row in fnd_sessions
1016: --
1017: dt_fndate.change_ses_date