DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on PAY_BATCH_ELEMENT_ENTRY_API

Line 522: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,

518: l_valid_batch_name := l_batch_name;
519: IF g_debug THEN
520: hr_utility.set_location('Before creating new valid batch header', 30);
521: END IF;
522: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,
523: p_batch_name => l_valid_batch_name,
524: p_business_group_id => p_bus_group_id,
525: p_action_if_exists => 'I',
526: p_batch_reference => l_valid_batch_name||l_string1,

Line 536: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,

532: IF g_debug THEN
533: hr_utility.set_location('After creating new valid batch header: '||l_valid_batch_id, 40);
534: END IF;
535: l_valid_batch_name := l_valid_batch_name||l_string2||to_char(l_valid_batch_id);
536: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,
537: p_batch_id => l_valid_batch_id,
538: p_object_version_number => l_object_version_number,
539: p_batch_name => l_valid_batch_name
540: ); /* For updating the batch_name of the newly created batch */

Line 566: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,

562: l_warning_batch_name := l_batch_name||'_W';
563: IF g_debug THEN
564: hr_utility.set_location('Before creating new warning batch header', 70);
565: END IF;
566: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,
567: p_batch_name => l_warning_batch_name,
568: p_business_group_id => p_bus_group_id,
569: p_action_if_exists => 'I',
570: p_batch_reference => l_warning_batch_name||l_string1,

Line 580: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,

576: IF g_debug THEN
577: hr_utility.set_location('After creating new warning batch header: '||l_warning_batch_id, 80);
578: END IF;
579: l_warning_batch_name := l_warning_batch_name||l_string2||to_char(l_warning_batch_id);
580: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,
581: p_batch_id => l_warning_batch_id,
582: p_object_version_number => l_object_version_number,
583: p_batch_name => l_warning_batch_name
584: ); /* For updating the batch_name of the newly created batch */

Line 611: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,

607: l_error_batch_name := l_batch_name||'_E';
608: IF g_debug THEN
609: hr_utility.set_location('Before creating new error batch header', 110);
610: END IF;
611: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,
612: p_batch_name => l_error_batch_name,
613: p_business_group_id => p_bus_group_id,
614: p_action_if_exists => 'I',
615: p_batch_reference => l_error_batch_name||l_string1,

Line 625: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,

621: IF g_debug THEN
622: hr_utility.set_location('after creating new error batch header: '||l_error_batch_id, 120);
623: END IF;
624: l_error_batch_name := l_error_batch_name||l_string2||to_char(l_error_batch_id);
625: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,
626: p_batch_id => l_error_batch_id,
627: p_object_version_number => l_object_version_number,
628: p_batch_name => l_error_batch_name
629: ); /* For updating the batch_name of the newly created batch */

Line 773: pay_batch_element_entry_api.delete_batch_header (p_batch_id => p_del_empty_batches(l_loop_index2).batch_id,

769: hr_utility.set_location('Before deleting empty batches: '||p_del_empty_batches(l_loop_index2).batch_id||
770: ' ovn: '||p_del_empty_batches(l_loop_index2).batch_ovn, 170);
771: END IF;
772:
773: pay_batch_element_entry_api.delete_batch_header (p_batch_id => p_del_empty_batches(l_loop_index2).batch_id,
774: p_object_version_number => p_del_empty_batches(l_loop_index2).batch_ovn
775: );
776: IF g_debug THEN
777: hr_utility.set_location('After deleting empty batches', 180);

Line 2188: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_line

2184: hr_utility.set_location('dtl_to_BEE',210);
2185: end if;
2186: HXT_UTIL.DEBUG('batch_sequence = '||to_char(p_batch_sequence)); --HXT115
2187: -- Insert data into BEE table
2188: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_line
2189: (p_session_date => sysdate
2190: ,p_batch_id => p_values_rec.batch_id
2191: ,p_batch_line_status => 'U'
2192: ,p_assignment_id => p_values_rec.assignment_id

Line 2787: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line

2783: for l_rec in c_get_batch_lines(p_batch_id)
2784: loop
2785: FND_FILE.put_line(FND_FILE.log,'=> Processing Batch Line id '||l_rec.batch_line_id);
2786: hr_utility.trace('=>Processing Batch Line id '||l_rec.batch_line_id);
2787: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line
2788: (p_batch_line_id => l_rec.batch_line_id
2789: ,p_object_version_number => l_rec.object_version_number
2790: );
2791: end loop;

Line 2824: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line

2820: -- delete the batch lines
2821: for l_line_rec in c_get_batch_lines(l_rec.retro_batch_id) loop
2822: FND_FILE.put_line(FND_FILE.log,'=>------- Retro Line Id: '||l_line_rec.batch_line_id);
2823: hr_utility.trace('=>------- Retro Line Id: '||l_line_rec.batch_line_id);
2824: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line
2825: (p_batch_line_id => l_line_rec.batch_line_id
2826: ,p_object_version_number => l_line_rec.object_version_number
2827: );
2828: end loop;

Line 2833: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_header

2829: -- delete the batch
2830: -- Bug 13388573
2831: -- Will delete the header later.
2832: /*
2833: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_header
2834: (p_batch_id => l_rec.retro_batch_id
2835: ,p_object_version_number => l_rec.object_version_number
2836: );
2837: */

Line 2880: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_header

2876: LOOP
2877: FND_FILE.put_line(FND_FILE.log,'=>--Deleting header for Batch '||l_retro_tab(i).retro_batch_id);
2878: hr_utility.trace('=>--Deleting header for Batch '||l_retro_tab(i).retro_batch_id);
2879:
2880: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_header
2881: (p_batch_id => l_retro_tab(i).retro_batch_id
2882: ,p_object_version_number => l_retro_tab(i).retro_ovn
2883: );
2884: END LOOP;

Line 2918: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_header

2914: SELECT business_group_id, batch_name, batch_reference
2915: INTO l_business_group_id, l_batch_name, l_batch_reference
2916: FROM pay_batch_headers
2917: WHERE batch_id = p_batch_id;
2918: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_header
2919: (p_session_date => sysdate
2920: ,p_batch_name => l_batch_name
2921: ,p_batch_status => 'U'
2922: ,p_business_group_id => l_business_group_id

Line 2950: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line

2946: SET tim.batch_id = l_new_batch
2947: WHERE tim.batch_id = p_batch_id
2948: AND tim.id = l_tim_id;
2949: -- Delete actual PayMIX batch lines
2950: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line
2951: (p_batch_line_id => batch_line_rec.batch_line_id
2952: ,p_object_version_number => batch_line_rec.object_version_number
2953: );
2954: END LOOP;

Line 2964: pay_batch_element_entry_api.delete_batch_header (

2960: -- no batch lines found. So we can delete this batch
2961: OPEN c_get_batch_ovn (p_batch_id);
2962: FETCH c_get_batch_ovn INTO l_batch_ovn;
2963: CLOSE c_get_batch_ovn;
2964: pay_batch_element_entry_api.delete_batch_header (
2965: p_batch_id => p_batch_id,
2966: p_object_version_number => l_batch_ovn
2967: );
2968: END IF;