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 72: p_where_clause IN hxt_interface_utilities.max_varchar,

68: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
69: p_session_date IN DATE,
70: p_start_date IN VARCHAR2, --hxc_time_building_blocks.start_time%TYPE,
71: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,
72: p_where_clause IN hxt_interface_utilities.max_varchar,
73: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
74: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
75: p_unique_params IN hxt_interface_utilities.max_varchar,
76: p_incremental IN hxt_interface_utilities.flag_varchar

Line 75: p_unique_params IN hxt_interface_utilities.max_varchar,

71: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,
72: p_where_clause IN hxt_interface_utilities.max_varchar,
73: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
74: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
75: p_unique_params IN hxt_interface_utilities.max_varchar,
76: p_incremental IN hxt_interface_utilities.flag_varchar
77: DEFAULT 'Y', -- We don't allow this anymore so set to Y always
78: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
79: DEFAULT 'N', -- We don't allow this anymore so set to N always

Line 76: p_incremental IN hxt_interface_utilities.flag_varchar

72: p_where_clause IN hxt_interface_utilities.max_varchar,
73: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
74: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
75: p_unique_params IN hxt_interface_utilities.max_varchar,
76: p_incremental IN hxt_interface_utilities.flag_varchar
77: DEFAULT 'Y', -- We don't allow this anymore so set to Y always
78: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
79: DEFAULT 'N', -- We don't allow this anymore so set to N always
80: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar

Line 78: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar

74: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
75: p_unique_params IN hxt_interface_utilities.max_varchar,
76: p_incremental IN hxt_interface_utilities.flag_varchar
77: DEFAULT 'Y', -- We don't allow this anymore so set to Y always
78: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
79: DEFAULT 'N', -- We don't allow this anymore so set to N always
80: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar
81: );
82:

Line 80: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar

76: p_incremental IN hxt_interface_utilities.flag_varchar
77: DEFAULT 'Y', -- We don't allow this anymore so set to Y always
78: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
79: DEFAULT 'N', -- We don't allow this anymore so set to N always
80: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar
81: );
82:
83: PROCEDURE extract_data_from_attr_tbl (
84: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

Line 91: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec

87: p_det_tbb_idx IN PLS_INTEGER,
88: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
89: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
90: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,
91: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec
92: );
93:
94: PROCEDURE bee_batch_line (
95: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

Line 100: p_bee_rec OUT NOCOPY hxt_interface_utilities.bee_rec,

96: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
97: p_det_tbb_idx IN PLS_INTEGER,
98: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
99: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,
100: p_bee_rec OUT NOCOPY hxt_interface_utilities.bee_rec,
101: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
102: p_is_old IN BOOLEAN DEFAULT FALSE
103: );
104:

Line 141: p_bee_rec IN hxt_interface_utilities.bee_rec

137: p_batch_lines IN OUT NOCOPY PLS_INTEGER,
138: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
139: p_session_date IN DATE,
140: p_effective_date IN DATE,
141: p_bee_rec IN hxt_interface_utilities.bee_rec
142: );
143:
144: PROCEDURE transfer_to_hr_payroll (
145: errbuf OUT NOCOPY VARCHAR2,