APPS.ARP_PROCESS_RCTS dependencies on AR_CASH_RECEIPTS

Line 142: l_cr_rec AR_CASH_RECEIPTS%ROWTYPE;

138: p_automatch_set_id IN NUMBER, /* ER Automatch Application */
139: p_autoapply_flag IN VARCHAR2
140: ) IS
141: --
142: l_cr_rec AR_CASH_RECEIPTS%ROWTYPE;
143: --
144: BEGIN
145:
146: IF PG_DEBUG in ('Y', 'C') THEN

Line 338: FROM ar_cash_receipts

334:
335: CURSOR cReceiptDtls IS
336: SELECT receipt_number,
337: receipt_date
338: FROM ar_cash_receipts
339: WHERE cash_receipt_id = p_cash_receipt_id;
340:
341:
342: l_history_id NUMBER;

Line 352: l_receipt_number ar_cash_receipts.receipt_number%type;

348: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
349: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
350: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;
351:
352: l_receipt_number ar_cash_receipts.receipt_number%type;
353: l_receipt_date ar_cash_receipts.receipt_date%type;
354:
355:
356: BEGIN

Line 353: l_receipt_date ar_cash_receipts.receipt_date%type;

349: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
350: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;
351:
352: l_receipt_number ar_cash_receipts.receipt_number%type;
353: l_receipt_date ar_cash_receipts.receipt_date%type;
354:
355:
356: BEGIN
357: IF PG_DEBUG in ('Y', 'C') THEN

Line 377: -- delete AR_CASH_RECEIPTS receipt record:

373: -- lock receipt record to make sure no one else has it locked
374:
375: arp_cash_receipts_pkg.lock_p(p_cash_receipt_id);
376:
377: -- delete AR_CASH_RECEIPTS receipt record:
378:
379: -- Before Deletion get the recipt details for Summary Tables
380: FOR ReceiptDtlsRec IN cReceiptDtls
381: LOOP

Line 637: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

633: | logic preventing unapp/reversal of misc rct |
634: +===========================================================================*/
635:
636: Procedure post_query_logic(
637: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
638: p_receipt_type IN VARCHAR2,
639: p_reference_type IN VARCHAR2,
640: p_reference_id IN NUMBER,
641: p_std_reversal_possible OUT NOCOPY VARCHAR2,

Line 682: l_cr_currency_code ar_cash_receipts.currency_code%TYPE;

678: l_prepayment_amount NUMBER;
679: l_amount_applied NUMBER;
680: l_tot_exchange_gain_loss NUMBER;
681: l_dummy NUMBER;
682: l_cr_currency_code ar_cash_receipts.currency_code%TYPE;
683: l_status VARCHAR2(20);
684:
685: BEGIN
686:

Line 771: FROM AR_CASH_RECEIPTS

767: ELSIF (p_reference_type = 'RECEIPT') THEN
768:
769: SELECT receipt_number
770: INTO p_reference_id_dsp
771: FROM AR_CASH_RECEIPTS
772: WHERE cash_receipt_id = p_reference_id;
773:
774: ELSIF (p_reference_type = 'PAYMENT_BATCH') THEN
775:

Line 925: FROM ar_cash_receipts cr

921: IF l_apps_exist = 'Y' THEN
922:
923: SELECT cr.currency_code
924: INTO l_cr_currency_code
925: FROM ar_cash_receipts cr
926: WHERE cr.cash_receipt_id = p_cr_id
927: AND exists
928: (select 1
929: from ar_receivable_applications ra,