eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXC_TIME_BUILDING_BLOCKS

Line 733: --hxc_time_building_blocks.start_time%TYPE,

729: PROCEDURE process_otlr_employees (
730: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
731: p_session_date IN DATE, -- Bug 6121705, need date for reversal batch creation
732: p_start_date IN VARCHAR2,
733: --hxc_time_building_blocks.start_time%TYPE,
734: p_end_date IN VARCHAR2,
735: --hxc_time_building_blocks.stop_time%TYPE,
736: p_where_clause IN hxt_interface_utilities.max_varchar,
737: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,

Line 735: --hxc_time_building_blocks.stop_time%TYPE,

731: p_session_date IN DATE, -- Bug 6121705, need date for reversal batch creation
732: p_start_date IN VARCHAR2,
733: --hxc_time_building_blocks.start_time%TYPE,
734: p_end_date IN VARCHAR2,
735: --hxc_time_building_blocks.stop_time%TYPE,
736: p_where_clause IN hxt_interface_utilities.max_varchar,
737: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
738: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
739: p_unique_params IN hxt_interface_utilities.max_varchar,

Line 810: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

806: -- Bug 10323310
807: -- Proj Pay Integration
808: -- Copies down the attribute records from Attribute table to the global table.
809: PROCEDURE record_pay_pa_details ( p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
810: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
811: p_det_tbb_idx IN PLS_INTEGER,
812: p_is_old IN BOOLEAN DEFAULT FALSE )
813: IS
814:

Line 896: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

892:
893: PROCEDURE extract_data_from_attr_tbl (
894: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
895: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
896: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
897: p_det_tbb_idx IN PLS_INTEGER,
898: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
899: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
900: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,

Line 2115: p_start_date IN hxc_time_building_blocks.start_time%TYPE,

2111: END add_lines_to_bee_batch;
2112:
2113: PROCEDURE process_non_otlr_employees (
2114: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
2115: p_start_date IN hxc_time_building_blocks.start_time%TYPE,
2116: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,
2117: p_session_date IN DATE,
2118: p_where_clause IN hxt_interface_utilities.max_varchar,
2119: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,

Line 2116: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,

2112:
2113: PROCEDURE process_non_otlr_employees (
2114: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
2115: p_start_date IN hxc_time_building_blocks.start_time%TYPE,
2116: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,
2117: p_session_date IN DATE,
2118: p_where_clause IN hxt_interface_utilities.max_varchar,
2119: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
2120: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

Line 2389: -- 1. Pull out the bb details from hxc_time_building_blocks table

2385:
2386:
2387: -- Private procedure create_bld_blk_table
2388: -- populates the detail bld blks plsql table like gen. retrieval
2389: -- 1. Pull out the bb details from hxc_time_building_blocks table
2390: -- which has an entry in hxc_bee_pref_adj_lines table, with
2391: -- batch_source as Time Store.
2392: -- 2. Update hxc_bee_pref_adj_lines table with these values for
2393: -- the corresponding bb_ids and ovns.

Line 2416: FROM hxc_time_building_blocks

2412: comment_text,
2413: unit_of_measure,
2414: 'N',
2415: 'N'
2416: FROM hxc_time_building_blocks
2417: WHERE (time_building_block_id,object_version_number)
2418: IN ( SELECT detail_bb_id,
2419: detail_bb_ovn
2420: FROM hxc_bee_pref_adj_lines