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_OE_OLA_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

Line 157: v_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type; --Added by Nagaraj.s for Bug3140153.

153: v_return_reference_id NUMBER;
154: v_count NUMBER; --2001/04/25 Deepak Prabhakar
155: c_source_line_id NUMBER;
156: v_header_tax_amount number; --File.Sql.35 Cbabu :=0; --Added by Nagaraj.s for Bug3140153.(Holds sum of tax amount for each order line. Used in case of a split line)
157: v_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type; --Added by Nagaraj.s for Bug3140153.
158:
159: -- additions by sriram - ATO - LMW
160: v_ato_line_amount Number;
161: v_ato_tax_amount Number;

Line 234: from JAI_CMN_TAXES_ALL

230: --Added by Nagaraj.s for Bug3140153.
231: cursor c_fetch_rounding_factor(p_tax_id number) is
232: select nvl(rounding_factor,0),
233: nvl(adhoc_flag,'N') --Added by Nagaraj.s for Bug3207633
234: from JAI_CMN_TAXES_ALL
235: where tax_id = p_tax_id;
236:
237: v_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type; --3207633
238:

Line 237: v_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type; --3207633

233: nvl(adhoc_flag,'N') --Added by Nagaraj.s for Bug3207633
234: from JAI_CMN_TAXES_ALL
235: where tax_id = p_tax_id;
236:
237: v_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type; --3207633
238:
239: CURSOR order_tax_amount_Cur (p_header_id NUMBER, p_line_id NUMBER) IS
240: SELECT SUM(A.tax_amount)
241: FROM JAI_OM_OE_SO_TAXES A,

Line 242: JAI_CMN_TAXES_ALL b

238:
239: CURSOR order_tax_amount_Cur (p_header_id NUMBER, p_line_id NUMBER) IS
240: SELECT SUM(A.tax_amount)
241: FROM JAI_OM_OE_SO_TAXES A,
242: JAI_CMN_TAXES_ALL b
243: WHERE A.Header_ID = p_header_id
244: AND A.line_id = p_line_id
245: AND b.tax_id = A.tax_id
246: AND b.tax_type <> jai_constants.tax_type_tds /* 'TDS'; Ramananda for removal of SQL LITERALs */

Line 251: FROM JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b

247: AND NVL(b.inclusive_tax_flag, 'N') = 'N'; -- Added by Jia Li for inclusive tax on 2008/01/08
248:
249: CURSOR return_tax_amount_Cur (p_header_id NUMBER, p_line_id NUMBER) IS
250: SELECT SUM(A.tax_amount)
251: FROM JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b
252: WHERE a.rma_line_id = p_line_id
253: AND b.tax_id = A.tax_id
254: AND b.tax_type <> jai_constants.tax_type_tds /* 'TDS'; Ramananda for removal of SQL LITERALs */
255: AND NVL(b.inclusive_tax_flag, 'N') = 'N'; -- Added by Jia Li for inclusive tax on 2008/01/08

Line 1188: JAI_CMN_TAXES_ALL jtc

1184: MIN (ptl.delivery_detail_id) delivery_detail_id
1185: FROM
1186: JAI_OM_WSH_LINES_ALL pl ,
1187: JAI_OM_WSH_LINE_TAXES ptl ,
1188: JAI_CMN_TAXES_ALL jtc
1189: WHERE
1190: ptl.delivery_detail_id = pl.delivery_detail_id AND
1191: pl.order_header_id = p_source_document_id AND
1192: pl.order_line_id = p_source_document_line_id AND

Line 1338: CURSOR c_so_tax_amount (p_tax_id JAI_CMN_TAXES_ALL.tax_id%type)

1334: JAI_OM_OE_SO_LINES
1335: WHERE
1336: line_id = pr_new.reference_line_id ;**/
1337:
1338: CURSOR c_so_tax_amount (p_tax_id JAI_CMN_TAXES_ALL.tax_id%type)
1339: IS
1340: SELECT
1341: tax_amount
1342: FROM

Line 1750: JAI_CMN_TAXES_ALL jtc

1746: precedence_8,
1747: precedence_9,
1748: precedence_10
1749: FROM JAI_OM_WSH_LINE_TAXES sptl,
1750: JAI_CMN_TAXES_ALL jtc
1751: WHERE order_line_id = v_reference_line_id
1752: AND jtc.tax_id = sptl.tax_id)
1753: LOOP
1754: -- added by Allen Yang for bug 9691880 10-May-2010, begin

Line 2105: JAI_CMN_TAXES_ALL jtc

