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_OM_TAX_PROCESSING_PKG dependencies on JAI_OM_OE_RMA_TAXES

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

826: WHERE line_id = p_line_id
827: AND header_id = p_header_id;
828:
829: /*
830: Get the rma trax lines detail from the table JAI_OM_OE_RMA_TAXES
831: */
832: CURSOR cur_get_JAI_OM_OE_RMA_TAXES(p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS
833: SELECT tax_line_no,
834: tax_id,

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

828:
829: /*
830: Get the rma trax lines detail from the table JAI_OM_OE_RMA_TAXES
831: */
832: CURSOR cur_get_JAI_OM_OE_RMA_TAXES(p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS
833: SELECT tax_line_no,
834: tax_id,
835: tax_rate,
836: qty_rate,

Line 851: FROM JAI_OM_OE_RMA_TAXES

847: precedence_10,
848: tax_amount,
849: base_tax_amount,
850: func_tax_amount
851: FROM JAI_OM_OE_RMA_TAXES
852: WHERE rma_line_id = p_line_id;
853:
854: /*
855: code to check whether a record exists in the table JAI_OM_OE_SO_TAXES for a given line_id and tax_id.

Line 864: rec_get_rma_tax_lines cur_get_JAI_OM_OE_RMA_TAXES%ROWTYPE;

860: FROM JAI_OM_OE_SO_TAXES
861: WHERE line_id = p_line_id1
862: AND tax_id = p_tax_id;
863:
864: rec_get_rma_tax_lines cur_get_JAI_OM_OE_RMA_TAXES%ROWTYPE;
865: l_tax_lines_exist VARCHAR2(10);
866: rec_cur_get_rma_entry_lines cur_get_rma_entry_lines%ROWTYPE;
867: l_exists VARCHAR2(1);
868: l_tax_exists VARCHAR2(2);

Line 954: FOR rec_get_rma_tax_lines in cur_get_JAI_OM_OE_RMA_TAXES(p_line_id => pr_order_line.SOURCE_DOCUMENT_LINE_ID) loop

950:
951: /********************* Return TO Order tax lines computation **************************/
952: l_tax_lines_exist := 'FALSE';
953:
954: FOR rec_get_rma_tax_lines in cur_get_JAI_OM_OE_RMA_TAXES(p_line_id => pr_order_line.SOURCE_DOCUMENT_LINE_ID) loop
955: l_tax_lines_exist := 'TRUE';
956: OPEN cur_chk_tax_lines_exists(p_line_id1 => pr_order_line.line_id,
957: p_tax_id => rec_get_rma_tax_lines.tax_id);
958: FETCH cur_chk_tax_lines_exists

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

1299: precedence_9,
1300: precedence_10;
1301:
1302: -- Check whether a rma_tax_lines exist for the new line_id and tax_id
1303: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE,
1304: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE) IS
1305: SELECT 'X'
1306: FROM JAI_OM_OE_RMA_TAXES
1307: WHERE rma_line_id = p_line_id

Line 1304: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE) IS

1300: precedence_10;
1301:
1302: -- Check whether a rma_tax_lines exist for the new line_id and tax_id
1303: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE,
1304: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE) IS
1305: SELECT 'X'
1306: FROM JAI_OM_OE_RMA_TAXES
1307: WHERE rma_line_id = p_line_id
1308: AND tax_id = p_tax_id;

Line 1306: FROM JAI_OM_OE_RMA_TAXES

1302: -- Check whether a rma_tax_lines exist for the new line_id and tax_id
1303: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE,
1304: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE) IS
1305: SELECT 'X'
1306: FROM JAI_OM_OE_RMA_TAXES
1307: WHERE rma_line_id = p_line_id
1308: AND tax_id = p_tax_id;
1309:
1310: l_tax_exists VARCHAR2(1);

Line 1557: INSERT INTO JAI_OM_OE_RMA_TAXES

1553: v_round_base := 0;
1554: v_round_func := 0;
1555: END IF;
1556:
1557: INSERT INTO JAI_OM_OE_RMA_TAXES
1558: (rma_line_id,
1559: tax_line_no,
1560: tax_id,
1561: tax_rate,

Line 1680: INSERT INTO JAI_OM_OE_RMA_TAXES

1676: v_round_base := tax_line_rec.base_tax_amount;
1677: v_round_func := tax_line_rec.func_tax_amount;
1678: END IF; -- lv_check_vat_type_exists = 1 AND v_vat_flag = 'N'
1679:
1680: INSERT INTO JAI_OM_OE_RMA_TAXES
1681: (rma_line_id,
1682: delivery_detail_id,
1683: tax_line_no,
1684: precedence_1,

Line 1756: INSERT INTO JAI_OM_OE_RMA_TAXES

1752: p_tax_id => rec_cur_get_picking_tax_lines.tax_id);
1753: FETCH cur_chk_rma_tax_lines_exists
1754: INTO l_tax_exists;
1755: IF cur_chk_rma_tax_lines_exists%NOTFOUND THEN
1756: INSERT INTO JAI_OM_OE_RMA_TAXES
1757: (rma_line_id,
1758: tax_line_no,
1759: tax_id,
1760: tax_rate,

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

1929: precedence_10,
1930: jtc.tax_type,
1931: nvl(jtc.rounding_factor, 0);
1932:
1933: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE,
1934: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE) IS
1935: SELECT 'X'
1936: FROM JAI_OM_OE_RMA_TAXES
1937: WHERE rma_line_id = p_line_id

Line 1934: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE) IS

