[Home] [Help]
1273: ar_cash_receipt_history crh,
1274: ar_batches bat,
1275: ar_receipt_method_accounts rma,
1276: ar_payment_schedules ps,
1277: ar_distributions d
1278: WHERE cr.selected_remittance_batch_id = :b_batch_id
1279: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID
1280: AND bat.batch_id = cr.selected_remittance_batch_id
1281: AND rm.receipt_method_id = cr.receipt_method_id
1760: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1761: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1762: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1763: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1764: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1765: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1767: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1768: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1899: ar_receipt_methods rm,
1900: ar_batches bat,
1901: ar_receipt_method_accounts rma,
1902: ar_payment_schedules ps,
1903: ar_distributions d
1904: WHERE cr.selected_remittance_batch_id = :ab_batch_id
1905: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID
1906: AND bat.batch_id = cr.selected_remittance_batch_id
1907: AND rm.receipt_method_id = cr.receipt_method_id
2362:
2363:
2364: /* the first update into ar_cash_receipt_history */
2365:
2366: ins_dist1 := 'INSERT into ar_distributions
2367: (line_id,
2368: source_id,
2369: source_table,
2370: source_type,
2385: last_updated_by,
2386: org_id,
2387: last_update_login)
2388: select
2389: ar_distributions_s.nextval,
2390: r.cash_receipt_history_id,
2391: ''CRH'',
2392: decode(:factor_flag,
2393: ''N'',decode(l.lookup_code,
2541: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2542: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2543: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2544: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2545: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2546: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2547: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2548: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2549: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
3121:
3122:
3123: /* the first update into ar_cash_receipt_history */
3124:
3125: ins_dist1 := 'INSERT into ar_distributions
3126: (line_id,
3127: source_id,
3128: source_table,
3129: source_type,
3144: last_updated_by,
3145: org_id,
3146: last_update_login)
3147: select
3148: ar_distributions_s.nextval,
3149: r.cash_receipt_history_id,
3150: ''CRH'',
3151: decode(:factor_flag,
3152: ''N'',decode(l.lookup_code,
5714: IF PG_DEBUG in ('Y','C') THEN
5715: fnd_file.put_line(FND_FILE.LOG,' rows UPDATED CRH = ' || SQL%ROWCOUNT );
5716: END IF;
5717:
5718: delete from ar_distributions
5719: where source_table = 'CRH'
5720: and source_id in ( select crh.cash_receipt_history_id
5721: from ar_cash_receipt_history crh,
5722: ar_cash_receipts cr