[Home] [Help]
PACKAGE: APPS.JAI_OM_WSH_PROCESSING_PKG
Source
1 PACKAGE jai_om_wsh_processing_pkg AS
2 /* $Header: jai_om_wsh_prc.pls 120.2 2007/04/23 05:13:28 ssawant ship $ */
3
4 function excise_balance_check
5 (
6 p_pref_rg23a NUMBER ,
7 p_pref_rg23c NUMBER ,
8 p_pref_pla in NUMBER ,
9 p_ssi_unit_flag VARCHAR2 ,
10 p_tot_excise_amt NUMBER ,
11 p_rg23a_balance NUMBER ,
12 p_rg23c_balance NUMBER ,
13 p_pla_balance NUMBER ,
14 p_basic_pla_balance NUMBER ,
15 p_additional_pla_balance NUMBER ,
16 p_other_pla_balance NUMBER ,
17 p_basic_excise_duty_amount NUMBER ,
18 p_add_excise_duty_amount NUMBER ,
19 p_oth_excise_duty_amount NUMBER ,
20 p_export_oriented_unit VARCHAR2 ,
21 p_register_code VARCHAR2 ,
22 p_delivery_id NUMBER ,
23 p_organization_id NUMBER ,
24 p_location_id NUMBER ,
25 p_cess_amount NUMBER ,
26 p_sh_cess_amount NUMBER , /* added by ssawant for bug 5989740 */
27 p_process_flag OUT NOCOPY VARCHAR2 ,
28 p_process_msg OUT NOCOPY VARCHAR2
29 )
30 RETURN VARCHAR2 ;
31
32 END jai_om_wsh_processing_pkg;