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

Line 120: -- The following cursor gets the sum of tax amount for the line_id from JAI_OM_OE_SO_TAXES table

116: WHERE
117: line_id = p_rec_new.line_id AND
118: header_id = p_rec_new.header_id;
119:
120: -- The following cursor gets the sum of tax amount for the line_id from JAI_OM_OE_SO_TAXES table
121: CURSOR c_ja_in_so_tax_lines_tax_amt
122: IS
123: SELECT
124: nvl(sum(so_tax.tax_amount),0)

Line 126: JAI_OM_OE_SO_TAXES so_tax

122: IS
123: SELECT
124: nvl(sum(so_tax.tax_amount),0)
125: FROM
126: JAI_OM_OE_SO_TAXES so_tax
127: , jai_cmn_taxes_all tax
128: WHERE
129: line_id = p_rec_new.line_id AND
130: header_id = p_rec_new.header_id

Line 163: CURSOR cur_chk_vat_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,

159: lv_applicable JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_CODE%TYPE;
160: lv_process_flag VARCHAR2 (2);
161: lv_process_message VARCHAR2 (1000);
162:
163: CURSOR cur_chk_vat_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,
164: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE)
165: IS
166: SELECT 1
167: FROM JAI_OM_OE_SO_TAXES jstl ,

Line 164: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE)

160: lv_process_flag VARCHAR2 (2);
161: lv_process_message VARCHAR2 (1000);
162:
163: CURSOR cur_chk_vat_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,
164: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE)
165: IS
166: SELECT 1
167: FROM JAI_OM_OE_SO_TAXES jstl ,
168: JAI_CMN_TAXES_ALL jtc ,

Line 167: FROM JAI_OM_OE_SO_TAXES jstl ,

163: CURSOR cur_chk_vat_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,
164: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE)
165: IS
166: SELECT 1
167: FROM JAI_OM_OE_SO_TAXES jstl ,
168: JAI_CMN_TAXES_ALL jtc ,
169: jai_regime_tax_types_v tax_types
170: WHERE jstl.line_id = cp_line_id
171: AND jstl.header_id = cp_header_id

Line 176: CURSOR cur_chk_excise_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,

172: AND jtc.tax_id = jstl.tax_id
173: AND jtc.tax_type = tax_types.tax_type
174: AND tax_types.regime_code = jai_constants.vat_regime;
175:
176: CURSOR cur_chk_excise_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,
177: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE
178: )
179: IS
180: SELECT 1

Line 177: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE

173: AND jtc.tax_type = tax_types.tax_type
174: AND tax_types.regime_code = jai_constants.vat_regime;
175:
176: CURSOR cur_chk_excise_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,
177: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE
178: )
179: IS
180: SELECT 1
181: FROM JAI_OM_OE_SO_TAXES jstl ,

Line 181: FROM JAI_OM_OE_SO_TAXES jstl ,

177: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE
178: )
179: IS
180: SELECT 1
181: FROM JAI_OM_OE_SO_TAXES jstl ,
182: JAI_CMN_TAXES_ALL jtc
183: WHERE jstl.line_id = cp_line_id
184: AND jstl.header_id = cp_header_id
185: AND jtc.tax_id = jstl.tax_id

Line 551: FROM JAI_OM_OE_SO_TAXES

547: v_api_name CONSTANT VARCHAR2(30) := 'COPY_ORDER_TO_ORDER';
548:
549: CURSOR get_so_tax_lines_count_cur(p_header_id NUMBER, p_line_id NUMBER) IS
550: SELECT COUNT(1)
551: FROM JAI_OM_OE_SO_TAXES
552: WHERE header_id = p_header_id
553: AND line_id = p_line_id;
554:
555: CURSOR so_tax_lines_cur(p_header_id NUMBER, p_line_id NUMBER) IS

Line 575: FROM JAI_OM_OE_SO_TAXES

571: tax_amount,
572: base_tax_amount,
573: func_tax_amount,
574: tax_category_id
575: FROM JAI_OM_OE_SO_TAXES
576: WHERE header_id = p_header_id
577: AND line_id = p_line_id;
578:
579: c_source_line_id NUMBER;

Line 671: FROM JAI_OM_OE_SO_TAXES

667: FOR Rec IN So_Tax_Lines_Cur(pr_order_line.SOURCE_DOCUMENT_ID,
668: pr_order_line.SOURCE_DOCUMENT_LINE_ID) LOOP
669: SELECT COUNT(1)
670: INTO v_tax_line_count
671: FROM JAI_OM_OE_SO_TAXES
672: WHERE line_id = pr_order_line.line_id
673: AND tax_id = rec.tax_id;
674:
675: IF v_tax_line_count = 0 THEN

Line 681: INSERT INTO JAI_OM_OE_SO_TAXES

677: /*
678: || call to the ja_in_calc_Taxes_ato would do the trick thru re-calculating the taxes.
679: */
680:
681: INSERT INTO JAI_OM_OE_SO_TAXES
682: (header_id,
683: line_id,
684: tax_line_no,
685: tax_id,

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

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.
856: */
857: CURSOR cur_chk_tax_lines_exists(p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE,
858: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE) IS
859: SELECT 'X'

Line 858: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE) IS

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.
856: */
857: CURSOR cur_chk_tax_lines_exists(p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE,
858: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE) IS
859: SELECT 'X'
860: FROM JAI_OM_OE_SO_TAXES
861: WHERE line_id = p_line_id1
862: AND tax_id = p_tax_id;

