APPS.HXC_TIMECARD_PROPERTIES dependencies on FND_DATE

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

706: cursor c_period_info
707: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is
708: select rp.period_type
709: ,rp.duration_in_days
710: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date
711: from hxc_recurring_periods rp
712: where rp.recurring_period_id = p_recurring_period_id;
713:
714: cursor c_number_per_year

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

911: Begin
912:
913: l_messages := hxc_message_table_type();
914: if(length(p_timecard_start_time)>5) then
915: l_timecard_start_time := fnd_date.canonical_to_date(p_timecard_start_time);
916: l_timecard_stop_time := fnd_date.canonical_to_date(p_timecard_stop_time);
917: end if;
918:
919:

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

912:
913: l_messages := hxc_message_table_type();
914: if(length(p_timecard_start_time)>5) then
915: l_timecard_start_time := fnd_date.canonical_to_date(p_timecard_start_time);
916: l_timecard_stop_time := fnd_date.canonical_to_date(p_timecard_stop_time);
917: end if;
918:
919:
920: get_preference_properties

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

951: p_messages := hxc_message_table_type();
952: end if;
953:
954: if(length(p_timecard_start_time)>5) then
955: l_timecard_start_time := fnd_date.canonical_to_date(p_timecard_start_time);
956: l_timecard_stop_time := fnd_date.canonical_to_date(p_timecard_stop_time);
957: else
958: l_timecard_start_time := sysdate;
959: l_timecard_stop_time := sysdate;

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

952: end if;
953:
954: if(length(p_timecard_start_time)>5) then
955: l_timecard_start_time := fnd_date.canonical_to_date(p_timecard_start_time);
956: l_timecard_stop_time := fnd_date.canonical_to_date(p_timecard_stop_time);
957: else
958: l_timecard_start_time := sysdate;
959: l_timecard_stop_time := sysdate;
960: end if;