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_PROGRAM_BR_REMIT dependencies on AR_BATCHES

Line 24: p_batch_id IN AR_BATCHES.batch_id%TYPE,

20:
21: /*-------------- Private procedures used by the package --------------------*/
22:
23: PROCEDURE create_remit_pvt(
24: p_batch_id IN AR_BATCHES.batch_id%TYPE,
25: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
26: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
27: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
28: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

Line 25: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,

21: /*-------------- Private procedures used by the package --------------------*/
22:
23: PROCEDURE create_remit_pvt(
24: p_batch_id IN AR_BATCHES.batch_id%TYPE,
25: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
26: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
27: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
28: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
29: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 26: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,

22:
23: PROCEDURE create_remit_pvt(
24: p_batch_id IN AR_BATCHES.batch_id%TYPE,
25: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
26: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
27: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
28: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
29: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
30: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 54: p_batch_id IN AR_BATCHES.batch_id%TYPE);

50: p_drawee_sort_criteria IN varchar2,
51: p_drawee_order IN varchar2);
52:
53: PROCEDURE approve_remit_pvt(
54: p_batch_id IN AR_BATCHES.batch_id%TYPE);
55:
56: PROCEDURE format_remit_pvt(
57: p_batch_id IN AR_BATCHES.batch_id%TYPE,
58: p_physical_bill IN varchar2);

Line 57: p_batch_id IN AR_BATCHES.batch_id%TYPE,

53: PROCEDURE approve_remit_pvt(
54: p_batch_id IN AR_BATCHES.batch_id%TYPE);
55:
56: PROCEDURE format_remit_pvt(
57: p_batch_id IN AR_BATCHES.batch_id%TYPE,
58: p_physical_bill IN varchar2);
59:
60: PROCEDURE cancel_remit_pvt(
61: p_batch_id IN AR_BATCHES.batch_id%TYPE);

Line 61: p_batch_id IN AR_BATCHES.batch_id%TYPE);

57: p_batch_id IN AR_BATCHES.batch_id%TYPE,
58: p_physical_bill IN varchar2);
59:
60: PROCEDURE cancel_remit_pvt(
61: p_batch_id IN AR_BATCHES.batch_id%TYPE);
62:
63: PROCEDURE print_remit_pvt(
64: p_batch_id IN AR_BATCHES.batch_id%TYPE);
65:

Line 64: p_batch_id IN AR_BATCHES.batch_id%TYPE);

60: PROCEDURE cancel_remit_pvt(
61: p_batch_id IN AR_BATCHES.batch_id%TYPE);
62:
63: PROCEDURE print_remit_pvt(
64: p_batch_id IN AR_BATCHES.batch_id%TYPE);
65:
66: PROCEDURE print_bills_remit_pvt(
67: p_batch_id IN AR_BATCHES.batch_id%TYPE);
68:

Line 67: p_batch_id IN AR_BATCHES.batch_id%TYPE);

63: PROCEDURE print_remit_pvt(
64: p_batch_id IN AR_BATCHES.batch_id%TYPE);
65:
66: PROCEDURE print_bills_remit_pvt(
67: p_batch_id IN AR_BATCHES.batch_id%TYPE);
68:
69: PROCEDURE process_br_payment(
70: p_batch_id IN AR_BATCHES.batch_id%TYPE);
71:

Line 70: p_batch_id IN AR_BATCHES.batch_id%TYPE);

66: PROCEDURE print_bills_remit_pvt(
67: p_batch_id IN AR_BATCHES.batch_id%TYPE);
68:
69: PROCEDURE process_br_payment(
70: p_batch_id IN AR_BATCHES.batch_id%TYPE);
71:
72:
73: /*------------------------ Public procedures ------------------------*/
74:

Line 147: l_batch_id AR_BATCHES.batch_id%TYPE;

