eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_MATCH_TAX_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 443: --This procedure updates the MRC data for ra_cust_trx_line_gl_dist_all, ar_payment_schedules_all,

439: END process_batch;
440:
441: ------------------------------------------------ ---------------------------------------
442: --=========================================================================================--
443: --This procedure updates the MRC data for ra_cust_trx_line_gl_dist_all, ar_payment_schedules_all,
444: --ar_receivable_applications_all
445: --=========================================================================================--
446:
447: PROCEDURE maintain_mrc( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

Line 468: FROM ar_payment_schedules_all

464:
465: CURSOR cur_payment_schedule_mrc(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
466: IS
467: SELECT payment_schedule_id
468: FROM ar_payment_schedules_all
469: WHERE customer_trx_id = cp_customer_trx_id;
470:
471: --get the cust_trx_line_gl_dist_id for the REC row from ra_cust_trx_line_gl_dist_all
472: CURSOR cur_gl_dist(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

Line 698: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

694: p_process_message := SUBSTR(SQLERRM,1,300);
695: END maintain_applications;
696:
697: --=========================================================================================--
698: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
699: --=========================================================================================--
700:
701: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
702: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,

Line 702: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,

698: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
699: --=========================================================================================--
700:
701: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
702: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
703: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
704: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
705: p_concurrent_req_num IN NUMBER,
706: p_request_id IN NUMBER,

Line 798: FROM ar_payment_schedules_all

794: ld_creation_date,
795: ln_last_updated_by,
796: ld_last_update_date,
797: ln_last_update_login
798: FROM ar_payment_schedules_all
799: WHERE customer_trx_id = p_customer_trx_id
800: AND payment_schedule_id = NVL(p_payment_schedule_id, payment_schedule_id);
801:
802: ELSIF p_operation_type = 'UPDATE' THEN

Line 836: FROM ar_payment_schedules_all b

832: actual_date_closed,
833: ln_last_updated_by,
834: ld_last_update_date,
835: ln_last_update_login
836: FROM ar_payment_schedules_all b
837: WHERE customer_trx_id = a.original_customer_trx_id
838: AND payment_schedule_id = a.payment_schedule_id)
839: WHERE original_customer_trx_id = p_customer_trx_id
840: AND payment_schedule_id = NVL(p_payment_schedule_id, payment_schedule_id)

Line 1193: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id

1189: SELECT allow_overapplication_flag
1190: FROM ra_cust_trx_types_all
1191: WHERE cust_trx_type_id = cp_cust_trx_type_id;
1192:
1193: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
1194: CURSOR cur_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1195: cp_payment_Schedule_id ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL)
1196: IS
1197: SELECT payment_schedule_id,

Line 1195: cp_payment_Schedule_id ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL)

1191: WHERE cust_trx_type_id = cp_cust_trx_type_id;
1192:
1193: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
1194: CURSOR cur_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1195: cp_payment_Schedule_id ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL)
1196: IS
1197: SELECT payment_schedule_id,
1198: term_id,
1199: terms_sequence_number,

Line 1206: FROM ar_payment_schedules_all

1202: tax_original,
1203: tax_remaining,
1204: freight_original,
1205: amount_due_remaining
1206: FROM ar_payment_schedules_all
1207: WHERE customer_trx_id = cp_customer_trx_id
1208: AND payment_schedule_id = NVL(cp_payment_schedule_id, payment_schedule_id);
1209:
1210: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type

Line 1305: --get the min(payment_schedule_id) and term_id from ar_payment_schedules_all for customer_trx_id

1301: AND customer_trx_line_id = cp_customer_trx_line_id
1302: AND line_type = lv_line_type_line; --'LINE'
1303:
1304:
1305: --get the min(payment_schedule_id) and term_id from ar_payment_schedules_all for customer_trx_id
1306: CURSOR cur_min_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1307: IS
1308: SELECT MIN(payment_schedule_id) payment_schedule_id,
1309: MIN(term_id) term_id

Line 1310: FROM ar_payment_schedules_all

1306: CURSOR cur_min_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1307: IS
1308: SELECT MIN(payment_schedule_id) payment_schedule_id,
1309: MIN(term_id) term_id
1310: FROM ar_payment_schedules_all
1311: WHERE customer_trx_id = cp_customer_trx_id;
1312:
1313:
1314: --get the data from ra_customer_trx_all for a customer_trx_id

