[Home] [Help]
27: SELECT COUNT(*) as CTR
28: FROM JL_BR_CUSTOMER_TRX_EXTS
29: WHERE ELECTRONIC_INV_STATUS IN ('2','7')
30: AND CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
31: AND NOT EXISTS ( SELECT 'X' FROM AR_PAYMENT_SCHEDULES
32: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
33: AND SELECTED_FOR_RECEIPT_BATCH_ID = -999);
34:
35: l_proceed_flag VARCHAR2(1) := 'F';
84: IF (l_country_code = 'BR') THEN
85:
86: FOR BATCH_SOURCE_REC IN C_BATCH_SOURCE LOOP
87: IF BATCH_SOURCE_REC.GLOBAL_ATTRIBUTE5 = 'Y' THEN
88: UPDATE AR_PAYMENT_SCHEDULES_ALL
89: SET SELECTED_FOR_RECEIPT_BATCH_ID = -999
90: WHERE CUSTOMER_TRX_ID = p_customer_trx_id;
91: END IF;
92: END LOOP;
1349: l_trx_amount NUMBER;
1350: l_CM_type VARCHAR2(20);
1351: l_CM_status VARCHAR2(20);
1352: CURSOR C_trx_details( p_trx_id IN NUMBER ) IS
1353: SELECT selected_for_receipt_batch_id, sum(amount_due_remaining) FROM ar_payment_schedules WHERE customer_trx_id = p_trx_id
1354: GROUP BY customer_trx_id,selected_for_receipt_batch_id;
1355: CURSOR C_CM_Details( p_type_id IN NUMBER ) IS
1356: SELECT TYPE, DEFAULT_STATUS FROM ra_cust_trx_types WHERE cust_trx_type_id = p_type_id;
1357: L_COUNTRY_CODE varchar2(30);
1368: CLOSE C_CM_Details;
1369:
1370: IF l_trx_status = -999 THEN
1371: IF l_CM_type = 'CM' AND l_CM_status = 'VD' AND (l_trx_amount + p_CM_amount) = 0 THEN
1372: UPDATE ar_payment_schedules
1373: SET selected_for_receipt_batch_id = NULL
1374: WHERE selected_for_receipt_batch_id = -999 AND
1375: customer_trx_id = p_inv_customer_trx_id;
1376: RETURN 1;