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_SO_TAXES

Line 60: DELETE JAI_OM_OE_SO_TAXES

56: DELETE JAI_OM_OE_SO_LINES
57: WHERE header_id = v_header_id
58: AND line_id = v_line_id;
59:
60: DELETE JAI_OM_OE_SO_TAXES
61: WHERE header_id = v_header_id
62: AND line_id = v_line_id;
63: END IF;
64: /* Added an exception block by Ramananda for bug#4570303 */

Line 226: FROM JAI_OM_OE_SO_TAXES

222: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
223: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10, -- precedence 6 to 10 added for bug#6485212
224: tax_amount, base_tax_amount, func_tax_amount,
225: tax_category_id -- cbabu for EnhancementBug# 2427465
226: FROM JAI_OM_OE_SO_TAXES
227: WHERE header_id = p_header_id
228: AND line_id = p_line_id;
229:
230: --Added by Nagaraj.s for Bug3140153.

Line 241: FROM JAI_OM_OE_SO_TAXES A,

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,
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

Line 269: FROM JAI_OM_OE_SO_TAXES

265: WHERE rma_line_id = v_line_id;
266:
267: CURSOR get_so_tax_lines_count_cur( p_header_id NUMBER, p_line_id NUMBER) IS
268: SELECT COUNT(1)
269: FROM JAI_OM_OE_SO_TAXES
270: WHERE header_id = p_header_id
271: AND line_id = p_line_id;
272:
273: CURSOR get_rma_tax_lines_count_cur IS

Line 778: DELETE JAI_OM_OE_SO_TAXES

774: IF pv_action = jai_constants.updating AND pr_new.inventory_item_id <> pr_old.inventory_item_id THEN
775: DELETE JAI_OM_OE_SO_LINES
776: WHERE line_id = pr_new.line_id;
777:
778: DELETE JAI_OM_OE_SO_TAXES
779: WHERE line_id = pr_new.line_id;
780:
781: END IF;
782:

Line 1343: JAI_OM_OE_SO_TAXES

1339: IS
1340: SELECT
1341: tax_amount
1342: FROM
1343: JAI_OM_OE_SO_TAXES
1344: WHERE
1345: line_id = pr_new.reference_line_id
1346: AND tax_id = p_tax_id ;
1347:

Line 2253: JAI_OM_OE_SO_TAXES

2249: IS
2250: SELECT
2251: tax_amount
2252: FROM
2253: JAI_OM_OE_SO_TAXES
2254: WHERE
2255: line_id = pr_new.reference_line_id
2256: AND tax_id = p_tax_id ;
2257:

Line 2773: --code to check the existing line in table JAI_OM_OE_SO_TAXES for bug #2519043

2769: IF NVL(v_so_tax_lines_count,0)>0 THEN
2770: l_tax_lines_exist := 'TRUE' ;
2771: FOR Rec IN So_Tax_Lines_Cur(V_SOURCE_DOCUMENT_ID, V_SOURCE_DOCUMENT_LINE_ID)
2772: LOOP
2773: --code to check the existing line in table JAI_OM_OE_SO_TAXES for bug #2519043
2774: SELECT COUNT(1) INTO v_tax_line_count
2775: FROM JAI_OM_OE_SO_TAXES
2776: WHERE line_id = v_line_id
2777: AND tax_id = rec.tax_id ;

Line 2775: FROM JAI_OM_OE_SO_TAXES

2771: FOR Rec IN So_Tax_Lines_Cur(V_SOURCE_DOCUMENT_ID, V_SOURCE_DOCUMENT_LINE_ID)
2772: LOOP
2773: --code to check the existing line in table JAI_OM_OE_SO_TAXES for bug #2519043
2774: SELECT COUNT(1) INTO v_tax_line_count
2775: FROM JAI_OM_OE_SO_TAXES
2776: WHERE line_id = v_line_id
2777: AND tax_id = rec.tax_id ;
2778:
2779: IF v_tax_line_count = 0 THEN

