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 107: OR (nvl(fnd_date.date_to_canonical

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

Line 109: <> nvl(fnd_date.date_to_canonical(

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

Line 111: OR (nvl(fnd_date.date_to_canonical (

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

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

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

Line 138: fnd_date.date_to_canonical (p_start_period),

134: p_timecard_id,
135: l_type,
136: p_measure,
137: 'HOURS',
138: fnd_date.date_to_canonical (p_start_period),
139: fnd_date.date_to_canonical (p_end_period),
140: p_parent_id,
141: 'N',
142: p_scope,

Line 139: fnd_date.date_to_canonical (p_end_period),

135: l_type,
136: p_measure,
137: 'HOURS',
138: fnd_date.date_to_canonical (p_start_period),
139: fnd_date.date_to_canonical (p_end_period),
140: p_parent_id,
141: 'N',
142: p_scope,
143: nvl(p_ovn,1),