DBA Data[Home] [Help]

APPS.BEN_MANAGE_LIFE_EVENTS dependencies on FND_DATE

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

5745: l_effective_date := to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
5746: l_lf_evt_ocrd_dt := to_date(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
5747: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt),'DD/MM/RRRR'),'DD/MM/RRRR');
5748: */
5749: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
5750: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
5751: --
5752: benutils.get_ler
5753: (p_business_group_id => p_business_group_id

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

5746: l_lf_evt_ocrd_dt := to_date(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
5747: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt),'DD/MM/RRRR'),'DD/MM/RRRR');
5748: */
5749: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
5750: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
5751: --
5752: benutils.get_ler
5753: (p_business_group_id => p_business_group_id
5754: ,p_typ_cd => 'SCHEDDU'

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

6130: process
6131: (errbuf => l_errbuf,
6132: retcode => l_retcode,
6133: p_benefit_action_id => p_benefit_action_id,
6134: p_effective_date => fnd_date.date_to_canonical(l_parameters.process_date),
6135: p_mode => l_parameters.mode_cd,
6136: p_derivable_factors => l_parameters.derivable_factors_flag,
6137: p_validate => l_parameters.validate_flag,
6138: p_person_id => l_parameters.person_id,

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

6164: p_abs_historical_mode => l_parameters.inelg_action_cd,
6165: p_lmt_prpnip_by_org_flag => l_parameters.lmt_prpnip_by_org_flag,
6166: -- PB : 5422 :
6167: -- Now pass on the lf_evt_ocrd_dt
6168: p_lf_evt_ocrd_dt => fnd_date.date_to_canonical(l_parameters.lf_evt_ocrd_dt));
6169: --
6170: -- The p_lf_evt_ocrd_dt needs to use lf_evt_ocrd_dt but that needs a schema
6171: -- change.
6172: --

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

6343: --
6344: -- Bug: 4128034. CWB Mode fnd_session needs to be set.
6345: if p_mode = 'W' then
6346: dt_fndate.change_ses_date
6347: (p_ses_date => fnd_date.canonical_to_date(p_effective_date)
6348: ,p_commit => l_commit
6349: );
6350: end if;
6351: --

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

6527: p_grade_ladder_id =>p_grade_ladder_id,
6528: p_asg_events_to_all_sel_dt =>p_asg_events_to_all_sel_dt,
6529: p_rate_id =>p_rate_id,
6530: p_per_sel_dt_cd =>p_per_sel_dt_cd,
6531: p_per_sel_dt_from => fnd_date.canonical_to_date(p_per_sel_dt_from),
6532: p_per_sel_dt_to => fnd_date.canonical_to_date(p_per_sel_dt_to),
6533: p_year_from =>p_year_from,
6534: p_year_to =>p_year_to,
6535: p_cagr_id =>p_cagr_id,

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

6528: p_asg_events_to_all_sel_dt =>p_asg_events_to_all_sel_dt,
6529: p_rate_id =>p_rate_id,
6530: p_per_sel_dt_cd =>p_per_sel_dt_cd,
6531: p_per_sel_dt_from => fnd_date.canonical_to_date(p_per_sel_dt_from),
6532: p_per_sel_dt_to => fnd_date.canonical_to_date(p_per_sel_dt_to),
6533: p_year_from =>p_year_from,
6534: p_year_to =>p_year_to,
6535: p_cagr_id =>p_cagr_id,
6536: p_qual_type =>p_qual_type,

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

7515: l_effective_date := to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
7516: l_lf_evt_ocrd_dt := to_date(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
7517: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt),'DD/MM/RRRR'),'DD/MM/RRRR');
7518: */
7519: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
7520: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
7521: --
7522: if p_asg_events_to_all_sel_dt is not null then
7523: /*

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

7516: l_lf_evt_ocrd_dt := to_date(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
7517: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt),'DD/MM/RRRR'),'DD/MM/RRRR');
7518: */
7519: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
7520: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
7521: --
7522: if p_asg_events_to_all_sel_dt is not null then
7523: /*
7524: l_asg_events_to_all_sel_dt := to_date(p_asg_events_to_all_sel_dt,'YYYY/MM/DD HH24:MI:SS');

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

7523: /*
7524: l_asg_events_to_all_sel_dt := to_date(p_asg_events_to_all_sel_dt,'YYYY/MM/DD HH24:MI:SS');
7525: 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');
7526: */
7527: l_asg_events_to_all_sel_dt := trunc(fnd_date.canonical_to_date(p_asg_events_to_all_sel_dt));
7528: --
7529: end if;
7530: --
7531: if p_per_sel_dt_from is not null then