[Home] [Help]
121: WHERE line_id = v_interface_line_attribute6 );
122:
123: CURSOR c_cust_trx_tax_line_amt IS
124: SELECT nvl(SUM(a.tax_amount),0)
125: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
126: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
127: AND a.tax_id = b.tax_id
128: AND nvl(b.inclusive_tax_flag, 'N') = 'N';
129:
252: GROUP BY A.tax_id;
253:
254: CURSOR DUPLICATE_TAX_LINES_CUR(v_tax_id NUMBER) IS
255: SELECT 1
256: FROM JAI_AR_TRX_TAX_LINES
257: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
258: AND tax_id = v_tax_id;
259:
260:
323: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b
324: WHERE A.line_id = TO_NUMBER(v_interface_line_attribute6)
325: AND A.line_id = b.line_id;
326:
327: CURSOR c_duplicate_tax(cp_tax_id JAI_AR_TRX_TAX_LINES.tax_id%TYPE,
328: cp_link_cust_trx_line_id JAI_AR_TRX_TAX_LINES.link_to_cust_trx_line_id%TYPE)
329: IS
330: SELECT 1
331: FROM JAI_AR_TRX_TAX_LINES
324: WHERE A.line_id = TO_NUMBER(v_interface_line_attribute6)
325: AND A.line_id = b.line_id;
326:
327: CURSOR c_duplicate_tax(cp_tax_id JAI_AR_TRX_TAX_LINES.tax_id%TYPE,
328: cp_link_cust_trx_line_id JAI_AR_TRX_TAX_LINES.link_to_cust_trx_line_id%TYPE)
329: IS
330: SELECT 1
331: FROM JAI_AR_TRX_TAX_LINES
332: WHERE tax_id = cp_tax_id
327: CURSOR c_duplicate_tax(cp_tax_id JAI_AR_TRX_TAX_LINES.tax_id%TYPE,
328: cp_link_cust_trx_line_id JAI_AR_TRX_TAX_LINES.link_to_cust_trx_line_id%TYPE)
329: IS
330: SELECT 1
331: FROM JAI_AR_TRX_TAX_LINES
332: WHERE tax_id = cp_tax_id
333: AND link_to_cust_trx_line_id = cp_link_cust_trx_line_id ;
334:
335: CURSOR ja_so_lines_info IS
523: )
524: is
525: select count(1)
526: from jai_regime_tax_types_v jrttv
527: , JAI_AR_TRX_TAX_LINES jrctt
528: , JAI_CMN_TAXES_ALL jtc
529: where jtc.tax_id = jrctt.tax_id
530: and jtc.tax_type = jrttv.tax_type
531: and regime_code = cp_regime_code
539:
540: Cursor get_ar_tax_amount
541: is
542: select sum(tax_amount)
543: from JAI_AR_TRX_TAX_LINES
544: Where link_to_cust_trx_line_id = v_customer_trx_line_id;
545:
546: ln_ar_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%type;
547: l_api_name CONSTANT VARCHAR2(30) := 'process_bill_only_invoice()';
542: select sum(tax_amount)
543: from JAI_AR_TRX_TAX_LINES
544: Where link_to_cust_trx_line_id = v_customer_trx_line_id;
545:
546: ln_ar_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%type;
547: l_api_name CONSTANT VARCHAR2(30) := 'process_bill_only_invoice()';
548: begin
549: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Inside Procedure process_bill_only_invoice');
550: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
721: end if;
722: end if;
723:
724: /*
725: insert into the JAI_AR_TRX_TAX_LINES table and then insert into the JAI_AR_TRX_LINES table.
726: pr_new.interface_line_attribute6 = order_line_id
727: pr_new.interface_line_context = 'ORDER ENTRY'
728: */
729:
791: This is not a discount line , so taxes can flow. In case it was discount , control would have never come here
792: because of the return statement above.
793: */
794:
795: INSERT INTO JAI_AR_TRX_TAX_LINES
796: (
797: tax_line_no ,
798: customer_trx_line_id ,
799: link_to_cust_trx_line_id ,
850: );
851: end if; /* end if for tax type not in excise .... */
852: else /* register association is not bond register , so all taxes can flow */
853:
854: INSERT INTO JAI_AR_TRX_TAX_LINES
855: (
856: tax_line_no ,
857: customer_trx_line_id ,
858: link_to_cust_trx_line_id ,
969: end if;
970: /* Get line number after which threshold taxes needs to be defaulted */
971: select max(tax_line_no)
972: into ln_last_line_no
973: from JAI_AR_TRX_TAX_LINES
974: where link_to_cust_trx_line_id = v_customer_trx_line_id;
975: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
976: select max(tax_line_no)
977: into ln_base_line_no
974: where link_to_cust_trx_line_id = v_customer_trx_line_id;
975: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
976: select max(tax_line_no)
977: into ln_base_line_no
978: from JAI_AR_TRX_TAX_LINES jrctt
979: , JAI_CMN_TAXES_ALL jtc
980: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
981: and jrctt.tax_id = jtc.tax_id
982: and jtc.tax_type = jai_constants.tax_type_tcs;
1340: );
1341: end if;
1342: 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
1343:
1344: INSERT INTO JAI_AR_TRX_TAX_LINES
1345: (
1346: tax_line_no ,
1347: customer_trx_line_id ,
1348: link_to_cust_trx_line_id ,
1397: so_taxes_rec.last_updated_by,
1398: so_taxes_rec.last_update_login
1399: );
1400:
1401: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRX_TAX_LINES');
1402: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1403: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1404: G_MODULE_NAME || l_api_name || '.IN',
1405: G_PKG_NAME || ': ' || l_api_name || '().'||' After insert into JAI_AR_TRX_TAX_LINES '
1401: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRX_TAX_LINES');
1402: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1403: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1404: G_MODULE_NAME || l_api_name || '.IN',
1405: G_PKG_NAME || ': ' || l_api_name || '().'||' After insert into JAI_AR_TRX_TAX_LINES '
1406: );
1407: end if;
1408: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1409:
1420: else
1421:
1422: -- handle for the case where the register code is not BOND_REG
1423:
1424: INSERT INTO JAI_AR_TRX_TAX_LINES
1425: (
1426: TAX_LINE_NO ,
1427: CUSTOMER_TRX_LINE_ID ,
1428: LINK_TO_CUST_TRX_LINE_ID ,
1478: so_taxes_rec.last_update_login
1479: );
1480:
1481: /*FND_FILE.PUT_LINE(FND_FILE.LOG,
1482: ' Else - After insert into JAI_AR_TRX_TAX_LINES');*/
1483: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1484: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1485: G_MODULE_NAME || l_api_name || '.IN',
1486: G_PKG_NAME || ': ' || l_api_name || '().'||' Else - After insert into JAI_AR_TRX_TAX_LINES '
1482: ' Else - After insert into JAI_AR_TRX_TAX_LINES');*/
1483: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1484: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1485: G_MODULE_NAME || l_api_name || '.IN',
1486: G_PKG_NAME || ': ' || l_api_name || '().'||' Else - After insert into JAI_AR_TRX_TAX_LINES '
1487: );
1488: end if;
1489: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1490: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax amount: '|| v_tax_amount);
2116: (nvl(v_ont_source_code,'ORDER ENTRY') <> nvl(ltrim(rtrim(pr_new.interface_line_context)),'$$$') -- added by sriram - bug# 3607101
2117: )
2118: then
2119:
2120: INSERT INTO JAI_AR_TRX_TAX_LINES (
2121: tax_line_no ,
2122: customer_trx_line_id ,
2123: link_to_cust_trx_line_id ,
2124: precedence_1 ,
2196: (nvl(v_ont_source_code,'ORDER ENTRY') <> nvl(ltrim(rtrim(pr_new.interface_line_context)),'$$$')
2197: )
2198: then
2199:
2200: INSERT INTO JAI_AR_TRX_TAX_LINES(
2201: tax_line_no ,
2202: customer_trx_line_id ,
2203: link_to_cust_trx_line_id ,
2204: precedence_1 ,
2337: (nvl(v_ont_source_code,'ORDER ENTRY') <>
2338: nvl(ltrim(rtrim(pr_new.interface_line_context)),'$$$')
2339: )
2340: THEN
2341: INSERT INTO JAI_AR_TRX_TAX_LINES (
2342: tax_line_no ,
2343: customer_trx_line_id ,
2344: link_to_cust_trx_line_id ,
2345: precedence_1 ,
2412: (nvl(v_ont_source_code,'ORDER ENTRY') <>
2413: nvl(ltrim(rtrim(pr_new.interface_line_context)),'$$$')
2414: )
2415: THEN
2416: INSERT INTO JAI_AR_TRX_TAX_LINES(
2417: tax_line_no ,
2418: customer_trx_line_id ,
2419: link_to_cust_trx_line_id ,
2420: precedence_1 ,
2520: FETCH ja_so_lines_tax_record_check INTO v_exist_flag;
2521: CLOSE ja_so_lines_tax_record_check;
2522: /*
2523: Check if a tax line exists in ja_in_so_tax_lines_table
2524: IF yes then insert all the taxes into JAI_AR_TRX_TAX_LINES table.
2525: */
2526: IF NVL(v_exist_flag,0) = 1 THEN
2527: FOR tax_rec IN ja_so_tax_lines_info LOOP
2528:
2532: CLOSE c_duplicate_tax ;
2533:
2534: IF nvl(ln_tax_exist, 0) <> 1 THEN
2535:
2536: INSERT INTO JAI_AR_TRX_TAX_LINES(
2537: tax_line_no ,
2538: customer_trx_line_id ,
2539: link_to_cust_trx_line_id ,
2540: precedence_1 ,
3509: LOOP
3510: v_tax_line_no := v_tax_line_no+1;
3511:
3512:
3513: INSERT INTO JAI_AR_TRX_TAX_LINES(
3514: tax_line_no ,
3515: customer_trx_line_id ,
3516: link_to_cust_trx_line_id ,
3517: precedence_1 ,
3599: FOR Tax_Rec IN SUPPLEMENT_TAX_LINES
3600: LOOP
3601: v_tax_line_no := v_tax_line_no+1;
3602:
3603: INSERT INTO JAI_AR_TRX_TAX_LINES(
3604: tax_line_no ,
3605: customer_trx_line_id ,
3606: link_to_cust_trx_line_id ,
3607: precedence_1 ,
4941: IS
4942: SELECT
4943: nvl(sum(tax_amount),0)
4944: FROM
4945: JAI_AR_TRX_TAX_LINES
4946: WHERE
4947: link_to_cust_trx_line_id = pr_new.customer_trx_line_id ;
4948:
4949:
5099: )
5100: is
5101: select count(1)
5102: from jai_regime_tax_types_v jrttv
5103: , JAI_AR_TRX_TAX_LINES jrctt
5104: , JAI_CMN_TAXES_ALL jtc
5105: where jtc.tax_id = jrctt.tax_id
5106: and jtc.tax_type = jrttv.tax_type
5107: and regime_code = cp_regime_code
5114:
5115: Cursor get_ar_tax_amount
5116: is
5117: select sum(tax_amount)
5118: from JAI_AR_TRX_TAX_LINES
5119: Where link_to_cust_trx_line_id = v_customer_trx_line_id;
5120:
5121: ln_ar_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%type;
5122:
5117: select sum(tax_amount)
5118: from JAI_AR_TRX_TAX_LINES
5119: Where link_to_cust_trx_line_id = v_customer_trx_line_id;
5120:
5121: ln_ar_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%type;
5122:
5123: l_api_name CONSTANT VARCHAR2(30) := 'process_bill_only_return()';
5124:
5125: begin
5293: end if;
5294: end if;
5295:
5296: /*
5297: insert into the JAI_AR_TRX_TAX_LINES table and then insert into the JAI_AR_TRX_LINES table.
5298: pr_new.interface_line_attribute6 = order_line_id
5299: pr_new.interface_line_context = 'ORDER ENTRY'
5300: */
5301:
5358: );
5359: end if;
5360: if upper(tax_rec.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
5361:
5362: INSERT INTO JAI_AR_TRX_TAX_LINES
5363: (
5364: tax_line_no ,
5365: customer_trx_line_id ,
5366: link_to_cust_trx_line_id ,
5417: );
5418: end if;
5419: else
5420:
5421: INSERT INTO JAI_AR_TRX_TAX_LINES
5422: (
5423: tax_line_no ,
5424: customer_trx_line_id ,
5425: link_to_cust_trx_line_id ,
5540: end if;
5541: /* Get line number after which threshold taxes needs to be defaulted */
5542: select max(tax_line_no)
5543: into ln_last_line_no
5544: from JAI_AR_TRX_TAX_LINES
5545: where link_to_cust_trx_line_id = v_customer_trx_line_id;
5546: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
5547: select max(tax_line_no)
5548: into ln_base_line_no
5545: where link_to_cust_trx_line_id = v_customer_trx_line_id;
5546: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
5547: select max(tax_line_no)
5548: into ln_base_line_no
5549: from JAI_AR_TRX_TAX_LINES jrctt
5550: , JAI_CMN_TAXES_ALL jtc
5551: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
5552: and jrctt.tax_id = jtc.tax_id
5553: and jtc.tax_type = jai_constants.tax_type_tcs;
5957: (nvl(v_ont_source_code,'ORDER ENTRY') <> nvl(ltrim(rtrim(pr_new.interface_line_context)),'$$$')
5958: )
5959: then
5960:
5961: INSERT INTO JAI_AR_TRX_TAX_LINES
5962: (
5963: tax_line_no,
5964: customer_trx_line_id,
5965: link_to_cust_trx_line_id,
6270: r_jai_ra_customer_trx c_jai_ra_customer_trx%rowtype;
6271:
6272: cursor c_jai_tax_line(pn_tax_line_no number) is
6273: select customer_trx_line_id
6274: from jai_ar_trx_tax_lines
6275: where 1=1 --customer_trx_id = r_new.customer_trx_id
6276: and link_to_cust_trx_line_id = r_new.customer_trx_line_id
6277: and tax_line_no = pn_tax_line_no;
6278: r_jai_tax_line c_jai_tax_line%rowtype;
6482: close c_jai_tax_line;
6483:
6484: if r_jai_tax_line.customer_trx_line_id is null then
6485:
6486: insert into jai_ar_trx_tax_lines(
6487: tax_line_no ,
6488: customer_trx_line_id ,
6489: link_to_cust_trx_line_id ,
6490: precedence_1 ,