Line 860: FROM JAI_OM_OE_SO_TAXES

856: */
857: CURSOR cur_chk_tax_lines_exists(p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE,
858: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE) IS
859: SELECT 'X'
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;

Line 962: INSERT INTO JAI_OM_OE_SO_TAXES

958: FETCH cur_chk_tax_lines_exists
959: INTO l_tax_exists;
960: IF cur_chk_tax_lines_exists%NOTFOUND THEN
961:
962: INSERT INTO JAI_OM_OE_SO_TAXES
963: (header_id,
964: line_id,
965: tax_line_no,
966: tax_id,

Line 2725: FROM JAI_OM_OE_SO_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)
2725: FROM JAI_OM_OE_SO_TAXES
2726: WHERE header_id = p_header_id
2727: AND line_id = p_line_id;
2728:
2729: CURSOR get_rma_lines_count_cur(p_line_id NUMBER) IS

Line 2749: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b

2745: AND NVL(b.inclusive_tax_flag, 'N') = 'N';
2746:
2747: CURSOR order_tax_amount_Cur(p_header_id NUMBER, p_line_id NUMBER) IS
2748: SELECT SUM(A.tax_amount)
2749: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
2750: WHERE A.Header_ID = p_header_id
2751: AND A.line_id = p_line_id
2752: AND b.tax_id = A.tax_id
2753: AND b.tax_type <> jai_constants.tax_type_tds

Line 2881: DELETE JAI_OM_OE_SO_TAXES WHERE Line_ID = pr_order_line.line_id;

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;
2883: END IF;
2884:
2885: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3196: from JAI_OM_OE_SO_TAXES

3192: v_api_name CONSTANT VARCHAR2(30) := 'PROCESS_CONFIG';
3193:
3194: cursor c_model_taxes is
3195: select *
3196: from JAI_OM_OE_SO_TAXES
3197: where header_id = pr_order_line.header_id
3198: and line_id = pr_order_line.ato_line_id;
3199:
3200: cursor c_model_tax_Categ is

Line 3286: Insert into JAI_OM_OE_SO_TAXES

3282: TO_CHAR(pr_order_line.header_id) || ' ~ ' ||
3283: TO_CHAR(pr_order_line.line_id));
3284: END IF;
3285:
3286: Insert into JAI_OM_OE_SO_TAXES
3287: (tax_line_no,
3288: line_id,
3289: header_id,
3290: precedence_1,

Line 3401: FROM JAI_OM_OE_SO_TAXES

3397: WHERE line_id = pr_order_line.split_from_line_id;
3398:
3399: CURSOR get_so_tax_lines_count_cur(p_header_id NUMBER, p_line_id NUMBER) IS
3400: SELECT COUNT(1)
3401: FROM JAI_OM_OE_SO_TAXES
3402: WHERE header_id = p_header_id
3403: AND line_id = p_line_id;
3404:
3405: CURSOR so_tax_lines_cur(p_header_id NUMBER, p_line_id NUMBER) IS

Line 3425: FROM JAI_OM_OE_SO_TAXES

3421: tax_amount,
3422: base_tax_amount,
3423: func_tax_amount,
3424: tax_category_id
3425: FROM JAI_OM_OE_SO_TAXES
3426: WHERE header_id = p_header_id
3427: AND line_id = p_line_id;
3428:
3429: cursor c_fetch_rounding_factor(p_tax_id number) is

Line 3436: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b

3432: where tax_id = p_tax_id;
3433:
3434: CURSOR order_tax_amount_Cur(p_header_id NUMBER, p_line_id NUMBER) IS
3435: SELECT SUM(A.tax_amount)
3436: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
3437: WHERE A.Header_ID = p_header_id
3438: AND A.line_id = p_line_id
3439: AND b.tax_id = A.tax_id
3440: AND b.tax_type <> jai_constants.tax_type_tds

Line 3581: FROM JAI_OM_OE_SO_TAXES

3577: pr_order_line.SPLIT_FROM_LINE_ID) LOOP
3578:
3579: SELECT COUNT(1)
3580: INTO v_tax_line_count
3581: FROM JAI_OM_OE_SO_TAXES
3582: WHERE line_id = pr_order_line.line_id
3583: AND tax_id = rec.tax_id;
3584:
3585: IF v_tax_line_count = 0 THEN

Line 3626: INSERT INTO JAI_OM_OE_SO_TAXES

3622: (v_line_quantity),
3623: v_rounding_factor);
3624: v_header_tax_amount := v_header_tax_amount +
3625: v_new_tax_amount;
3626: INSERT INTO JAI_OM_OE_SO_TAXES
3627: (header_id,
3628: line_id,
3629: tax_line_no,
3630: tax_id,

Line 3850: DELETE JAI_OM_OE_SO_TAXES WHERE line_id = pr_new.line_id;

3846: IF pv_action = jai_constants.updating AND
3847: pr_new.inventory_item_id <> pr_old.inventory_item_id THEN
3848: DELETE JAI_OM_OE_SO_LINES WHERE line_id = pr_new.line_id;
3849:
3850: DELETE JAI_OM_OE_SO_TAXES WHERE line_id = pr_new.line_id;
3851:
3852: END IF;
3853:
3854: OPEN get_header_info(pr_new.header_id);