[Home] [Help]
1475: END IF;
1476:
1477: SELECT cash_receipt_id
1478: INTO p_cash_receipt_id
1479: FROM ar_receivable_applications
1480: where receivable_application_id = (SELECT MAX(receivable_application_id)
1481: FROM ar_receivable_applications
1482: WHERE applied_customer_trx_id = p_customer_trx_id
1483: AND status = 'APP' );
1477: SELECT cash_receipt_id
1478: INTO p_cash_receipt_id
1479: FROM ar_receivable_applications
1480: where receivable_application_id = (SELECT MAX(receivable_application_id)
1481: FROM ar_receivable_applications
1482: WHERE applied_customer_trx_id = p_customer_trx_id
1483: AND status = 'APP' );
1484:
1485: IF PG_DEBUG in ('Y', 'C') THEN
1515:
1516:
1517: PROCEDURE Find_Last_STD ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
1518: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE ,
1519: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE)
1520:
1521: IS
1522:
1523: CURSOR last_std_application_cur IS
1521: IS
1522:
1523: CURSOR last_std_application_cur IS
1524: SELECT receivable_application_id, cash_receipt_id
1525: FROM ar_receivable_applications
1526: WHERE link_to_customer_trx_id = p_customer_trx_id
1527: AND status = 'ACTIVITY'
1528: AND applied_payment_schedule_id = -2
1529: AND display = 'Y'
1831: l_msg_count NUMBER;
1832: l_msg_data VARCHAR2(2000);
1833: l_return_status VARCHAR2(1);
1834:
1835: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE;
1836: l_cr_rec ar_cash_receipts%ROWTYPE;
1837:
1838: l_secondary_application_ref_id NUMBER:= NULL;
1839: l_application_ref_type VARCHAR2(30):= NULL;
1837:
1838: l_secondary_application_ref_id NUMBER:= NULL;
1839: l_application_ref_type VARCHAR2(30):= NULL;
1840: l_application_ref_id NUMBER:= NULL;
1841: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1842: ln_rec_application_id ar_receivable_applications.receivable_application_id%type;
1843:
1844: l_org_return_status VARCHAR2(1);
1845: l_org_id NUMBER;
1838: l_secondary_application_ref_id NUMBER:= NULL;
1839: l_application_ref_type VARCHAR2(30):= NULL;
1840: l_application_ref_id NUMBER:= NULL;
1841: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1842: ln_rec_application_id ar_receivable_applications.receivable_application_id%type;
1843:
1844: l_org_return_status VARCHAR2(1);
1845: l_org_id NUMBER;
1846: BEGIN
1974:
1975: IS
1976:
1977:
1978: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1979:
1980: l_msg_count NUMBER;
1981: l_msg_data VARCHAR2(2000);
1982: l_return_status VARCHAR2(1);
2089: l_adj_id ar_adjustments.adjustment_id%TYPE ;
2090: l_batch_rec ar_batches%ROWTYPE ;
2091: l_called_from VARCHAR2(30) := NULL ;
2092: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE ;
2093: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2094: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE ;
2095:
2096: BEGIN
2097:
2745: IS
2746:
2747: CURSOR last_application_cur IS
2748: SELECT receivable_application_id
2749: FROM ar_receivable_applications
2750: WHERE applied_customer_trx_id = p_trh_rec.customer_trx_id
2751: AND status = 'APP'
2752: AND display = 'Y'
2753: ORDER BY receivable_application_id DESC;
2793: | Update the LINK_TO_TRX_HIST_ID on the |
2794: | application |
2795: +-----------------------------------------------*/
2796:
2797: UPDATE ar_receivable_applications
2798: SET LINK_TO_TRX_HIST_ID = p_trh_rec.transaction_history_id
2799: WHERE receivable_application_id = last_application_rec.receivable_application_id;
2800:
2801: