DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXC_TIME_BUILDING_BLOCKS

Line 112: p_start_date IN VARCHAR2, --hxc_time_building_blocks.start_time%TYPE,

108:
109: PROCEDURE process_otlr_employees (
110: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
111: p_session_date IN DATE,
112: p_start_date IN VARCHAR2, --hxc_time_building_blocks.start_time%TYPE,
113: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,
114: p_where_clause IN hxt_interface_utilities.max_varchar,
115: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
116: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

Line 113: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,

109: PROCEDURE process_otlr_employees (
110: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
111: p_session_date IN DATE,
112: p_start_date IN VARCHAR2, --hxc_time_building_blocks.start_time%TYPE,
113: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,
114: p_where_clause IN hxt_interface_utilities.max_varchar,
115: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
116: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
117: p_unique_params IN hxt_interface_utilities.max_varchar,

Line 128: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

124:
125: PROCEDURE extract_data_from_attr_tbl (
126: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
127: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
128: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
129: p_det_tbb_idx IN PLS_INTEGER,
130: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
131: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
132: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,

Line 294: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

290: -- R12.2 Projects Payroll Integration
291: -- New procedures.
292:
293: PROCEDURE record_pay_pa_details ( p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
294: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
295: p_det_tbb_idx IN PLS_INTEGER,
296: p_is_old IN BOOLEAN DEFAULT FALSE );
297:
298: PROCEDURE cache_preferences ( p_resource_id IN NUMBER,