APPS.HXC_ALIAS_TRANSLATOR dependencies on HR_GENERAL

Line 475: l_tbb_end_date := HR_GENERAL.END_OF_TIME;

471:
472: --dbms_output.put_line('l_index_string '||l_index_string);
473:
474: l_tbb_start_date := SYSDATE;
475: l_tbb_end_date := HR_GENERAL.END_OF_TIME;
476: --dbms_output.put_line('l_time_building_block_id '||l_time_building_block_id);
477:
478: IF (p_tbb_date_reference_table.exists(l_time_building_block_id)) THEN
479: l_tbb_start_date := p_tbb_date_reference_table(l_time_building_block_id).START_TIME;

Line 966: ,p_stop_time IN DATE DEFAULT hr_general.end_of_time

962: PROCEDURE do_retrieval_translation
963: (p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE--hxc_self_service_time_deposit.building_block_attribute_info
964: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE--hxc_self_service_time_deposit.timecard_info
965: ,p_start_time IN DATE DEFAULT sysdate
966: ,p_stop_time IN DATE DEFAULT hr_general.end_of_time
967: ,p_resource_id IN NUMBER -- timekeeper or resource
968: ,p_processing_mode IN VARCHAR2 DEFAULT hxc_alias_utility.c_ss_processing
969: ,p_add_alias_display_value IN BOOLEAN DEFAULT FALSE
970: ,p_add_alias_ref_object IN BOOLEAN DEFAULT FALSE

Line 983: and nvl(date_to,hr_general.end_of_time) >= p_start_time;

979: from hxc_alias_values
980: where alias_definition_id = p_alias_definition_id
981: and enabled_flag = 'Y'
982: and date_from <= p_stop_time
983: and nvl(date_to,hr_general.end_of_time) >= p_start_time;
984:
985: -- index for pl/sql table
986: l_index_alias_def NUMBER;
987: --l_time_building_block_id NUMBER;