DBA Data[Home] [Help]

APPS.HXT_INTERFACE_UTILITIES dependencies on PAY_BATCH_HEADERS

Line 22: batch_ref pay_batch_headers.batch_reference%TYPE,

18: asg_system_status per_assignment_status_types.per_system_status%TYPE
19: );
20:
21: TYPE batch_info_rec IS RECORD (
22: batch_ref pay_batch_headers.batch_reference%TYPE,
23: request_id fnd_concurrent_requests.request_id%TYPE,
24: business_group_id pay_batch_headers.business_group_id%TYPE,
25: free_batch_suffix NUMBER
26: );

Line 24: business_group_id pay_batch_headers.business_group_id%TYPE,

20:
21: TYPE batch_info_rec IS RECORD (
22: batch_ref pay_batch_headers.batch_reference%TYPE,
23: request_id fnd_concurrent_requests.request_id%TYPE,
24: business_group_id pay_batch_headers.business_group_id%TYPE,
25: free_batch_suffix NUMBER
26: );
27:
28: TYPE asg_type_table IS TABLE OF asg_type_rec

Line 111: g_batch_status_transferred CONSTANT pay_batch_headers.batch_status%TYPE

107: g_hxc_app_id CONSTANT fnd_application.application_id%TYPE
108: := 809;
109: g_cost_flex_code CONSTANT fnd_id_flex_segments.id_flex_code%TYPE
110: := 'COST';
111: g_batch_status_transferred CONSTANT pay_batch_headers.batch_status%TYPE
112: := 'T';
113: g_asg_type_employed CONSTANT per_all_assignments_f.assignment_type%TYPE
114: := 'E';
115: g_element_attribute CONSTANT hxc_mapping_components.field_name%TYPE

Line 176: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

172: FUNCTION conc_request_id_suffix (p_from_last IN PLS_INTEGER DEFAULT 4)
173: RETURN NUMBER;
174:
175: FUNCTION batch_name (
176: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
177: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
178: p_invalid_batch_status IN pay_batch_headers.batch_status%TYPE
179: DEFAULT NULL
180: )

Line 177: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

173: RETURN NUMBER;
174:
175: FUNCTION batch_name (
176: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
177: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
178: p_invalid_batch_status IN pay_batch_headers.batch_status%TYPE
179: DEFAULT NULL
180: )
181: RETURN pay_batch_headers.batch_name%TYPE;

Line 178: p_invalid_batch_status IN pay_batch_headers.batch_status%TYPE

174:
175: FUNCTION batch_name (
176: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
177: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
178: p_invalid_batch_status IN pay_batch_headers.batch_status%TYPE
179: DEFAULT NULL
180: )
181: RETURN pay_batch_headers.batch_name%TYPE;
182:

Line 181: RETURN pay_batch_headers.batch_name%TYPE;

177: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
178: p_invalid_batch_status IN pay_batch_headers.batch_status%TYPE
179: DEFAULT NULL
180: )
181: RETURN pay_batch_headers.batch_name%TYPE;
182:
183: FUNCTION max_batch_id (
184: p_batch_name IN pay_batch_headers.batch_name%TYPE,
185: p_bg_id IN pay_batch_headers.business_group_id%TYPE

Line 184: p_batch_name IN pay_batch_headers.batch_name%TYPE,

180: )
181: RETURN pay_batch_headers.batch_name%TYPE;
182:
183: FUNCTION max_batch_id (
184: p_batch_name IN pay_batch_headers.batch_name%TYPE,
185: p_bg_id IN pay_batch_headers.business_group_id%TYPE
186: )
187: RETURN pay_batch_headers.batch_id%TYPE;
188:

Line 185: p_bg_id IN pay_batch_headers.business_group_id%TYPE

181: RETURN pay_batch_headers.batch_name%TYPE;
182:
183: FUNCTION max_batch_id (
184: p_batch_name IN pay_batch_headers.batch_name%TYPE,
185: p_bg_id IN pay_batch_headers.business_group_id%TYPE
186: )
187: RETURN pay_batch_headers.batch_id%TYPE;
188:
189: FUNCTION count_batch_lines (p_batch_id IN pay_batch_headers.batch_id%TYPE)

Line 187: RETURN pay_batch_headers.batch_id%TYPE;

183: FUNCTION max_batch_id (
184: p_batch_name IN pay_batch_headers.batch_name%TYPE,
185: p_bg_id IN pay_batch_headers.business_group_id%TYPE
186: )
187: RETURN pay_batch_headers.batch_id%TYPE;
188:
189: FUNCTION count_batch_lines (p_batch_id IN pay_batch_headers.batch_id%TYPE)
190: RETURN NUMBER;
191:

Line 189: FUNCTION count_batch_lines (p_batch_id IN pay_batch_headers.batch_id%TYPE)

