[Home] [Help]
88: v_once_completed_flag Varchar2(1);
89:
90: CURSOR excise_cal_cur IS
91: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
92: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
93: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
94: and A.tax_id = B.tax_id
95: order by 1;
96:
245: WHERE il.customer_trx_id = v_customer_trx_id
246: AND NVL(il.interface_status , '~') <> 'P'
247: );
248:
249: DELETE JAI_AR_TRX_TAX_LINES
250: WHERE LINK_TO_CUST_TRX_LINE_ID = v_customer_trx_line_id;
251:
252: -- the followining delete from temp_lines_insert added by sriram bug # 2590650
253:
346: a.precedence_9 p_9, a.precedence_10 p_10,
347: a.tax_rate, a.tax_amount, a.uom uom_code, a.qty_rate,
348: decode(upper(b.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0) tax_type_val,
349: b.tax_type
350: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
351: WHERE a.customer_trx_line_id = v_prev_customer_trx_line_id
352: AND a.tax_id = b.tax_id;
353:
354:
535: FOR rec in localization_tax_info
536: LOOP
537: -- Date 23/02/2006 by sacsethi for bug 5228046
538: -- precedence 6 to 10
539: INSERT INTO JAI_AR_TRX_TAX_LINES
540: (customer_trx_line_id,
541: link_to_cust_trx_line_id,
542: tax_line_no,
543: precedence_1,
1097: FROM JAI_AR_TRX_LINES
1098: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
1099: CURSOR DUPLICATE_TAX_LINES_CUR(v_tax_id NUMBER) IS
1100: SELECT 1
1101: FROM JAI_AR_TRX_TAX_LINES
1102: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
1103: AND tax_id = v_tax_id;
1104: v_line_count NUMBER;
1105: v_tax_line_count NUMBER;
1268: */
1269: -- bug # 3000550 sriram
1270: cursor c_cust_trx_tax_line_amt is
1271: select nvl(sum(tax_amount),0)
1272: from JAI_AR_TRX_TAX_LINES
1273: where link_to_cust_trx_line_id = v_customer_trx_line_id;
1274: -- bug # 3000550 sriram
1275: -- End of bug 3328871
1276:
1441: IF v_tax_type NOT IN ('Excise','Other Excise','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS',jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) THEN
1442: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
1443: -- Date 23/02/2006 by sacsethi for bug 5228046
1444: -- precedence 6 to 10
1445: INSERT INTO JAI_AR_TRX_TAX_LINES
1446: (
1447: tax_line_no ,
1448: customer_trx_line_id ,
1449: link_to_cust_trx_line_id ,
1497: so_taxes_rec.last_updated_by,
1498: so_taxes_rec.last_update_login
1499: );
1500:
1501: FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRX_TAX_LINES');
1502:
1503: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1504:
1505: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
1509:
1510: -- handle for the case where the register code is not BOND_REG
1511: -- Date 23/02/2006 by sacsethi for bug 5228046
1512: -- precedence 6 to 10
1513: INSERT INTO JAI_AR_TRX_TAX_LINES
1514: (
1515: TAX_LINE_NO ,
1516: CUSTOMER_TRX_LINE_ID ,
1517: LINK_TO_CUST_TRX_LINE_ID ,
1565: so_taxes_rec.last_updated_by,
1566: so_taxes_rec.last_update_login
1567: );
1568: FND_FILE.PUT_LINE(FND_FILE.LOG,
1569: ' Else - After insert into JAI_AR_TRX_TAX_LINES');
1570: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1571: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax amount: '|| v_tax_amount);
1572:
1573: end if; -- for 'BOND_REG'
1863: )
1864: is
1865: select count(1)
1866: from jai_regime_tax_types_v jrttv
1867: , JAI_AR_TRX_TAX_LINES jrctt
1868: , JAI_CMN_TAXES_ALL jtc
1869: where jtc.tax_id = jrctt.tax_id
1870: and jtc.tax_type = jrttv.tax_type
1871: and regime_code = cp_regime_code
1879: /*added for bug#6498072*/
1880: Cursor get_ar_tax_amount
1881: is
1882: select sum(tax_amount)
1883: from JAI_AR_TRX_TAX_LINES
1884: Where link_to_cust_trx_line_id = v_customer_trx_line_id;
1885:
1886: ln_ar_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%type;
1887:
1882: select sum(tax_amount)
1883: from JAI_AR_TRX_TAX_LINES
1884: Where link_to_cust_trx_line_id = v_customer_trx_line_id;
1885:
1886: ln_ar_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%type;
1887:
1888: begin
1889: FND_FILE.PUT_LINE(FND_FILE.LOG,
1890: ' Inside Procedure process_bill_only_invoice');
2032: ' After insert into JAI_AR_TRXS - Bill only invoice');
2033: end if;
2034:
2035: /*
2036: insert into the JAI_AR_TRX_TAX_LINES table and then insert into the JAI_AR_TRX_LINES table.
2037: pr_new.interface_line_attribute6 = order_line_id
2038: pr_new.interface_line_context = 'ORDER ENTRY'
2039: */
2040:
2072: because of the return statement above.
2073: */
2074: /* Date 23/02/2006 by sacsethi for bug 5228046
2075: precedence 6 to 10 */
2076: INSERT INTO JAI_AR_TRX_TAX_LINES
2077: (
2078: tax_line_no ,
2079: customer_trx_line_id ,
2080: link_to_cust_trx_line_id ,
2132: end if; /* end if for tax type not in excise .... */
2133: else /* register association is not bond register , so all taxes can flow */
2134: /* Date 23/02/2006 by sacsethi for bug 5228046
2135: precedence 6 to 10 */
2136: INSERT INTO JAI_AR_TRX_TAX_LINES
2137: (
2138: tax_line_no ,
2139: customer_trx_line_id ,
2140: link_to_cust_trx_line_id ,
2251: end if;
2252: /* Get line number after which threshold taxes needs to be defaulted */
2253: select max(tax_line_no)
2254: into ln_last_line_no
2255: from JAI_AR_TRX_TAX_LINES
2256: where link_to_cust_trx_line_id = v_customer_trx_line_id;
2257: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
2258: select max(tax_line_no)
2259: into ln_base_line_no
2256: where link_to_cust_trx_line_id = v_customer_trx_line_id;
2257: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
2258: select max(tax_line_no)
2259: into ln_base_line_no
2260: from JAI_AR_TRX_TAX_LINES jrctt
2261: , JAI_CMN_TAXES_ALL jtc
2262: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
2263: and jrctt.tax_id = jtc.tax_id
2264: and jtc.tax_type = jai_constants.tax_type_tcs;
2427: 4. 2001/05/03 Gadde,Jagdish
2428: Check added to avoid firing of trigger for Non_Indian OU.
2429: 5. 2001/06/05 Anuradha Parthasarathy
2430: Cursor added to take care of correct tax insertions
2431: into JAI_AR_TRX_TAX_LINES
2432: 6. 2001/09/13 Vijay
2433: Added condition of interface_line_context to return
2434: for Project Accounting
2435: 7. 2001/11/01 Anuradha Parthasarathy
2445: 9. 2002/04/22 SRIRAM For Bug # 2316589 . The JAI_AR_TRXS table was updated with
2446: wrong values . Instead a new update has been written using a different value to
2447: update tax amounts correctly.
2448: 10 2002/06/26 SRIRAM For Bug # 2398198 . Tax Lines were inserted multiple times in the
2449: JAI_AR_TRX_TAX_LINES , JAI_AR_TRX_LINES tables when discounts
2450: exist and tax amounts were updated doubly in JAI_AR_TRXS table, which have been
2451: solved in this bug.
2452: 11. 2002/08/17 SRIRAM .Fopr Bug # 2518534 . When there is a change in UOM in the
2453: Sales order screen , the taxes in the localization screen are not
2478:
2479: 15. 2003/06/26 Sriram - Bug # 3000550 version 616.1
2480: Tax amounts were not calculated correctly , in the JAI_AR_TRXS and JAI_AR_TRX_LINES
2481: table.This was observed when there was a split done during shipment.
2482: Data was correct in the JAI_AR_TRX_TAX_LINES table , but incorrect in the JAI_AR_TRX_LINES
2483: and JAI_AR_TRXS table.
2484: This has been fixed in this bug
2485:
2486: 16. 2003/08/22 Sriram - Bug # 3021588 version 616.2
2639: 35. 16-oCT-2007 CSahoo for bug#6498072, File Version 120.21
2640: Multipled p_quantity to the assesible value in the call to the procedure jai_rgm_thhold_proc_pkg.default_thhold_taxes
2641:
2642: 36. 18-OCT-2007 CSahoo for bug#6498072, File Version 120.22
2643: Added the cursor get_ar_tax_amount to get the total tax amount from JAI_AR_TRX_TAX_LINES table.
2644: Moved the code for Inserting into JAI_AR_TRX_LINES and updating the table JAI_AR_TRXS to the end in the procedure
2645: process_bill_only_invoice
2646:
2647: 37 11-Nov-2008 JMEENA for bug#6498345( FP 6492966 )
2957: v_tax_line_no := v_tax_line_no+1;
2958:
2959: -- Date 23/02/2006 by sacsethi for bug 5228046
2960: -- precedence 6 to 10
2961: INSERT INTO JAI_AR_TRX_TAX_LINES(
2962: tax_line_no ,
2963: customer_trx_line_id ,
2964: link_to_cust_trx_line_id ,
2965: precedence_1 ,
3033: ELSIF pr_new.interface_line_attribute4 IS NOT NULL THEN -- pr_new.interface_line_attribute1, Bug# 4392001
3034: FOR Tax_Rec IN SUPPLEMENT_TAX_LINES LOOP
3035: v_tax_line_no := v_tax_line_no+1;
3036:
3037: INSERT INTO JAI_AR_TRX_TAX_LINES(
3038: tax_line_no ,
3039: customer_trx_line_id ,
3040: link_to_cust_trx_line_id ,
3041: precedence_1 ,
3652: )
3653: then
3654: -- Date 23/02/2006 by sacsethi for bug 5228046
3655: -- precedence 6 to 10
3656: INSERT INTO JAI_AR_TRX_TAX_LINES (
3657: tax_line_no ,
3658: customer_trx_line_id ,
3659: link_to_cust_trx_line_id ,
3660: precedence_1 ,
3729: )
3730: then
3731: -- Date 23/02/2006 by sacsethi for bug 5228046
3732: -- precedence 6 to 10
3733: INSERT INTO JAI_AR_TRX_TAX_LINES(
3734: tax_line_no ,
3735: customer_trx_line_id ,
3736: link_to_cust_trx_line_id ,
3737: precedence_1 ,
3835: FETCH ja_so_lines_tax_record_check INTO v_exist_flag;
3836: CLOSE ja_so_lines_tax_record_check;
3837: /*
3838: Check if a tax line exists in ja_in_so_tax_lines_table
3839: IF yes then insert all the taxes into JAI_AR_TRX_TAX_LINES table.
3840: */
3841: IF NVL(v_exist_flag,0) = 1 THEN
3842: FOR tax_rec IN ja_so_tax_lines_info LOOP
3843: -- Date 23/02/2006 by sacsethi for bug 5228046
3841: IF NVL(v_exist_flag,0) = 1 THEN
3842: FOR tax_rec IN ja_so_tax_lines_info LOOP
3843: -- Date 23/02/2006 by sacsethi for bug 5228046
3844: -- precedence 6 to 10
3845: INSERT INTO JAI_AR_TRX_TAX_LINES(
3846: tax_line_no ,
3847: customer_trx_line_id ,
3848: link_to_cust_trx_line_id ,
3849: precedence_1 ,
4358: IS
4359: SELECT
4360: nvl(sum(tax_amount),0)
4361: FROM
4362: JAI_AR_TRX_TAX_LINES
4363: WHERE
4364: link_to_cust_trx_line_id = pr_new.customer_trx_line_id ;
4365: /*added by csahoo for bug#6407648, end*/
4366:
4664: )
4665: then
4666: -- Date 23/02/2006 by sacsethi for bug 5228046
4667: -- precedence 6 to 10
4668: INSERT INTO JAI_AR_TRX_TAX_LINES
4669: (
4670: tax_line_no,
4671: customer_trx_line_id,
4672: link_to_cust_trx_line_id,
4966: WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
4967:
4968: CURSOR excise_cal_cur IS
4969: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
4970: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
4971: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
4972: AND A.tax_id = B.tax_id
4973: ORDER BY 1;
4974:
5227: tax_amount = nvl(tax_amount,0) - nvl(v_old_tax_tot,0),
5228: total_amount = nvl(total_amount,0) - (nvl(v_old_line_amount,0) + nvl(v_old_tax_tot,0))
5229: WHERE customer_trx_id = pr_old.CUSTOMER_TRX_ID;
5230:
5231: DELETE JAI_AR_TRX_TAX_LINES
5232: WHERE LINK_TO_CUST_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
5233:
5234: DELETE JAI_AR_TRX_LINES
5235: WHERE CUSTOMER_TRX_ID = pr_old.CUSTOMER_TRX_ID
5600: WHERE customer_trx_id = v_header_id;
5601:
5602: CURSOR excise_cal_cur IS
5603: select A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
5604: from JAI_AR_TRX_TAX_LINES A ,
5605: JAI_CMN_TAXES_ALL B
5606: where link_to_cust_trx_line_id = pr_old.customer_trx_line_id
5607: and A.tax_id = B.tax_id
5608: order by 1;
5934: -- WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
5935:
5936: CURSOR excise_cal_cur IS
5937: select A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
5938: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
5939: where link_to_cust_trx_line_id = pr_old.customer_trx_line_id
5940: and A.tax_id = B.tax_id
5941: order by 1;
5942:
6530: else
6531: ln_base_tax_amount := ln_tax_amount;
6532: end if;
6533:
6534: insert into jai_ar_trx_tax_lines(
6535: tax_line_no ,
6536: customer_trx_line_id ,
6537: link_to_cust_trx_line_id ,
6538: precedence_1 ,