APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on FND_DATE

Line 790: l_can_date := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);

786: l_object_version_number number;
787: BEGIN
788:
789: begin
790: l_can_date := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);
791: l_var_date := fnd_date.date_to_canonical(l_can_date);
792: if(l_var_date = p_lf_evt_ocrd_dt) then
793: l_lf_evt_ocrd_dt := l_can_date;
794: else

Line 791: l_var_date := fnd_date.date_to_canonical(l_can_date);

787: BEGIN
788:
789: begin
790: l_can_date := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);
791: l_var_date := fnd_date.date_to_canonical(l_can_date);
792: if(l_var_date = p_lf_evt_ocrd_dt) then
793: l_lf_evt_ocrd_dt := l_can_date;
794: else
795: l_lf_evt_ocrd_dt := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);

Line 795: l_lf_evt_ocrd_dt := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);

791: l_var_date := fnd_date.date_to_canonical(l_can_date);
792: if(l_var_date = p_lf_evt_ocrd_dt) then
793: l_lf_evt_ocrd_dt := l_can_date;
794: else
795: l_lf_evt_ocrd_dt := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);
796: end if;
797: exception
798: when others then
799: l_lf_evt_ocrd_dt := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);

Line 799: l_lf_evt_ocrd_dt := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);

795: l_lf_evt_ocrd_dt := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);
796: end if;
797: exception
798: when others then
799: l_lf_evt_ocrd_dt := fnd_date.canonical_to_date(p_lf_evt_ocrd_dt);
800: end;
801:
802: g_sent_total := 0;
803: g_unsent_total := 0;

Line 833: l_effective_date := trunc(fnd_date.canonical_to_date(sysdate));

829: WRITE ('|p_withhold_notifn - ' || p_withhold_notifn);
830: --WRITE ('||p_is_multi_thread - ' || p_is_multi_thread);
831: WRITE ('===========================================================================');
832:
833: l_effective_date := trunc(fnd_date.canonical_to_date(sysdate));
834: --
835: -- Put row in fnd_sessions
836: --
837: dt_fndate.change_ses_date