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 HXT_INTERFACE_UTILITIES

Line 114: p_where_clause IN hxt_interface_utilities.max_varchar,

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,
118: p_incremental IN hxt_interface_utilities.flag_varchar

Line 117: p_unique_params IN hxt_interface_utilities.max_varchar,

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,
118: p_incremental IN hxt_interface_utilities.flag_varchar
119: DEFAULT 'Y', -- We don't allow this anymore so set to Y always
120: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
121: DEFAULT 'N', -- We don't allow this anymore so set to N always

Line 118: p_incremental IN hxt_interface_utilities.flag_varchar

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,
118: p_incremental IN hxt_interface_utilities.flag_varchar
119: DEFAULT 'Y', -- We don't allow this anymore so set to Y always
120: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
121: DEFAULT 'N', -- We don't allow this anymore so set to N always
122: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar

Line 120: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar

116: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
117: p_unique_params IN hxt_interface_utilities.max_varchar,
118: p_incremental IN hxt_interface_utilities.flag_varchar
119: DEFAULT 'Y', -- We don't allow this anymore so set to Y always
120: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
121: DEFAULT 'N', -- We don't allow this anymore so set to N always
122: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar
123: );
124:

Line 122: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar

118: p_incremental IN hxt_interface_utilities.flag_varchar
119: DEFAULT 'Y', -- We don't allow this anymore so set to Y always
120: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
121: DEFAULT 'N', -- We don't allow this anymore so set to N always
122: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar
123: );
124:
125: PROCEDURE extract_data_from_attr_tbl (
126: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

Line 133: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec,

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,
133: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec,
134: p_is_old IN BOOLEAN DEFAULT FALSE
135: );
136:
137: PROCEDURE bee_batch_line (

Line 143: p_bee_rec OUT NOCOPY hxt_interface_utilities.bee_rec,

139: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
140: p_det_tbb_idx IN PLS_INTEGER,
141: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
142: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,
143: p_bee_rec OUT NOCOPY hxt_interface_utilities.bee_rec,
144: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
145: p_is_old IN BOOLEAN DEFAULT FALSE
146: );
147:

Line 186: p_bee_rec IN hxt_interface_utilities.bee_rec,

182: p_batch_lines IN OUT NOCOPY PLS_INTEGER,
183: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
184: p_session_date IN DATE,
185: p_effective_date IN DATE,
186: p_bee_rec IN hxt_interface_utilities.bee_rec,
187: p_is_retro IN BOOLEAN DEFAULT FALSE
188: );
189:
190: PROCEDURE transfer_to_hr_payroll (