APPS.HXC_PROJ_PAY_DEP_VALIDATION dependencies on FND_DATE

Line 119: AND FND_DATE.canonical_to_date(p_blocks(l_index).DATE_TO) = hr_general.end_of_time

115:
116: LOOP
117: EXIT WHEN NOT p_blocks.exists(l_index);
118: IF p_blocks(l_index).scope = 'DETAIL'
119: AND FND_DATE.canonical_to_date(p_blocks(l_index).DATE_TO) = hr_general.end_of_time
120: THEN
121: IF l_active_building_block_ids IS NULL THEN
122: l_active_building_block_ids := p_blocks(l_index).time_building_block_id;
123: ELSE

Line 324: AND FND_DATE.canonical_to_date(p_blocks(l_index).DATE_TO) = hr_general.end_of_time

320:
321: l_index := p_blocks.FIRST;
322: LOOP
323: IF (p_blocks(l_index).scope = 'TIMECARD' or p_blocks(l_index).scope = 'TIMECARD_TEMPLATE')
324: AND FND_DATE.canonical_to_date(p_blocks(l_index).DATE_TO) = hr_general.end_of_time
325: THEN
326: hxc_preference_evaluation.resource_preferences(p_blocks(l_index).resource_id,
327: FND_DATE.canonical_to_date(p_blocks(l_index).start_time),
328: FND_DATE.canonical_to_date(p_blocks(l_index).stop_time),

Line 327: FND_DATE.canonical_to_date(p_blocks(l_index).start_time),

323: IF (p_blocks(l_index).scope = 'TIMECARD' or p_blocks(l_index).scope = 'TIMECARD_TEMPLATE')
324: AND FND_DATE.canonical_to_date(p_blocks(l_index).DATE_TO) = hr_general.end_of_time
325: THEN
326: hxc_preference_evaluation.resource_preferences(p_blocks(l_index).resource_id,
327: FND_DATE.canonical_to_date(p_blocks(l_index).start_time),
328: FND_DATE.canonical_to_date(p_blocks(l_index).stop_time),
329: l_pref_table);
330: l_resource_id := p_blocks(l_index).resource_id;
331: l_timecard_id := p_blocks(l_index).time_building_block_id;

Line 328: FND_DATE.canonical_to_date(p_blocks(l_index).stop_time),

324: AND FND_DATE.canonical_to_date(p_blocks(l_index).DATE_TO) = hr_general.end_of_time
325: THEN
326: hxc_preference_evaluation.resource_preferences(p_blocks(l_index).resource_id,
327: FND_DATE.canonical_to_date(p_blocks(l_index).start_time),
328: FND_DATE.canonical_to_date(p_blocks(l_index).stop_time),
329: l_pref_table);
330: l_resource_id := p_blocks(l_index).resource_id;
331: l_timecard_id := p_blocks(l_index).time_building_block_id;
332: l_timecard_ovn := p_blocks(l_index).object_version_number;

Line 333: l_start_time := FND_DATE.canonical_to_date(p_blocks(l_index).start_time);

329: l_pref_table);
330: l_resource_id := p_blocks(l_index).resource_id;
331: l_timecard_id := p_blocks(l_index).time_building_block_id;
332: l_timecard_ovn := p_blocks(l_index).object_version_number;
333: l_start_time := FND_DATE.canonical_to_date(p_blocks(l_index).start_time);
334: l_stop_time := FND_DATE.canonical_to_date(p_blocks(l_index).stop_time);
335:
336: EXIT;
337: END IF;

Line 334: l_stop_time := FND_DATE.canonical_to_date(p_blocks(l_index).stop_time);

330: l_resource_id := p_blocks(l_index).resource_id;
331: l_timecard_id := p_blocks(l_index).time_building_block_id;
332: l_timecard_ovn := p_blocks(l_index).object_version_number;
333: l_start_time := FND_DATE.canonical_to_date(p_blocks(l_index).start_time);
334: l_stop_time := FND_DATE.canonical_to_date(p_blocks(l_index).stop_time);
335:
336: EXIT;
337: END IF;
338: l_index := p_blocks.NEXT(l_index);