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 PAY_BATCH_HEADERS

Line 12: batch_id pay_batch_headers.batch_id%TYPE,

8:
9: SUBTYPE package_name IS VARCHAR2 (32);
10:
11: TYPE batches_type_rec IS RECORD (
12: batch_id pay_batch_headers.batch_id%TYPE,
13: business_group_id pay_batch_headers.business_group_id%TYPE,
14: batch_reference pay_batch_headers.batch_reference%TYPE,
15: batch_name pay_batch_headers.batch_name%TYPE
16: );

Line 13: business_group_id pay_batch_headers.business_group_id%TYPE,

9: SUBTYPE package_name IS VARCHAR2 (32);
10:
11: TYPE batches_type_rec IS RECORD (
12: batch_id pay_batch_headers.batch_id%TYPE,
13: business_group_id pay_batch_headers.business_group_id%TYPE,
14: batch_reference pay_batch_headers.batch_reference%TYPE,
15: batch_name pay_batch_headers.batch_name%TYPE
16: );
17:

Line 14: batch_reference pay_batch_headers.batch_reference%TYPE,

10:
11: TYPE batches_type_rec IS RECORD (
12: batch_id pay_batch_headers.batch_id%TYPE,
13: business_group_id pay_batch_headers.business_group_id%TYPE,
14: batch_reference pay_batch_headers.batch_reference%TYPE,
15: batch_name pay_batch_headers.batch_name%TYPE
16: );
17:
18: -- Bug 12919783

Line 15: batch_name pay_batch_headers.batch_name%TYPE

11: TYPE batches_type_rec IS RECORD (
12: batch_id pay_batch_headers.batch_id%TYPE,
13: business_group_id pay_batch_headers.business_group_id%TYPE,
14: batch_reference pay_batch_headers.batch_reference%TYPE,
15: batch_name pay_batch_headers.batch_name%TYPE
16: );
17:
18: -- Bug 12919783
19: TYPE NUMTABLE IS TABLE OF NUMBER INDEX BY VARCHAR2(15);

Line 66: g_insert_if_exist CONSTANT pay_batch_headers.action_if_exists%TYPE

62:
63: g_inclusive CONSTANT VARCHAR2 (2) := 'IN';
64: g_bee_retrieval_process CONSTANT hxc_retrieval_processes.NAME%TYPE
65: := 'BEE Retrieval Process';
66: g_insert_if_exist CONSTANT pay_batch_headers.action_if_exists%TYPE
67: := 'I';
68: g_time_store_batch_source CONSTANT pay_batch_headers.batch_source%TYPE
69: := 'Time Store';
70: g_max_message_size CONSTANT PLS_INTEGER := 2000;

Line 68: g_time_store_batch_source CONSTANT pay_batch_headers.batch_source%TYPE

64: g_bee_retrieval_process CONSTANT hxc_retrieval_processes.NAME%TYPE
65: := 'BEE Retrieval Process';
66: g_insert_if_exist CONSTANT pay_batch_headers.action_if_exists%TYPE
67: := 'I';
68: g_time_store_batch_source CONSTANT pay_batch_headers.batch_source%TYPE
69: := 'Time Store';
70: g_max_message_size CONSTANT PLS_INTEGER := 2000;
71: g_trx_success CONSTANT hxc_transactions.status%TYPE
72: := 'SUCCESS';

Line 90: p_batch_id IN pay_batch_headers.batch_id%TYPE,

86:
87: PROCEDURE record_batch_info (p_batch_rec IN batches_type_rec);
88:
89: PROCEDURE record_batch_info (
90: p_batch_id IN pay_batch_headers.batch_id%TYPE,
91: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
92: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
93: p_batch_name IN pay_batch_headers.batch_name%TYPE
94: );

Line 91: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,

87: PROCEDURE record_batch_info (p_batch_rec IN batches_type_rec);
88:
89: PROCEDURE record_batch_info (
90: p_batch_id IN pay_batch_headers.batch_id%TYPE,
91: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
92: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
93: p_batch_name IN pay_batch_headers.batch_name%TYPE
94: );
95:

Line 92: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

88:
89: PROCEDURE record_batch_info (
90: p_batch_id IN pay_batch_headers.batch_id%TYPE,
91: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
92: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
93: p_batch_name IN pay_batch_headers.batch_name%TYPE
94: );
95:
96: FUNCTION batches_created

Line 93: p_batch_name IN pay_batch_headers.batch_name%TYPE

89: PROCEDURE record_batch_info (
90: p_batch_id IN pay_batch_headers.batch_id%TYPE,
91: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
92: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
93: p_batch_name IN pay_batch_headers.batch_name%TYPE
94: );
95:
96: FUNCTION batches_created
97: RETURN batches_type_table;

Line 116: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

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
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

Line 138: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

134: p_is_old IN BOOLEAN DEFAULT FALSE
135: );
136:
137: PROCEDURE bee_batch_line (
138: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
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,

Line 149: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

145: p_is_old IN BOOLEAN DEFAULT FALSE
146: );
147:
148: FUNCTION batch_name (
149: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
150: p_bg_id IN pay_batch_headers.business_group_id%TYPE
151: )
152: RETURN pay_batch_headers.batch_name%TYPE;
153:

