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_WDD_TRIGGER_PKG dependencies on JAI_OM_OE_SO_LINES

Line 276: JAI_OM_OE_SO_LINES

272: IS
273: SELECT
274: lc_flag
275: FROM
276: JAI_OM_OE_SO_LINES
277: WHERE
278: lc_flag = 'Y' AND
279: header_id = pr_new.source_header_id;
280:

Line 324: -- The following cursor gets the tax amount for the line_id from JAI_OM_OE_SO_LINES table

320: /* end bug#5686360 */
321:
322:
323: -- Following cursors added by sriram - bug # 2689417
324: -- The following cursor gets the tax amount for the line_id from JAI_OM_OE_SO_LINES table
325: CURSOR c_ja_in_so_lines_tax_amt
326: IS
327: SELECT
328: tax_amount

Line 330: JAI_OM_OE_SO_LINES

326: IS
327: SELECT
328: tax_amount
329: FROM
330: JAI_OM_OE_SO_LINES
331: WHERE
332: line_id = pr_new.source_line_id AND
333: header_id = pr_new.source_header_id;
334:

Line 352: v_line_tax_amount Number; --File.Sql.35 Cbabu :=0; -- to hold the tax amount for a line - based on JAI_OM_OE_SO_LINES

348: AND NVL(tax.inclusive_tax_flag,'N') = 'N' ; -- Added by Jia Li for inclusive tax on 2008/01/07
349:
350:
351:
352: v_line_tax_amount Number; --File.Sql.35 Cbabu :=0; -- to hold the tax amount for a line - based on JAI_OM_OE_SO_LINES
353: v_sum_tax_amount Number; --File.Sql.35 Cbabu :=0; -- to hold the sum of taxes for a line - based on JAI_OM_OE_SO_TAXES
354: -- ends here -- cursors added by sriram - bug # 2689417
355:
356:

Line 379: JAI_OM_OE_SO_LINES a

375: a.line_number ,
376: a.shipment_line_number ,
377: quantity -- added by sriram bug# 3441684
378: FROM
379: JAI_OM_OE_SO_LINES a
380: WHERE
381: a.line_id = pr_new.source_line_id AND
382: a.header_id = pr_new.source_header_id ;
383:

Line 384: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;

380: WHERE
381: a.line_id = pr_new.source_line_id AND
382: a.header_id = pr_new.source_header_id ;
383:
384: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;
385: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;
386: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;
387: lv_ret_flag VARCHAR2(10) ;
388: lv_error_msg VARCHAR2(1996) ;

Line 385: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;

381: a.line_id = pr_new.source_line_id AND
382: a.header_id = pr_new.source_header_id ;
383:
384: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;
385: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;
386: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;
387: lv_ret_flag VARCHAR2(10) ;
388: lv_error_msg VARCHAR2(1996) ;
389: v_quantity number;

Line 386: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;

382: a.header_id = pr_new.source_header_id ;
383:
384: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;
385: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;
386: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;
387: lv_ret_flag VARCHAR2(10) ;
388: lv_error_msg VARCHAR2(1996) ;
389: v_quantity number;
390: -- End Of Bug #

Line 485: where the tax amounts in the JAI_OM_OE_SO_TAXES and JAI_OM_OE_SO_LINES do not tally.

481: Also the update statement , which updates the released_flag in the JAI_OM_LC_MATCHINGS table
482: has been commented , because the update should happen after the shipping has completed.
483:
484: Also an error message has to be thrown , when shipping is done , for an order
485: where the tax amounts in the JAI_OM_OE_SO_TAXES and JAI_OM_OE_SO_LINES do not tally.
486:
487: 3. Avishek - Bug # 2928261
488: Added a RAISE_APPLICATION_ERROR to give an error message when a sub-inventory is not
489: associated properly with a location ID.