185: p_bg_id IN pay_batch_headers.business_group_id%TYPE
186: )
187: RETURN pay_batch_headers.batch_id%TYPE;
188:
189: FUNCTION count_batch_lines (p_batch_id IN pay_batch_headers.batch_id%TYPE)
190: RETURN NUMBER;
191:
192: FUNCTION count_batch_lines (
193: p_batch_name IN pay_batch_headers.batch_name%TYPE,

Line 193: p_batch_name IN pay_batch_headers.batch_name%TYPE,

189: FUNCTION count_batch_lines (p_batch_id IN pay_batch_headers.batch_id%TYPE)
190: RETURN NUMBER;
191:
192: FUNCTION count_batch_lines (
193: p_batch_name IN pay_batch_headers.batch_name%TYPE,
194: p_bg_id IN pay_batch_headers.business_group_id%TYPE
195: )
196: RETURN NUMBER;
197:

Line 194: p_bg_id IN pay_batch_headers.business_group_id%TYPE

190: RETURN NUMBER;
191:
192: FUNCTION count_batch_lines (
193: p_batch_name IN pay_batch_headers.batch_name%TYPE,
194: p_bg_id IN pay_batch_headers.business_group_id%TYPE
195: )
196: RETURN NUMBER;
197:
198: FUNCTION total_batch_lines (

Line 199: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

195: )
196: RETURN NUMBER;
197:
198: FUNCTION total_batch_lines (
199: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
200: p_bg_id IN pay_batch_headers.business_group_id%TYPE
201: )
202: RETURN NUMBER;
203:

Line 200: p_bg_id IN pay_batch_headers.business_group_id%TYPE

196: RETURN NUMBER;
197:
198: FUNCTION total_batch_lines (
199: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
200: p_bg_id IN pay_batch_headers.business_group_id%TYPE
201: )
202: RETURN NUMBER;
203:
204: PROCEDURE max_lines_exceeded (

Line 205: p_batch_id IN pay_batch_headers.batch_reference%TYPE,

201: )
202: RETURN NUMBER;
203:
204: PROCEDURE max_lines_exceeded (
205: p_batch_id IN pay_batch_headers.batch_reference%TYPE,
206: p_number_lines IN OUT NOCOPY PLS_INTEGER,
207: p_max_lines_exceeded OUT NOCOPY BOOLEAN
208: );
209:

Line 211: p_batch_id IN pay_batch_headers.batch_reference%TYPE

207: p_max_lines_exceeded OUT NOCOPY BOOLEAN
208: );
209:
210: FUNCTION max_lines_exceeded (
211: p_batch_id IN pay_batch_headers.batch_reference%TYPE
212: )
213: RETURN BOOLEAN;
214:
215: FUNCTION max_lines_exceeded (

Line 216: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

212: )
213: RETURN BOOLEAN;
214:
215: FUNCTION max_lines_exceeded (
216: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
217: p_bg_id IN pay_batch_headers.business_group_id%TYPE
218: )
219: RETURN BOOLEAN;
220:

Line 217: p_bg_id IN pay_batch_headers.business_group_id%TYPE

213: RETURN BOOLEAN;
214:
215: FUNCTION max_lines_exceeded (
216: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
217: p_bg_id IN pay_batch_headers.business_group_id%TYPE
218: )
219: RETURN BOOLEAN;
220:
221: FUNCTION isnumber (p_value VARCHAR2)

Line 419: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

415: )
416: RETURN pay_element_types_f.element_type_id%TYPE;
417:
418: PROCEDURE find_other_in_attr_tbl (
419: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
420: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
421: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
422: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
423: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,

Line 524: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

520: FUNCTION purge_pipe
521: RETURN BOOLEAN;
522: */
523: FUNCTION free_batch_suffix (
524: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
525: p_bg_id IN pay_batch_headers.business_group_id%TYPE
526: )
527: RETURN NUMBER;
528:

Line 525: p_bg_id IN pay_batch_headers.business_group_id%TYPE

521: RETURN BOOLEAN;
522: */
523: FUNCTION free_batch_suffix (
524: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
525: p_bg_id IN pay_batch_headers.business_group_id%TYPE
526: )
527: RETURN NUMBER;
528:
529: /* FUNCTION total_lines (

Line 530: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

526: )
527: RETURN NUMBER;
528:
529: /* FUNCTION total_lines (
530: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
531: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
532: p_incremental_value IN PLS_INTEGER DEFAULT 0
533: )
534: RETURN NUMBER;

Line 531: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

527: RETURN NUMBER;
528:
529: /* FUNCTION total_lines (
530: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
531: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
532: p_incremental_value IN PLS_INTEGER DEFAULT 0
533: )
534: RETURN NUMBER;
535:

Line 537: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

533: )
534: RETURN NUMBER;
535:
536: FUNCTION is_full (
537: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
538: p_bg_id IN pay_batch_headers.business_group_id%TYPE
539: )
540: RETURN BOOLEAN; */
541: FUNCTION is_changed (

Line 538: p_bg_id IN pay_batch_headers.business_group_id%TYPE

534: RETURN NUMBER;
535:
536: FUNCTION is_full (
537: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
538: p_bg_id IN pay_batch_headers.business_group_id%TYPE
539: )
540: RETURN BOOLEAN; */
541: FUNCTION is_changed (
542: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks