[Home] [Help]
263: p_legal_entity_id IN NUMBER default NULL,
264: p_payment_trxn_extension_id IN NUMBER default NULL /* PAYMENT_UPTAKE */
265: ) IS
266:
267: l_cr_rec ar_cash_receipts%ROWTYPE;
268: l_crh_rec ar_cash_receipt_history%ROWTYPE;
269: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
270: l_ps_rec ar_payment_schedules%ROWTYPE;
271: l_dist_rec ar_distributions%ROWTYPE;
317: l_rev_crh_id ar_cash_receipt_history.reversal_cash_receipt_hist_id%TYPE;
318:
319: -- dummy variables:
320:
321: l_override_dummy ar_cash_receipts.override_remit_account_flag%TYPE;
322: l_number_dummy NUMBER;
323:
324: -- GL date defaulting variables
325: l_error_message VARCHAR2(128);
370: --{BUG#4353362
371: CURSOR cu_current_customer IS
372: SELECT pay_from_customer,
373: customer_site_use_id
374: FROM ar_cash_receipts
375: WHERE cash_receipt_id = p_cash_receipt_id;
376: l_current_customer_id NUMBER;
377: l_current_csu_id NUMBER;
378: x_errbuf VARCHAR2(2000);
746: l_ae_doc_rec.miscel6 := p_customer_site_use_id;
747: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
748:
749: -- also don't forget to set the pay_from_customer column in
750: -- ar_cash_receipts to new customer and the status of the receipt:
751:
752: l_cr_rec.pay_from_customer := p_pay_from_customer;
753: l_cr_rec.status := 'UNAPP';
754:
824: and sub id is from the cash receipt, so no need to pass these */
825: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
826:
827: -- also don't forget to set the pay_from_customer column in
828: -- ar_cash_receipts to NULL and the status to UNID.
829:
830: l_cr_rec.pay_from_customer := NULL;
831: l_cr_rec.status := 'UNID';
832:
846: -- deal with amount changes
847: -- -------------------------------------------------------------
848:
849: -- if the receipt status is APPROVED, we only update the amounts in
850: -- ar_cash_receipts, ar_cash_receipt_history, and ar_payment_schedules,
851: -- but not ar_receivable_applications, since this is being taken
852: -- care of by the applications form and its server-side code:
853:
854:
1659: p_new_state,
1660: p_new_state_dsp
1661: FROM
1662: ar_cash_receipt_history crh_current,
1663: ar_cash_receipts cr,
1664: ar_lookups l_cr_status,
1665: ar_lookups l_crh_status
1666: WHERE
1667: cr.cash_receipt_id = p_cash_receipt_id