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.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: l_program_name ap_payment_programs.program_name%TYPE;
769: l_batch_app_status ar_batches.batch_applied_status%TYPE;
770: BEGIN

Line 769: l_batch_app_status ar_batches.batch_applied_status%TYPE;

765: l_request_id NUMBER;
766: l_bat_rec ar_batches%ROWTYPE;
767: l_org_id NUMBER;
768: l_program_name ap_payment_programs.program_name%TYPE;
769: l_batch_app_status ar_batches.batch_applied_status%TYPE;
770: BEGIN
771: --
772: IF PG_DEBUG in ('Y', 'C') THEN
773: arp_standard.debug( 'arp_process_boe.create_auto_batch_conc_req()+');

Line 900: FROM ar_batches bat,

896: SELECT bat.batch_applied_status,
897: app.program_name
898: INTO l_batch_app_status,
899: l_program_name
900: FROM ar_batches bat,
901: ar_receipt_methods rm,
902: ap_payment_programs app
903: WHERE bat.batch_id = p_batch_id
904: AND bat.receipt_method_id = rm.receipt_method_id

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

1137: | |
1138: | MODIFICATION HISTORY - Created by J Rautiainen BugFix 951138 - 15-SEP-1999|
1139: | |
1140: +===========================================================================*/
1141: PROCEDURE Val_Create_Auto_Batch_Submit(p_batch_id ar_batches.batch_id%TYPE) IS
1142:
1143: /* 15-SEP-1999 J Rautiainen BugFix 951138 Start
1144: * Need the payment method name and batch date in order to check
1145: * whether an active document sequence assignment exists for the

Line 1152: ar_batches b

1148:
1149: CURSOR batch_cursor IS
1150: select rm.name rm_name, b.batch_date batch_date
1151: from ar_receipt_methods rm,
1152: ar_batches b
1153: where b.batch_id = p_batch_id
1154: AND rm.receipt_method_id = b.receipt_method_id;
1155:
1156: l_batch_rec batch_cursor%ROWTYPE;