DBA Data[Home] [Help]

APPS.BEN_DERIVE_FACTORS dependencies on FND_DATE

Line 200: to fnd_date.date_to_displaydate(p_effective_date).

196: 13-Oct-04 mmudigon 115.80 Forward port from 115.74.11510.4
197: Bug 3818453. Added call to get_latest_paa_id()
198: 17-Feb-05 ssarkar 115.81 Bug 4120426--Called load_warnings in proc determine_compensation.
199: 23-feb-05 ssarkar 115.82 changed to_char(p_effective_date, 'DD-MON-RRRR')
200: to fnd_date.date_to_displaydate(p_effective_date).
201: 07-apr-05 nhunur 115.83 apply fnd_number on what FF returns in run_rule.
202: 27-Apr-05 mmudigon 115.84 OIC integration. Addition of the
203: codes 'OICAMTEARNED' and'OICAMTPAID'
204: 02-May-05 bmanyam 115.85 Bug 4343063. Fixed a Typo..

Line 362: p_param2_value => fnd_date.date_to_canonical(p_fonm_rt_strt_dt) ,

358: --RCHASE Bug Fix - Include person_id for evaluating other than participants
359: p_param1 => 'PERSON_ID',
360: p_param1_value => to_char(p_person_id),
361: p_param2 => 'BEN_IV_RT_STRT_DT' ,
362: p_param2_value => fnd_date.date_to_canonical(p_fonm_rt_strt_dt) ,
363: p_param3 => 'BEN_IV_CVG_STRT_DT' ,
364: p_param3_value => fnd_date.date_to_canonical(p_fonm_cvg_strt_dt)
365: );
366: --

Line 364: p_param3_value => fnd_date.date_to_canonical(p_fonm_cvg_strt_dt)

360: p_param1_value => to_char(p_person_id),
361: p_param2 => 'BEN_IV_RT_STRT_DT' ,
362: p_param2_value => fnd_date.date_to_canonical(p_fonm_rt_strt_dt) ,
363: p_param3 => 'BEN_IV_CVG_STRT_DT' ,
364: p_param3_value => fnd_date.date_to_canonical(p_fonm_cvg_strt_dt)
365: );
366: --
367: if p_rule_type = 'NUMBER' then
368: --

Line 391: fnd_date.canonical_to_date(l_outputs(l_outputs.first).value);

387: --
388: begin
389: --
390: p_ret_date :=
391: fnd_date.canonical_to_date(l_outputs(l_outputs.first).value);
392: p_ret_val := null;
393: --
394: exception
395: --

Line 541: fnd_date.canonical_to_date(aei.aei_information8) change_date

537: asg.normal_hours,
538: asg.payroll_id,
539: asg.frequency,
540: asg.assignment_id assignment_id,
541: fnd_date.canonical_to_date(aei.aei_information8) change_date
542: from --per_assignments_f asg,
543: per_all_assignments_f asg,
544: per_assignment_extra_info aei,
545: per_pay_bases ppb,

Line 1242: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2));

1238: --Bug 2519393 Message made more clear.
1239: -- start bug # 4185334 -- changed the tokens --
1240: fnd_message.set_token('PARMA','c_stated_salary');
1241: fnd_message.set_token('PARMB',l_proc);
1242: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2));
1243: fnd_message.set_token('PARM1',p_person_id);
1244: --- end bug # 4185334
1245: /*
1246: fnd_message.raise_error;

Line 1260: p_parmc => fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2),

1256: (p_application_short_name => 'BEN',
1257: p_message_name => 'BEN_93298_SAL_NOT_DFND',
1258: p_parma => 'c_stated_salary',
1259: p_parmb => l_proc,
1260: p_parmc => fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2),
1261: p_parm1 => p_person_id,
1262: p_person_id => p_person_id);
1263: -- end bug # 4185334
1264: benutils.write(p_text=> fnd_message.get);

Line 2645: l_start_date := fnd_date.canonical_to_date(l_person_extra.iasd);

2641: --
2642: if l_lsf.use_overid_svc_dt_flag = 'Y' then
2643: l_start_date := l_elig_per.ovrid_svc_dt;
2644: if l_start_date is null then
2645: l_start_date := fnd_date.canonical_to_date(l_person_extra.iasd);
2646: end if;
2647: else
2648: l_start_date := fnd_date.canonical_to_date(l_person_extra.iasd);
2649: end if;

Line 2648: l_start_date := fnd_date.canonical_to_date(l_person_extra.iasd);

2644: if l_start_date is null then
2645: l_start_date := fnd_date.canonical_to_date(l_person_extra.iasd);
2646: end if;
2647: else
2648: l_start_date := fnd_date.canonical_to_date(l_person_extra.iasd);
2649: end if;
2650: --
2651: elsif l_lsf.los_dt_to_use_cd ='IDOH' then
2652: --

Line 2658: l_start_date := fnd_date.canonical_to_date(l_person_extra.idoh);

2654: --
2655: if l_lsf.use_overid_svc_dt_flag = 'Y' then
2656: l_start_date := l_elig_per.ovrid_svc_dt;
2657: if l_start_date is null then
2658: l_start_date := fnd_date.canonical_to_date(l_person_extra.idoh);
2659: end if;
2660: else
2661: l_start_date := fnd_date.canonical_to_date(l_person_extra.idoh);
2662: end if;

Line 2661: l_start_date := fnd_date.canonical_to_date(l_person_extra.idoh);

2657: if l_start_date is null then
2658: l_start_date := fnd_date.canonical_to_date(l_person_extra.idoh);
2659: end if;
2660: else
2661: l_start_date := fnd_date.canonical_to_date(l_person_extra.idoh);
2662: end if;
2663: --
2664: elsif l_lsf.los_dt_to_use_cd ='IOHD' then
2665: --

Line 2668: l_start_date := fnd_date.canonical_to_date(l_person_extra.iohd);

2664: elsif l_lsf.los_dt_to_use_cd ='IOHD' then
2665: --
2666: -- inherited original hire date
2667: --
2668: l_start_date := fnd_date.canonical_to_date(l_person_extra.iohd);
2669: --
2670: elsif l_lsf.los_dt_to_use_cd ='RL' then
2671: run_rule(
2672: p_formula_id => l_lsf.los_dt_to_use_rl,