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_PROCESSING_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 477: v_old_register JAI_OM_WSH_LINES_ALL.register%TYPE;

473: counter NUMBER;
474: v_bonded_flag VARCHAR2(1);
475: v_register_code VARCHAR2(30);
476: v_fin_year NUMBER;
477: v_old_register JAI_OM_WSH_LINES_ALL.register%TYPE;
478: v_reg_type VARCHAR2(10);
479: v_tot_excise_amt NUMBER;
480: v_tot_basic_ed_amt NUMBER;
481: v_pref_rg23a NUMBER;

Line 503: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;

499: v_basic_pla_balance NUMBER;
500: v_additional_pla_balance NUMBER;
501: v_other_pla_balance NUMBER;
502: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;
503: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
504: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
505: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
506: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;
507:

Line 504: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;

500: v_additional_pla_balance NUMBER;
501: v_other_pla_balance NUMBER;
502: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;
503: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
504: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
505: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
506: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;
507:
508: CURSOR Get_Status_Cur IS

Line 505: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;

501: v_other_pla_balance NUMBER;
502: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;
503: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
504: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
505: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
506: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;
507:
508: CURSOR Get_Status_Cur IS
509: SELECT A.delivery_id,

Line 506: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;

502: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;
503: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
504: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
505: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
506: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;
507:
508: CURSOR Get_Status_Cur IS
509: SELECT A.delivery_id,
510: A.confirm_date,

Line 610: FROM JAI_OM_WSH_LINES_ALL

606: AND b.Tax_Type <> 'TDS';
607:
608: CURSOR Get_Delivery_Line_Count_Cur IS
609: SELECT COUNT(*)
610: FROM JAI_OM_WSH_LINES_ALL
611: WHERE Delivery_Detail_Id = v_delivery_detail_id
612: AND Delivery_id = v_delivery_id;
613:
614: CURSOR Location_Cursor IS

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

767: v_asst_register_id Number;
768: v_reg_exp_date Date;
769: v_lou_flag Varchar2(1);
770:
771: CURSOR c_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
772: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
773: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
774: JAI_CMN_TAXES_ALL jtc
775: WHERE jtc.tax_id = jsptl.tax_id

Line 778: FROM JAI_OM_WSH_LINES_ALL

774: JAI_CMN_TAXES_ALL jtc
775: WHERE jtc.tax_id = jsptl.tax_id
776: AND delivery_detail_id in
777: (SELECT delivery_detail_id
778: FROM JAI_OM_WSH_LINES_ALL
779: WHERE delivery_id = cp_delivery_id
780: )
781: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));
782:

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

781: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));
782:
783: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
784:
785: CURSOR c_sh_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
786: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
787: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
788: JAI_CMN_TAXES_ALL jtc
789: WHERE jtc.tax_id = jsptl.tax_id

Line 792: FROM JAI_OM_WSH_LINES_ALL

788: JAI_CMN_TAXES_ALL jtc
789: WHERE jtc.tax_id = jsptl.tax_id
790: AND delivery_detail_id in
791: (SELECT delivery_detail_id
792: FROM JAI_OM_WSH_LINES_ALL
793: WHERE delivery_id = cp_delivery_id
794: )
795: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_sh_exc_edu_cess),
796: upper(jai_constants.tax_type_sh_cvd_edu_cess)

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

804: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
805: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;
806: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;
807:
808: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
809: IS
810: SELECT 1
811: FROM JAI_OM_WSH_LINE_TAXES jsptl,
812: JAI_CMN_TAXES_ALL jtc

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

828: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
829: AND attribute_code = jai_constants.attr_code_regn_no
830: AND regime_code = jai_constants.vat_regime;
831:
832: CURSOR cur_chk_vat_proc_entry (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE)
833: IS
834: SELECT 1
835: FROM JAI_RGM_INVOICE_GEN_T
836: WHERE delivery_id = cp_delivery_id;

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