Line 692: /* RAISE_APPLICATION_ERROR(-20405,'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id);

688: FETCH c_ja_in_so_tax_lines_tax_amt INTO v_sum_tax_amount;
689: CLOSE c_ja_in_so_tax_lines_tax_amt;
690:
691: IF NVL(v_line_tax_amount,0) <> NVL(v_sum_tax_amount,0) THEN
692: /* RAISE_APPLICATION_ERROR(-20405,'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id);
693: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id ; return ;
694: END IF;
695: -- ends here bug # 2689417
696:

Line 693: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id ; return ;

689: CLOSE c_ja_in_so_tax_lines_tax_amt;
690:
691: IF NVL(v_line_tax_amount,0) <> NVL(v_sum_tax_amount,0) THEN
692: /* RAISE_APPLICATION_ERROR(-20405,'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id);
693: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id ; return ;
694: END IF;
695: -- ends here bug # 2689417
696:
697: -- Start Of Bug #3392528,

Line 701: that can exists between JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the

697: -- Start Of Bug #3392528,
698: /*
699: This code has been added by aiyer for the bug 3392528.
700: Call the function jai_om_utils_pkg.validate_excise_exemption to validate the different valid combination of values
701: that can exists between JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the
702: table JAI_OM_OE_SO_TAXES
703: */
704:
705: OPEN c_chk_exc_exmpt_rule;

Line 1135: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;

1131: --Ends here for Enh2415656
1132: -- end of addition by subbu
1133:
1134: -- Added by Brathod for Bug#4215808
1135: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;
1136: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
1137: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
1138: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
1139: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;

Line 1170: FROM JAI_OM_OE_SO_LINES

1166:
1167: -- End of Addition
1168: CURSOR Get_So_Lines_Count_Cur IS
1169: SELECT COUNT(*)
1170: FROM JAI_OM_OE_SO_LINES
1171: WHERE Line_id = v_source_line_id;
1172:
1173: CURSOR Get_So_Lines_Details_Cur IS
1174: SELECT NVL(Selling_Price,0),

Line 1188: FROM JAI_OM_OE_SO_LINES

1184: vat_exemption_type,
1185: vat_exemption_date,
1186: vat_exemption_refno
1187: -- End of Bug#4215808
1188: FROM JAI_OM_OE_SO_LINES
1189: WHERE Line_id = v_source_line_id;
1190: /*
1191: Code changed by aiyer for the bug #3139718.
1192: Added the cursor to details required for currency conversion.

Line 1446: FROM JAI_OM_OE_SO_LINES

1442: -- following cursors added by sriram bug# 2165355
1443:
1444: CURSOR C_CHECK_LC_ORDER IS
1445: SELECT LC_FLAG
1446: FROM JAI_OM_OE_SO_LINES
1447: WHERE LC_FLAG = 'Y' AND
1448: HEADER_ID = pr_new.SOURCE_HEADER_ID;
1449:
1450: CURSOR C_MATCHED_QTY_CUR IS

Line 1724: Else take it from JAI_OM_OE_SO_LINES and JAI_OM_OE_SO_TAXES table.

1720: With this the check becomes that if a organization is trdable, item is tradable , excisable and the order
1721: associated to the bond register is Trading Domestic With Excise and Export With Excise only then
1722: it can be assumed that there would be data in table JAI_CMN_MATCH_TAXES (Match receipts has been performed).
1723: In such a case take the tax_amoutn ,base_tax_amount and func_tax_amoutn for the above table.
1724: Else take it from JAI_OM_OE_SO_LINES and JAI_OM_OE_SO_TAXES table.
1725:
1726:
1727: Dependency Introduced Due to this Bug : -
1728: None

Line 1868: from JAI_OM_OE_SO_LINES table. Also populated jai_vat_preocessing_t temporery

1864:
1865: 23. 2005/03/15 brathod - Bug#4215808- File version 115.5
1866: Trigger modified for VAT Implementation.
1867: New VAT fields in JAI_OM_WSH_LINES_ALL are populated by fetching them
1868: from JAI_OM_OE_SO_LINES table. Also populated jai_vat_preocessing_t temporery
1869: table for VAT invoice number generation
1870:
1871: 24 26/04/2005 Brathod for Bug# 4299606 File Version 116.1
1872: Issue:-