Line 1413: --Get the data from ar_payment_schedules_all for customer_trx_id

1409: AND display = 'Y'
1410: and status = 'APP'
1411: AND applied_payment_Schedule_id = cp_applied_payment_Schedule_id;
1412:
1413: --Get the data from ar_payment_schedules_all for customer_trx_id
1414: CURSOR cur_prev_payment_schedule( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1415: cp_payment_Schedule_id ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL)
1416: IS
1417: SELECT amount_line_items_original,

Line 1415: cp_payment_Schedule_id ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL)

1411: AND applied_payment_Schedule_id = cp_applied_payment_Schedule_id;
1412:
1413: --Get the data from ar_payment_schedules_all for customer_trx_id
1414: CURSOR cur_prev_payment_schedule( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1415: cp_payment_Schedule_id ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL)
1416: IS
1417: SELECT amount_line_items_original,
1418: amount_line_items_remaining,
1419: tax_original,

Line 1423: FROM ar_payment_schedules_all

1419: tax_original,
1420: tax_remaining,
1421: freight_original,
1422: amount_due_remaining
1423: FROM ar_payment_schedules_all
1424: WHERE customer_trx_id = cp_customer_trx_id
1425: AND payment_schedule_id = NVL(cp_payment_schedule_id, payment_schedule_id);
1426:
1427: CURSOR ORG_CUR IS

Line 1555: --get the min(payment_schedule_id) and term_id from ar_payment_schedules_all for customer_trx_id

1551: ELSE
1552: ln_inv_curr_conv_rate := rec_customer_trx.exchange_rate;
1553: END IF;
1554:
1555: --get the min(payment_schedule_id) and term_id from ar_payment_schedules_all for customer_trx_id
1556: OPEN cur_min_payment_schedule(p_customer_trx_id);
1557: FETCH cur_min_payment_schedule INTO rec_min_payment_schedule;
1558: CLOSE cur_min_payment_schedule;
1559:

Line 1848: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

1844:
1845: ln_payment_audit_id := NULL;
1846: ln_rec_appl_audit_id := NULL;
1847:
1848: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
1849: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
1850: p_payment_schedule_id => NULL,
1851: p_cm_customer_trx_id => p_customer_trx_id,
1852: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

Line 1870: UPDATE ar_payment_schedules_all

1866: IF p_debug = 'Y' THEN
1867: fnd_file.put_line(FND_FILE.LOG, 'After INSERT call to maintain_schedules');
1868: END IF;
1869:
1870: UPDATE ar_payment_schedules_all
1871: SET amount_due_original = ROUND(NVL(amount_line_items_original,0) + ln_total_tax_amt_for_inv + ln_total_frt_amt_for_inv, ln_precision),
1872: tax_original = ROUND(ln_total_tax_amt_for_inv, ln_precision),
1873: freight_original = ROUND(ln_total_frt_amt_for_inv, ln_precision),
1874: amount_applied = ROUND(NVL(amount_line_items_original,0) + ln_total_tax_amt_for_inv + ln_total_frt_amt_for_inv, ln_precision),

Line 1878: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

1874: amount_applied = ROUND(NVL(amount_line_items_original,0) + ln_total_tax_amt_for_inv + ln_total_frt_amt_for_inv, ln_precision),
1875: last_update_date = SYSDATE
1876: WHERE customer_trx_id = p_customer_trx_id;
1877:
1878: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
1879: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
1880: p_payment_schedule_id => NULL,
1881: p_cm_customer_trx_id => p_customer_trx_id,
1882: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

Line 1901: --get the min(payment_schedule_id) and term_id from ar_payment_schedules_all for customer_trx_id

1897: fnd_file.put_line(FND_FILE.LOG, 'After UPDATE call to maintain_schedules');
1898: END IF;
1899:
1900:
1901: --get the min(payment_schedule_id) and term_id from ar_payment_schedules_all for customer_trx_id
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:

Line 1933: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id

1929: IF p_debug = 'Y' THEN
1930: fnd_file.put_line(FND_FILE.LOG, 'Before entering rec_payment LOOP');
1931: END IF;
1932:
1933: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
1934: FOR rec_payment in cur_payment_schedule(ln_previous_customer_trx_id)
1935: LOOP
1936: IF p_debug = 'Y' THEN
1937: fnd_file.put_line(FND_FILE.LOG, 'In rec_payment LOOP');

Line 1982: --Get the data from ar_payment_schedules_all for customer_trx_id

