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: TYPE batches_type_table IS TABLE OF batches_type_rec

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: TYPE batches_type_table IS TABLE OF batches_type_rec
19: INDEX BY BINARY_INTEGER;

Line 24: g_insert_if_exist CONSTANT pay_batch_headers.action_if_exists%TYPE

20:
21: g_inclusive CONSTANT VARCHAR2 (2) := 'IN';
22: g_bee_retrieval_process CONSTANT hxc_retrieval_processes.NAME%TYPE
23: := 'BEE Retrieval Process';
24: g_insert_if_exist CONSTANT pay_batch_headers.action_if_exists%TYPE
25: := 'I';
26: g_time_store_batch_source CONSTANT pay_batch_headers.batch_source%TYPE
27: := 'Time Store';
28: g_max_message_size CONSTANT PLS_INTEGER := 2000;

Line 26: g_time_store_batch_source CONSTANT pay_batch_headers.batch_source%TYPE

22: g_bee_retrieval_process CONSTANT hxc_retrieval_processes.NAME%TYPE
23: := 'BEE Retrieval Process';
24: g_insert_if_exist CONSTANT pay_batch_headers.action_if_exists%TYPE
25: := 'I';
26: g_time_store_batch_source CONSTANT pay_batch_headers.batch_source%TYPE
27: := 'Time Store';
28: g_max_message_size CONSTANT PLS_INTEGER := 2000;
29: g_trx_success CONSTANT hxc_transactions.status%TYPE
30: := 'SUCCESS';

Line 48: p_batch_id IN pay_batch_headers.batch_id%TYPE,

44:
45: PROCEDURE record_batch_info (p_batch_rec IN batches_type_rec);
46:
47: PROCEDURE record_batch_info (
48: p_batch_id IN pay_batch_headers.batch_id%TYPE,
49: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
50: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
51: p_batch_name IN pay_batch_headers.batch_name%TYPE
52: );

Line 49: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,

45: PROCEDURE record_batch_info (p_batch_rec IN batches_type_rec);
46:
47: PROCEDURE record_batch_info (
48: p_batch_id IN pay_batch_headers.batch_id%TYPE,
49: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
50: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
51: p_batch_name IN pay_batch_headers.batch_name%TYPE
52: );
53:

Line 50: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

46:
47: PROCEDURE record_batch_info (
48: p_batch_id IN pay_batch_headers.batch_id%TYPE,
49: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
50: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
51: p_batch_name IN pay_batch_headers.batch_name%TYPE
52: );
53:
54: FUNCTION batches_created

Line 51: p_batch_name IN pay_batch_headers.batch_name%TYPE

47: PROCEDURE record_batch_info (
48: p_batch_id IN pay_batch_headers.batch_id%TYPE,
49: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
50: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
51: p_batch_name IN pay_batch_headers.batch_name%TYPE
52: );
53:
54: FUNCTION batches_created
55: RETURN batches_type_table;

Line 74: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

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

Line 95: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

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

Line 106: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

102: p_is_old IN BOOLEAN DEFAULT FALSE
103: );
104:
105: FUNCTION batch_name (
106: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
107: p_bg_id IN pay_batch_headers.business_group_id%TYPE
108: )
109: RETURN pay_batch_headers.batch_name%TYPE;
110:

Line 107: p_bg_id IN pay_batch_headers.business_group_id%TYPE

