APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on FND_DATE

Line 505: AND xtra_info.aei_information5 = fnd_date.date_to_canonical(v_perf_revw_strt_dt)

501: AND xtra_info.assignment_id = per.assignment_id
502: AND xtra_info.information_type = 'CWBRANK'
503: AND xtra_info.aei_information1 IS NOT NULL
504: AND xtra_info.aei_information3 = v_group_per_in_ler_id
505: AND xtra_info.aei_information5 = fnd_date.date_to_canonical(v_perf_revw_strt_dt)
506: AND xtra_info.aei_information6 = v_plan_id;
507:
508: CURSOR c_ranking_info_date ( v_group_per_in_ler_id IN NUMBER
509: ,v_eff_dt IN DATE

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

519: , ben_cwb_person_info per
520: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
521: AND xtra_info.assignment_id = per.assignment_id
522: AND xtra_info.information_type = 'CWBRANK'
523: AND xtra_info.aei_information5 = fnd_date.date_to_canonical(v_eff_dt)
524: AND xtra_info.aei_information2 = v_ranked_by;
525:
526:
527: CURSOR c_element_input_value_name(v_input_value_id IN NUMBER,

Line 1099: fnd_date.date_to_canonical(sysdate),

1095: null,
1096: null,
1097: hr_general.decode_lookup('BEN_WS_ACC', 'UP' ),
1098: 'Your worksheet is now available for further updates. Please make any changes as required and re-submit for approval.' ,
1099: fnd_date.date_to_canonical(sysdate),
1100: hr_general.decode_lookup('BEN_WS_ACC', l_grp_ovn.access_cd ),
1101: null, --l_requestor_first_name,
1102: 'System Administrator' --l_requestor_last_name
1103: )

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

3925: write_h ('||p_thread_id - ' || p_thread_id);
3926: write_h ('||p_audit_log - ' || p_audit_log);
3927: write_h ('||p_is_self_service - ' || p_is_self_service);
3928: write_h ('||p_is_backout_perf - ' || p_is_backout_perf);
3929: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
3930: --l_effective_date := TRUNC (TO_DATE (p_effective_date, 'YYYY/MM/DD HH24:MI:SS'));
3931: write_m ('l_effective_date is ' || l_effective_date);
3932: g_actn := 'Put row in fnd_sessions...';
3933: WRITE (g_actn);

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

4170: g_actn := 'Stating the backout post-process...';
4171: WRITE (g_actn);
4172: g_proc := g_package || '.process';
4173: g_debug_level := p_debug_level;
4174: l_lf_evt_orcd_date := trunc(fnd_date.canonical_to_date(p_lf_evt_orcd_date));
4175: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
4176: write_h ('=====================process====================');
4177: write_h ('||Parameter Description ');
4178: write_h ('||p_effective_dates - ' || l_effective_date);

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

4171: WRITE (g_actn);
4172: g_proc := g_package || '.process';
4173: g_debug_level := p_debug_level;
4174: l_lf_evt_orcd_date := trunc(fnd_date.canonical_to_date(p_lf_evt_orcd_date));
4175: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
4176: write_h ('=====================process====================');
4177: write_h ('||Parameter Description ');
4178: write_h ('||p_effective_dates - ' || l_effective_date);
4179: write_h ('||p_validate - ' || p_validate);