1333: WHERE customer_trx_id = cp_customer_trx_id
1334: FOR UPDATE NOWAIT;
1335:
1336:
1337: --Get the first_installment_code and base_amount from ra_terms
1338: CURSOR cur_term_details(cp_term_id ra_terms.term_id%TYPE)
1339: IS
1340: SELECT first_installment_code,
1341: DECODE(base_amount, 0, 1, base_amount) base_amount
1334: FOR UPDATE NOWAIT;
1335:
1336:
1337: --Get the first_installment_code and base_amount from ra_terms
1338: CURSOR cur_term_details(cp_term_id ra_terms.term_id%TYPE)
1339: IS
1340: SELECT first_installment_code,
1341: DECODE(base_amount, 0, 1, base_amount) base_amount
1342: FROM ra_terms
1338: CURSOR cur_term_details(cp_term_id ra_terms.term_id%TYPE)
1339: IS
1340: SELECT first_installment_code,
1341: DECODE(base_amount, 0, 1, base_amount) base_amount
1342: FROM ra_terms
1343: WHERE term_id = cp_term_id;
1344:
1345:
1346: --Get the relative_amount from ra_terms_lines
1342: FROM ra_terms
1343: WHERE term_id = cp_term_id;
1344:
1345:
1346: --Get the relative_amount from ra_terms_lines
1347: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1348: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1349: IS
1350: SELECT relative_amount
1343: WHERE term_id = cp_term_id;
1344:
1345:
1346: --Get the relative_amount from ra_terms_lines
1347: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1348: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1349: IS
1350: SELECT relative_amount
1351: FROM ra_terms_lines
1344:
1345:
1346: --Get the relative_amount from ra_terms_lines
1347: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1348: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1349: IS
1350: SELECT relative_amount
1351: FROM ra_terms_lines
1352: WHERE term_id = cp_term_id
1347: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1348: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1349: IS
1350: SELECT relative_amount
1351: FROM ra_terms_lines
1352: WHERE term_id = cp_term_id
1353: AND sequence_num = cp_sequence_num;
1354:
1355:
1902: OPEN cur_min_payment_schedule(ln_previous_customer_trx_id);
1903: FETCH cur_min_payment_schedule INTO rec_inv_payment_schedule;
1904: CLOSE cur_min_payment_schedule;
1905:
1906: --Get the first_installment_code and base_amount from ra_terms
1907: OPEN cur_term_details(rec_inv_payment_schedule.term_id);
1908: FETCH cur_term_details INTO rec_term_details;
1909: CLOSE cur_term_details;
1910:
1937: fnd_file.put_line(FND_FILE.LOG, 'In rec_payment LOOP');
1938: END IF;
1939:
1940:
1941: --Get the relative_amount from ra_terms_lines
1942: OPEN cur_term_lines(rec_payment.term_id,
1943: rec_payment.terms_sequence_number);
1944: FETCH cur_term_lines INTO ln_relative_amt;
1945: CLOSE cur_term_lines;
2174: IF p_debug = 'Y' THEN
2175: fnd_file.put_line(FND_FILE.LOG, 'In else of previous_customer_trx_id');
2176: END IF;
2177:
2178: --Get the first_installment_code and base_amount from ra_terms
2179: OPEN cur_term_details(rec_min_payment_schedule.term_id);
2180: FETCH cur_term_details INTO rec_term_details;
2181: CLOSE cur_term_details;
2182:
2188: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_payment.payment_schedule_id'||rec_payment.payment_schedule_id);
2189: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_term_details.first_installment_code'||rec_term_details.first_installment_code);
2190: END IF;
2191:
2192: --Get the relative_amount from ra_terms_lines
2193: OPEN cur_term_lines(rec_payment.term_id,
2194: rec_payment.terms_sequence_number);
2195: FETCH cur_term_lines INTO ln_relative_amt;
2196: CLOSE cur_term_lines;