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 517: --hxc_time_building_blocks.start_time%TYPE,

513: PROCEDURE process_otlr_employees (
514: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
515: p_session_date IN DATE, -- Bug 6121705, need date for reversal batch creation
516: p_start_date IN VARCHAR2,
517: --hxc_time_building_blocks.start_time%TYPE,
518: p_end_date IN VARCHAR2,
519: --hxc_time_building_blocks.stop_time%TYPE,
520: p_where_clause IN hxt_interface_utilities.max_varchar,
521: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,

Line 519: --hxc_time_building_blocks.stop_time%TYPE,

515: p_session_date IN DATE, -- Bug 6121705, need date for reversal batch creation
516: p_start_date IN VARCHAR2,
517: --hxc_time_building_blocks.start_time%TYPE,
518: p_end_date IN VARCHAR2,
519: --hxc_time_building_blocks.stop_time%TYPE,
520: p_where_clause IN hxt_interface_utilities.max_varchar,
521: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
522: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
523: p_unique_params IN hxt_interface_utilities.max_varchar,

Line 592: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

588:
589: PROCEDURE extract_data_from_attr_tbl (
590: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
591: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
592: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
593: p_det_tbb_idx IN PLS_INTEGER,
594: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
595: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
596: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,

Line 1398: p_start_date IN hxc_time_building_blocks.start_time%TYPE,

1394: END add_lines_to_bee_batch;
1395:
1396: PROCEDURE process_non_otlr_employees (
1397: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
1398: p_start_date IN hxc_time_building_blocks.start_time%TYPE,
1399: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,
1400: p_session_date IN DATE,
1401: p_where_clause IN hxt_interface_utilities.max_varchar,
1402: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,

Line 1399: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,

1395:
1396: PROCEDURE process_non_otlr_employees (
1397: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
1398: p_start_date IN hxc_time_building_blocks.start_time%TYPE,
1399: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,
1400: p_session_date IN DATE,
1401: p_where_clause IN hxt_interface_utilities.max_varchar,
1402: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
1403: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

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

1646:
1647:
1648: -- Private procedure create_bld_blk_table
1649: -- populates the detail bld blks plsql table like gen. retrieval
1650: -- 1. Pull out the bb details from hxc_time_building_blocks table
1651: -- which has an entry in hxc_bee_pref_adj_lines table, with
1652: -- batch_source as Time Store.
1653: -- 2. Update hxc_bee_pref_adj_lines table with these values for
1654: -- the corresponding bb_ids and ovns.

Line 1677: FROM hxc_time_building_blocks

1673: comment_text,
1674: unit_of_measure,
1675: 'N',
1676: 'N'
1677: FROM hxc_time_building_blocks
1678: WHERE (time_building_block_id,object_version_number)
1679: IN ( SELECT detail_bb_id,
1680: detail_bb_ovn
1681: FROM hxc_bee_pref_adj_lines