2101: MIN (ptl.delivery_detail_id) delivery_detail_id
2102: FROM
2103: JAI_OM_WSH_LINES_ALL pl ,
2104: JAI_OM_WSH_LINE_TAXES ptl ,
2105: JAI_CMN_TAXES_ALL jtc
2106: WHERE
2107: ptl.delivery_detail_id = pl.delivery_detail_id AND
2108: pl.order_header_id = p_source_document_id AND
2109: pl.order_line_id = p_source_document_line_id AND

Line 2248: CURSOR c_so_tax_amount (p_tax_id JAI_CMN_TAXES_ALL.tax_id%type)

2244: AND wdd.inventory_item_id = pr_new.inventory_item_id ;
2245:
2246:
2247:
2248: CURSOR c_so_tax_amount (p_tax_id JAI_CMN_TAXES_ALL.tax_id%type)
2249: IS
2250: SELECT
2251: tax_amount
2252: FROM

Line 2654: JAI_CMN_TAXES_ALL jtc

2650: precedence_8,
2651: precedence_9,
2652: precedence_10
2653: FROM JAI_OM_WSH_LINE_TAXES sptl,
2654: JAI_CMN_TAXES_ALL jtc
2655: WHERE order_line_id = v_reference_line_id
2656: AND jtc.tax_id = sptl.tax_id)
2657: LOOP
2658: lv_check_vat_type_exists := NULL;

Line 4313: , JAI_CMN_TAXES_ALL jcta

4309: , joost.Base_Tax_Amount
4310: , joost.Func_Tax_Amount
4311: FROM
4312: JAI_OM_OE_SO_TAXES joost
4313: , JAI_CMN_TAXES_ALL jcta
4314: WHERE joost.line_id = ln_order_line_id
4315: AND joost.Tax_Id = jcta.Tax_Id
4316: ORDER BY joost.Tax_Line_No;
4317:

Line 4350: , JAI_CMN_TAXES_ALL jcta

4346:
4347: CURSOR Get_Tot_Tax_Amount_Cur IS
4348: SELECT SUM(jowlt.Tax_Amount)
4349: FROM JAI_OM_WSH_LINE_TAXES jowlt
4350: , JAI_CMN_TAXES_ALL jcta
4351: WHERE jowlt.Order_Line_Id = ln_order_line_id
4352: AND jcta.Tax_Id = jowlt.Tax_Id
4353: AND jcta.Tax_Type <> 'TDS';
4354:

Line 4366: , JAI_CMN_TAXES_ALL jtc

4362: CURSOR cur_chk_vat_exists (cp_order_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE)
4363: IS
4364: SELECT 1
4365: FROM JAI_OM_WSH_LINE_TAXES jsptl
4366: , JAI_CMN_TAXES_ALL jtc
4367: , jai_regime_tax_types_v tax_types
4368: WHERE jsptl.order_line_id = cp_order_line_id
4369: AND jtc.tax_id = jsptl.tax_id
4370: AND jtc.tax_type = tax_types.tax_type

Line 4381: , cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )

4377: WHERE order_line_id = cp_order_line_id;
4378:
4379: -- Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
4380: CURSOR c_chk_vat_reversal (cp_order_line_id JAI_OM_WSH_LINES_ALL.order_line_id%TYPE
4381: , cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
4382: IS
4383: SELECT 1
4384: FROM JAI_OM_WSH_LINE_TAXES jsptl
4385: , JAI_CMN_TAXES_ALL jtc

Line 4385: , JAI_CMN_TAXES_ALL jtc

4381: , cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
4382: IS
4383: SELECT 1
4384: FROM JAI_OM_WSH_LINE_TAXES jsptl
4385: , JAI_CMN_TAXES_ALL jtc
4386: WHERE jsptl.order_line_id = cp_order_line_id
4387: AND jtc.tax_id = jsptl.tax_id
4388: AND jtc.tax_type = cp_tax_type;
4389:

Line 4416: , JAI_CMN_TAXES_ALL jtc

4412: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE)
4413: IS
4414: SELECT 1
4415: FROM JAI_OM_WSH_LINE_TAXES jsptl
4416: , JAI_CMN_TAXES_ALL jtc
4417: , jai_regime_tax_types_v tax_types
4418: WHERE jsptl.order_line_id = cp_order_line_id
4419: AND jtc.tax_id = jsptl.tax_id
4420: AND jtc.tax_type = tax_types.tax_type

Line 5018: JAI_CMN_TAXES_ALL b

5014:
5015: CURSOR order_tax_amount_Cur IS
5016: SELECT SUM(a.tax_amount)
5017: FROM JAI_OM_OE_SO_TAXES a,
5018: JAI_CMN_TAXES_ALL b
5019: WHERE a.Header_ID = v_header_id
5020: AND a.line_id = v_line_id
5021: AND b.tax_id = a.tax_id
5022: AND b.tax_type <> 'TDS';