APPS.ARP_BR_HOUSEKEEPER_PKG dependencies on AR_BATCHES

Line 32: pg_receipt_method_id ar_batches.receipt_method_id%TYPE;

28: pg_deferred_tax_exists BOOLEAN := TRUE;
29: pg_collection_days ar_receipt_method_accounts.br_collection_days%TYPE;
30: pg_risk_elimination_days ar_receipt_method_accounts.risk_elimination_days%TYPE;
31: pg_rct_inherit_inv_num_flag ar_receipt_methods.receipt_inherit_inv_num_flag%TYPE;
32: pg_receipt_method_id ar_batches.receipt_method_id%TYPE;
33: pg_remit_bank_acct_use_id ar_batches.remit_bank_acct_use_id%type;
34: pg_remittance_batch_date ar_batches.batch_date%TYPE;
35: pg_endorsement_date DATE;
36: pg_called_from VARCHAR2(50);

Line 33: pg_remit_bank_acct_use_id ar_batches.remit_bank_acct_use_id%type;

29: pg_collection_days ar_receipt_method_accounts.br_collection_days%TYPE;
30: pg_risk_elimination_days ar_receipt_method_accounts.risk_elimination_days%TYPE;
31: pg_rct_inherit_inv_num_flag ar_receipt_methods.receipt_inherit_inv_num_flag%TYPE;
32: pg_receipt_method_id ar_batches.receipt_method_id%TYPE;
33: pg_remit_bank_acct_use_id ar_batches.remit_bank_acct_use_id%type;
34: pg_remittance_batch_date ar_batches.batch_date%TYPE;
35: pg_endorsement_date DATE;
36: pg_called_from VARCHAR2(50);
37:

Line 34: pg_remittance_batch_date ar_batches.batch_date%TYPE;

30: pg_risk_elimination_days ar_receipt_method_accounts.risk_elimination_days%TYPE;
31: pg_rct_inherit_inv_num_flag ar_receipt_methods.receipt_inherit_inv_num_flag%TYPE;
32: pg_receipt_method_id ar_batches.receipt_method_id%TYPE;
33: pg_remit_bank_acct_use_id ar_batches.remit_bank_acct_use_id%type;
34: pg_remittance_batch_date ar_batches.batch_date%TYPE;
35: pg_endorsement_date DATE;
36: pg_called_from VARCHAR2(50);
37:
38: pg_BR_rec BR_rec_type;

Line 64: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL);

60: PROCEDURE prev_posted_trh(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
61: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE);
62:
63: PROCEDURE fetch_remittance_setup_data(p_status IN ar_transaction_history.status%TYPE,
64: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL);
65:
66: PROCEDURE fetch_endorsement_setup_data(p_receivables_trx_id IN ar_receivables_trx.receivables_trx_id%TYPE);
67:
68: PROCEDURE process_standard_remitted;

Line 1746: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL) IS

1742: | 30-JUN-2000 Jani Rautiainen Created |
1743: | |
1744: +===========================================================================*/
1745: PROCEDURE fetch_remittance_setup_data(p_status IN ar_transaction_history.status%TYPE,
1746: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL) IS
1747: /*------------------------------------------------+
1748: | Fetch remittance data from BR remittance batch |
1749: +------------------------------------------------*/
1750: CURSOR remittance_setup_cur IS

Line 1757: FROM ar_batches ab, ar_receipt_method_accounts rma, ar_receipt_methods rm

1753: rm.receipt_inherit_inv_num_flag,
1754: ab.receipt_method_id,
1755: ab.remit_bank_acct_use_id,
1756: ab.batch_date
1757: FROM ar_batches ab, ar_receipt_method_accounts rma, ar_receipt_methods rm
1758: WHERE ab.batch_id = p_batch_id
1759: and rma.remit_bank_acct_use_id = ab.remit_bank_acct_use_id
1760: and rma.receipt_method_id = ab.receipt_method_id
1761: and rm.receipt_method_id = ab.receipt_method_id;