APPS.ARP_PROC_RECEIPTS1 dependencies on AR_RECEIVABLE_APPLICATIONS

Line 276: l_ra_id_unapp ar_receivable_applications.receivable_application_id%TYPE;

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

Line 277: l_ra_id_unid ar_receivable_applications.receivable_application_id%TYPE;

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

Line 697: UPDATE ar_receivable_applications

693: IF (l_rct_identified_flag = TRUE) THEN
694:
695: -- first reverse existing UNID record by setting reversal GL Date:
696:
697: UPDATE ar_receivable_applications
698: SET reversal_gl_date = l_valid_gl_date
699: WHERE cash_receipt_id = p_cash_receipt_id
700: AND reversal_gl_date IS NULL
701: AND status = 'UNID';

Line 747: update ar_receivable_applications

743: '',
744: l_ra_id_unapp);
745:
746: -- 6924942 - Start
747: update ar_receivable_applications
748: set include_in_accumulation ='N'
749: where cash_receipt_id = p_cash_receipt_id
750: and status = 'UNAPP';
751: -- 6924942 - End

Line 785: UPDATE ar_receivable_applications

781:
782: -- In this case, first reverse the UNAPP record and then create an
783: -- UNID record.
784:
785: UPDATE ar_receivable_applications
786: SET reversal_gl_date = l_valid_gl_date
787: WHERE cash_receipt_id = p_cash_receipt_id
788: AND reversal_gl_date IS NULL
789: AND status = 'UNAPP';

Line 822: update ar_receivable_applications

818: '',
819: l_ra_id_unid);
820:
821: -- 6924942 - Start
822: update ar_receivable_applications
823: set include_in_accumulation ='N'
824: where cash_receipt_id = p_cash_receipt_id
825: and status = 'UNAPP';
826: -- 6924942 - End

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

877: -- -------------------------------------------------------------
878:
879: -- if the receipt status is APPROVED, we only update the amounts in
880: -- ar_cash_receipts, ar_cash_receipt_history, and ar_payment_schedules,
881: -- but not ar_receivable_applications, since this is being taken
882: -- care of by the applications form and its server-side code:
883:
884:
885: IF (l_crh_rec.status = 'APPROVED') THEN

Line 1257: -- AR_RECEIVABLE_APPLICATIONS

1253:
1254: IF (l_cr_rec.pay_from_customer IS NULL) THEN
1255:
1256: -- receipt is unidentified; create UNID record in
1257: -- AR_RECEIVABLE_APPLICATIONS
1258:
1259: arp_proc_rct_util.insert_ra_rec_cash(
1260: p_cash_receipt_id,
1261: l_cr_amount_delta,

Line 1297: -- AR_RECEIVABLE_APPLICATIONS

1293:
1294: ELSE
1295:
1296: -- receipt is identified; create UNAPP record in
1297: -- AR_RECEIVABLE_APPLICATIONS
1298:
1299: arp_proc_rct_util.insert_ra_rec_cash(
1300: p_cash_receipt_id,
1301: l_cr_amount_delta,

Line 1313: update ar_receivable_applications

1309: '',
1310: l_ra_id_unapp);
1311:
1312: -- 6924942 - Start
1313: update ar_receivable_applications
1314: set include_in_accumulation ='N'
1315: where cash_receipt_id = p_cash_receipt_id
1316: and status = 'UNAPP';
1317: -- 6924942 - End