APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_OM_WSH_PROCESSING_PKG

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

1349: v_raise_exempt_flag VARCHAR2(1);
1350: v_exe_flag VARCHAR2(150);
1351: v_mod_flag VARCHAR2(150);
1352: --New Variables Declared by Nagaraj.s for Enh2415656
1353: v_output NUMBER ;-- By Nagaraj.s to get the output of the function jai_om_wsh_processing_pkg.excise_balance_check
1354: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;
1355: v_basic_pla_balance NUMBER;
1356: v_additional_pla_balance NUMBER;
1357: v_other_pla_balance NUMBER;

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

1893:
1894: 8 03/07/2002 Nagaraj.s - For Enh#2415656.
1895: Cursors pref_cur - Incorporated v_export_oriented_unit also in the select clause
1896: RG Bal Cur- Incorporated basic,additional,other pla balance also in the select clause.
1897: Functions jai_om_wsh_processing_pkg.excise_balance_check - for preference checks in case of EOU and Non-EOU for total excise amount
1898: jai_om_wsh_pkg.get_excise_register_with_bal - for preference checks in case of EOU and Non-EOU
1899: for exempted amount.
1900: Before sending this patch it has to be taken care that, the alter scripts,functions should also
1901: accompany the patch otherwise the patch would certainly fail.

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

2098:
2099: The change done in this object is to pass the additional parameters correctly to the functions.
2100:
2101: Dependency Due to this Bug:-
2102: The current trigger becomes dependent on the functions jai_om_wsh_processing_pkg.excise_balance_check (version 115.1) and
2103: jai_om_wsh_pkg.get_excise_register_with_bal (version 115.1) also packaged as part of this bug.
2104:
2105: 23. 2005/03/15 brathod - Bug#4215808- File version 115.5
2106: Trigger modified for VAT Implementation.

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

3387: 'CT2_OTH', 'EXCISE_EXEMPT_CERT_OTH','CT3' ) THEN
3388: --***************************************************************************************************
3389: --Calling the Function by Nagaraj.s for Enh#2415656............................
3390: IF v_debug_flag ='Y' THEN
3391: UTL_FILE.PUT_LINE(v_myfilehandle,'10 BEFORE the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION');
3392: UTL_FILE.FCLOSE(v_myfilehandle);
3393: END IF;
3394:
3395: open c_cess_amount(v_delivery_id);

Line 3407: v_reg_type:= jai_om_wsh_processing_pkg.excise_balance_check

3403:
3404: -- end Bgowrava for forward porting bug#5989740
3405:
3406:
3407: v_reg_type:= jai_om_wsh_processing_pkg.excise_balance_check
3408: (v_pref_rg23a,
3409: v_pref_rg23c,
3410: v_pref_pla,
3411: NVL(v_ssi_unit_flag,'N'),

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

3431: );
3432: --Ends here......................................
3433: IF v_debug_flag ='Y' THEN
3434: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_wsh_dlry_dtls_au_trg.LOG','A');
3435: UTL_FILE.PUT_LINE(v_myfilehandle,'11 AFTER the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION v_reg_type -> ' || v_reg_type);
3436: END IF;
3437: --***************************************************************************************************
3438: ELSE
3439: OPEN get_item_dtls(v_organization_id,v_inventory_item_id);