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_OM_OE_RMA_TAXES

Line 53: DELETE FROM JAI_OM_OE_RMA_TAXES

49: DELETE JAI_OM_OE_RMA_LINES
50: WHERE rma_header_id = v_header_id
51: AND rma_line_id = v_line_id;
52:
53: DELETE FROM JAI_OM_OE_RMA_TAXES
54: WHERE rma_line_id = v_line_id;
55: ELSE
56: DELETE JAI_OM_OE_SO_LINES
57: WHERE header_id = v_header_id

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 275: FROM JAI_OM_OE_RMA_TAXES

271: AND line_id = p_line_id;
272:
273: CURSOR get_rma_tax_lines_count_cur IS
274: SELECT COUNT(1)
275: FROM JAI_OM_OE_RMA_TAXES
276: WHERE rma_line_id = pr_new.line_id;
277:
278: CURSOR get_assessable_value_cur(p_customer_id NUMBER, p_address_id NUMBER,
279: p_inventory_item_id NUMBER, p_uom_code VARCHAR2, p_ordered_date DATE )IS

Line 1212: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,

1208: precedence_10 ,
1209: jtc.tax_type ,
1210: nvl(jtc.rounding_factor,0) ;/*bduvarag for the bug#6071813*/
1211:
1212: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,
1213: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE)
1214: IS
1215: SELECT
1216: 'X'

Line 1213: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE)

1209: jtc.tax_type ,
1210: nvl(jtc.rounding_factor,0) ;/*bduvarag for the bug#6071813*/
1211:
1212: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,
1213: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE)
1214: IS
1215: SELECT
1216: 'X'
1217: FROM

Line 1218: JAI_OM_OE_RMA_TAXES

1214: IS
1215: SELECT
1216: 'X'
1217: FROM
1218: JAI_OM_OE_RMA_TAXES
1219: WHERE
1220: rma_line_id = p_line_id AND
1221: tax_id = p_tax_id ;
1222: /*Bug 14039657 - Added sum clause*/

Line 1637: INSERT INTO JAI_OM_OE_RMA_TAXES

1633: v_round_base := 0;
1634: v_round_func := 0;
1635: END IF;
1636:
1637: INSERT INTO JAI_OM_OE_RMA_TAXES
1638: (
1639: rma_line_id ,
1640: tax_line_no ,
1641: tax_id ,

Line 1773: INSERT INTO JAI_OM_OE_RMA_TAXES

1769: v_round_func := tax_line_rec.func_tax_amount;
1770: END IF; -- lv_check_vat_type_exists = 1 AND v_vat_flag = 'N'
1771: -- added by Allen Yang for bug 9691880 10-May-2010, end
1772:
1773: INSERT INTO JAI_OM_OE_RMA_TAXES
1774: (rma_line_id,
1775: delivery_detail_id,
1776: tax_line_no,
1777: precedence_1,

Line 1949: from JAI_OM_OE_RMA_TAXES

1945: );
1946:
1947: FOR cv_rma_taxes in
1948: (select *
1949: from JAI_OM_OE_RMA_TAXES
1950: where rma_line_id = pr_new.source_document_line_id
1951: )
1952: Loop
1953: insert into JAI_OM_OE_RMA_TAXES

Line 1953: insert into JAI_OM_OE_RMA_TAXES

1949: from JAI_OM_OE_RMA_TAXES
1950: where rma_line_id = pr_new.source_document_line_id
1951: )
1952: Loop
1953: insert into JAI_OM_OE_RMA_TAXES
1954: (
1955: rma_line_id ,
1956: tax_line_no ,
1957: precedence_1 ,

Line 2129: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,

2125: precedence_10 ,
2126: jtc.tax_type ,
2127: nvl(jtc.rounding_factor,0) ;/*bduvarag for the bug#6071813*/
2128:
2129: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,
2130: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE)
2131: IS
2132: SELECT
2133: 'X'

Line 2130: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE)

2126: jtc.tax_type ,
2127: nvl(jtc.rounding_factor,0) ;/*bduvarag for the bug#6071813*/
2128:
2129: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,
2130: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE)
2131: IS
2132: SELECT
2133: 'X'
2134: FROM

Line 2135: JAI_OM_OE_RMA_TAXES

2131: IS
2132: SELECT
2133: 'X'
2134: FROM
2135: JAI_OM_OE_RMA_TAXES
2136: WHERE
2137: rma_line_id = p_line_id AND
2138: tax_id = p_tax_id ;
2139: /*Bug 14039657 - Added sum clause*/

Line 2544: INSERT INTO JAI_OM_OE_RMA_TAXES