1930: jtc.tax_type,
1931: nvl(jtc.rounding_factor, 0);
1932:
1933: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE,
1934: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE) IS
1935: SELECT 'X'
1936: FROM JAI_OM_OE_RMA_TAXES
1937: WHERE rma_line_id = p_line_id
1938: AND tax_id = p_tax_id;

Line 1936: FROM JAI_OM_OE_RMA_TAXES

1932:
1933: CURSOR cur_chk_rma_tax_lines_exists(p_line_id JAI_OM_OE_RMA_TAXES.RMA_LINE_ID%TYPE,
1934: p_tax_id JAI_OM_OE_RMA_TAXES.TAX_ID%TYPE) IS
1935: SELECT 'X'
1936: FROM JAI_OM_OE_RMA_TAXES
1937: WHERE rma_line_id = p_line_id
1938: AND tax_id = p_tax_id;
1939: CURSOR c_get_quantity(p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type,
1940: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type) IS

Line 2109: from JAI_OM_OE_RMA_TAXES

2105: null,
2106: pr_order_line.ship_to_org_id);
2107:
2108: FOR cv_rma_taxes in (select *
2109: from JAI_OM_OE_RMA_TAXES
2110: where rma_line_id =
2111: pr_order_line.source_document_line_id) Loop
2112: insert into JAI_OM_OE_RMA_TAXES
2113: (rma_line_id,

Line 2112: insert into JAI_OM_OE_RMA_TAXES

2108: FOR cv_rma_taxes in (select *
2109: from JAI_OM_OE_RMA_TAXES
2110: where rma_line_id =
2111: pr_order_line.source_document_line_id) Loop
2112: insert into JAI_OM_OE_RMA_TAXES
2113: (rma_line_id,
2114: tax_line_no,
2115: precedence_1,
2116: precedence_2,

Line 2391: INSERT INTO JAI_OM_OE_RMA_TAXES

2387: v_round_base := 0;
2388: v_round_func := 0;
2389: END IF;
2390:
2391: INSERT INTO JAI_OM_OE_RMA_TAXES
2392: (rma_line_id,
2393: tax_line_no,
2394: tax_id,
2395: tax_rate,

Line 2514: INSERT INTO JAI_OM_OE_RMA_TAXES

2510: v_round_base := tax_line_rec.base_tax_amount;
2511: v_round_func := tax_line_rec.func_tax_amount;
2512: END IF; -- lv_check_vat_type_exists = 1 AND v_vat_flag = 'N'
2513:
2514: INSERT INTO JAI_OM_OE_RMA_TAXES
2515: (rma_line_id,
2516: delivery_detail_id,
2517: tax_line_no,
2518: precedence_1,

Line 2720: FROM JAI_OM_OE_RMA_TAXES

2716: WHERE header_id = pr_order_line.header_id;
2717:
2718: CURSOR get_rma_tax_lines_count_cur IS
2719: SELECT COUNT(1)
2720: FROM JAI_OM_OE_RMA_TAXES
2721: WHERE rma_line_id = pr_order_line.line_id;
2722:
2723: CURSOR get_so_tax_lines_count_cur(p_header_id NUMBER, p_line_id NUMBER) IS
2724: SELECT COUNT(1)

Line 2741: FROM JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b

2737: WHERE line_id = p_line_id;
2738:
2739: CURSOR return_tax_amount_Cur(p_header_id NUMBER, p_line_id NUMBER) IS
2740: SELECT SUM(A.tax_amount)
2741: FROM JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b
2742: WHERE a.rma_line_id = p_line_id
2743: AND b.tax_id = A.tax_id
2744: AND b.tax_type <> jai_constants.tax_type_tds /* 'TDS'; Ramananda for removal of SQL LITERALs */
2745: AND NVL(b.inclusive_tax_flag, 'N') = 'N';

Line 2878: DELETE JAI_OM_OE_RMA_TAXES WHERE RMA_LINE_ID = pr_order_line.line_id;

2874:
2875: IF (v_transaction_name = 'RMA_LEGACY_INSERT') THEN
2876:
2877: DELETE JAI_OM_OE_RMA_LINES WHERE RMA_LINE_ID = pr_order_line.line_id;
2878: DELETE JAI_OM_OE_RMA_TAXES WHERE RMA_LINE_ID = pr_order_line.line_id;
2879: ELSE
2880: DELETE JAI_OM_OE_SO_LINES WHERE LINE_ID = pr_order_line.line_id;
2881: DELETE JAI_OM_OE_SO_TAXES WHERE Line_ID = pr_order_line.line_id;
2882: END IF;