APPS.ARP_PROC_RECEIPTS1 dependencies on AR_RECEIVABLE_APPLICATIONS

Line 273: l_ra_id_unapp ar_receivable_applications.receivable_application_id%TYPE;

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;
272: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
273: l_ra_id_unapp ar_receivable_applications.receivable_application_id%TYPE;
274: l_ra_id_unid ar_receivable_applications.receivable_application_id%TYPE;
275: l_ae_doc_rec ae_doc_rec_type;
276:
277: -- boolean flags:

Line 274: l_ra_id_unid ar_receivable_applications.receivable_application_id%TYPE;

270: l_ps_rec ar_payment_schedules%ROWTYPE;
271: l_dist_rec ar_distributions%ROWTYPE;
272: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
273: l_ra_id_unapp ar_receivable_applications.receivable_application_id%TYPE;
274: l_ra_id_unid ar_receivable_applications.receivable_application_id%TYPE;
275: l_ae_doc_rec ae_doc_rec_type;
276:
277: -- boolean flags:
278:

Line 682: UPDATE ar_receivable_applications

678: IF (l_rct_identified_flag = TRUE) THEN
679:
680: -- first reverse existing UNID record by setting reversal GL Date:
681:
682: UPDATE ar_receivable_applications
683: SET reversal_gl_date = l_valid_gl_date
684: WHERE cash_receipt_id = p_cash_receipt_id
685: AND reversal_gl_date IS NULL
686: AND status = 'UNID';

Line 763: UPDATE ar_receivable_applications

759:
760: -- In this case, first reverse the UNAPP record and then create an
761: -- UNID record.
762:
763: UPDATE ar_receivable_applications
764: SET reversal_gl_date = l_valid_gl_date
765: WHERE cash_receipt_id = p_cash_receipt_id
766: AND reversal_gl_date IS NULL
767: AND status = 'UNAPP';

Line 851: -- but not ar_receivable_applications, since this is being taken

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:
855: IF (l_crh_rec.status = 'APPROVED') THEN

Line 1227: -- AR_RECEIVABLE_APPLICATIONS

1223:
1224: IF (l_cr_rec.pay_from_customer IS NULL) THEN
1225:
1226: -- receipt is unidentified; create UNID record in
1227: -- AR_RECEIVABLE_APPLICATIONS
1228:
1229: arp_proc_rct_util.insert_ra_rec_cash(
1230: p_cash_receipt_id,
1231: l_cr_amount_delta,

Line 1267: -- AR_RECEIVABLE_APPLICATIONS

1263:
1264: ELSE
1265:
1266: -- receipt is identified; create UNAPP record in
1267: -- AR_RECEIVABLE_APPLICATIONS
1268:
1269: arp_proc_rct_util.insert_ra_rec_cash(
1270: p_cash_receipt_id,
1271: l_cr_amount_delta,