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 207: FROM JAI_OM_OE_SO_TAXES

203: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
204: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10, -- precedence 6 to 10 added for bug#6485212
205: tax_amount, base_tax_amount, func_tax_amount,
206: tax_category_id -- cbabu for EnhancementBug# 2427465
207: FROM JAI_OM_OE_SO_TAXES
208: WHERE header_id = p_header_id
209: AND line_id = p_line_id;
210:
211: --Added by Nagaraj.s for Bug3140153.

Line 222: FROM JAI_OM_OE_SO_TAXES A,

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

Line 250: FROM JAI_OM_OE_SO_TAXES

246: WHERE rma_line_id = v_line_id;
247:
248: CURSOR get_so_tax_lines_count_cur( p_header_id NUMBER, p_line_id NUMBER) IS
249: SELECT COUNT(1)
250: FROM JAI_OM_OE_SO_TAXES
251: WHERE header_id = p_header_id
252: AND line_id = p_line_id;
253:
254: CURSOR get_rma_tax_lines_count_cur IS

Line 645: DELETE JAI_OM_OE_SO_TAXES

641: IF pv_action = jai_constants.updating AND pr_new.inventory_item_id <> pr_old.inventory_item_id THEN
642: DELETE JAI_OM_OE_SO_LINES
643: WHERE line_id = pr_new.line_id;
644:
645: DELETE JAI_OM_OE_SO_TAXES
646: WHERE line_id = pr_new.line_id;
647:
648: END IF;
649:

Line 1147: JAI_OM_OE_SO_TAXES

1143: IS
1144: SELECT
1145: tax_amount
1146: FROM
1147: JAI_OM_OE_SO_TAXES
1148: WHERE
1149: line_id = pr_new.reference_line_id
1150: AND tax_id = p_tax_id ;
1151:

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

1665: IF NVL(v_so_tax_lines_count,0)>0 THEN
1666: l_tax_lines_exist := 'TRUE' ;
1667: FOR Rec IN So_Tax_Lines_Cur(V_SOURCE_DOCUMENT_ID, V_SOURCE_DOCUMENT_LINE_ID)
1668: LOOP
1669: --code to check the existing line in table JAI_OM_OE_SO_TAXES for bug #2519043
1670: SELECT COUNT(1) INTO v_tax_line_count
1671: FROM JAI_OM_OE_SO_TAXES
1672: WHERE line_id = v_line_id
1673: AND tax_id = rec.tax_id ;

Line 1671: FROM JAI_OM_OE_SO_TAXES

1667: FOR Rec IN So_Tax_Lines_Cur(V_SOURCE_DOCUMENT_ID, V_SOURCE_DOCUMENT_LINE_ID)
1668: LOOP
1669: --code to check the existing line in table JAI_OM_OE_SO_TAXES for bug #2519043
1670: SELECT COUNT(1) INTO v_tax_line_count
1671: FROM JAI_OM_OE_SO_TAXES
1672: WHERE line_id = v_line_id
1673: AND tax_id = rec.tax_id ;
1674:
1675: IF v_tax_line_count = 0 THEN

