APPS.BEN_CWB_POST_PROCESS dependencies on FND_DATE

Line 855: AND xtra_info.aei_information5 = fnd_date.date_to_canonical(v_eff_dt)

851: , ben_cwb_person_info per
852: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
853: AND xtra_info.assignment_id = per.assignment_id
854: AND xtra_info.information_type = 'CWBRANK'
855: AND xtra_info.aei_information5 = fnd_date.date_to_canonical(v_eff_dt)
856: AND xtra_info.aei_information2 = v_ranked_by;
857:
858:
859: CURSOR c_prev_pay_proposal (v_group_per_in_ler_id IN NUMBER, v_effective_date IN DATE)

Line 4376: ,p_aei_information5 => fnd_date.date_to_canonical(l_perf_revw_strt_dt)

4372: ,p_aei_information1 => l_ranking_info.aei_information1
4373: ,p_aei_information2 => l_ranking_info.aei_information2
4374: ,p_aei_information3 => p_group_per_in_ler_id
4375: ,p_aei_information4 => l_ranking_info.aei_information4
4376: ,p_aei_information5 => fnd_date.date_to_canonical(l_perf_revw_strt_dt)
4377: ,p_aei_information6 => p_plan_id
4378: ,p_assignment_extra_info_id => l_assignment_extra_info_id
4379: ,p_object_version_number => l_ovn );
4380: ELSE

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

4816: write_h ('||p_thread_id - ' || p_thread_id);
4817: write_h ('||p_audit_log - ' || p_audit_log);
4818: write_h ('||p_is_force_on_per - ' || p_is_force_on_per);
4819: write_h ('||p_is_self_service - ' || p_is_self_service);
4820: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
4821: --l_effective_date := TRUNC (TO_DATE (p_effective_date, 'YYYY/MM/DD HH24:MI:SS'));
4822: write_m ('l_effective_date is ' || l_effective_date);
4823: g_actn := 'Put row in fnd_sessions...';
4824: WRITE (g_actn);

Line 5057: l_lf_evt_orcd_date := trunc(fnd_date.canonical_to_date(p_lf_evt_orcd_date));

5053: g_actn := 'Stating the post-process...';
5054: WRITE (g_actn);
5055: g_proc := g_package || '.process';
5056: g_debug_level := p_debug_level;
5057: l_lf_evt_orcd_date := trunc(fnd_date.canonical_to_date(p_lf_evt_orcd_date));
5058: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
5059: write_h ('=====================process====================');
5060: write_h ('||Parameter Description ');
5061: write_h ('||p_effective_dates - ' || l_effective_date);

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

5054: WRITE (g_actn);
5055: g_proc := g_package || '.process';
5056: g_debug_level := p_debug_level;
5057: l_lf_evt_orcd_date := trunc(fnd_date.canonical_to_date(p_lf_evt_orcd_date));
5058: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
5059: write_h ('=====================process====================');
5060: write_h ('||Parameter Description ');
5061: write_h ('||p_effective_dates - ' || l_effective_date);
5062: write_h ('||p_validate - ' || p_validate);