APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on FND_DATE

Line 2174: IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )

2170: END IF;
2171:
2172: -- only copy blocks which are NOT deleted
2173:
2174: IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )
2175: THEN
2176:
2177: IF ( g_debug ) THEN
2178: hr_utility.trace('Scope : start time '||p_blocks(l_ind).scope||' : '||p_blocks(l_ind).start_time);

Line 2189: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);

2185: THEN
2186:
2187: l_day_index_tab(p_blocks(l_ind).time_building_block_id) := l_ind;
2188:
2189: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2190: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2191:
2192: ELSIF ( p_blocks(l_ind).scope = 'DETAIL' )
2193: THEN

Line 2190: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);

2186:
2187: l_day_index_tab(p_blocks(l_ind).time_building_block_id) := l_ind;
2188:
2189: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2190: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2191:
2192: ELSIF ( p_blocks(l_ind).scope = 'DETAIL' )
2193: THEN
2194:

Line 2207: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).start_time);

2203: fnd_message.raise_error;
2204: END IF;
2205:
2206: l_start_time :=
2207: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).start_time);
2208: l_stop_time :=
2209: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).stop_time);
2210:
2211: ELSE

Line 2209: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).stop_time);

2205:
2206: l_start_time :=
2207: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).start_time);
2208: l_stop_time :=
2209: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).stop_time);
2210:
2211: ELSE
2212:
2213: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);

Line 2213: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);

2209: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).stop_time);
2210:
2211: ELSE
2212:
2213: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2214: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2215:
2216: END IF; -- ( p_blocks(l_ind).type = 'MEASURE' )
2217:

Line 2214: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);

2210:
2211: ELSE
2212:
2213: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2214: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2215:
2216: END IF; -- ( p_blocks(l_ind).type = 'MEASURE' )
2217:
2218: ELSE

Line 2220: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);

2216: END IF; -- ( p_blocks(l_ind).type = 'MEASURE' )
2217:
2218: ELSE
2219:
2220: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2221: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2222:
2223: END IF; -- scope test
2224:

Line 2221: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);

2217:
2218: ELSE
2219:
2220: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2221: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2222:
2223: END IF; -- scope test
2224:
2225: ELSE -- all DETAILS with date already denormalised from DAY

Line 2227: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);

2223: END IF; -- scope test
2224:
2225: ELSE -- all DETAILS with date already denormalised from DAY
2226:
2227: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2228: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2229:
2230: END IF; -- IF ( NOT p_details_only )
2231:

Line 2228: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);

2224:
2225: ELSE -- all DETAILS with date already denormalised from DAY
2226:
2227: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2228: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2229:
2230: END IF; -- IF ( NOT p_details_only )
2231:
2232: x := x + 1;

Line 2262: END IF; -- IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )

2258:
2259: END IF; -- t_scope(x) = 'DETAIL'
2260:
2261:
2262: END IF; -- IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )
2263:
2264: l_ind := p_blocks.NEXT(l_ind);
2265:
2266: END LOOP;