DBA Data[Home] [Help]

APPS.HXC_TIMECARD_DEPOSIT dependencies on FND_DATE

Line 732: AND p_blocks(l_index).date_to = fnd_date.date_to_canonical(hr_general.end_of_time)

728:
729:
730: if(p_blocks(l_index).scope = 'DETAIL'
731: AND p_blocks(l_index).time_building_block_id <> p_block_new.time_building_block_id
732: AND p_blocks(l_index).date_to = fnd_date.date_to_canonical(hr_general.end_of_time)
733: AND p_blocks(l_index).parent_building_block_id = p_block_new.parent_building_block_id
734: AND p_blocks(l_index).translation_display_key is NOT NULL
735: AND p_block_new.translation_display_key is NOT NULL
736: AND p_blocks(l_index).translation_display_key = p_block_new.translation_display_key

Line 1164: p_start_time=> FND_DATE.CANONICAL_TO_DATE(l_block.start_time),

1160: hr_utility.trace('ABS : new time_building_block_id '||l_new_bb_id);
1161: END IF;
1162: hxc_retrieve_absences.update_co_absences(p_old_bb_id => l_old_bb_id,
1163: p_new_bb_id => l_new_bb_id,
1164: p_start_time=> FND_DATE.CANONICAL_TO_DATE(l_block.start_time),
1165: p_stop_time => FND_DATE.CANONICAL_TO_DATE(l_block.stop_time),
1166: p_element_id => l_element);
1167: add_transaction_info(l_new_bb_id,1,null,p_transaction_info,p_messages);
1168: p_blocks(p_detail_blocks(l_index)) := l_block;

Line 1165: p_stop_time => FND_DATE.CANONICAL_TO_DATE(l_block.stop_time),

1161: END IF;
1162: hxc_retrieve_absences.update_co_absences(p_old_bb_id => l_old_bb_id,
1163: p_new_bb_id => l_new_bb_id,
1164: p_start_time=> FND_DATE.CANONICAL_TO_DATE(l_block.start_time),
1165: p_stop_time => FND_DATE.CANONICAL_TO_DATE(l_block.stop_time),
1166: p_element_id => l_element);
1167: add_transaction_info(l_new_bb_id,1,null,p_transaction_info,p_messages);
1168: p_blocks(p_detail_blocks(l_index)) := l_block;
1169: maintain_dependents

Line 1197: p_start_time => FND_DATE.CANONICAL_TO_DATE(l_block.start_time),

1193: hr_utility.trace('ABS l_old_ovn '||l_new_ovn);
1194: END IF;
1195: hxc_retrieve_absences.update_co_absences_ovn(p_old_bb_id => l_block.time_building_block_id,
1196: p_new_ovn => l_new_ovn,
1197: p_start_time => FND_DATE.CANONICAL_TO_DATE(l_block.start_time),
1198: p_stop_time => FND_DATE.CANONICAL_TO_DATE(l_block.stop_time),
1199: p_element_id => l_element);
1200: END IF;
1201: add_transaction_info(l_block.time_building_block_id,l_new_ovn,null,p_transaction_info,p_messages);

Line 1198: p_stop_time => FND_DATE.CANONICAL_TO_DATE(l_block.stop_time),

1194: END IF;
1195: hxc_retrieve_absences.update_co_absences_ovn(p_old_bb_id => l_block.time_building_block_id,
1196: p_new_ovn => l_new_ovn,
1197: p_start_time => FND_DATE.CANONICAL_TO_DATE(l_block.start_time),
1198: p_stop_time => FND_DATE.CANONICAL_TO_DATE(l_block.stop_time),
1199: p_element_id => l_element);
1200: END IF;
1201: add_transaction_info(l_block.time_building_block_id,l_new_ovn,null,p_transaction_info,p_messages);
1202: p_blocks(p_detail_blocks(l_index)) := l_block;

Line 1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),

1685: -- OTL - ABS Integration
1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN
1687:
1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),
1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));
1691: END IF;
1692:
1693:

Line 1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));

1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN
1687:
1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),
1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));
1691: END IF;
1692:
1693:
1694: