APPS.HXC_TIMEKEEPER_UTILITIES dependencies on FND_DATE

Line 88: l_date_from := fnd_date.date_to_canonical (p_date_from);

84: END if;
85: /*end of fix for 5099360 */
86: END IF;
87:
88: l_date_from := fnd_date.date_to_canonical (p_date_from);
89: l_date_to := fnd_date.date_to_canonical (p_date_to);
90:
91:
92: IF p_timecard_index_info.EXISTS (p_timecard_id) THEN

Line 89: l_date_to := fnd_date.date_to_canonical (p_date_to);

85: /*end of fix for 5099360 */
86: END IF;
87:
88: l_date_from := fnd_date.date_to_canonical (p_date_from);
89: l_date_to := fnd_date.date_to_canonical (p_date_to);
90:
91:
92: IF p_timecard_index_info.EXISTS (p_timecard_id) THEN
93: l_block_index := p_timecard_index_info (p_timecard_id).time_block_row_index;

Line 104: OR (nvl(fnd_date.date_to_canonical

100: -- check the changed flag
101: IF l_changed <> 'Y' THEN
102:
103: IF ((nvl(p_timecard (l_block_index).measure,-999) <> nvl(p_measure,-999))
104: OR (nvl(fnd_date.date_to_canonical
105: (to_date(p_timecard (l_block_index).start_time,'YYYY/MM/DD HH24:MI:SS')),-999)
106: <> nvl(fnd_date.date_to_canonical(
107: to_date(p_start_period,'YYYY/MM/DD HH24:MI:SS')),-999))
108: OR (nvl(fnd_date.date_to_canonical (

Line 106: <> nvl(fnd_date.date_to_canonical(

102:
103: IF ((nvl(p_timecard (l_block_index).measure,-999) <> nvl(p_measure,-999))
104: OR (nvl(fnd_date.date_to_canonical
105: (to_date(p_timecard (l_block_index).start_time,'YYYY/MM/DD HH24:MI:SS')),-999)
106: <> nvl(fnd_date.date_to_canonical(
107: to_date(p_start_period,'YYYY/MM/DD HH24:MI:SS')),-999))
108: OR (nvl(fnd_date.date_to_canonical (
109: to_date(p_timecard (l_block_index).stop_time,'YYYY/MM/DD HH24:MI:SS')),-999)
110: <> nvl(fnd_date.date_to_canonical(to_date(p_end_period,'YYYY/MM/DD HH24:MI:SS')),-999))

Line 108: OR (nvl(fnd_date.date_to_canonical (

104: OR (nvl(fnd_date.date_to_canonical
105: (to_date(p_timecard (l_block_index).start_time,'YYYY/MM/DD HH24:MI:SS')),-999)
106: <> nvl(fnd_date.date_to_canonical(
107: to_date(p_start_period,'YYYY/MM/DD HH24:MI:SS')),-999))
108: OR (nvl(fnd_date.date_to_canonical (
109: to_date(p_timecard (l_block_index).stop_time,'YYYY/MM/DD HH24:MI:SS')),-999)
110: <> nvl(fnd_date.date_to_canonical(to_date(p_end_period,'YYYY/MM/DD HH24:MI:SS')),-999))
111: OR (nvl(p_timecard (l_block_index).comment_text,-999)
112: <> nvl(p_comment_text,-999))) THEN

Line 110: <> nvl(fnd_date.date_to_canonical(to_date(p_end_period,'YYYY/MM/DD HH24:MI:SS')),-999))

106: <> nvl(fnd_date.date_to_canonical(
107: to_date(p_start_period,'YYYY/MM/DD HH24:MI:SS')),-999))
108: OR (nvl(fnd_date.date_to_canonical (
109: to_date(p_timecard (l_block_index).stop_time,'YYYY/MM/DD HH24:MI:SS')),-999)
110: <> nvl(fnd_date.date_to_canonical(to_date(p_end_period,'YYYY/MM/DD HH24:MI:SS')),-999))
111: OR (nvl(p_timecard (l_block_index).comment_text,-999)
112: <> nvl(p_comment_text,-999))) THEN
113: l_changed := 'Y';
114: END IF;

Line 129: fnd_date.date_to_canonical (p_start_period),

125: p_timecard_id,
126: l_type,
127: p_measure,
128: 'HOURS',
129: fnd_date.date_to_canonical (p_start_period),
130: fnd_date.date_to_canonical (p_end_period),
131: p_parent_id,
132: 'N',
133: p_scope,

Line 130: fnd_date.date_to_canonical (p_end_period),

126: l_type,
127: p_measure,
128: 'HOURS',
129: fnd_date.date_to_canonical (p_start_period),
130: fnd_date.date_to_canonical (p_end_period),
131: p_parent_id,
132: 'N',
133: p_scope,
134: nvl(p_ovn,1),