APPS.HXC_TIMECARD_PROPERTIES dependencies on FND_DATE

Line 683: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date

679: cursor c_period_info
680: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is
681: select rp.period_type
682: ,rp.duration_in_days
683: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date
684: from hxc_recurring_periods rp
685: where rp.recurring_period_id = p_recurring_period_id;
686:
687: cursor c_number_per_year

Line 888: l_timecard_start_time := fnd_date.canonical_to_date(p_timecard_start_time);

884: Begin
885:
886: l_messages := hxc_message_table_type();
887: if(length(p_timecard_start_time)>5) then
888: l_timecard_start_time := fnd_date.canonical_to_date(p_timecard_start_time);
889: l_timecard_stop_time := fnd_date.canonical_to_date(p_timecard_stop_time);
890: end if;
891:
892:

Line 889: l_timecard_stop_time := fnd_date.canonical_to_date(p_timecard_stop_time);

885:
886: l_messages := hxc_message_table_type();
887: if(length(p_timecard_start_time)>5) then
888: l_timecard_start_time := fnd_date.canonical_to_date(p_timecard_start_time);
889: l_timecard_stop_time := fnd_date.canonical_to_date(p_timecard_stop_time);
890: end if;
891:
892:
893: get_preference_properties

Line 928: l_timecard_start_time := fnd_date.canonical_to_date(p_timecard_start_time);

924: p_messages := hxc_message_table_type();
925: end if;
926:
927: if(length(p_timecard_start_time)>5) then
928: l_timecard_start_time := fnd_date.canonical_to_date(p_timecard_start_time);
929: l_timecard_stop_time := fnd_date.canonical_to_date(p_timecard_stop_time);
930: else
931: l_timecard_start_time := sysdate;
932: l_timecard_stop_time := sysdate;

Line 929: l_timecard_stop_time := fnd_date.canonical_to_date(p_timecard_stop_time);

925: end if;
926:
927: if(length(p_timecard_start_time)>5) then
928: l_timecard_start_time := fnd_date.canonical_to_date(p_timecard_start_time);
929: l_timecard_stop_time := fnd_date.canonical_to_date(p_timecard_stop_time);
930: else
931: l_timecard_start_time := sysdate;
932: l_timecard_stop_time := sysdate;
933: end if;