APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

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

146: v_return_reference_id NUMBER;
147: v_count NUMBER; --2001/04/25 Deepak Prabhakar
148: c_source_line_id NUMBER;
149: 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)
150: v_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type; --Added by Nagaraj.s for Bug3140153.
151:
152: -- additions by sriram - ATO - LMW
153: v_ato_line_amount Number;
154: v_ato_tax_amount Number;

Line 215: from JAI_CMN_TAXES_ALL

211: --Added by Nagaraj.s for Bug3140153.
212: cursor c_fetch_rounding_factor(p_tax_id number) is
213: select nvl(rounding_factor,0),
214: nvl(adhoc_flag,'N') --Added by Nagaraj.s for Bug3207633
215: from JAI_CMN_TAXES_ALL
216: where tax_id = p_tax_id;
217:
218: v_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type; --3207633
219:

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

214: nvl(adhoc_flag,'N') --Added by Nagaraj.s for Bug3207633
215: from JAI_CMN_TAXES_ALL
216: where tax_id = p_tax_id;
217:
218: v_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type; --3207633
219:
220: CURSOR order_tax_amount_Cur (p_header_id NUMBER, p_line_id NUMBER) IS
221: SELECT SUM(A.tax_amount)
222: FROM JAI_OM_OE_SO_TAXES A,

Line 223: JAI_CMN_TAXES_ALL b

219:
220: CURSOR order_tax_amount_Cur (p_header_id NUMBER, p_line_id NUMBER) IS
221: SELECT SUM(A.tax_amount)
222: FROM JAI_OM_OE_SO_TAXES A,
223: JAI_CMN_TAXES_ALL b
224: WHERE A.Header_ID = p_header_id
225: AND A.line_id = p_line_id
226: AND b.tax_id = A.tax_id
227: AND b.tax_type <> jai_constants.tax_type_tds /* 'TDS'; Ramananda for removal of SQL LITERALs */

Line 232: FROM JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b

228: AND NVL(b.inclusive_tax_flag, 'N') = 'N'; -- Added by Jia Li for inclusive tax on 2008/01/08
229:
230: CURSOR return_tax_amount_Cur (p_header_id NUMBER, p_line_id NUMBER) IS
231: SELECT SUM(A.tax_amount)
232: FROM JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b
233: WHERE a.rma_line_id = p_line_id
234: AND b.tax_id = A.tax_id
235: AND b.tax_type <> jai_constants.tax_type_tds /* 'TDS'; Ramananda for removal of SQL LITERALs */
236: AND NVL(b.inclusive_tax_flag, 'N') = 'N'; -- Added by Jia Li for inclusive tax on 2008/01/08

Line 1007: JAI_CMN_TAXES_ALL jtc

1003: MIN (ptl.delivery_detail_id) delivery_detail_id
1004: FROM
1005: JAI_OM_WSH_LINES_ALL pl ,
1006: JAI_OM_WSH_LINE_TAXES ptl ,
1007: JAI_CMN_TAXES_ALL jtc
1008: WHERE
1009: ptl.delivery_detail_id = pl.delivery_detail_id AND
1010: pl.order_header_id = p_source_document_id AND
1011: pl.order_line_id = p_source_document_line_id AND

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

1138: JAI_OM_OE_SO_LINES
1139: WHERE
1140: line_id = pr_new.reference_line_id ;**/
1141:
1142: CURSOR c_so_tax_amount (p_tax_id JAI_CMN_TAXES_ALL.tax_id%type)
1143: IS
1144: SELECT
1145: tax_amount
1146: FROM

Line 3116: JAI_CMN_TAXES_ALL b

3112:
3113: CURSOR order_tax_amount_Cur IS
3114: SELECT SUM(a.tax_amount)
3115: FROM JAI_OM_OE_SO_TAXES a,
3116: JAI_CMN_TAXES_ALL b
3117: WHERE a.Header_ID = v_header_id
3118: AND a.line_id = v_line_id
3119: AND b.tax_id = a.tax_id
3120: AND b.tax_type <> 'TDS';