Line 2791: INSERT INTO JAI_OM_OE_SO_TAXES (

2787: || Start additions by bgowrava for forward porting bug#4895477 - Copy Order
2788: */
2789:
2790:
2791: INSERT INTO JAI_OM_OE_SO_TAXES (
2792: header_id, line_id, tax_line_no, tax_id,
2793: tax_rate, qty_rate, uom, precedence_1,
2794: precedence_2, precedence_3, precedence_4, precedence_5,
2795: /*precedence 6 to 10 added by csahoo for bug#6485212 */

Line 2905: code to check whether a record exists in the table JAI_OM_OE_SO_TAXES for a given line_id and tax_id.

2901:
2902:
2903: /*
2904: Added by aiyer for the bug # #2798930.
2905: code to check whether a record exists in the table JAI_OM_OE_SO_TAXES for a given line_id and tax_id.
2906: */
2907: CURSOR cur_chk_tax_lines_exists ( p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
2908: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE
2909: )

Line 2908: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE

2904: Added by aiyer for the bug # #2798930.
2905: code to check whether a record exists in the table JAI_OM_OE_SO_TAXES for a given line_id and tax_id.
2906: */
2907: CURSOR cur_chk_tax_lines_exists ( p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
2908: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE
2909: )
2910: IS
2911: SELECT
2912: 'X'

Line 2914: JAI_OM_OE_SO_TAXES

2910: IS
2911: SELECT
2912: 'X'
2913: FROM
2914: JAI_OM_OE_SO_TAXES
2915: WHERE
2916: line_id = p_line_id1 AND
2917: tax_id = p_tax_id;
2918:

Line 2935: INSERT INTO JAI_OM_OE_SO_TAXES (

2931: FETCH cur_chk_tax_lines_exists INTO l_exists;
2932: IF cur_chk_tax_lines_exists%NOTFOUND THEN
2933: -- Insert into JAI_OM_OE_SO_LINES
2934:
2935: INSERT INTO JAI_OM_OE_SO_TAXES (
2936: header_id ,
2937: line_id ,
2938: tax_line_no ,
2939: tax_id ,

Line 3499: --code to check the existing line in table JAI_OM_OE_SO_TAXES for bug #2519043

3495: v_new_func_tax_amount := round((rec.func_tax_amount/v_old_quantity )*(v_line_quantity), v_rounding_factor);
3496: --Added by Nagaraj.s for Bug3140153
3497: v_header_tax_amount := v_header_tax_amount + v_new_tax_amount;
3498: *//*7523501*/
3499: --code to check the existing line in table JAI_OM_OE_SO_TAXES for bug #2519043
3500: SELECT COUNT(1) INTO v_tax_line_count
3501: FROM JAI_OM_OE_SO_TAXES
3502: WHERE line_id = v_line_id
3503: AND tax_id = rec.tax_id ;

Line 3501: FROM JAI_OM_OE_SO_TAXES

3497: v_header_tax_amount := v_header_tax_amount + v_new_tax_amount;
3498: *//*7523501*/
3499: --code to check the existing line in table JAI_OM_OE_SO_TAXES for bug #2519043
3500: SELECT COUNT(1) INTO v_tax_line_count
3501: FROM JAI_OM_OE_SO_TAXES
3502: WHERE line_id = v_line_id
3503: AND tax_id = rec.tax_id ;
3504:
3505: IF v_tax_line_count = 0 THEN

Line 3546: INSERT INTO JAI_OM_OE_SO_TAXES (

3542: v_new_func_tax_amount := round((rec.func_tax_amount/v_old_quantity )*(v_line_quantity), v_rounding_factor);
3543: --Added by Nagaraj.s for Bug3140153
3544: v_header_tax_amount := v_header_tax_amount + v_new_tax_amount;
3545: /*end bug 7523501*/
3546: INSERT INTO JAI_OM_OE_SO_TAXES (
3547: header_id, line_id, tax_line_no, tax_id,
3548: tax_rate, qty_rate, uom, precedence_1,
3549: precedence_2, precedence_3, precedence_4, precedence_5,
3550: /*precedence 6 to 10 added by csahoo for bug#6485212 */

Line 3736: DELETE JAI_OM_OE_SO_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;
3736: DELETE JAI_OM_OE_SO_TAXES
3737: WHERE Line_ID = v_line_id;
3738: END IF;
3739: END IF;
3740:

Line 4047: from JAI_OM_OE_SO_TAXES

4043: Declare
4044:
4045: cursor c_model_taxes is
4046: select *
4047: from JAI_OM_OE_SO_TAXES
4048: where header_id = pr_new.header_id
4049: and line_id = pr_new.ato_line_id ;
4050: -- ato_line_id gets the line_id of the model item
4051:

Line 4093: Insert into JAI_OM_OE_SO_TAXES

4089: -- select ' before insert 3 values are : ' || model_rec.precedence_5|| model_rec.tax_id|| model_rec.tax_rate|| model_rec.qty_rate|| model_rec.uom into v_trigg_stat from dual;
4090: -- select ' before insert 4 values are : ' || model_rec.tax_amount || model_rec.base_tax_amount|| model_rec.func_tax_amount|| model_rec.creation_date into v_trigg_stat from dual;
4091: -- select ' before insert 5 values are : ' || model_rec.created_by || model_rec.last_update_date|| model_rec.last_updated_by|| model_rec.last_update_login|| model_rec.tax_category_id into v_trigg_stat from dual;
4092:
4093: Insert into JAI_OM_OE_SO_TAXES
4094: (
4095: tax_line_no ,
4096: line_id ,
4097: header_id ,

Line 4312: JAI_OM_OE_SO_TAXES joost

4308: , joost.Tax_Amount
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;

Line 5017: FROM JAI_OM_OE_SO_TAXES a,

5013:
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