APPS.FV_LOCKBOX_FC_PKG dependencies on AR_BATCHES

Line 12: v_batch_id ar_batches.batch_id%TYPE;

8: -- Variable Declarations
9: -- -----------------------------------------------------------------------
10: v_test number;
11: v_transmission_id ar_transmissions_all.transmission_id%TYPE;
12: v_batch_id ar_batches.batch_id%TYPE;
13: v_org_id ar_batches.org_id%TYPE;
14: v_invoice_id ra_customer_trx.customer_trx_id%TYPE;
15: v_temp_id fv_lockbox_ipa_temp.temp_id%TYPE;
16: v_debit_memo_id ra_customer_trx.customer_trx_id%TYPE;

Line 13: v_org_id ar_batches.org_id%TYPE;

9: -- -----------------------------------------------------------------------
10: v_test number;
11: v_transmission_id ar_transmissions_all.transmission_id%TYPE;
12: v_batch_id ar_batches.batch_id%TYPE;
13: v_org_id ar_batches.org_id%TYPE;
14: v_invoice_id ra_customer_trx.customer_trx_id%TYPE;
15: v_temp_id fv_lockbox_ipa_temp.temp_id%TYPE;
16: v_debit_memo_id ra_customer_trx.customer_trx_id%TYPE;
17: v_amount ar_payment_schedules.amount_due_remaining%TYPE;

Line 48: cursor c_batches(cv_transmission_id ar_batches.transmission_id%TYPE) is

44: -- -----------------------------------------------------------------------
45: -- Cursor Declarations
46: -- -----------------------------------------------------------------------
47:
48: cursor c_batches(cv_transmission_id ar_batches.transmission_id%TYPE) is
49: select *
50: from ar_batches
51: where transmission_id = cv_transmission_id;
52:

Line 50: from ar_batches

46: -- -----------------------------------------------------------------------
47:
48: cursor c_batches(cv_transmission_id ar_batches.transmission_id%TYPE) is
49: select *
50: from ar_batches
51: where transmission_id = cv_transmission_id;
52:
53: cursor c_invoices(cv_batch_id ar_batches.batch_id%TYPE,
54: cv_org_id ar_batches.org_id%TYPE) is

Line 53: cursor c_invoices(cv_batch_id ar_batches.batch_id%TYPE,

49: select *
50: from ar_batches
51: where transmission_id = cv_transmission_id;
52:
53: cursor c_invoices(cv_batch_id ar_batches.batch_id%TYPE,
54: cv_org_id ar_batches.org_id%TYPE) is
55: /*
56: select distinct(decode(a.customer_trx_id,null,b.customer_trx_id,
57: a.customer_trx_id)) customer_trx_id

Line 54: cv_org_id ar_batches.org_id%TYPE) is

50: from ar_batches
51: where transmission_id = cv_transmission_id;
52:
53: cursor c_invoices(cv_batch_id ar_batches.batch_id%TYPE,
54: cv_org_id ar_batches.org_id%TYPE) is
55: /*
56: select distinct(decode(a.customer_trx_id,null,b.customer_trx_id,
57: a.customer_trx_id)) customer_trx_id
58: from ar_interim_cash_receipts a,

Line 90: cursor c_receipt_dms(cv_batch_id ar_batches.batch_id%TYPE,

86: and rct.set_of_books_id = fcc.set_of_books_id
87: and aps.amount_due_remaining > 0
88: order by fcc.priority ;
89:
90: cursor c_receipt_dms(cv_batch_id ar_batches.batch_id%TYPE,
91: cv_org_id ar_interim_cash_receipts.org_id%TYPE) is
92: select sum(amount) amount,
93: aicr.customer_trx_id,
94: aicr.payment_schedule_id

Line 120: cursor c_receipt_details(cv_batch_id ar_batches.batch_id%TYPE,

116: and aicrl.org_id = cv_org_id
117: group by aicrl.customer_trx_id, aicrl.payment_schedule_id;
118:
119:
120: cursor c_receipt_details(cv_batch_id ar_batches.batch_id%TYPE,
121: cv_org_id ar_interim_cash_receipts.org_id%TYPE) is
122: select customer_trx_id, aicr.amount amount, 'R' origin,
123: cash_receipt_id, 0 cash_receipt_line_id, payment_schedule_id,
124: 0 sold_to_customer, ussgl_transaction_code