APPS.ARP_REVERSE_RECEIPT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 105: | AR_RECEIVABLE_APPLICATIONS table |

101: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
102: | arp_process_application.reverse - Reverse an application |
103: | arp_cash_receipts_pkg.fetch_p - Fetch a record from ar_cash_receipts |
104: | arp_app_pkg.lock_p - lock a record in |
105: | AR_RECEIVABLE_APPLICATIONS table |
106: | |
107: | ARGUMENTS : IN: |
108: | p_cr_id - Cahs receipt ID |
109: | p_reversal_category - Reversal Category |

Line 166: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;

162: /*CCR-add cursor for receipt method pkt */
163:
164: --
165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
166: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
167: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
168: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
169: l_rm_code ar_receipt_methods.payment_type_code%TYPE;
170: l_rt_type ar_receivables_trx.type%TYPE;

Line 167: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

163:
164: --
165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
166: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
167: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
168: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
169: l_rm_code ar_receipt_methods.payment_type_code%TYPE;
170: l_rt_type ar_receivables_trx.type%TYPE;
171:

Line 211: FROM ar_receivable_applications

207: SELECT receivable_application_id
208: , receivables_trx_id
209: , applied_payment_schedule_id
210: , application_ref_id
211: FROM ar_receivable_applications
212: WHERE cash_receipt_id = p_cr_id
213: AND ( (
214: status||'' in ('APP', 'ACC','ACTIVITY','OTHER ACC')
215: AND display = 'Y'

Line 236: FROM ar_receivable_applications ra ,ar_cash_receipts cr

232: /* bug3635777 : Added table ar_cash_receipts to avoid FTS on ra table */
233:
234: CURSOR ar_rc_rec( p_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
235: SELECT ra.receivable_application_id
236: FROM ar_receivable_applications ra ,ar_cash_receipts cr
237: WHERE cr.reference_id = ra.cash_receipt_id
238: AND cr.cash_receipt_id = p_cr_id
239: AND ra.application_ref_id = p_cr_id
240: AND ra.application_ref_type = 'MISC_RECEIPT';

Line 510: -- ar_receivable_applications for the cash_receipt

506: end if; --(l_cr_rec.amount < 0 and v_credit_card)
507: ELSIF ( l_cr_rec.type = 'CASH' ) THEN
508: --
509: -- If receipt_type is 'CASH', fetch each receivable_application_id from
510: -- ar_receivable_applications for the cash_receipt
511: -- For each record fetched, reverse application
512: -- Update ar_payment_schedule record with amount_due_remaining = 0,
513: -- acctd_amount_due_remaining = 0, amount_applied = 0,
514: -- actual_date_closed,last_update_date, last_updated_by, gl_date_closed,

Line 530: -- ar_receivable_applications_pkg.insert

526: -- procedure and the GL_DATE validation need not be done again.
527: -- If the flag is not 'Y', this implies the procedure is called
528: -- by a form, and GL_DATE validation needs to be done and 'UNAPP'
529: -- record needs to be inserted by calling
530: -- ar_receivable_applications_pkg.insert
531: --
532:
533: -- bug 584303: added ln_bal_due_remaining.. Don't need to
534: -- do anything with this.. it is just a place holder.

Line 1506: | AR_RECEIVABLE_APPLICATIONS table |

1502: | SCOPE - PUBLIC |
1503: | |
1504: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1505: | arp_app_pkg.lock_p - lock a record in |
1506: | AR_RECEIVABLE_APPLICATIONS table |
1507: | |
1508: | ARGUMENTS : IN: |
1509: | p_cr_id - Cash receipt ID |
1510: | p_reversal_gl_date - Reversal GL date |

Line 2222: FROM ar_receivable_applications

2218: RETURN BOOLEAN
2219: IS
2220: CURSOR c_claim_count IS
2221: SELECT count(*)
2222: FROM ar_receivable_applications
2223: WHERE cash_receipt_id = p_cr_id
2224: AND display = 'Y'
2225: AND applied_payment_schedule_id = DECODE(p_include_trx_claims,
2226: 'N',-4,applied_payment_schedule_id)

Line 2231: FROM ar_receivable_applications

2227: AND application_ref_type = 'CLAIM';
2228:
2229: CURSOR c_claims IS
2230: SELECT secondary_application_ref_id
2231: FROM ar_receivable_applications
2232: WHERE cash_receipt_id = p_cr_id
2233: AND display = 'Y'
2234: AND applied_payment_schedule_id = DECODE(p_include_trx_claims,
2235: 'N',-4,applied_payment_schedule_id)

Line 2318: FROM ar_receivable_applications

2314: applied_payment_schedule_id,
2315: applied_customer_trx_id,
2316: amount_applied,
2317: apply_date
2318: FROM ar_receivable_applications
2319: WHERE cash_receipt_id = p_cr_id
2320: AND display = 'Y'
2321: AND applied_payment_schedule_id = DECODE(p_include_trx_claims,
2322: 'N',-4,applied_payment_schedule_id)

Line 2405: FROM ar_receivable_applications

2401: RETURN BOOLEAN
2402: IS
2403: CURSOR c_claim_count IS
2404: SELECT count(*)
2405: FROM ar_receivable_applications
2406: WHERE cash_receipt_id = p_cr_id
2407: AND display = 'Y'
2408: AND application_ref_type = 'CLAIM';
2409:

Line 2467: FROM ar_receivable_applications app,

2463: IS
2464:
2465: CURSOR c_netted_receipts IS
2466: SELECT ps.cash_receipt_id, app.amount_applied
2467: FROM ar_receivable_applications app,
2468: ar_payment_schedules ps
2469: WHERE app.applied_payment_schedule_id = ps.payment_schedule_id
2470: AND app.cash_receipt_id = p_cr_id
2471: AND app.display = 'Y'

Line 2540: FROM ar_receivable_applications

2536: IS
2537:
2538: CURSOR c_refunds IS
2539: SELECT application_ref_id
2540: FROM ar_receivable_applications
2541: WHERE cash_receipt_id = p_cr_id
2542: AND display = 'Y'
2543: AND applied_payment_schedule_id = -8;
2544: l_refund_count NUMBER ;