APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_OM_WSH_PROCESSING_PKG

Line 1121: v_output NUMBER ;-- By Nagaraj.s to get the output of the function jai_om_wsh_processing_pkg.excise_balance_check

1117: v_raise_exempt_flag VARCHAR2(1);
1118: v_exe_flag VARCHAR2(150);
1119: v_mod_flag VARCHAR2(150);
1120: --New Variables Declared by Nagaraj.s for Enh2415656
1121: v_output NUMBER ;-- By Nagaraj.s to get the output of the function jai_om_wsh_processing_pkg.excise_balance_check
1122: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;
1123: v_basic_pla_balance NUMBER;
1124: v_additional_pla_balance NUMBER;
1125: v_other_pla_balance NUMBER;

Line 1657: Functions jai_om_wsh_processing_pkg.excise_balance_check - for preference checks in case of EOU and Non-EOU for total excise amount

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
1656: RG Bal Cur- Incorporated basic,additional,other pla balance also in the select clause.
1657: Functions jai_om_wsh_processing_pkg.excise_balance_check - for preference checks in case of EOU and Non-EOU for total excise amount
1658: jai_om_wsh_pkg.get_excise_register_with_bal - for preference checks in case of EOU and Non-EOU
1659: for exempted amount.
1660: Before sending this patch it has to be taken care that, the alter scripts,functions should also
1661: accompany the patch otherwise the patch would certainly fail.

Line 1862: The current trigger becomes dependent on the functions jai_om_wsh_processing_pkg.excise_balance_check (version 115.1) and

1858:
1859: The change done in this object is to pass the additional parameters correctly to the functions.
1860:
1861: Dependency Due to this Bug:-
1862: The current trigger becomes dependent on the functions jai_om_wsh_processing_pkg.excise_balance_check (version 115.1) and
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.

Line 3018: UTL_FILE.PUT_LINE(v_myfilehandle,'10 BEFORE the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION');

3014: 'CT2_OTH', 'EXCISE_EXEMPT_CERT_OTH','CT3' ) THEN
3015: --***************************************************************************************************
3016: --Calling the Function by Nagaraj.s for Enh#2415656............................
3017: IF v_debug_flag ='Y' THEN
3018: UTL_FILE.PUT_LINE(v_myfilehandle,'10 BEFORE the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION');
3019: UTL_FILE.FCLOSE(v_myfilehandle);
3020: END IF;
3021:
3022: open c_cess_amount(v_delivery_id);

Line 3034: v_reg_type:= jai_om_wsh_processing_pkg.excise_balance_check

3030:
3031: -- end Bgowrava for forward porting bug#5989740
3032:
3033:
3034: v_reg_type:= jai_om_wsh_processing_pkg.excise_balance_check
3035: (v_pref_rg23a,
3036: v_pref_rg23c,
3037: v_pref_pla,
3038: NVL(v_ssi_unit_flag,'N'),

Line 3062: UTL_FILE.PUT_LINE(v_myfilehandle,'11 AFTER the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION v_reg_type -> ' || v_reg_type);

3058: );
3059: --Ends here......................................
3060: IF v_debug_flag ='Y' THEN
3061: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_wsh_dlry_dtls_au_trg.LOG','A');
3062: UTL_FILE.PUT_LINE(v_myfilehandle,'11 AFTER the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION v_reg_type -> ' || v_reg_type);
3063: END IF;
3064: --***************************************************************************************************
3065: ELSE
3066: OPEN get_item_dtls(v_organization_id,v_inventory_item_id);