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.

[Home] [Help]

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

252: AND line_id = p_line_id;
253:
254: CURSOR get_rma_tax_lines_count_cur IS
255: SELECT COUNT(1)
256: FROM JAI_OM_OE_RMA_TAXES
257: WHERE rma_line_id = pr_new.line_id;
258:
259: CURSOR get_assessable_value_cur(p_customer_id NUMBER, p_address_id NUMBER,
260: p_inventory_item_id NUMBER, p_uom_code VARCHAR2, p_ordered_date DATE )IS

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

1027: precedence_10 ,
1028: jtc.tax_type ,
1029: nvl(jtc.rounding_factor,0) ;/*bduvarag for the bug#6071813*/
1030:
1031: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,
1032: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE)
1033: IS
1034: SELECT
1035: 'X'

Line 1032: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE)

1028: jtc.tax_type ,
1029: nvl(jtc.rounding_factor,0) ;/*bduvarag for the bug#6071813*/
1030:
1031: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,
1032: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE)
1033: IS
1034: SELECT
1035: 'X'
1036: FROM

Line 1037: JAI_OM_OE_RMA_TAXES

1033: IS
1034: SELECT
1035: 'X'
1036: FROM
1037: JAI_OM_OE_RMA_TAXES
1038: WHERE
1039: rma_line_id = p_line_id AND
1040: tax_id = p_tax_id ;
1041:

Line 1387: INSERT INTO JAI_OM_OE_RMA_TAXES

1383: v_round_base := 0;
1384: v_round_func := 0;
1385: END IF;
1386:
1387: INSERT INTO JAI_OM_OE_RMA_TAXES
1388: (
1389: rma_line_id ,
1390: tax_line_no ,
1391: tax_id ,

Line 1570: from JAI_OM_OE_RMA_TAXES

1566: );
1567:
1568: FOR cv_rma_taxes in
1569: (select *
1570: from JAI_OM_OE_RMA_TAXES
1571: where rma_line_id = pr_new.source_document_line_id
1572: )
1573: Loop
1574: insert into JAI_OM_OE_RMA_TAXES

Line 1574: insert into JAI_OM_OE_RMA_TAXES

1570: from JAI_OM_OE_RMA_TAXES
1571: where rma_line_id = pr_new.source_document_line_id
1572: )
1573: Loop
1574: insert into JAI_OM_OE_RMA_TAXES
1575: (
1576: rma_line_id ,
1577: tax_line_no ,
1578: precedence_1 ,

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

1749: ELSIF v_source_order_category_code = 'RETURN' AND v_line_category_code = 'ORDER' THEN
1750: DECLARE
1751: /*
1752: Added by aiyer for the bug # #2798930.
1753: Get the rma trax lines detail from the table JAI_OM_OE_RMA_TAXES
1754: */
1755: CURSOR cur_get_JAI_OM_OE_RMA_TAXES (p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE)
1756: IS
1757: SELECT

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

1751: /*
1752: Added by aiyer for the bug # #2798930.
1753: Get the rma trax lines detail from the table JAI_OM_OE_RMA_TAXES
1754: */
1755: CURSOR cur_get_JAI_OM_OE_RMA_TAXES (p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE)
1756: IS
1757: SELECT
1758: tax_line_no ,
1759: tax_id ,

Line 1778: JAI_OM_OE_RMA_TAXES

1774: tax_amount ,
1775: base_tax_amount ,
1776: func_tax_amount
1777: FROM
1778: JAI_OM_OE_RMA_TAXES
1779: WHERE
1780: rma_line_id = p_line_id ;
1781:
1782:

Line 1799: rec_get_rma_tax_lines cur_get_JAI_OM_OE_RMA_TAXES%ROWTYPE;

1795: WHERE
1796: line_id = p_line_id1 AND
1797: tax_id = p_tax_id;
1798:
1799: rec_get_rma_tax_lines cur_get_JAI_OM_OE_RMA_TAXES%ROWTYPE;
1800: l_exists VARCHAR2(1);
1801:
1802: BEGIN
1803: pv_return_code := jai_constants.successful ;

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

1801:
1802: BEGIN
1803: pv_return_code := jai_constants.successful ;
1804:
1805: FOR rec_get_rma_tax_lines in cur_get_JAI_OM_OE_RMA_TAXES ( p_line_id => v_source_document_line_id )
1806: loop
1807: l_tax_lines_exist := 'TRUE' ;
1808: OPEN cur_chk_tax_lines_exists ( p_line_id1 => v_line_id ,
1809: p_tax_id => rec_get_rma_tax_lines.tax_id

Line 2091: p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,

2087: /* End Bug# 4244829 */
2088:
2089: -- Check whether a rma_tax_lines exist for the new line_id and tax_id
2090: CURSOR cur_chk_rma_tax_lines_exists (
2091: p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,
2092: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE
2093: )
2094: IS
2095: SELECT

Line 2092: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE

2088:
2089: -- Check whether a rma_tax_lines exist for the new line_id and tax_id
2090: CURSOR cur_chk_rma_tax_lines_exists (
2091: p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE ,
2092: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE
2093: )
2094: IS
2095: SELECT
2096: 'X'

Line 2098: JAI_OM_OE_RMA_TAXES

2094: IS
2095: SELECT
2096: 'X'
2097: FROM
2098: JAI_OM_OE_RMA_TAXES
2099: WHERE
2100: rma_line_id = p_line_id AND
2101: tax_id = p_tax_id;
2102:

Line 2117: INSERT INTO JAI_OM_OE_RMA_TAXES

2113: );
2114: FETCH cur_chk_rma_tax_lines_exists INTO l_exists;
2115: IF cur_chk_rma_tax_lines_exists%NOTFOUND THEN
2116: -- Insert into ja_in_rma_entax_lines
2117: INSERT INTO JAI_OM_OE_RMA_TAXES
2118: (
2119: rma_line_id ,
2120: tax_line_no ,
2121: tax_id ,

Line 2566: DELETE JAI_OM_OE_RMA_TAXES

2562: IF ( v_transaction_name = 'RMA_LEGACY_INSERT') THEN
2563:
2564: DELETE JAI_OM_OE_RMA_LINES
2565: WHERE RMA_LINE_ID = V_LINE_ID;
2566: DELETE JAI_OM_OE_RMA_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;