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_OPEN_API_PKG dependencies on JAI_INTERFACE_TAX_LINES_ALL

Line 168: delete from jai_interface_tax_lines_all

164: PROCEDURE del_success_lines
165: IS
166: BEGIN
167: --Delete tax lines firstly
168: delete from jai_interface_tax_lines_all
169: where interface_line_id in
170: (
171: select interface_line_id
172: from jai_interface_lines_all

Line 466: pn_interface_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_LINE_ID%TYPE,

462: /*
463: || Validate CODE_COMBINATION_ID is suitable to EBS System
464: */
465: PROCEDURE validate_ccid_id_suitable(
466: pn_interface_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_LINE_ID%TYPE,
467: pn_tax_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_TAX_LINE_ID%TYPE,
468: pn_code_combination_id IN JAI_INTERFACE_TAX_LINES_ALL.CODE_COMBINATION_ID%TYPE,
469: xn_err_flag IN OUT NOCOPY NUMBER
470: )

Line 467: pn_tax_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_TAX_LINE_ID%TYPE,

463: || Validate CODE_COMBINATION_ID is suitable to EBS System
464: */
465: PROCEDURE validate_ccid_id_suitable(
466: pn_interface_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_LINE_ID%TYPE,
467: pn_tax_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_TAX_LINE_ID%TYPE,
468: pn_code_combination_id IN JAI_INTERFACE_TAX_LINES_ALL.CODE_COMBINATION_ID%TYPE,
469: xn_err_flag IN OUT NOCOPY NUMBER
470: )
471: IS

Line 468: pn_code_combination_id IN JAI_INTERFACE_TAX_LINES_ALL.CODE_COMBINATION_ID%TYPE,

464: */
465: PROCEDURE validate_ccid_id_suitable(
466: pn_interface_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_LINE_ID%TYPE,
467: pn_tax_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_TAX_LINE_ID%TYPE,
468: pn_code_combination_id IN JAI_INTERFACE_TAX_LINES_ALL.CODE_COMBINATION_ID%TYPE,
469: xn_err_flag IN OUT NOCOPY NUMBER
470: )
471: IS
472: --Cursor define here

Line 740: FROM JAI_INTERFACE_TAX_LINES_ALL

736: --Cursor define here
737: CURSOR get_sum_in_tax_amount_cur
738: IS
739: SELECT SUM(TAX_AMOUNT)
740: FROM JAI_INTERFACE_TAX_LINES_ALL
741: WHERE INTERFACE_LINE_ID = pr_interface_lines.INTERFACE_LINE_ID
742: AND NVL(INCLUSIVE_TAX_FLAG,'N') = 'Y';
743:
744: CURSOR get_sum_ex_tax_amount_cur

Line 747: FROM JAI_INTERFACE_TAX_LINES_ALL

743:
744: CURSOR get_sum_ex_tax_amount_cur
745: IS
746: SELECT SUM(TAX_AMOUNT)
747: FROM JAI_INTERFACE_TAX_LINES_ALL
748: WHERE INTERFACE_LINE_ID = pr_interface_lines.INTERFACE_LINE_ID
749: AND NVL(INCLUSIVE_TAX_FLAG,'N') = 'N';
750:
751: --Variable define here

Line 752: ln_in_tax_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;

748: WHERE INTERFACE_LINE_ID = pr_interface_lines.INTERFACE_LINE_ID
749: AND NVL(INCLUSIVE_TAX_FLAG,'N') = 'N';
750:
751: --Variable define here
752: ln_in_tax_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
753: ln_ex_tax_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
754: --ln_dist_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
755:
756: lv_return_mess VARCHAR2(1000);

Line 753: ln_ex_tax_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;

749: AND NVL(INCLUSIVE_TAX_FLAG,'N') = 'N';
750:
751: --Variable define here
752: ln_in_tax_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
753: ln_ex_tax_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
754: --ln_dist_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
755:
756: lv_return_mess VARCHAR2(1000);
757: lv_error_mess VARCHAR2(1000);

Line 754: --ln_dist_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;

750:
751: --Variable define here
752: ln_in_tax_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
753: ln_ex_tax_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
754: --ln_dist_sum_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
755:
756: lv_return_mess VARCHAR2(1000);
757: lv_error_mess VARCHAR2(1000);
758: --Main block

Line 921: FROM JAI_INTERFACE_TAX_LINES_ALL

917: CURSOR get_tax_line_count_cur
918: IS
919: SELECT
920: COUNT(INTERFACE_TAX_LINE_ID)
921: FROM JAI_INTERFACE_TAX_LINES_ALL
922: WHERE INTERFACE_LINE_ID = pn_interface_line_id;
923: --AND TAX_AMOUNT is not null ;
924:
925: --Variable define here

Line 1663: pn_tax_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_TAX_LINE_ID%TYPE,

1659: ||Check the tax line no is not null in tax lines
1660: */
1661: PROCEDURE validate_tax_line_no(
1662: pn_interface_line_id IN JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE,
1663: pn_tax_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_TAX_LINE_ID%TYPE,
1664: pn_tax_line_no IN JAI_INTERFACE_TAX_LINES_ALL.TAX_LINE_NO%TYPE,
1665: pn_trx_id IN JAI_INTERFACE_LINES_ALL.TRANSACTION_ID%TYPE,
1666: xn_err_flag IN OUT NOCOPY NUMBER
1667: )

Line 1664: pn_tax_line_no IN JAI_INTERFACE_TAX_LINES_ALL.TAX_LINE_NO%TYPE,

1660: */
1661: PROCEDURE validate_tax_line_no(
1662: pn_interface_line_id IN JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE,
1663: pn_tax_line_id IN JAI_INTERFACE_TAX_LINES_ALL.INTERFACE_TAX_LINE_ID%TYPE,
1664: pn_tax_line_no IN JAI_INTERFACE_TAX_LINES_ALL.TAX_LINE_NO%TYPE,
1665: pn_trx_id IN JAI_INTERFACE_LINES_ALL.TRANSACTION_ID%TYPE,
1666: xn_err_flag IN OUT NOCOPY NUMBER
1667: )
1668: IS

Line 1716: pr_tax_lines IN JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE,

1712: * 3. tax should in available term ,startdate and enddate
1713: */
1714: PROCEDURE validate_tax_code(
1715: pr_interface_lines IN JAI_INTERFACE_LINES_ALL%ROWTYPE,
1716: pr_tax_lines IN JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE,
1717: pn_trx_id IN JAI_INTERFACE_LINES_ALL.TRANSACTION_ID%TYPE,
1718: xn_err_flag IN OUT NOCOPY NUMBER,
1719: xn_tax_id OUT NOCOPY NUMBER
1720: )

Line 1725: cv_external_tax_code IN JAI_INTERFACE_TAX_LINES_ALL.EXTERNAL_TAX_CODE%TYPE,

1721: IS
1722: --Cursor define here
1723: CURSOR get_tax_id_from_mapping_cur(
1724: cn_org_id IN JAI_INTERFACE_LINES_ALL.ORG_ID%TYPE,
1725: cv_external_tax_code IN JAI_INTERFACE_TAX_LINES_ALL.EXTERNAL_TAX_CODE%TYPE,
1726: cv_taxable_event IN JAI_INTERFACE_LINES_ALL.TAXABLE_EVENT%TYPE
1727: )IS
1728: SELECT TAX_ID
1729: FROM JAI_IM_TAX_MAPPING

Line 1986: pr_tax_lines IN JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE,

1982: ||Check the ccid of distribution line is available
1983: */
1984: PROCEDURE validate_dist_info(
1985: pr_interface_lines IN JAI_INTERFACE_LINES_ALL%ROWTYPE,
1986: pr_tax_lines IN JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE,
1987: xn_err_flag IN OUT NOCOPY NUMBER
1988: ) IS
1989:
1990: lv_return_mess VARCHAR2(1000);

Line 2028: update jai_interface_tax_lines_all

2024: --For external , if tax amount is null , just warning , proceed .
2025: --xn_err_flag := 1; --Commented by bug#12589785
2026: --Added by zhiwei for bug#12589785 begin
2027: -----------------------------------------------------------
2028: update jai_interface_tax_lines_all
2029: set tax_amount = 0
2030: where interface_tax_line_id = pr_tax_lines.interface_tax_line_id
2031: and interface_line_id = pr_interface_lines.interface_line_id
2032: and nvl(tax_amount,-1) = -1;

Line 2082: pr_tax_lines IN JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE,

2078: * Tax types under CUSTOMS Regime
2079: */
2080: PROCEDURE validate_tax_constrain(
2081: pr_interface_lines IN JAI_INTERFACE_LINES_ALL%ROWTYPE,
2082: pr_tax_lines IN JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE,
2083: pn_trx_id IN JAI_INTERFACE_LINES_ALL.TRANSACTION_ID%TYPE,
2084: xn_err_flag IN OUT NOCOPY NUMBER,
2085: pn_tax_id IN NUMBER
2086: )

Line 2231: pr_tax_lines IN JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE,

2227: ||
2228: */
2229: PROCEDURE validate_tax_precedence(
2230: pn_interface_line_id IN JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE,
2231: pr_tax_lines IN JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE,
2232: pn_trx_id IN JAI_INTERFACE_LINES_ALL.TRANSACTION_ID%TYPE,
2233: xn_err_flag IN OUT NOCOPY NUMBER
2234: )
2235: IS

Line 2241: FROM JAI_INTERFACE_TAX_LINES_ALL

2237: --Cursor define here
2238: CURSOR get_line_count_cur
2239: IS
2240: SELECT COUNT(tax_id)
2241: FROM JAI_INTERFACE_TAX_LINES_ALL
2242: WHERE INTERFACE_LINE_ID = pn_interface_line_id
2243: ;
2244:
2245: --Variable define here

Line 2433: pn_tax_line_id IN JAI_INTERFACE_TAX_LINES_ALL.interface_tax_line_id%TYPE,

2429: ||
2430: */
2431: PROCEDURE validate_qty_rate(
2432: pn_interface_line_id IN JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE,
2433: pn_tax_line_id IN JAI_INTERFACE_TAX_LINES_ALL.interface_tax_line_id%TYPE,
2434: pn_tax_id IN JAI_INTERFACE_TAX_LINES_ALL.tax_ID%TYPE,
2435: xn_err_flag IN OUT NOCOPY NUMBER
2436: )
2437: IS

Line 2434: pn_tax_id IN JAI_INTERFACE_TAX_LINES_ALL.tax_ID%TYPE,

2430: */
2431: PROCEDURE validate_qty_rate(
2432: pn_interface_line_id IN JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE,
2433: pn_tax_line_id IN JAI_INTERFACE_TAX_LINES_ALL.interface_tax_line_id%TYPE,
2434: pn_tax_id IN JAI_INTERFACE_TAX_LINES_ALL.tax_ID%TYPE,
2435: xn_err_flag IN OUT NOCOPY NUMBER
2436: )
2437: IS
2438:

Line 2443: FROM JAI_INTERFACE_TAX_LINES_ALL

2439: --Cursor define here
2440: CURSOR get_tax_cur
2441: IS
2442: SELECT qty_rate,tax_amount
2443: FROM JAI_INTERFACE_TAX_LINES_ALL
2444: WHERE INTERFACE_tax_LINE_ID = pn_tax_line_id
2445: ;
2446: CURSOR chk_qty_rate_cur
2447: IS

Line 2710: jai_interface_tax_lines_all jitla,

2706: SELECT 'Y'
2707: FROM dual
2708: WHERE EXISTS (SELECT 1
2709: FROM jai_cmn_taxes_all jcta,
2710: jai_interface_tax_lines_all jitla,
2711: jai_interface_lines_all jila
2712: WHERE jitla.tax_id = jcta.tax_id
2713: AND jila.interface_line_id = jitla.interface_line_id
2714: AND jila.internal_trx_id = cn_trx_id

Line 2728: jai_interface_tax_lines_all jitla,

2724: SELECT 'Y'
2725: FROM dual
2726: WHERE EXISTS (SELECT 1
2727: FROM jai_cmn_taxes_all jcta,
2728: jai_interface_tax_lines_all jitla,
2729: jai_interface_lines_all jila
2730: WHERE jitla.tax_id = jcta.tax_id
2731: AND jila.interface_line_id = jitla.interface_line_id
2732: AND jila.internal_trx_id = cn_trx_id

Line 2827: jai_interface_tax_lines_all jitla,

2823: SELECT 'Y'
2824: FROM dual
2825: WHERE EXISTS (SELECT 1
2826: FROM jai_cmn_taxes_all jcta,
2827: jai_interface_tax_lines_all jitla,
2828: jai_interface_lines_all jila
2829: WHERE jitla.tax_id = jcta.tax_id
2830: AND jila.interface_line_id = jitla.interface_line_id
2831: AND jila.internal_trx_id = cn_trx_id

Line 4468: JAI_INTERFACE_TAX_LINES_ALL intf

4464: IS
4465: SELECT
4466: count(tax.tax_id)
4467: FROM JAI_CMN_TAXES_ALL tax,
4468: JAI_INTERFACE_TAX_LINES_ALL intf
4469: WHERE intf.tax_id = tax.tax_id
4470: and intf.interface_line_id = pn_interface_line_id
4471: and (
4472: upper(tax_type) in

Line 4674: FROM JAI_INTERFACE_TAX_LINES_ALL

4670: --Cursor define here
4671: CURSOR get_tax_line_cur
4672: IS
4673: SELECT *
4674: FROM JAI_INTERFACE_TAX_LINES_ALL
4675: WHERE INTERFACE_LINE_ID = pr_interface_lines.INTERFACE_LINE_ID
4676: ORDER BY INTERFACE_TAX_LINE_ID;
4677:
4678: CURSOR chk_category_id_cur(cn_category_id IN JAI_INTERFACE_LINES_ALL.TAX_CATEGORY_ID%TYPE)

Line 4695: ln_tax_id JAI_INTERFACE_TAX_LINES_ALL.TAX_ID%TYPE;

4691: --Variable define here
4692: lv_return_mess VARCHAR2(1000);
4693: lv_error_mess VARCHAR2(1000);
4694:
4695: ln_tax_id JAI_INTERFACE_TAX_LINES_ALL.TAX_ID%TYPE;
4696: rec_tax_line JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE;
4697: ln_rec_percent NUMBER;
4698: ln_func_tax_amount NUMBER;
4699: ln_tax_category_id JAI_INTERFACE_LINES_ALL.TAX_CATEGORY_ID%TYPE;

Line 4696: rec_tax_line JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE;

4692: lv_return_mess VARCHAR2(1000);
4693: lv_error_mess VARCHAR2(1000);
4694:
4695: ln_tax_id JAI_INTERFACE_TAX_LINES_ALL.TAX_ID%TYPE;
4696: rec_tax_line JAI_INTERFACE_TAX_LINES_ALL%ROWTYPE;
4697: ln_rec_percent NUMBER;
4698: ln_func_tax_amount NUMBER;
4699: ln_tax_category_id JAI_INTERFACE_LINES_ALL.TAX_CATEGORY_ID%TYPE;
4700: ln_tax_exist_flag NUMBER;

Line 4764: UPDATE JAI_INTERFACE_TAX_LINES_ALL

4760: IF(NVL(ln_tax_id,-1) <> -1)THEN
4761: --tax_id is updated only for not use ebs tax code
4762: IF ln_not_ebs_code > 0 THEN
4763: --Update tax id to tax line
4764: UPDATE JAI_INTERFACE_TAX_LINES_ALL
4765: SET TAX_ID = ln_tax_id
4766: WHERE INTERFACE_TAX_LINE_ID = rec_tax_line.INTERFACE_TAX_LINE_ID;
4767: END IF;
4768:

Line 6738: v_exter_code_combination_id JAI_INTERFACE_TAX_LINES_ALL.CODE_COMBINATION_ID%TYPE;

6734: SELECT count(customer_trx_line_id)
6735: FROM JAI_AR_TRX_INS_LINES_T
6736: WHERE customer_trx_id = pn_customer_trx_id;
6737:
6738: v_exter_code_combination_id JAI_INTERFACE_TAX_LINES_ALL.CODE_COMBINATION_ID%TYPE;
6739: v_exter_percent NUMBER;
6740: v_exter_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
6741:
6742: v_exter_request_id NUMBER;

Line 6740: v_exter_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;

6736: WHERE customer_trx_id = pn_customer_trx_id;
6737:
6738: v_exter_code_combination_id JAI_INTERFACE_TAX_LINES_ALL.CODE_COMBINATION_ID%TYPE;
6739: v_exter_percent NUMBER;
6740: v_exter_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
6741:
6742: v_exter_request_id NUMBER;
6743:
6744: CURSOR cur_get_external_dis_detail(pn_c_tax_line_no IN JAI_INTERFACE_TAX_LINES_ALL.TAX_LINE_NO%TYPE) IS

Line 6744: CURSOR cur_get_external_dis_detail(pn_c_tax_line_no IN JAI_INTERFACE_TAX_LINES_ALL.TAX_LINE_NO%TYPE) IS

6740: v_exter_amount JAI_INTERFACE_TAX_LINES_ALL.TAX_AMOUNT%TYPE;
6741:
6742: v_exter_request_id NUMBER;
6743:
6744: CURSOR cur_get_external_dis_detail(pn_c_tax_line_no IN JAI_INTERFACE_TAX_LINES_ALL.TAX_LINE_NO%TYPE) IS
6745: SELECT
6746: CODE_COMBINATION_ID,
6747: 100,--Hardcode temporarily.
6748: TAX_AMOUNT,

Line 6750: FROM JAI_INTERFACE_TAX_LINES_ALL TAX

6746: CODE_COMBINATION_ID,
6747: 100,--Hardcode temporarily.
6748: TAX_AMOUNT,
6749: GN_REQUEST_ID
6750: FROM JAI_INTERFACE_TAX_LINES_ALL TAX
6751: WHERE TAX.INTERFACE_LINE_ID = pn_interface_line_id
6752: AND TAX_LINE_NO = pn_c_tax_line_no;--TEMP_REC.LINE_NUMBER
6753:
6754:

Line 7411: --jai_interface_tax_lines_all get interface_TAX_line_id base pn_interface_line_id and TEMP_REC.LINE_NUMBER

7407: CLOSE cur_get_external_dis_detail;
7408:
7409:
7410: --jai_ar_trx_tax_lines get tax_line_no base TEMP_REC.customer_trx_line_id and TEMP_REC.link_to_cust_trx_line_id
7411: --jai_interface_tax_lines_all get interface_TAX_line_id base pn_interface_line_id and TEMP_REC.LINE_NUMBER
7412: --JAI-INTERFACE_DIS_LINES_ALL GET CODE_COMBINATION_ID PERCENT AMOUNT ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 REQUEST_ID
7413: OPEN SO_AR_HDR_INFO;
7414: FETCH SO_AR_HDR_INFO INTO v_organization_id, v_location_id, v_batch_source_id;
7415: CLOSE SO_AR_HDR_INFO;

Line 7614: --jai_interface_tax_lines_all get interface_TAX_line_id base pn_interface_line_id and TEMP_REC.LINE_NUMBER

7610: CLOSE cur_get_external_dis_detail;
7611:
7612:
7613: --jai_ar_trx_tax_lines get tax_line_no base TEMP_REC.customer_trx_line_id and TEMP_REC.link_to_cust_trx_line_id
7614: --jai_interface_tax_lines_all get interface_TAX_line_id base pn_interface_line_id and TEMP_REC.LINE_NUMBER
7615: --JAI-INTERFACE_DIS_LINES_ALL GET CODE_COMBINATION_ID PERCENT AMOUNT ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 REQUEST_ID
7616: OPEN SO_AR_HDR_INFO;
7617: FETCH SO_AR_HDR_INFO INTO v_organization_id, v_location_id, v_batch_source_id;
7618: CLOSE SO_AR_HDR_INFO;

Line 8047: jai_interface_tax_lines_all jitla,

8043: SELECT 'Y'
8044: FROM dual
8045: WHERE EXISTS (SELECT 1
8046: FROM jai_cmn_taxes_all jcta,
8047: jai_interface_tax_lines_all jitla,
8048: jai_interface_lines_all jila
8049: WHERE jitla.tax_id = jcta.tax_id
8050: AND jila.interface_line_id = jitla.interface_line_id
8051: --AND jila.interface_line_id = pn_interface_line_id --Commented by zhiwei for Bug#12564566 on 20110523

Line 8075: jai_interface_tax_lines_all jitla,

8071: SELECT 'Y'
8072: FROM dual
8073: WHERE EXISTS (SELECT 1
8074: FROM jai_cmn_taxes_all jcta,
8075: jai_interface_tax_lines_all jitla,
8076: jai_interface_lines_all jila
8077: WHERE jitla.tax_id = jcta.tax_id
8078: AND jila.interface_line_id = jitla.interface_line_id
8079: --AND jila.interface_line_id = pn_interface_line_id--Commented by zhiwei for Bug#12564566 on 20110523

Line 8136: jai_interface_tax_lines_all jitla,

8132: SELECT 'Y'
8133: FROM dual
8134: WHERE EXISTS (SELECT 1
8135: FROM jai_cmn_taxes_all jcta,
8136: jai_interface_tax_lines_all jitla,
8137: jai_interface_lines_all jila
8138: WHERE jitla.tax_id = jcta.tax_id
8139: AND jila.interface_line_id = jitla.interface_line_id
8140: AND jila.interface_line_id in

Line 10369: jai_interface_tax_lines_all tax

10365: tax.code_combination_id
10366: FROM
10367: --jai_interface_dis_lines_all dist,
10368: jai_interface_lines_all lines,
10369: jai_interface_tax_lines_all tax
10370: WHERE tax.tax_line_no = pn_tax_line_no
10371: AND tax.interface_line_id = lines.interface_line_id
10372: AND lines.internal_trx_id = pn_invoice_id
10373: AND lines.internal_trx_line_id = pn_line_number;

Line 10397: -- Fetch the tax lines from jai_interface_tax_lines_all, and insert them

10393: --
10394: -- populate_jai_interface_taxes Private
10395: --
10396: -- DESCRIPTION:
10397: -- Fetch the tax lines from jai_interface_tax_lines_all, and insert them
10398: -- to AR/AP tax tables.
10399: --
10400: -- PARAMETERS:
10401: -- In: pn_interface_line_id IN NUMBER interface line id

Line 10719: FROM jai_interface_tax_lines_all

10715:
10716:
10717: SELECT COUNT(1)
10718: INTO ln_tax_line_count
10719: FROM jai_interface_tax_lines_all
10720: WHERE interface_line_id = pn_interface_line_id;
10721:
10722: -- Tax lines exist in JAI_INTERFACE_TAX_LINES_ALL
10723: -- Will fetch taxes from JAI_INTERFACE_TAX_LINES_ALL

Line 10722: -- Tax lines exist in JAI_INTERFACE_TAX_LINES_ALL

10718: INTO ln_tax_line_count
10719: FROM jai_interface_tax_lines_all
10720: WHERE interface_line_id = pn_interface_line_id;
10721:
10722: -- Tax lines exist in JAI_INTERFACE_TAX_LINES_ALL
10723: -- Will fetch taxes from JAI_INTERFACE_TAX_LINES_ALL
10724:
10725: IF ln_tax_line_count > 0 THEN
10726:

Line 10723: -- Will fetch taxes from JAI_INTERFACE_TAX_LINES_ALL

10719: FROM jai_interface_tax_lines_all
10720: WHERE interface_line_id = pn_interface_line_id;
10721:
10722: -- Tax lines exist in JAI_INTERFACE_TAX_LINES_ALL
10723: -- Will fetch taxes from JAI_INTERFACE_TAX_LINES_ALL
10724:
10725: IF ln_tax_line_count > 0 THEN
10726:
10727: lv_tax_sql :=

Line 10752: , 'JAI_INTERFACE_TAX_LINES_ALL'

10748: );
10749: lv_tax_sql :=
10750: REPLACE( lv_tax_sql
10751: , '$$TAX_SOURCE_TABLE$$'
10752: , 'JAI_INTERFACE_TAX_LINES_ALL'
10753: );
10754:
10755: lv_tax_sql :=
10756: REPLACE( lv_tax_sql

Line 10761: ELSE -- No related tax lines in JAI_INTERFACE_TAX_LINES_ALL, tax category will be used.

10757: , '$$SOURCE_TABLE_FILTER$$'
10758: , 'a.interface_line_id = ' || pn_interface_line_id
10759: );
10760:
10761: ELSE -- No related tax lines in JAI_INTERFACE_TAX_LINES_ALL, tax category will be used.
10762: -- Tax_category_id is populated in jai_interface_lines_all during VALIDATION phase.
10763: -- Will fetch taxes from JAI_CMN_TAX_CTG_LINES
10764:
10765: SELECT tax_category_id

Line 11355: JAI_INTERFACE_TAX_LINES_ALL

11351: INTERFACE_TAX_LINE_ID,
11352: INTERFACE_LINE_ID
11353: ,ROWID--Added by zhiwei for Bug#12561396 and Bug#12589644 on 20110607
11354: FROM
11355: JAI_INTERFACE_TAX_LINES_ALL
11356: WHERE
11357: PARTY_ID = cn_party_id
11358: AND PARTY_SITE_ID = cn_party_site_id
11359: AND IMPORT_MODULE = cv_import_module

Line 11437: ln_interface_tax_line_id := JAI_INTERFACE_TAX_LINES_ALL_S.nextval;

11433: ln_tax_line_no := ln_tax_line_no + 1;
11434:
11435: IF(NVL(rec_tax_line_no.interface_tax_line_id,-1) = -1)THEN
11436: --If interface_tax_line_id is null then generate interface_tax_line_id use sequence
11437: ln_interface_tax_line_id := JAI_INTERFACE_TAX_LINES_ALL_S.nextval;
11438:
11439: --If interface_tax_line_id is null
11440: -- and
11441: --(interface_line_id is null or interface_line_id is not as same as interface_line_id of jai_interface_lines_all accordingly)

Line 11448: UPDATE jai_interface_tax_lines_all

11444: OR
11445: NVL(rec_tax_line_no.interface_line_id,-1) <> ln_interface_line_id
11446: )THEN
11447:
11448: UPDATE jai_interface_tax_lines_all
11449: SET interface_tax_line_id = ln_interface_tax_line_id,
11450: interface_line_id = ln_interface_line_id,
11451: tax_line_no = ln_tax_line_no
11452: WHERE party_id = rec_interface_line.party_id

Line 11464: UPDATE jai_interface_tax_lines_all

11460: --interface_tax_line_id is null
11461: --and
11462: --interface_line_id is as same as interface_line_id of jai_interface_lines_all accordingly
11463: --only mark interface_tax_line_id
11464: UPDATE jai_interface_tax_lines_all
11465: SET interface_tax_line_id = ln_interface_tax_line_id,
11466: tax_line_no = ln_tax_line_no
11467: WHERE party_id = rec_interface_line.party_id
11468: AND party_site_id = rec_interface_line.PARTY_SITE_ID

Line 11484: UPDATE jai_interface_tax_lines_all

11480: IF( NVL(rec_tax_line_no.interface_line_id,-1) = -1
11481: OR
11482: NVL(rec_tax_line_no.interface_line_id,-1) <> ln_interface_line_id
11483: )THEN
11484: UPDATE jai_interface_tax_lines_all
11485: SET
11486: interface_line_id = ln_interface_line_id,
11487: tax_line_no = ln_tax_line_no
11488: WHERE party_id = rec_interface_line.party_id

Line 12175: delete from jai_interface_tax_lines_all

12171: AND party_site_id = nvl(pn_party_site,party_site_id)
12172: and (request_id is null or request_id='')
12173: );
12174:
12175: delete from jai_interface_tax_lines_all
12176: where 1=1
12177: and interface_line_id in
12178: (
12179: select interface_line_id

Line 12207: delete from jai_interface_tax_lines_all

12203: and (request_id is null or request_id='')
12204: ;
12205:
12206: if(pn_org_id is null)then
12207: delete from jai_interface_tax_lines_all
12208: where 1=1
12209: AND import_module = nvl(pv_import_module,import_module)
12210: AND transaction_num >= nvl(pv_transaction_num_from, transaction_num)
12211: AND transaction_num <= nvl(pv_transaction_num_to, transaction_num)

Line 12237: delete from jai_interface_tax_lines_all

12233: AND party_site_id = nvl(pn_party_site,party_site_id)
12234: and (request_id is null or request_id='')
12235: );
12236:
12237: delete from jai_interface_tax_lines_all
12238: where 1=1
12239: and interface_line_id in
12240: (
12241: SELECT interface_line_id

Line 12291: delete from jai_interface_tax_lines_all

12287: AND party_id = nvl(pn_party,party_id)
12288: AND party_site_id = nvl(pn_party_site,party_site_id)
12289: );
12290:
12291: delete from jai_interface_tax_lines_all
12292: where 1=1
12293: and interface_line_id in
12294: (
12295: SELECT interface_line_id