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_WSH_LINES_ALL

Line 19: From JAI_OM_WSH_LINES_ALL

15: x Number; --File.Sql.35 Cbabu := 0;
16:
17: Cursor del_count IS
18: Select 1
19: From JAI_OM_WSH_LINES_ALL
20: Where delivery_detail_id = v_delivery_detail_id;
21:
22:
23: BEGIN

Line 88: DELETE JAI_OM_WSH_LINES_ALL

84:
85: If nvl(x,0) <> 1 then
86: Return;
87: Else
88: DELETE JAI_OM_WSH_LINES_ALL
89: WHERE delivery_detail_id = v_DELIVERY_DETAIL_ID;
90:
91: DELETE JAI_OM_WSH_LINE_TAXES
92: WHERE delivery_detail_id = v_DELIVERY_DETAIL_ID;

Line 425: CURSOR cur_chk_org_loc_setup (cp_organization_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,

421: AND jtc.tax_id = jstl.tax_id
422: AND jtc.tax_type = tax_types.tax_type
423: AND tax_types.regime_code = jai_constants.vat_regime;
424:
425: CURSOR cur_chk_org_loc_setup (cp_organization_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
426: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE
427: )
428: IS
429: SELECT 1

Line 426: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE

422: AND jtc.tax_type = tax_types.tax_type
423: AND tax_types.regime_code = jai_constants.vat_regime;
424:
425: CURSOR cur_chk_org_loc_setup (cp_organization_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
426: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE
427: )
428: IS
429: SELECT 1
430: FROM jai_rgm_parties rgmpt,

Line 1091: v_old_register JAI_OM_WSH_LINES_ALL.register%TYPE;

1087: v_raise_error_flag VARCHAR2(1);
1088: v_bonded_flag VARCHAR2(1);
1089: v_register_code VARCHAR2(30);
1090: v_fin_year NUMBER;
1091: v_old_register JAI_OM_WSH_LINES_ALL.register%TYPE;
1092: v_old_excise_invoice_no VARCHAR2(200);
1093: v_reg_type VARCHAR2(10);
1094: v_rg_type VARCHAR2(1);
1095: v_exc_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%TYPE;

Line 1095: v_exc_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%TYPE;

1091: v_old_register JAI_OM_WSH_LINES_ALL.register%TYPE;
1092: v_old_excise_invoice_no VARCHAR2(200);
1093: v_reg_type VARCHAR2(10);
1094: v_rg_type VARCHAR2(1);
1095: v_exc_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%TYPE;
1096: v_tot_excise_amt NUMBER;
1097: v_tot_basic_ed_amt NUMBER;
1098: v_tot_addl_ed_amt NUMBER;
1099: v_tot_oth_ed_amt NUMBER;

Line 1136: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;

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;
1140: -- End of Bug#4215808

Line 1137: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;

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;
1140: -- End of Bug#4215808
1141:

Line 1138: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;

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;
1140: -- End of Bug#4215808
1141:
1142:

Line 1139: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;

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;
1140: -- End of Bug#4215808
1141:
1142:
1143: CURSOR Get_Status_Cur IS

Line 1267: FROM JAI_OM_WSH_LINES_ALL

1263: AND b.Tax_Id = A.Tax_Id
1264: AND b.Tax_Type <> 'TDS';
1265: CURSOR Get_Delivery_Line_Count_Cur IS
1266: SELECT COUNT(*)
1267: FROM JAI_OM_WSH_LINES_ALL
1268: WHERE Delivery_Detail_Id = v_delivery_detail_id;
1269: CURSOR Location_Cursor IS
1270: SELECT NVL(Location_id,0),
1271: trading

Line 1306: FROM JAI_OM_WSH_LINES_ALL

1302: A.receipt_id IS NOT NULL;
1303:
1304: CURSOR ja_in_so_picking_exc_check(p_delivery_id NUMBER) IS
1305: SELECT DISTINCT register
1306: FROM JAI_OM_WSH_LINES_ALL
1307: WHERE delivery_id = p_delivery_id;
1308:
1309: --2001/07/10 Anuradha Parthasarathy
1310: CURSOR item_trading_cur IS

Line 1485: CURSOR c_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS

1481: v_asst_register_id Number;
1482: v_reg_exp_date Date;
1483: v_lou_flag Varchar2(1);
1484:
1485: CURSOR c_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1486: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
1487: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1488: JAI_CMN_TAXES_ALL jtc
1489: WHERE jtc.tax_id = jsptl.tax_id

Line 1492: FROM JAI_OM_WSH_LINES_ALL

1488: JAI_CMN_TAXES_ALL jtc
1489: WHERE jtc.tax_id = jsptl.tax_id
1490: AND delivery_detail_id in
1491: (SELECT delivery_detail_id
1492: FROM JAI_OM_WSH_LINES_ALL
1493: WHERE delivery_id = cp_delivery_id
1494: )
1495: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));
1496:

