[Home] [Help]
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..
343: --RCHASE Bug Fix - Include person_id for evaluating other than participants
344: p_param1 => 'PERSON_ID',
345: p_param1_value => to_char(p_person_id),
346: p_param2 => 'BEN_IV_RT_STRT_DT' ,
347: p_param2_value => fnd_date.date_to_canonical(p_fonm_rt_strt_dt) ,
348: p_param3 => 'BEN_IV_CVG_STRT_DT' ,
349: p_param3_value => fnd_date.date_to_canonical(p_fonm_cvg_strt_dt)
350: );
351: --
345: p_param1_value => to_char(p_person_id),
346: p_param2 => 'BEN_IV_RT_STRT_DT' ,
347: p_param2_value => fnd_date.date_to_canonical(p_fonm_rt_strt_dt) ,
348: p_param3 => 'BEN_IV_CVG_STRT_DT' ,
349: p_param3_value => fnd_date.date_to_canonical(p_fonm_cvg_strt_dt)
350: );
351: --
352: if p_rule_type = 'NUMBER' then
353: --
372: --
373: begin
374: --
375: p_ret_date :=
376: fnd_date.canonical_to_date(l_outputs(l_outputs.first).value);
377: p_ret_val := null;
378: --
379: exception
380: --
522: asg.normal_hours,
523: asg.payroll_id,
524: asg.frequency,
525: asg.assignment_id assignment_id,
526: fnd_date.canonical_to_date(aei.aei_information8) change_date
527: from --per_assignments_f asg,
528: per_all_assignments_f asg,
529: per_assignment_extra_info aei,
530: per_pay_bases ppb,
1120: --Bug 2519393 Message made more clear.
1121: -- start bug # 4185334 -- changed the tokens --
1122: fnd_message.set_token('PARMA','c_stated_salary');
1123: fnd_message.set_token('PARMB',l_proc);
1124: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date));
1125: fnd_message.set_token('PARM1',p_person_id);
1126: --- end bug # 4185334
1127: /*
1128: fnd_message.raise_error;
1138: (p_application_short_name => 'BEN',
1139: p_message_name => 'BEN_93298_SAL_NOT_DFND',
1140: p_parma => 'c_stated_salary',
1141: p_parmb => l_proc,
1142: p_parmc => fnd_date.date_to_displaydate(p_effective_date),
1143: p_parm1 => p_person_id,
1144: p_person_id => p_person_id);
1145: -- end bug # 4185334
1146: benutils.write(p_text=> fnd_message.get);
2520: --
2521: if l_lsf.use_overid_svc_dt_flag = 'Y' then
2522: l_start_date := l_elig_per.ovrid_svc_dt;
2523: if l_start_date is null then
2524: l_start_date := fnd_date.canonical_to_date(l_person_extra.iasd);
2525: end if;
2526: else
2527: l_start_date := fnd_date.canonical_to_date(l_person_extra.iasd);
2528: end if;
2523: if l_start_date is null then
2524: l_start_date := fnd_date.canonical_to_date(l_person_extra.iasd);
2525: end if;
2526: else
2527: l_start_date := fnd_date.canonical_to_date(l_person_extra.iasd);
2528: end if;
2529: --
2530: elsif l_lsf.los_dt_to_use_cd ='IDOH' then
2531: --
2533: --
2534: if l_lsf.use_overid_svc_dt_flag = 'Y' then
2535: l_start_date := l_elig_per.ovrid_svc_dt;
2536: if l_start_date is null then
2537: l_start_date := fnd_date.canonical_to_date(l_person_extra.idoh);
2538: end if;
2539: else
2540: l_start_date := fnd_date.canonical_to_date(l_person_extra.idoh);
2541: end if;
2536: if l_start_date is null then
2537: l_start_date := fnd_date.canonical_to_date(l_person_extra.idoh);
2538: end if;
2539: else
2540: l_start_date := fnd_date.canonical_to_date(l_person_extra.idoh);
2541: end if;
2542: --
2543: elsif l_lsf.los_dt_to_use_cd ='IOHD' then
2544: --
2543: elsif l_lsf.los_dt_to_use_cd ='IOHD' then
2544: --
2545: -- inherited original hire date
2546: --
2547: l_start_date := fnd_date.canonical_to_date(l_person_extra.iohd);
2548: --
2549: elsif l_lsf.los_dt_to_use_cd ='RL' then
2550: run_rule(
2551: p_formula_id => l_lsf.los_dt_to_use_rl,