1978: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_trx_types');
1979: END IF;
1980:
1981:
1982: --Get the data from ar_payment_schedules_all for customer_trx_id
1983: OPEN cur_prev_payment_schedule( ln_previous_customer_trx_id,
1984: rec_payment.payment_schedule_id);
1985: FETCH cur_prev_payment_schedule INTO rec_prev_payment_schedule;
1986: CLOSE cur_prev_payment_schedule;

Line 2008: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

2004: IF ( NVL(lv_allow_overappln_flag,'N') = 'Y' ) OR
2005: ( NVL(lv_allow_overappln_flag,'N') = 'N' AND ln_amt_due_rem >= 0 )
2006: THEN
2007:
2008: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2009: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2010: p_payment_schedule_id => rec_payment.payment_schedule_id,
2011: p_cm_customer_trx_id => p_customer_trx_id,
2012: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

Line 2030: UPDATE ar_payment_schedules_all

2026: IF p_debug = 'Y' THEN
2027: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_schedules');
2028: END IF;
2029:
2030: UPDATE ar_payment_schedules_all
2031: SET amount_due_remaining = ROUND (ln_amt_due_rem ,ln_precision) ,
2032: tax_remaining = ROUND(tax_original - ln_tax_amt_cashrcpt + NVL(ln_inst_tax_amt_for_inv,0),ln_precision) ,
2033: freight_remaining = ROUND(freight_original - ln_frt_amt_cashrcpt + NVL(ln_inst_frt_amt_for_inv,0),ln_precision) ,
2034: acctd_amount_due_remaining = ROUND(ln_amt_due_rem * ln_inv_curr_conv_rate, ln_precision) ,

Line 2042: fnd_file.put_line(FND_FILE.LOG, 'After first update fo ar_payment_schedules_all');

2038: AND payment_schedule_id = rec_payment.payment_schedule_id;
2039:
2040:
2041: IF p_debug = 'Y' THEN
2042: fnd_file.put_line(FND_FILE.LOG, 'After first update fo ar_payment_schedules_all');
2043: END IF;
2044:
2045: UPDATE ar_payment_schedules_all
2046: SET status = DECODE (amount_due_remaining, 0, 'CL', 'OP'),

Line 2045: UPDATE ar_payment_schedules_all

2041: IF p_debug = 'Y' THEN
2042: fnd_file.put_line(FND_FILE.LOG, 'After first update fo ar_payment_schedules_all');
2043: END IF;
2044:
2045: UPDATE ar_payment_schedules_all
2046: SET status = DECODE (amount_due_remaining, 0, 'CL', 'OP'),
2047: gl_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('31/12/4712','DD/MM/RRRR') /* Commented by Nprashar for Bug #6784276(SYSDATE -100000 )*/ ), --TO_DATE('31-DEC-4712','DD-MON-YYYY')) ,
2048: actual_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('31/12/4712','DD/MM/RRRR') /* Commented by Nprashar for Bug #6784276(SYSDATE -100000 )*/ ),-- TO_DATE('31-DEC-4712','DD-MON-YYYY')),
2049: last_update_date = SYSDATE

Line 2054: fnd_file.put_line(FND_FILE.LOG, 'After second update fo ar_payment_schedules_all');

