DBA Data[Home] [Help]

APPS.BEN_MANAGE_LIFE_EVENTS dependencies on FND_DATE

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

6137: l_effective_date := to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
6138: l_lf_evt_ocrd_dt := to_date(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
6139: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt),'DD/MM/RRRR'),'DD/MM/RRRR');
6140: */
6141: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
6142: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
6143: --
6144: benutils.get_ler
6145: (p_business_group_id => p_business_group_id

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

6138: l_lf_evt_ocrd_dt := to_date(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
6139: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt),'DD/MM/RRRR'),'DD/MM/RRRR');
6140: */
6141: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
6142: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
6143: --
6144: benutils.get_ler
6145: (p_business_group_id => p_business_group_id
6146: ,p_typ_cd => 'SCHEDDU'

Line 6537: p_effective_date => fnd_date.date_to_canonical(l_parameters.process_date),

6533: process
6534: (errbuf => l_errbuf,
6535: retcode => l_retcode,
6536: p_benefit_action_id => p_benefit_action_id,
6537: p_effective_date => fnd_date.date_to_canonical(l_parameters.process_date),
6538: p_mode => l_parameters.mode_cd,
6539: p_derivable_factors => l_parameters.derivable_factors_flag,
6540: p_validate => l_parameters.validate_flag,
6541: p_person_id => l_parameters.person_id,

Line 6571: p_lf_evt_ocrd_dt => fnd_date.date_to_canonical(l_parameters.lf_evt_ocrd_dt));

6567: p_abs_historical_mode => l_parameters.inelg_action_cd,
6568: p_lmt_prpnip_by_org_flag => l_parameters.lmt_prpnip_by_org_flag,
6569: -- PB : 5422 :
6570: -- Now pass on the lf_evt_ocrd_dt
6571: p_lf_evt_ocrd_dt => fnd_date.date_to_canonical(l_parameters.lf_evt_ocrd_dt));
6572: --
6573: -- The p_lf_evt_ocrd_dt needs to use lf_evt_ocrd_dt but that needs a schema
6574: -- change.
6575: --

Line 6750: (p_ses_date => fnd_date.canonical_to_date(p_effective_date)

6746: --
6747: -- Bug: 4128034. CWB Mode fnd_session needs to be set.
6748: if p_mode = 'W' then
6749: dt_fndate.change_ses_date
6750: (p_ses_date => fnd_date.canonical_to_date(p_effective_date)
6751: ,p_commit => l_commit
6752: );
6753: end if;
6754: --

Line 6934: p_per_sel_dt_from => fnd_date.canonical_to_date(p_per_sel_dt_from),

6930: p_grade_ladder_id =>p_grade_ladder_id,
6931: p_asg_events_to_all_sel_dt =>p_asg_events_to_all_sel_dt,
6932: p_rate_id =>p_rate_id,
6933: p_per_sel_dt_cd =>p_per_sel_dt_cd,
6934: p_per_sel_dt_from => fnd_date.canonical_to_date(p_per_sel_dt_from),
6935: p_per_sel_dt_to => fnd_date.canonical_to_date(p_per_sel_dt_to),
6936: p_year_from =>p_year_from,
6937: p_year_to =>p_year_to,
6938: p_cagr_id =>p_cagr_id,

Line 6935: p_per_sel_dt_to => fnd_date.canonical_to_date(p_per_sel_dt_to),

6931: p_asg_events_to_all_sel_dt =>p_asg_events_to_all_sel_dt,
6932: p_rate_id =>p_rate_id,
6933: p_per_sel_dt_cd =>p_per_sel_dt_cd,
6934: p_per_sel_dt_from => fnd_date.canonical_to_date(p_per_sel_dt_from),
6935: p_per_sel_dt_to => fnd_date.canonical_to_date(p_per_sel_dt_to),
6936: p_year_from =>p_year_from,
6937: p_year_to =>p_year_to,
6938: p_cagr_id =>p_cagr_id,
6939: p_qual_type =>p_qual_type,

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

7921: l_effective_date := to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
7922: l_lf_evt_ocrd_dt := to_date(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
7923: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt),'DD/MM/RRRR'),'DD/MM/RRRR');
7924: */
7925: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
7926: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
7927: --
7928: if p_asg_events_to_all_sel_dt is not null then
7929: /*

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

7922: l_lf_evt_ocrd_dt := to_date(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
7923: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt),'DD/MM/RRRR'),'DD/MM/RRRR');
7924: */
7925: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
7926: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
7927: --
7928: if p_asg_events_to_all_sel_dt is not null then
7929: /*
7930: l_asg_events_to_all_sel_dt := to_date(p_asg_events_to_all_sel_dt,'YYYY/MM/DD HH24:MI:SS');

Line 7933: l_asg_events_to_all_sel_dt := trunc(fnd_date.canonical_to_date(p_asg_events_to_all_sel_dt));

7929: /*
7930: l_asg_events_to_all_sel_dt := to_date(p_asg_events_to_all_sel_dt,'YYYY/MM/DD HH24:MI:SS');
7931: l_asg_events_to_all_sel_dt := to_date(to_char(trunc(l_asg_events_to_all_sel_dt),'DD/MM/RRRR'),'DD/MM/RRRR');
7932: */
7933: l_asg_events_to_all_sel_dt := trunc(fnd_date.canonical_to_date(p_asg_events_to_all_sel_dt));
7934: --
7935: end if;
7936: --
7937: if p_per_sel_dt_from is not null then