APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on FND_DATE

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

2191: END IF;
2192:
2193: -- only copy blocks which are NOT deleted
2194:
2195: IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )
2196: THEN
2197:
2198: IF ( g_debug ) THEN
2199: hr_utility.trace('Scope : start time '||p_blocks(l_ind).scope||' : '||p_blocks(l_ind).start_time);

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

2206: THEN
2207:
2208: l_day_index_tab(p_blocks(l_ind).time_building_block_id) := l_ind;
2209:
2210: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2211: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2212:
2213: ELSIF ( p_blocks(l_ind).scope = 'DETAIL' )
2214: THEN

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

2207:
2208: l_day_index_tab(p_blocks(l_ind).time_building_block_id) := l_ind;
2209:
2210: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2211: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2212:
2213: ELSIF ( p_blocks(l_ind).scope = 'DETAIL' )
2214: THEN
2215:

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

2224: fnd_message.raise_error;
2225: END IF;
2226:
2227: l_start_time :=
2228: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).start_time);
2229: l_stop_time :=
2230: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).stop_time);
2231:
2232: ELSE

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

2226:
2227: l_start_time :=
2228: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).start_time);
2229: l_stop_time :=
2230: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).stop_time);
2231:
2232: ELSE
2233:
2234: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);

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

2230: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).stop_time);
2231:
2232: ELSE
2233:
2234: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2235: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2236:
2237: END IF; -- ( p_blocks(l_ind).type = 'MEASURE' )
2238:

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

2231:
2232: ELSE
2233:
2234: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2235: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2236:
2237: END IF; -- ( p_blocks(l_ind).type = 'MEASURE' )
2238:
2239: ELSE

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

2237: END IF; -- ( p_blocks(l_ind).type = 'MEASURE' )
2238:
2239: ELSE
2240:
2241: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2242: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2243:
2244: END IF; -- scope test
2245:

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

2238:
2239: ELSE
2240:
2241: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2242: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2243:
2244: END IF; -- scope test
2245:
2246: ELSE -- all DETAILS with date already denormalised from DAY

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

2244: END IF; -- scope test
2245:
2246: ELSE -- all DETAILS with date already denormalised from DAY
2247:
2248: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2249: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2250:
2251: END IF; -- IF ( NOT p_details_only )
2252:

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

2245:
2246: ELSE -- all DETAILS with date already denormalised from DAY
2247:
2248: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).start_time);
2249: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).stop_time);
2250:
2251: END IF; -- IF ( NOT p_details_only )
2252:
2253: x := x + 1;

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

2279:
2280: END IF; -- t_scope(x) = 'DETAIL'
2281:
2282:
2283: END IF; -- IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )
2284:
2285: l_ind := p_blocks.NEXT(l_ind);
2286:
2287: END LOOP;