DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on ARP_BALANCE_CHECK

Line 3956: l_unbal_rcpt_tab ARP_BALANCE_CHECK.unbalanced_receipts;

3952: l_cnt NUMBER;
3953: l_msg_data VARCHAR2(2000);
3954: l_msg_count NUMBER;
3955:
3956: l_unbal_rcpt_tab ARP_BALANCE_CHECK.unbalanced_receipts;
3957:
3958: CURSOR unbal_rec_applns( p_cr_id NUMBER, p_gt_id NUMBER) IS
3959: SELECT ard.source_id, ard.source_id_secondary, trx.upgrade_method,
3960: ra.applied_customer_trx_id, ra.payment_schedule_id, ra.applied_payment_schedule_id

Line 4491: ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK(

4487:
4488: IF l_from_cr_id IS NOT NULL AND l_to_cr_id IS NOT NULL THEN
4489:
4490: arp_standard.debug(' Checking Journal Balance in Bulk: for receipt_create');
4491: ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK(
4492: p_cr_id_low => l_from_cr_id,
4493: p_cr_id_high => l_to_cr_id,
4494: p_unbalanced_cr_tbl => l_unbal_rcpt_tab );
4495:

Line 4835: ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK(

4831:
4832: IF l_from_cr_id IS NOT NULL AND l_to_cr_id IS NOT NULL THEN
4833:
4834: arp_standard.debug('Checking Journal Balance in Bulk: After Application');
4835: ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK(
4836: p_cr_id_low => l_from_cr_id,
4837: p_cr_id_high => l_to_cr_id,
4838: p_unbalanced_cr_tbl => l_unbal_rcpt_tab );
4839:

Line 4847: ARP_BALANCE_CHECK.CHECK_APPLN_BALANCE(

4843: arp_standard.debug('Check Journal Balance for each application for balance failed receipts');
4844: FOR unbal_rec_appln IN unbal_rec_applns(l_unbal_rcpt_tab(i).cash_receipt_id, l_gt_id) LOOP
4845:
4846: BEGIN
4847: ARP_BALANCE_CHECK.CHECK_APPLN_BALANCE(
4848: p_receivable_application_id1 => unbal_rec_appln.source_id_secondary,
4849: p_receivable_application_id2 => unbal_rec_appln.source_id,
4850: p_request_id => pg_request_id,
4851: p_called_from_api => 'Y' );