eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_POST_PROCESS dependencies on FND_DATE

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

863: , ben_cwb_person_info per
864: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
865: AND xtra_info.assignment_id = per.assignment_id
866: AND xtra_info.information_type = 'CWBRANK'
867: AND xtra_info.aei_information5 = fnd_date.date_to_canonical(v_eff_dt)
868: AND xtra_info.aei_information2 = v_ranked_by;
869:
870:
871: CURSOR c_prev_pay_proposal (v_group_per_in_ler_id IN NUMBER, v_effective_date IN DATE)

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

4449: ,p_aei_information1 => l_ranking_info.aei_information1
4450: ,p_aei_information2 => l_ranking_info.aei_information2
4451: ,p_aei_information3 => p_group_per_in_ler_id
4452: ,p_aei_information4 => l_ranking_info.aei_information4
4453: ,p_aei_information5 => fnd_date.date_to_canonical(l_perf_revw_strt_dt)
4454: ,p_aei_information6 => p_plan_id
4455: ,p_assignment_extra_info_id => l_assignment_extra_info_id
4456: ,p_object_version_number => l_ovn );
4457: ELSE

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

4893: write_h ('||p_thread_id - ' || p_thread_id);
4894: write_h ('||p_audit_log - ' || p_audit_log);
4895: write_h ('||p_is_force_on_per - ' || p_is_force_on_per);
4896: write_h ('||p_is_self_service - ' || p_is_self_service);
4897: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
4898: --l_effective_date := TRUNC (TO_DATE (p_effective_date, 'YYYY/MM/DD HH24:MI:SS'));
4899: write_m ('l_effective_date is ' || l_effective_date);
4900: g_actn := 'Put row in fnd_sessions...';
4901: WRITE (g_actn);

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

5130: g_actn := 'Stating the post-process...';
5131: WRITE (g_actn);
5132: g_proc := g_package || '.process';
5133: g_debug_level := p_debug_level;
5134: l_lf_evt_orcd_date := trunc(fnd_date.canonical_to_date(p_lf_evt_orcd_date));
5135: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
5136: write_h ('=====================process====================');
5137: write_h ('||Parameter Description ');
5138: write_h ('||p_effective_dates - ' || l_effective_date);

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

5131: WRITE (g_actn);
5132: g_proc := g_package || '.process';
5133: g_debug_level := p_debug_level;
5134: l_lf_evt_orcd_date := trunc(fnd_date.canonical_to_date(p_lf_evt_orcd_date));
5135: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
5136: write_h ('=====================process====================');
5137: write_h ('||Parameter Description ');
5138: write_h ('||p_effective_dates - ' || l_effective_date);
5139: write_h ('||p_validate - ' || p_validate);