DBA Data[Home] [Help]

APPS.ARP_PROCESS_BOE dependencies on AR_BATCHES

Line 30: PROCEDURE Val_Create_Auto_Batch_Submit(p_batch_id ar_batches.batch_id%TYPE);

26: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
27: p_customer_bank_account_id IN
28: ra_customer_trx.customer_bank_account_id%TYPE );
29:
30: PROCEDURE Val_Create_Auto_Batch_Submit(p_batch_id ar_batches.batch_id%TYPE);
31:
32: /* ---------------------- Public functions -------------------------------- */
33:
34: /*===========================================================================+

Line 119: l_batch_rec ar_batches%ROWTYPE;

115: --
116: l_cr_rec ar_cash_receipts%ROWTYPE;
117: l_ps_rec ar_payment_schedules%ROWTYPE;
118: l_crh_rec ar_cash_receipt_history%ROWTYPE;
119: l_batch_rec ar_batches%ROWTYPE;
120: --
121: l_approve_flag VARCHAR2(1) DEFAULT 'N';
122: l_format_flag VARCHAR2(1) DEFAULT 'N';
123: --

Line 220: from ar_batches

216: IF l_batch_id IS NULL OR l_batch_id <> p_batch_id THEN
217:
218: select nvl(control_amount,0), nvl(control_count,0)
219: into l_actual_amount_total,l_actual_count_total
220: from ar_batches
221: where batch_id = p_batch_id;
222:
223: l_batch_id := p_batch_id;
224:

Line 332: p_batch_id IN ar_batches.batch_id%TYPE,

328: --
329: PROCEDURE create_remit_batch_conc_req( p_create_flag IN VARCHAR2,
330: p_approve_flag IN VARCHAR2,
331: p_format_flag IN VARCHAR2,
332: p_batch_id IN ar_batches.batch_id%TYPE,
333: p_due_date_low IN ar_payment_schedules.due_date%TYPE,
334: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
335: p_receipt_date_low IN ar_cash_receipts.receipt_date%TYPE,
336: p_receipt_date_high IN ar_cash_receipts.receipt_date%TYPE,

Line 356: l_bat_rec ar_batches%ROWTYPE;

352: p_batch_applied_status OUT NOCOPY VARCHAR2,
353: p_module_name IN VARCHAR2,
354: p_module_version IN VARCHAR2 ) IS
355: l_request_id NUMBER;
356: l_bat_rec ar_batches%ROWTYPE;
357: l_org_id NUMBER;
358: BEGIN
359: --
360: IF PG_DEBUG in ('Y', 'C') THEN

Line 500: p_batch_id IN ar_batches.batch_id%TYPE,

496: --
497: --
498: PROCEDURE app_fmt_remit_batch_conc_req( p_approve_flag IN VARCHAR2,
499: p_format_flag IN VARCHAR2,
500: p_batch_id IN ar_batches.batch_id%TYPE,
501: p_request_id OUT NOCOPY NUMBER,
502: p_batch_applied_status OUT NOCOPY VARCHAR2,
503: p_module_name IN VARCHAR2,
504: p_module_version IN VARCHAR2 ) IS

Line 506: l_bat_rec ar_batches%ROWTYPE;

502: p_batch_applied_status OUT NOCOPY VARCHAR2,
503: p_module_name IN VARCHAR2,
504: p_module_version IN VARCHAR2 ) IS
505: l_request_id NUMBER;
506: l_bat_rec ar_batches%ROWTYPE;
507: l_org_id NUMBER;
508: BEGIN
509: --
510: IF PG_DEBUG in ('Y', 'C') THEN

Line 618: p_batch_id IN ar_batches.batch_id%TYPE,

614: END app_fmt_remit_batch_conc_req;
615: --
616: PROCEDURE app_fmt_auto_batch_conc_req( p_approve_flag IN VARCHAR2,
617: p_format_flag IN VARCHAR2,
618: p_batch_id IN ar_batches.batch_id%TYPE,
619: p_request_id OUT NOCOPY NUMBER,
620: p_batch_applied_status OUT NOCOPY VARCHAR2,
621: p_module_name IN VARCHAR2,
622: p_module_version IN VARCHAR2 ) IS

Line 624: l_bat_rec ar_batches%ROWTYPE;

620: p_batch_applied_status OUT NOCOPY VARCHAR2,
621: p_module_name IN VARCHAR2,
622: p_module_version IN VARCHAR2 ) IS
623: l_request_id NUMBER;
624: l_bat_rec ar_batches%ROWTYPE;
625: l_org_id NUMBER;
626: BEGIN
627: --
628: IF PG_DEBUG in ('Y', 'C') THEN

Line 739: p_batch_id IN ar_batches.batch_id%TYPE,

735: --
736: PROCEDURE create_auto_batch_conc_req( p_create_flag IN VARCHAR2,
737: p_approve_flag IN VARCHAR2,
738: p_format_flag IN VARCHAR2,
739: p_batch_id IN ar_batches.batch_id%TYPE,
740: p_due_date_low IN ar_payment_schedules.due_date%TYPE,
741: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
742: p_trx_date_low IN ra_customer_trx.trx_date%TYPE,
743: p_trx_date_high IN ra_customer_trx.trx_date%TYPE,

Line 766: l_bat_rec ar_batches%ROWTYPE;

762: p_bank_account_low IN VARCHAR2,
763: p_bank_account_high IN VARCHAR2 ) IS
764:
765: l_request_id NUMBER;
766: l_bat_rec ar_batches%ROWTYPE;
767: l_org_id NUMBER;
768:
769: BEGIN
770: --

Line 1108: PROCEDURE Val_Create_Auto_Batch_Submit(p_batch_id ar_batches.batch_id%TYPE) IS

1104: | |
1105: | MODIFICATION HISTORY - Created by J Rautiainen BugFix 951138 - 15-SEP-1999|
1106: | |
1107: +===========================================================================*/
1108: PROCEDURE Val_Create_Auto_Batch_Submit(p_batch_id ar_batches.batch_id%TYPE) IS
1109:
1110: /* 15-SEP-1999 J Rautiainen BugFix 951138 Start
1111: * Need the payment method name and batch date in order to check
1112: * whether an active document sequence assignment exists for the

Line 1119: ar_batches b

1115:
1116: CURSOR batch_cursor IS
1117: select rm.name rm_name, b.batch_date batch_date
1118: from ar_receipt_methods rm,
1119: ar_batches b
1120: where b.batch_id = p_batch_id
1121: AND rm.receipt_method_id = b.receipt_method_id;
1122:
1123: l_batch_rec batch_cursor%ROWTYPE;