143: p_drawee_sort_criteria IN varchar2 DEFAULT NULL,
144: p_drawee_order IN varchar2 DEFAULT NULL,
145: p_physical_bill IN varchar2 DEFAULT 'N') IS
146:
147: l_batch_id AR_BATCHES.batch_id%TYPE;
148: l_remit_total_low AR_BATCHES.control_amount%TYPE;
149: l_remit_total_high AR_BATCHES.control_amount%TYPE;
150: l_maturity_date_low AR_PAYMENT_SCHEDULES.due_date%TYPE;
151: l_maturity_date_high AR_PAYMENT_SCHEDULES.due_date%TYPE;

Line 148: l_remit_total_low AR_BATCHES.control_amount%TYPE;

144: p_drawee_order IN varchar2 DEFAULT NULL,
145: p_physical_bill IN varchar2 DEFAULT 'N') IS
146:
147: l_batch_id AR_BATCHES.batch_id%TYPE;
148: l_remit_total_low AR_BATCHES.control_amount%TYPE;
149: l_remit_total_high AR_BATCHES.control_amount%TYPE;
150: l_maturity_date_low AR_PAYMENT_SCHEDULES.due_date%TYPE;
151: l_maturity_date_high AR_PAYMENT_SCHEDULES.due_date%TYPE;
152: l_br_amount_low AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 149: l_remit_total_high AR_BATCHES.control_amount%TYPE;

145: p_physical_bill IN varchar2 DEFAULT 'N') IS
146:
147: l_batch_id AR_BATCHES.batch_id%TYPE;
148: l_remit_total_low AR_BATCHES.control_amount%TYPE;
149: l_remit_total_high AR_BATCHES.control_amount%TYPE;
150: l_maturity_date_low AR_PAYMENT_SCHEDULES.due_date%TYPE;
151: l_maturity_date_high AR_PAYMENT_SCHEDULES.due_date%TYPE;
152: l_br_amount_low AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
153: l_br_amount_high AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 305: p_batch_id IN AR_BATCHES.batch_id%TYPE,

