APPS.ARP_PROCESS_RCTS dependencies on AR_CASH_RECEIPTS

Line 140: l_cr_rec AR_CASH_RECEIPTS%ROWTYPE;

136: p_rec_version_number IN NUMBER, /* Bug fix 3032059 */
137: p_payment_trxn_extension_id IN NUMBER
138: ) IS
139: --
140: l_cr_rec AR_CASH_RECEIPTS%ROWTYPE;
141: --
142: BEGIN
143:
144: IF PG_DEBUG in ('Y', 'C') THEN

Line 320: FROM ar_cash_receipts

316:
317: CURSOR cReceiptDtls IS
318: SELECT receipt_number,
319: receipt_date
320: FROM ar_cash_receipts
321: WHERE cash_receipt_id = p_cash_receipt_id;
322:
323:
324: l_history_id NUMBER;

Line 334: l_receipt_number ar_cash_receipts.receipt_number%type;

330: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
331: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
332: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;
333:
334: l_receipt_number ar_cash_receipts.receipt_number%type;
335: l_receipt_date ar_cash_receipts.receipt_date%type;
336:
337:
338: BEGIN

Line 335: l_receipt_date ar_cash_receipts.receipt_date%type;

331: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
332: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;
333:
334: l_receipt_number ar_cash_receipts.receipt_number%type;
335: l_receipt_date ar_cash_receipts.receipt_date%type;
336:
337:
338: BEGIN
339: IF PG_DEBUG in ('Y', 'C') THEN

Line 359: -- delete AR_CASH_RECEIPTS receipt record:

355: -- lock receipt record to make sure no one else has it locked
356:
357: arp_cash_receipts_pkg.lock_p(p_cash_receipt_id);
358:
359: -- delete AR_CASH_RECEIPTS receipt record:
360:
361: -- Before Deletion get the recipt details for Summary Tables
362: FOR ReceiptDtlsRec IN cReceiptDtls
363: LOOP

Line 593: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

589: | logic preventing unapp/reversal of misc rct |
590: +===========================================================================*/
591:
592: Procedure post_query_logic(
593: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
594: p_receipt_type IN VARCHAR2,
595: p_reference_type IN VARCHAR2,
596: p_reference_id IN NUMBER,
597: p_std_reversal_possible OUT NOCOPY VARCHAR2,

Line 638: l_cr_currency_code ar_cash_receipts.currency_code%TYPE;

634: l_prepayment_amount NUMBER;
635: l_amount_applied NUMBER;
636: l_tot_exchange_gain_loss NUMBER;
637: l_dummy NUMBER;
638: l_cr_currency_code ar_cash_receipts.currency_code%TYPE;
639:
640: BEGIN
641:
642: IF PG_DEBUG in ('Y', 'C') THEN

Line 718: FROM AR_CASH_RECEIPTS

714: ELSIF (p_reference_type = 'RECEIPT') THEN
715:
716: SELECT receipt_number
717: INTO p_reference_id_dsp
718: FROM AR_CASH_RECEIPTS
719: WHERE cash_receipt_id = p_reference_id;
720:
721: ELSIF (p_reference_type = 'PAYMENT_BATCH') THEN
722:

Line 872: FROM ar_cash_receipts cr

868: IF l_apps_exist = 'Y' THEN
869:
870: SELECT cr.currency_code
871: INTO l_cr_currency_code
872: FROM ar_cash_receipts cr
873: WHERE cr.cash_receipt_id = p_cr_id
874: AND exists
875: (select 1
876: from ar_receivable_applications ra,