Line 1503: CURSOR c_sh_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS

1499:
1500: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
1501: /* Cursor is responsible to get secondary and higher cess */
1502:
1503: CURSOR c_sh_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1504: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
1505: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1506: JAI_CMN_TAXES_ALL jtc
1507: WHERE jtc.tax_id = jsptl.tax_id

Line 1510: FROM JAI_OM_WSH_LINES_ALL

1506: JAI_CMN_TAXES_ALL jtc
1507: WHERE jtc.tax_id = jsptl.tax_id
1508: AND delivery_detail_id in
1509: (SELECT delivery_detail_id
1510: FROM JAI_OM_WSH_LINES_ALL
1511: WHERE delivery_id = cp_delivery_id
1512: )
1513: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_sh_exc_edu_cess),
1514: upper(jai_constants.tax_type_sh_cvd_edu_cess)

Line 1531: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)

1527: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
1528: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;
1529: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;
1530:
1531: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
1532: IS
1533: SELECT 1
1534: FROM JAI_OM_WSH_LINE_TAXES jsptl,
1535: JAI_CMN_TAXES_ALL jtc

Line 1555: CURSOR cur_chk_vat_proc_entry (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE)

1551: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
1552: AND attribute_code = jai_constants.attr_code_regn_no
1553: AND regime_code = jai_constants.vat_regime;
1554:
1555: CURSOR cur_chk_vat_proc_entry (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE)
1556: IS
1557: SELECT 1
1558: FROM JAI_RGM_INVOICE_GEN_T
1559: WHERE delivery_id = cp_delivery_id;