2050: WHERE customer_trx_id = ln_previous_customer_trx_id
2051: AND payment_schedule_id = rec_payment.payment_schedule_id;
2052:
2053: IF p_debug = 'Y' THEN
2054: fnd_file.put_line(FND_FILE.LOG, 'After second update fo ar_payment_schedules_all');
2055: END IF;
2056:
2057: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2058: maintain_schedules( p_customer_trx_id => p_customer_trx_id,

Line 2057: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

2053: IF p_debug = 'Y' THEN
2054: fnd_file.put_line(FND_FILE.LOG, 'After second update fo ar_payment_schedules_all');
2055: END IF;
2056:
2057: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2058: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2059: p_payment_schedule_id => rec_payment.payment_schedule_id,
2060: p_cm_customer_trx_id => p_customer_trx_id,
2061: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

Line 2183: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id

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:
2183: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
2184: FOR rec_payment in cur_payment_schedule(p_customer_trx_id)
2185: LOOP
2186:
2187: IF p_debug = 'Y' THEN

Line 2209: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

2205: ln_inst_tax_amt_for_inv := ln_total_tax_amt_for_inv * ln_apportion_factor;
2206: ln_inst_frt_amt_for_inv := ln_total_frt_amt_for_inv * ln_apportion_factor;
2207:
2208:
2209: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2210: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2211: p_payment_schedule_id => rec_payment.payment_schedule_id,
2212: p_cm_customer_trx_id => NULL,
2213: p_invoice_customer_trx_id => p_customer_trx_id,

Line 2231: UPDATE ar_payment_schedules_all

2227: IF p_debug = 'Y' THEN
2228: fnd_file.put_line(FND_FILE.LOG, 'After call to maintain_schedules');
2229: END IF;
2230:
2231: UPDATE ar_payment_schedules_all
2232: SET amount_due_original = ROUND(NVL(amount_line_items_original,0) + NVL(ln_inst_tax_amt_for_inv,0) + NVL(ln_inst_frt_amt_for_inv,0) , ln_precision),
2233: amount_due_remaining = ROUND(NVL(amount_line_items_remaining,0) + NVL(ln_inst_tax_amt_for_inv,0) + NVL(ln_inst_frt_amt_for_inv,0), ln_precision),
2234: tax_original = ROUND(NVL(ln_inst_tax_amt_for_inv,0), ln_precision),
2235: tax_remaining = ROUND(NVL(ln_inst_tax_amt_for_inv,0), ln_precision),

Line 2244: fnd_file.put_line(FND_FILE.LOG, 'After First update of ar_payment_schedules_all');

2240: WHERE customer_trx_id = p_customer_trx_id
2241: AND payment_schedule_id = rec_payment.payment_schedule_id;
2242:
2243: IF p_debug = 'Y' THEN
2244: fnd_file.put_line(FND_FILE.LOG, 'After First update of ar_payment_schedules_all');
2245: END IF;
2246:
2247: UPDATE ar_payment_schedules_all
2248: SET status = DECODE (amount_due_remaining, 0, 'CL', 'OP'),

Line 2247: UPDATE ar_payment_schedules_all

2243: IF p_debug = 'Y' THEN
2244: fnd_file.put_line(FND_FILE.LOG, 'After First update of ar_payment_schedules_all');
2245: END IF;
2246:
2247: UPDATE ar_payment_schedules_all
2248: SET status = DECODE (amount_due_remaining, 0, 'CL', 'OP'),
2249: gl_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('31/12/4712','DD/MM/RRRR') /* Commented by Nprashar for Bug #6784276(SYSDATE -100000 )*/ ), --TO_DATE('31-DEC-4712','DD-MON-YYYY')) ,
2250: actual_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('31/12/4712','DD/MM/RRRR') /* Commented by Nprashar for Bug #6784276(SYSDATE -100000 )*/ ), --TO_DATE('31-DEC-4712','DD-MON-YYYY')),
2251: last_update_date = SYSDATE

Line 2256: fnd_file.put_line(FND_FILE.LOG, 'After Second update of ar_payment_schedules_all '||SQL%ROWCOUNT);

2252: WHERE customer_trx_id = p_customer_trx_id
2253: AND payment_schedule_id = rec_payment.payment_schedule_id;
2254:
2255: IF p_debug = 'Y' THEN
2256: fnd_file.put_line(FND_FILE.LOG, 'After Second update of ar_payment_schedules_all '||SQL%ROWCOUNT);
2257: END IF;
2258:
2259:
2260: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

Line 2260: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

2256: fnd_file.put_line(FND_FILE.LOG, 'After Second update of ar_payment_schedules_all '||SQL%ROWCOUNT);
2257: END IF;
2258:
2259:
2260: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2261: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2262: p_payment_schedule_id => rec_payment.payment_schedule_id,
2263: p_cm_customer_trx_id => NULL,
2264: p_invoice_customer_trx_id => p_customer_trx_id,

Line 2292: --This procedure updates the MRC data for ra_cust_trx_line_gl_dist_all, ar_payment_schedules_all, ar_receivable_applications_all