Line 150: p_bg_id IN pay_batch_headers.business_group_id%TYPE

146: );
147:
148: FUNCTION batch_name (
149: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
150: p_bg_id IN pay_batch_headers.business_group_id%TYPE
151: )
152: RETURN pay_batch_headers.batch_name%TYPE;
153:
154: FUNCTION create_batch_header (

Line 152: RETURN pay_batch_headers.batch_name%TYPE;

148: FUNCTION batch_name (
149: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
150: p_bg_id IN pay_batch_headers.business_group_id%TYPE
151: )
152: RETURN pay_batch_headers.batch_name%TYPE;
153:
154: FUNCTION create_batch_header (
155: p_batch_name IN pay_batch_headers.batch_name%TYPE,
156: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

Line 155: p_batch_name IN pay_batch_headers.batch_name%TYPE,

151: )
152: RETURN pay_batch_headers.batch_name%TYPE;
153:
154: FUNCTION create_batch_header (
155: p_batch_name IN pay_batch_headers.batch_name%TYPE,
156: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
157: p_batch_source IN pay_batch_headers.batch_source%TYPE
158: DEFAULT g_time_store_batch_source,
159: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

Line 156: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

152: RETURN pay_batch_headers.batch_name%TYPE;
153:
154: FUNCTION create_batch_header (
155: p_batch_name IN pay_batch_headers.batch_name%TYPE,
156: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
157: p_batch_source IN pay_batch_headers.batch_source%TYPE
158: DEFAULT g_time_store_batch_source,
159: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
160: p_session_date IN DATE,

Line 157: p_batch_source IN pay_batch_headers.batch_source%TYPE

153:
154: FUNCTION create_batch_header (
155: p_batch_name IN pay_batch_headers.batch_name%TYPE,
156: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
157: p_batch_source IN pay_batch_headers.batch_source%TYPE
158: DEFAULT g_time_store_batch_source,
159: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
160: p_session_date IN DATE,
161: p_det_tbb_idx IN PLS_INTEGER

Line 159: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

155: p_batch_name IN pay_batch_headers.batch_name%TYPE,
156: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
157: p_batch_source IN pay_batch_headers.batch_source%TYPE
158: DEFAULT g_time_store_batch_source,
159: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
160: p_session_date IN DATE,
161: p_det_tbb_idx IN PLS_INTEGER
162: )
163: RETURN pay_batch_headers.batch_id%TYPE;

Line 163: RETURN pay_batch_headers.batch_id%TYPE;

159: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
160: p_session_date IN DATE,
161: p_det_tbb_idx IN PLS_INTEGER
162: )
163: RETURN pay_batch_headers.batch_id%TYPE;
164:
165: FUNCTION create_batch_header (
166: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
167: p_batch_source IN pay_batch_headers.batch_source%TYPE

Line 166: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

162: )
163: RETURN pay_batch_headers.batch_id%TYPE;
164:
165: FUNCTION create_batch_header (
166: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
167: p_batch_source IN pay_batch_headers.batch_source%TYPE
168: DEFAULT g_time_store_batch_source,
169: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
170: p_session_date IN DATE,

Line 167: p_batch_source IN pay_batch_headers.batch_source%TYPE

163: RETURN pay_batch_headers.batch_id%TYPE;
164:
165: FUNCTION create_batch_header (
166: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
167: p_batch_source IN pay_batch_headers.batch_source%TYPE
168: DEFAULT g_time_store_batch_source,
169: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
170: p_session_date IN DATE,
171: p_det_tbb_idx IN PLS_INTEGER

Line 169: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

165: FUNCTION create_batch_header (
166: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
167: p_batch_source IN pay_batch_headers.batch_source%TYPE
168: DEFAULT g_time_store_batch_source,
169: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
170: p_session_date IN DATE,
171: p_det_tbb_idx IN PLS_INTEGER
172: )
173: RETURN pay_batch_headers.batch_id%TYPE;

Line 173: RETURN pay_batch_headers.batch_id%TYPE;

169: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
170: p_session_date IN DATE,
171: p_det_tbb_idx IN PLS_INTEGER
172: )
173: RETURN pay_batch_headers.batch_id%TYPE;
174:
175: -- Bug 9494444
176: -- Added new parameter for marking retro lines.
177: PROCEDURE add_to_batch (

Line 178: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

174:
175: -- Bug 9494444
176: -- Added new parameter for marking retro lines.
177: PROCEDURE add_to_batch (
178: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
179: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
180: p_det_tbb_idx IN PLS_INTEGER,
181: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
182: p_batch_lines IN OUT NOCOPY PLS_INTEGER,

Line 179: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,

175: -- Bug 9494444
176: -- Added new parameter for marking retro lines.
177: PROCEDURE add_to_batch (
178: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
179: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
180: p_det_tbb_idx IN PLS_INTEGER,
181: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
182: p_batch_lines IN OUT NOCOPY PLS_INTEGER,
183: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

Line 183: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

179: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
180: p_det_tbb_idx IN PLS_INTEGER,
181: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
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