Line 1567: CURSOR c_chk_vat_reversal (cp_del_det_id JAI_OM_WSH_LINES_ALL.delivery_detail_id%TYPE,

1563: /*
1564: || Added by csahoo for bug#5680459
1565: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
1566: */
1567: CURSOR c_chk_vat_reversal (cp_del_det_id JAI_OM_WSH_LINES_ALL.delivery_detail_id%TYPE,
1568: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
1569: IS
1570: SELECT 1
1571: FROM JAI_OM_WSH_LINE_TAXES jsptl,

Line 1651: Insert of non zero selling price and assessable value in JAI_OM_WSH_LINES_ALL even though

1647: 6 03/10/2001 Anuradha Parthasarathy
1648: Tax Calculation as per the Inventory Uom
1649:
1650: 7 08/05/2002 Sriram SJ Bug # 2330055
1651: Insert of non zero selling price and assessable value in JAI_OM_WSH_LINES_ALL even though
1652: tax lines are not there.
1653:
1654: 8 03/07/2002 Nagaraj.s - For Enh#2415656.
1655: Cursors pref_cur - Incorporated v_export_oriented_unit also in the select clause

Line 1677: For trading functionality JAI_OM_WSH_LINES_ALL.excise_amount is getting populated NULL always, if one

1673: is carried over to AR , but the taxes are not present in Shiping Localization tables ,
1674: causing lot of Data fix requirements.
1675:
1676: 12 09/01/2003 cbabu for Bug# 2736191 - File Version# 615.4
1677: For trading functionality JAI_OM_WSH_LINES_ALL.excise_amount is getting populated NULL always, if one
1678: of 'Excise', 'Addl. Excise', 'Other Excise' tax components is missing. ED_CUR cursor is modified to fetch
1679: 0 if query does not retreive any data.
1680:
1681: 13. 12/03/2003 Arun Iyer Bug # 2828927 615.5

Line 1814: the JAI_CMN_MATCH_TAXES table is used for population into JAI_OM_WSH_LINES_ALL

1810: on the quantity causing the taxes to be calculated as less than that of the actual value
1811:
1812: Solution :- Issue has been resolved by doing the following :
1813: The apportion based on quantity shipped has been removed and instead the tax amount from
1814: the JAI_CMN_MATCH_TAXES table is used for population into JAI_OM_WSH_LINES_ALL
1815: and jain_so_picking_tax_lines table
1816:
1817: Dependency : None
1818:

Line 1867: New VAT fields in JAI_OM_WSH_LINES_ALL are populated by fetching them

1863: jai_om_wsh_pkg.get_excise_register_with_bal (version 115.1) also packaged as part of this bug.
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

Line 2314: -- for inserting into JAI_OM_WSH_LINES_ALL Table.

2310: END IF;
2311:
2312:
2313: -- Accumulate the respective types of Excise Duties
2314: -- for inserting into JAI_OM_WSH_LINES_ALL Table.
2315: IF rec.tax_type = 'Excise' THEN --3
2316: v_basic_excise_duty_amount := NVL(v_basic_excise_duty_amount,0) + v_tax_amount ;
2317: ELSIF rec.tax_type = 'Addl. Excise' THEN --3
2318: v_add_excise_duty_amount := NVL(v_add_excise_duty_amount,0) + v_tax_amount ;

Line 2587: Before this fix, Null value used to get inserted into taxes in table JAI_OM_WSH_LINES_ALL for Bond register with

2583: to the other three checks (of organization being a trading organization, Item being tradable and excisable ):-
2584: The order attached to the bond register is one of 'Trading Domestic With Excise' or 'Export With Excise'
2585: hence applying the check that
2586: v_trad_register_code IN ( '23D_DOMESTIC_EXCISE','23D_EXPORT_EXCISE') .
2587: Before this fix, Null value used to get inserted into taxes in table JAI_OM_WSH_LINES_ALL for Bond register with
2588: 'Trading Domestic Without Excise' and 'Export Without Excise' ( problem stated in the bug )
2589: */
2590:
2591:

Line 2608: --for inserting into JAI_OM_WSH_LINES_ALL Table.

2604: FETCH ed_cur INTO v_oth_excise_duty_amount;
2605: CLOSE ed_cur;
2606: END IF;
2607: --Get Cumulative Excise amount
2608: --for inserting into JAI_OM_WSH_LINES_ALL Table.
2609: v_excise_amount := (v_basic_excise_duty_amount + v_add_excise_duty_amount +
2610: v_oth_excise_duty_amount);
2611: -- Get Total Tax Amount for the Line
2612: -- for Inserting into JAI_OM_WSH_LINES_ALL Table.

Line 2612: -- for Inserting into JAI_OM_WSH_LINES_ALL Table.

2608: --for inserting into JAI_OM_WSH_LINES_ALL Table.
2609: v_excise_amount := (v_basic_excise_duty_amount + v_add_excise_duty_amount +
2610: v_oth_excise_duty_amount);
2611: -- Get Total Tax Amount for the Line
2612: -- for Inserting into JAI_OM_WSH_LINES_ALL Table.
2613: OPEN Get_Tot_Tax_Amount_Cur;
2614: FETCH Get_Tot_Tax_Amount_Cur INTO v_tot_tax_amount;
2615: CLOSE Get_Tot_Tax_Amount_Cur;
2616: -- Check for Delivery lines existence in JAI_OM_WSH_LINES_ALL Table

Line 2616: -- Check for Delivery lines existence in JAI_OM_WSH_LINES_ALL Table

2612: -- for Inserting into JAI_OM_WSH_LINES_ALL Table.
2613: OPEN Get_Tot_Tax_Amount_Cur;
2614: FETCH Get_Tot_Tax_Amount_Cur INTO v_tot_tax_amount;
2615: CLOSE Get_Tot_Tax_Amount_Cur;
2616: -- Check for Delivery lines existence in JAI_OM_WSH_LINES_ALL Table
2617: OPEN Get_Delivery_Line_Count_Cur ;
2618: FETCH Get_Delivery_Line_Count_Cur INTO v_delivery_line_count;
2619: CLOSE Get_Delivery_Line_Count_Cur ;
2620: IF v_delivery_line_count = 0 THEN

Line 2622: INSERT INTO JAI_OM_WSH_LINES_ALL(

2618: FETCH Get_Delivery_Line_Count_Cur INTO v_delivery_line_count;
2619: CLOSE Get_Delivery_Line_Count_Cur ;
2620: IF v_delivery_line_count = 0 THEN
2621: --5
2622: INSERT INTO JAI_OM_WSH_LINES_ALL(
2623: Delivery_Detail_Id,
2624: Order_Header_Id,
2625: Order_Line_Id,
2626: split_from_delivery_detail_id,

Line 2833: UPDATE JAI_OM_WSH_LINES_ALL

2829: END IF;
2830: -- End of Bug#4215808
2831:
2832: ELSE
2833: UPDATE JAI_OM_WSH_LINES_ALL
2834: SET quantity = v_shipped_quantity,
2835: tax_amount = v_tot_tax_amount,
2836: order_line_id = v_source_line_id,
2837: excise_amount = v_excise_amount,