837:
838: /*
839: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
840: */
841: CURSOR c_chk_vat_reversal (cp_del_det_id JAI_OM_WSH_LINES_ALL.delivery_detail_id%TYPE,
842: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
843: IS
844: SELECT 1
845: FROM JAI_OM_WSH_LINE_TAXES jsptl,

Line 1165: -- for inserting into JAI_OM_WSH_LINES_ALL Table.

1161: END IF;
1162: END IF;
1163:
1164: -- Accumulate the respective types of Excise Duties
1165: -- for inserting into JAI_OM_WSH_LINES_ALL Table.
1166: IF rec.tax_type = 'Excise' THEN
1167: v_basic_excise_duty_amount := NVL(v_basic_excise_duty_amount,0) + v_tax_amount ;
1168: ELSIF rec.tax_type = 'Addl. Excise' THEN
1169: v_add_excise_duty_amount := NVL(v_add_excise_duty_amount,0) + v_tax_amount ;

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

1433: to the other three checks (of organization being a trading organization, Item being tradable and excisable ):-
1434: The order attached to the bond register is one of 'Trading Domestic With Excise' or 'Export With Excise'
1435: hence applying the check that
1436: v_trad_register_code IN ( '23D_DOMESTIC_EXCISE','23D_EXPORT_EXCISE') .
1437: Before this fix, Null value used to get inserted into taxes in table JAI_OM_WSH_LINES_ALL for Bond register with
1438: 'Trading Domestic Without Excise' and 'Export Without Excise' ( problem stated in the bug )
1439: */
1440: IF nvl(v_trading_flag,'N') = 'Y' AND
1441: nvl(v_item_trading_flag,'N') = 'Y' AND

Line 1456: --for inserting into JAI_OM_WSH_LINES_ALL Table.

1452: FETCH ed_cur INTO v_oth_excise_duty_amount;
1453: CLOSE ed_cur;
1454: END IF;
1455: --Get Cumulative Excise amount
1456: --for inserting into JAI_OM_WSH_LINES_ALL Table.
1457: v_excise_amount := (v_basic_excise_duty_amount + v_add_excise_duty_amount +
1458: v_oth_excise_duty_amount);
1459: -- Get Total Tax Amount for the Line
1460: -- for Inserting into JAI_OM_WSH_LINES_ALL Table.

Line 1460: -- for Inserting into JAI_OM_WSH_LINES_ALL Table.

1456: --for inserting into JAI_OM_WSH_LINES_ALL Table.
1457: v_excise_amount := (v_basic_excise_duty_amount + v_add_excise_duty_amount +
1458: v_oth_excise_duty_amount);
1459: -- Get Total Tax Amount for the Line
1460: -- for Inserting into JAI_OM_WSH_LINES_ALL Table.
1461: OPEN Get_Tot_Tax_Amount_Cur;
1462: FETCH Get_Tot_Tax_Amount_Cur INTO v_tot_tax_amount;
1463: CLOSE Get_Tot_Tax_Amount_Cur;
1464: -- Check for Delivery lines existence in JAI_OM_WSH_LINES_ALL Table

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

1460: -- for Inserting into JAI_OM_WSH_LINES_ALL Table.
1461: OPEN Get_Tot_Tax_Amount_Cur;
1462: FETCH Get_Tot_Tax_Amount_Cur INTO v_tot_tax_amount;
1463: CLOSE Get_Tot_Tax_Amount_Cur;
1464: -- Check for Delivery lines existence in JAI_OM_WSH_LINES_ALL Table
1465: OPEN Get_Delivery_Line_Count_Cur ;
1466: FETCH Get_Delivery_Line_Count_Cur INTO v_delivery_line_count;
1467: CLOSE Get_Delivery_Line_Count_Cur ;
1468: IF v_delivery_line_count = 0 THEN

Line 1470: INSERT INTO JAI_OM_WSH_LINES_ALL( Delivery_Detail_Id,

1466: FETCH Get_Delivery_Line_Count_Cur INTO v_delivery_line_count;
1467: CLOSE Get_Delivery_Line_Count_Cur ;
1468: IF v_delivery_line_count = 0 THEN
1469:
1470: INSERT INTO JAI_OM_WSH_LINES_ALL( Delivery_Detail_Id,
1471: Order_Header_Id,
1472: Order_Line_Id,
1473: split_from_delivery_detail_id,
1474: Selling_Price,

Line 1664: UPDATE JAI_OM_WSH_LINES_ALL

1660:
1661: END IF;
1662:
1663: ELSE
1664: UPDATE JAI_OM_WSH_LINES_ALL
1665: SET quantity = v_shipped_quantity,
1666: tax_amount = v_tot_tax_amount,
1667: order_line_id = v_source_line_id,
1668: excise_amount = v_excise_amount,

Line 3185: JAI_OM_WSH_LINES_ALL jspl ,

3181: jsptl.* ,
3182: jrttv.regime_id,
3183: jtc.tax_type
3184: FROM
3185: JAI_OM_WSH_LINES_ALL jspl ,
3186: JAI_OM_WSH_LINE_TAXES jsptl,
3187: JAI_CMN_TAXES_ALL jtc ,
3188: jai_regime_tax_types_v jrttv
3189: WHERE