2540: v_round_func := 0;
2541: END IF;
2542:
2543:
2544: INSERT INTO JAI_OM_OE_RMA_TAXES
2545: (
2546: rma_line_id ,
2547: tax_line_no ,
2548: tax_id ,

Line 2675: INSERT INTO JAI_OM_OE_RMA_TAXES

2671: v_round_base := tax_line_rec.base_tax_amount;
2672: v_round_func := tax_line_rec.func_tax_amount;
2673: END IF; -- lv_check_vat_type_exists = 1 AND v_vat_flag = 'N'
2674:
2675: INSERT INTO JAI_OM_OE_RMA_TAXES
2676: (rma_line_id,
2677: delivery_detail_id,
2678: tax_line_no,
2679: precedence_1,

Line 2873: Get the rma trax lines detail from the table JAI_OM_OE_RMA_TAXES

2869: ELSIF v_source_order_category_code = 'RETURN' AND v_line_category_code = 'ORDER' THEN
2870: DECLARE
2871: /*
2872: Added by aiyer for the bug # #2798930.
2873: Get the rma trax lines detail from the table JAI_OM_OE_RMA_TAXES
2874: */
2875: CURSOR cur_get_JAI_OM_OE_RMA_TAXES (p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE)
2876: IS
2877: SELECT

Line 2875: CURSOR cur_get_JAI_OM_OE_RMA_TAXES (p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE)

2871: /*
2872: Added by aiyer for the bug # #2798930.
2873: Get the rma trax lines detail from the table JAI_OM_OE_RMA_TAXES
2874: */
2875: CURSOR cur_get_JAI_OM_OE_RMA_TAXES (p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE)
2876: IS
2877: SELECT
2878: tax_line_no ,
2879: tax_id ,

Line 2898: JAI_OM_OE_RMA_TAXES

2894: tax_amount ,
2895: base_tax_amount ,
2896: func_tax_amount
2897: FROM
2898: JAI_OM_OE_RMA_TAXES
2899: WHERE
2900: rma_line_id = p_line_id ;
2901:
2902:

Line 2919: rec_get_rma_tax_lines cur_get_JAI_OM_OE_RMA_TAXES%ROWTYPE;

2915: WHERE
2916: line_id = p_line_id1 AND
2917: tax_id = p_tax_id;
2918:
2919: rec_get_rma_tax_lines cur_get_JAI_OM_OE_RMA_TAXES%ROWTYPE;
2920: l_exists VARCHAR2(1);
2921:
2922: BEGIN
2923: pv_return_code := jai_constants.successful ;

Line 2925: FOR rec_get_rma_tax_lines in cur_get_JAI_OM_OE_RMA_TAXES ( p_line_id => v_source_document_line_id )

2921:
2922: BEGIN
2923: pv_return_code := jai_constants.successful ;
2924:
2925: FOR rec_get_rma_tax_lines in cur_get_JAI_OM_OE_RMA_TAXES ( p_line_id => v_source_document_line_id )
2926: loop
2927: l_tax_lines_exist := 'TRUE' ;
2928: OPEN cur_chk_tax_lines_exists ( p_line_id1 => v_line_id ,
2929: p_tax_id => rec_get_rma_tax_lines.tax_id

Line 3228: p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,

3224: /* End Bug# 4244829 */
3225:
3226: -- Check whether a rma_tax_lines exist for the new line_id and tax_id
3227: CURSOR cur_chk_rma_tax_lines_exists (
3228: p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,
3229: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE
3230: )
3231: IS
3232: SELECT

Line 3229: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE

3225:
3226: -- Check whether a rma_tax_lines exist for the new line_id and tax_id
3227: CURSOR cur_chk_rma_tax_lines_exists (
3228: p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,
3229: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE
3230: )
3231: IS
3232: SELECT
3233: 'X'

Line 3235: JAI_OM_OE_RMA_TAXES

3231: IS
3232: SELECT
3233: 'X'
3234: FROM
3235: JAI_OM_OE_RMA_TAXES
3236: WHERE
3237: rma_line_id = p_line_id AND
3238: tax_id = p_tax_id;
3239:

Line 3254: INSERT INTO JAI_OM_OE_RMA_TAXES

3250: );
3251: FETCH cur_chk_rma_tax_lines_exists INTO l_exists;
3252: IF cur_chk_rma_tax_lines_exists%NOTFOUND THEN
3253: -- Insert into ja_in_rma_entax_lines
3254: INSERT INTO JAI_OM_OE_RMA_TAXES
3255: (
3256: rma_line_id ,
3257: tax_line_no ,
3258: tax_id ,

Line 3731: DELETE JAI_OM_OE_RMA_TAXES

3727: IF ( v_transaction_name = 'RMA_LEGACY_INSERT') THEN
3728:
3729: DELETE JAI_OM_OE_RMA_LINES
3730: WHERE RMA_LINE_ID = V_LINE_ID;
3731: DELETE JAI_OM_OE_RMA_TAXES
3732: WHERE RMA_LINE_ID = V_LINE_ID;
3733: ELSE
3734: DELETE JAI_OM_OE_SO_LINES
3735: WHERE LINE_ID = v_line_id;