2288: END LOOP; --End cursor rec_payment
2289: END IF;
2290:
2291:
2292: --This procedure updates the MRC data for ra_cust_trx_line_gl_dist_all, ar_payment_schedules_all, ar_receivable_applications_all
2293: maintain_mrc( p_customer_trx_id => p_customer_trx_id,
2294: p_previous_cust_trx_id => ln_previous_customer_trx_id,
2295: p_called_from => 7/13/2007,
2296: p_process_status => lv_process_status,

Line 2431: From Ar_Payment_Schedules_All

2427:
2428: --2001/06/26 Anuradha Parthasarathy
2429: Cursor payment_schedule_cur IS
2430: Select min(payment_schedule_id)
2431: From Ar_Payment_Schedules_All
2432: Where Customer_trx_ID = p_customer_trx_id;
2433:
2434: /* AR Transactions with Invoicing Acctg Rules not supported by Localization, Enhancement Done on 16th NOV */
2435: Cursor accounting_set_cur IS

Line 2452: from ar_payment_schedules_all

2448: v_prev_customer_trx_id Number;
2449:
2450: Cursor Inv_payment_schedule_cur(p_prev_customer_trx_id IN Number) is
2451: Select payment_schedule_id
2452: from ar_payment_schedules_all
2453: where customer_trx_id = p_prev_customer_trx_id;
2454:
2455: --2001/07/04 Anuradha Parthasarathy
2456: v_interface_line_attribute6 Varchar2(30);

Line 2817: Update Ar_Payment_Schedules_All

2813: DELETE RA_CUSTOMER_TRX_LINES_ALL
2814: WHERE LINK_TO_CUST_TRX_LINE_ID = LINK_REC.LINK_TO_CUST_TRX_LINE_ID;
2815: v_sql_num :=16;
2816:
2817: Update Ar_Payment_Schedules_All
2818: Set Tax_Original = 0,
2819: Tax_Remaining = 0,
2820: Freight_Original = 0,
2821: Freight_Remaining = 0,

Line 3097: Update Ar_Payment_Schedules_All

3093: If v_prev_customer_trx_id is null then
3094:
3095: v_sql_num :=32;
3096:
3097: Update Ar_Payment_Schedules_All
3098: Set Tax_Original = NVL(Tax_Original,0) + NVL(v_tax_amount,0),
3099: Tax_Remaining = NVL(Tax_Remaining,0) + NVL(v_tax_amount,0),
3100: Freight_Original = NVL(Freight_Original,0) + NVL(v_freight_amount,0),
3101: Freight_Remaining = NVL(Freight_Remaining,0) + NVL(v_freight_amount,0),

Line 3179: Update Ar_Payment_Schedules_All

3175:
3176: --2001/07/04 Anuradha Parthasarathy
3177:
3178: IF v_return_reference_type_code = 'Sales Order India' and v_credit_invoice_line_id IS NULL THEN
3179: Update Ar_Payment_Schedules_All
3180: Set Tax_Original = NVL(Tax_Original,0) + NVL(v_tax_amount,0),
3181: Freight_Original = NVL(Freight_Original,0) + NVL(v_freight_amount,0),
3182: Amount_Due_Original = NVL(Amount_Due_Original,0) + NVL(v_receivable_amount,0)
3183: Where Customer_Trx_ID = p_customer_trx_id

Line 3205: Update Ar_Payment_Schedules_All

3201: WHERE customer_trx_id = p_customer_trx_id
3202: AND account_class = lv_acc_class_rec; --rchandan for bug#4428980
3203:
3204:
3205: Update Ar_Payment_Schedules_All
3206: Set Tax_Original = NVL(v_tax_amount1,0),
3207: Freight_Original = NVL(v_freight_amount1,0),
3208: Amount_Due_Original = NVL(Amount_line_items_Original,0) + NVL(v_tax_amount1,0) + NVL(v_freight_amount1,0),
3209: Amount_Applied = NVL(Amount_line_items_Original,0) + NVL(v_tax_amount1,0) + NVL(v_freight_amount1,0)

Line 3232: Update Ar_Payment_Schedules_All

3228: OPEN Inv_payment_schedule_cur(v_prev_customer_trx_id);
3229: FETCH Inv_payment_schedule_cur into v_payment_schedule_id;
3230: CLOSE Inv_payment_schedule_cur;
3231:
3232: Update Ar_Payment_Schedules_All
3233: Set --Tax_Remaining = NVL(Tax_remaining,0) - NVL(v_tax_amount1,0),
3234: Freight_Remaining = NVL(Freight_Remaining,0) + NVL(v_freight_amount1,0),
3235: Amount_Due_Remaining = NVL(Amount_Due_Remaining,0) + NVL(v_freight_amount1,0),
3236: Amount_Credited = NVL(Amount_Credited,0) + NVL(v_freight_amount1,0),