103: );
104:
105: FUNCTION batch_name (
106: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
107: p_bg_id IN pay_batch_headers.business_group_id%TYPE
108: )
109: RETURN pay_batch_headers.batch_name%TYPE;
110:
111: FUNCTION create_batch_header (

Line 109: RETURN pay_batch_headers.batch_name%TYPE;

105: FUNCTION batch_name (
106: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
107: p_bg_id IN pay_batch_headers.business_group_id%TYPE
108: )
109: RETURN pay_batch_headers.batch_name%TYPE;
110:
111: FUNCTION create_batch_header (
112: p_batch_name IN pay_batch_headers.batch_name%TYPE,
113: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

Line 112: p_batch_name IN pay_batch_headers.batch_name%TYPE,

108: )
109: RETURN pay_batch_headers.batch_name%TYPE;
110:
111: FUNCTION create_batch_header (
112: p_batch_name IN pay_batch_headers.batch_name%TYPE,
113: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
114: p_batch_source IN pay_batch_headers.batch_source%TYPE
115: DEFAULT g_time_store_batch_source,
116: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

Line 113: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

109: RETURN pay_batch_headers.batch_name%TYPE;
110:
111: FUNCTION create_batch_header (
112: p_batch_name IN pay_batch_headers.batch_name%TYPE,
113: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
114: p_batch_source IN pay_batch_headers.batch_source%TYPE
115: DEFAULT g_time_store_batch_source,
116: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
117: p_session_date IN DATE,

Line 114: p_batch_source IN pay_batch_headers.batch_source%TYPE

110:
111: FUNCTION create_batch_header (
112: p_batch_name IN pay_batch_headers.batch_name%TYPE,
113: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
114: p_batch_source IN pay_batch_headers.batch_source%TYPE
115: DEFAULT g_time_store_batch_source,
116: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
117: p_session_date IN DATE,
118: p_det_tbb_idx IN PLS_INTEGER

Line 116: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

112: p_batch_name IN pay_batch_headers.batch_name%TYPE,
113: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
114: p_batch_source IN pay_batch_headers.batch_source%TYPE
115: DEFAULT g_time_store_batch_source,
116: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
117: p_session_date IN DATE,
118: p_det_tbb_idx IN PLS_INTEGER
119: )
120: RETURN pay_batch_headers.batch_id%TYPE;

Line 120: RETURN pay_batch_headers.batch_id%TYPE;

116: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
117: p_session_date IN DATE,
118: p_det_tbb_idx IN PLS_INTEGER
119: )
120: RETURN pay_batch_headers.batch_id%TYPE;
121:
122: FUNCTION create_batch_header (
123: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
124: p_batch_source IN pay_batch_headers.batch_source%TYPE

Line 123: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

119: )
120: RETURN pay_batch_headers.batch_id%TYPE;
121:
122: FUNCTION create_batch_header (
123: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
124: p_batch_source IN pay_batch_headers.batch_source%TYPE
125: DEFAULT g_time_store_batch_source,
126: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
127: p_session_date IN DATE,

Line 124: p_batch_source IN pay_batch_headers.batch_source%TYPE

120: RETURN pay_batch_headers.batch_id%TYPE;
121:
122: FUNCTION create_batch_header (
123: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
124: p_batch_source IN pay_batch_headers.batch_source%TYPE
125: DEFAULT g_time_store_batch_source,
126: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
127: p_session_date IN DATE,
128: p_det_tbb_idx IN PLS_INTEGER

Line 126: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

122: FUNCTION create_batch_header (
123: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
124: p_batch_source IN pay_batch_headers.batch_source%TYPE
125: DEFAULT g_time_store_batch_source,
126: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
127: p_session_date IN DATE,
128: p_det_tbb_idx IN PLS_INTEGER
129: )
130: RETURN pay_batch_headers.batch_id%TYPE;

Line 130: RETURN pay_batch_headers.batch_id%TYPE;

126: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
127: p_session_date IN DATE,
128: p_det_tbb_idx IN PLS_INTEGER
129: )
130: RETURN pay_batch_headers.batch_id%TYPE;
131:
132: PROCEDURE add_to_batch (
133: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
134: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,

Line 133: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

129: )
130: RETURN pay_batch_headers.batch_id%TYPE;
131:
132: PROCEDURE add_to_batch (
133: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
134: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
135: p_det_tbb_idx IN PLS_INTEGER,
136: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
137: p_batch_lines IN OUT NOCOPY PLS_INTEGER,

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

130: RETURN pay_batch_headers.batch_id%TYPE;
131:
132: PROCEDURE add_to_batch (
133: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
134: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
135: p_det_tbb_idx IN PLS_INTEGER,
136: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
137: p_batch_lines IN OUT NOCOPY PLS_INTEGER,
138: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

Line 138: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

134: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
135: p_det_tbb_idx IN PLS_INTEGER,
136: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
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: );