301: | |
302: | 22-AUG-01 V Crisostomo Bug 1810619 : set process_status |
303: +===========================================================================*/
304: PROCEDURE create_remit_pvt(
305: p_batch_id IN AR_BATCHES.batch_id%TYPE,
306: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
307: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
308: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
309: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

Line 306: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,

302: | 22-AUG-01 V Crisostomo Bug 1810619 : set process_status |
303: +===========================================================================*/
304: PROCEDURE create_remit_pvt(
305: p_batch_id IN AR_BATCHES.batch_id%TYPE,
306: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
307: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
308: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
309: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
310: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 307: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,

303: +===========================================================================*/
304: PROCEDURE create_remit_pvt(
305: p_batch_id IN AR_BATCHES.batch_id%TYPE,
306: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
307: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
308: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
309: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
310: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
311: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 335: l_batch_rec AR_BATCHES%ROWTYPE;

331: p_drawee_sort_criteria IN varchar2,
332: p_drawee_order IN varchar2) IS
333:
334:
335: l_batch_rec AR_BATCHES%ROWTYPE;
336:
337: l_select_detail varchar2(25000);
338:
339: l_control_count AR_BATCHES.control_count%TYPE;

Line 339: l_control_count AR_BATCHES.control_count%TYPE;

335: l_batch_rec AR_BATCHES%ROWTYPE;
336:
337: l_select_detail varchar2(25000);
338:
339: l_control_count AR_BATCHES.control_count%TYPE;
340: l_control_amount AR_BATCHES.control_amount%TYPE;
341:
342: BEGIN
343:

Line 340: l_control_amount AR_BATCHES.control_amount%TYPE;

336:
337: l_select_detail varchar2(25000);
338:
339: l_control_count AR_BATCHES.control_count%TYPE;
340: l_control_amount AR_BATCHES.control_amount%TYPE;
341:
342: BEGIN
343:
344: process_status := 'STARTED CREATE_REMIT_PVT';

Line 492: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS

488: | 22-AUG-01 V Crisostomo Bug 1810619 : define process_status |
489: | |
490: +===========================================================================*/
491: PROCEDURE cancel_remit_pvt(
492: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
493:
494: l_batch_rec AR_BATCHES%ROWTYPE;
495: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
496:

Line 494: l_batch_rec AR_BATCHES%ROWTYPE;

490: +===========================================================================*/
491: PROCEDURE cancel_remit_pvt(
492: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
493:
494: l_batch_rec AR_BATCHES%ROWTYPE;
495: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
496:
497: BEGIN
498:

Line 495: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

491: PROCEDURE cancel_remit_pvt(
492: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
493:
494: l_batch_rec AR_BATCHES%ROWTYPE;
495: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
496:
497: BEGIN
498:
499: process_status := 'STARTED CANCEL_REMIT_PVT';

Line 568: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS

564: | |
565: | 22-AUG-01 V Crisostomo Bug 1810619 : set process_status |
566: +===========================================================================*/
567: PROCEDURE approve_remit_pvt(
568: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
569:
570: l_batch_rec AR_BATCHES%ROWTYPE;
571: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
572:

Line 570: l_batch_rec AR_BATCHES%ROWTYPE;

566: +===========================================================================*/
567: PROCEDURE approve_remit_pvt(
568: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
569:
570: l_batch_rec AR_BATCHES%ROWTYPE;
571: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
572:
573: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
574:

Line 673: p_batch_id IN AR_BATCHES.batch_id%TYPE,

669: | 05-OCT-05 Surendra Rajan Bug 4609222 : Removed the auto trans program |
670: | validation. |
671: +===========================================================================*/
672: PROCEDURE format_remit_pvt(
673: p_batch_id IN AR_BATCHES.batch_id%TYPE,
674: p_physical_bill IN varchar2) IS
675:
676: l_batch_rec AR_BATCHES%ROWTYPE;
677:

Line 676: l_batch_rec AR_BATCHES%ROWTYPE;

672: PROCEDURE format_remit_pvt(
673: p_batch_id IN AR_BATCHES.batch_id%TYPE,
674: p_physical_bill IN varchar2) IS
675:
676: l_batch_rec AR_BATCHES%ROWTYPE;
677:
678: format_program AP_PAYMENT_PROGRAMS.program_name%TYPE;
679:
680: l_request_id number;

Line 807: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS

803: | MODIFICATION HISTORY - Created by Mireille Flahaut - 18/04/2000 |
804: | |
805: +===========================================================================*/
806: PROCEDURE print_remit_pvt(
807: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
808:
809: l_batch_rec AR_BATCHES%ROWTYPE;
810:
811: -- Report 'BR Remittance Batch Management Report'

Line 809: l_batch_rec AR_BATCHES%ROWTYPE;

805: +===========================================================================*/
806: PROCEDURE print_remit_pvt(
807: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
808:
809: l_batch_rec AR_BATCHES%ROWTYPE;
810:
811: -- Report 'BR Remittance Batch Management Report'
812: print_program AP_PAYMENT_PROGRAMS.program_name%TYPE := 'ARBRRMBM';
813:

Line 981: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS

977: | MODIFICATION HISTORY - Created by Mireille Flahaut - 15/06/2000 |
978: | |
979: +===========================================================================*/
980: PROCEDURE print_bills_remit_pvt(
981: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
982:
983: l_batch_rec AR_BATCHES%ROWTYPE;
984: l_request_id NUMBER;
985: l_format VARCHAR2(30) := 'REMIT BATCH';

Line 983: l_batch_rec AR_BATCHES%ROWTYPE;

979: +===========================================================================*/
980: PROCEDURE print_bills_remit_pvt(
981: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
982:
983: l_batch_rec AR_BATCHES%ROWTYPE;
984: l_request_id NUMBER;
985: l_format VARCHAR2(30) := 'REMIT BATCH';
986:
987: BEGIN

Line 1068: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS

1064: | |
1065: | 22-AUG-01 V Crisostomo Bug 1810619 : set process_status |
1066: +===========================================================================*/
1067: PROCEDURE process_br_payment(
1068: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
1069:
1070: CURSOR br_rem_info_cur IS
1071: SELECT br.trx_number,
1072: br.customer_trx_id,