Line 1687: INSERT INTO JAI_OM_OE_SO_TAXES (

1683: || Start additions by bgowrava for forward porting bug#4895477 - Copy Order
1684: */
1685:
1686:
1687: INSERT INTO JAI_OM_OE_SO_TAXES (
1688: header_id, line_id, tax_line_no, tax_id,
1689: tax_rate, qty_rate, uom, precedence_1,
1690: precedence_2, precedence_3, precedence_4, precedence_5,
1691: /*precedence 6 to 10 added by csahoo for bug#6485212 */

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

1781:
1782:
1783: /*
1784: Added by aiyer for the bug # #2798930.
1785: code to check whether a record exists in the table JAI_OM_OE_SO_TAXES for a given line_id and tax_id.
1786: */
1787: CURSOR cur_chk_tax_lines_exists ( p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
1788: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE
1789: )

Line 1788: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE

1784: Added by aiyer for the bug # #2798930.
1785: code to check whether a record exists in the table JAI_OM_OE_SO_TAXES for a given line_id and tax_id.
1786: */
1787: CURSOR cur_chk_tax_lines_exists ( p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE ,
1788: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE
1789: )
1790: IS
1791: SELECT
1792: 'X'

Line 1794: JAI_OM_OE_SO_TAXES

1790: IS
1791: SELECT
1792: 'X'
1793: FROM
1794: JAI_OM_OE_SO_TAXES
1795: WHERE
1796: line_id = p_line_id1 AND
1797: tax_id = p_tax_id;
1798:

Line 1815: INSERT INTO JAI_OM_OE_SO_TAXES (

1811: FETCH cur_chk_tax_lines_exists INTO l_exists;
1812: IF cur_chk_tax_lines_exists%NOTFOUND THEN
1813: -- Insert into JAI_OM_OE_SO_LINES
1814:
1815: INSERT INTO JAI_OM_OE_SO_TAXES (
1816: header_id ,
1817: line_id ,
1818: tax_line_no ,
1819: tax_id ,

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

2355: v_new_func_tax_amount := round((rec.func_tax_amount/v_old_quantity )*(v_line_quantity), v_rounding_factor);
2356: --Added by Nagaraj.s for Bug3140153
2357: v_header_tax_amount := v_header_tax_amount + v_new_tax_amount;
2358: *//*7523501*/
2359: --code to check the existing line in table JAI_OM_OE_SO_TAXES for bug #2519043
2360: SELECT COUNT(1) INTO v_tax_line_count
2361: FROM JAI_OM_OE_SO_TAXES
2362: WHERE line_id = v_line_id
2363: AND tax_id = rec.tax_id ;

Line 2361: FROM JAI_OM_OE_SO_TAXES

2357: v_header_tax_amount := v_header_tax_amount + v_new_tax_amount;
2358: *//*7523501*/
2359: --code to check the existing line in table JAI_OM_OE_SO_TAXES for bug #2519043
2360: SELECT COUNT(1) INTO v_tax_line_count
2361: FROM JAI_OM_OE_SO_TAXES
2362: WHERE line_id = v_line_id
2363: AND tax_id = rec.tax_id ;
2364:
2365: IF v_tax_line_count = 0 THEN

Line 2406: INSERT INTO JAI_OM_OE_SO_TAXES (

2402: v_new_func_tax_amount := round((rec.func_tax_amount/v_old_quantity )*(v_line_quantity), v_rounding_factor);
2403: --Added by Nagaraj.s for Bug3140153
2404: v_header_tax_amount := v_header_tax_amount + v_new_tax_amount;
2405: /*end bug 7523501*/
2406: INSERT INTO JAI_OM_OE_SO_TAXES (
2407: header_id, line_id, tax_line_no, tax_id,
2408: tax_rate, qty_rate, uom, precedence_1,
2409: precedence_2, precedence_3, precedence_4, precedence_5,
2410: /*precedence 6 to 10 added by csahoo for bug#6485212 */

Line 2571: DELETE JAI_OM_OE_SO_TAXES

2567: WHERE RMA_LINE_ID = V_LINE_ID;
2568: ELSE
2569: DELETE JAI_OM_OE_SO_LINES
2570: WHERE LINE_ID = v_line_id;
2571: DELETE JAI_OM_OE_SO_TAXES
2572: WHERE Line_ID = v_line_id;
2573: END IF;
2574: END IF;
2575:

Line 2831: from JAI_OM_OE_SO_TAXES

2827: Declare
2828:
2829: cursor c_model_taxes is
2830: select *
2831: from JAI_OM_OE_SO_TAXES
2832: where header_id = pr_new.header_id
2833: and line_id = pr_new.ato_line_id ;
2834: -- ato_line_id gets the line_id of the model item
2835:

Line 2877: Insert into JAI_OM_OE_SO_TAXES

2873: -- 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;
2874: -- 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;
2875: -- 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;
2876:
2877: Insert into JAI_OM_OE_SO_TAXES
2878: (
2879: tax_line_no ,
2880: line_id ,
2881: header_id ,

Line 3115: FROM JAI_OM_OE_SO_TAXES a,

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