APPS.FV_LOCKBOX_FC_PKG dependencies on AR_INTERIM_CASH_RCPT_LINES_ALL

Line 22: v_sold_to_customer ar_interim_cash_rcpt_lines_all.sold_to_customer%TYPE;

18: v_priority fv_finance_charge_controls.priority%TYPE;
19: v_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
20: v_appl_inv_id ra_customer_trx.customer_trx_id%TYPE;
21: v_appl_inv_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
22: v_sold_to_customer ar_interim_cash_rcpt_lines_all.sold_to_customer%TYPE;
23: v_transaction_code ar_interim_cash_receipts.ussgl_transaction_code%TYPE;
24: v_appl_inv_amt number;
25: v_appl_amt_remain number;
26: v_appl_dm_id fv_lockbox_ipa_temp.debit_memo_id%TYPE;

Line 59: ar_interim_cash_rcpt_lines_all b

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,
59: ar_interim_cash_rcpt_lines_all b
60: where a.batch_id = cv_batch_id
61: and a.cash_receipt_id = b.cash_receipt_id (+)
62: and(a.customer_trx_id is not null or b.customer_trx_id is not null);
63: */

Line 70: from ar_interim_cash_rcpt_lines_all

66: where batch_id = cv_batch_id
67: and customer_trx_id is not null
68: union
69: select distinct(customer_trx_id) customer_trx_id
70: from ar_interim_cash_rcpt_lines_all
71: where batch_id = cv_batch_id
72: and org_id = cv_org_id
73: and customer_trx_id is not null;
74:

Line 108: from ar_interim_cash_rcpt_lines_all aicrl,

104: union
105: select sum(payment_amount) amount,
106: aicrl.customer_trx_id,
107: aicrl.payment_schedule_id
108: from ar_interim_cash_rcpt_lines_all aicrl,
109: ra_customer_trx rct,
110: fv_finance_charge_controls fcc
111: where aicrl.batch_id = cv_batch_id
112: and aicrl.customer_trx_id is not null

Line 135: from ar_interim_cash_rcpt_lines_all aicrl

131: union
132: select customer_trx_id, aicrl.payment_amount amount, 'L' origin,
133: cash_receipt_id, cash_receipt_line_id, payment_schedule_id,
134: sold_to_customer, ussgl_transaction_code
135: from ar_interim_cash_rcpt_lines_all aicrl
136: where batch_id = cv_batch_id
137: and org_id = cv_org_id
138: and customer_trx_id is not null
139: and exists (select 'x' from fv_lockbox_ipa_temp f

Line 375: -- into ar_interim_cash_rcpt_lines_all

371:
372: v_appl_amt_remain := v_appl_amt_remain - v_dm_amt;
373:
374: -- insert new cash receipt applied to a finance charge debit memo
375: -- into ar_interim_cash_rcpt_lines_all
376: IF v_dm_amt >0 THEN -- don't want to insert $0 receipts
377: insert_cash_receipt(v_appl_dm_id, v_dm_pay_sch_id, v_dm_amt, null);
378:
379: --update temp table subtracting v_dm_amt

Line 424: update ar_interim_cash_rcpt_lines_all

420: --to apply to a finance charge debit memo, the ussgl_transaction
421: --_code should be set to null. There should not be a tc
422: --applied to a debit memo.
423:
424: update ar_interim_cash_rcpt_lines_all
425: set ussgl_transaction_code = null
426: where cash_receipt_id = v_cash_receipt_id
427: and cash_receipt_line_id = v_cash_receipt_line_id;
428:

Line 506: -- This procedures inserts a record into ar_interim_cash_rcpt_lines_all

502:
503: -- ------------------------------------------------------------------------
504: -- PROCEDURE insert_cash_receipt
505: -- ------------------------------------------------------------------------
506: -- This procedures inserts a record into ar_interim_cash_rcpt_lines_all
507: -- for a new receipt.
508: -- ------------------------------------------------------------------------
509: PROCEDURE insert_cash_receipt(v_cust_trx_id IN number,
510: v_pay_sch_id IN number,

Line 522: from ar_interim_cash_rcpt_lines_all

518:
519: --find current max cash_receipt_line_id for current cash_receipt_id
520: select max(cash_receipt_line_id)
521: into v_cash_receipt_line_id_ctr
522: from ar_interim_cash_rcpt_lines_all
523: where batch_id = v_batch_id
524: and cash_receipt_id = v_cash_receipt_id;
525:
526: END IF;

Line 533: insert into ar_interim_cash_rcpt_lines_all

529: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CTR = '||TO_CHAR(V_CASH_RECEIPT_LINE_ID_CTR));
531: END IF;
532:
533: insert into ar_interim_cash_rcpt_lines_all
534: (cash_receipt_id,
535: cash_receipt_line_id,
536: last_updated_by,
537: last_update_date,

Line 620: -- is in ar_interim_cash_rcpt_lines_all.

616: -- the orginal application receipt record must be updated with the amount
617: -- remaining on the receipt and the debit memo being paid off.
618: -- V_table will contain a 'R' if the receipt
619: -- record is in ar_interim_cash_receipts or a 'L' if the receipt record
620: -- is in ar_interim_cash_rcpt_lines_all.
621: -- ------------------------------------------------------------------------
622:
623: PROCEDURE update_interim_table(v_table IN VARCHAR2,
624: v_decrease_appl_amt IN NUMBER,

Line 632: update ar_interim_cash_rcpt_lines_all

628:
629: BEGIN
630:
631:
632: update ar_interim_cash_rcpt_lines_all
633: set payment_amount = nvl(v_decrease_appl_amt,0),
634: customer_trx_id = v_upd_customer_trx_id,
635: payment_schedule_id = v_upd_pay_sch_id,
636: last_updated_by = v_last_updated_by,