[Home] [Help]
PACKAGE: APPS.JAI_OM_WSH_PKG
Source
1 PACKAGE jai_om_wsh_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_om_wsh.pls 120.2 2007/04/23 05:14:24 ssawant ship $ */
3
4 procedure process_delivery
5 (
6 errbuf OUT NOCOPY VARCHAR2 ,
7 retcode OUT NOCOPY VARCHAR2 ,
8 p_delivery_id IN NUMBER
9 );
10
11 function get_excise_register_with_bal
12 (
13 p_pref_rg23a NUMBER ,
14 p_pref_rg23c NUMBER ,
15 p_pref_pla in NUMBER ,
16 p_ssi_unit_flag VARCHAR2 ,
17 p_exempt_amt NUMBER ,
18 p_rg23a_balance NUMBER ,
19 p_rg23c_balance NUMBER ,
20 p_pla_balance NUMBER ,
21 p_basic_pla_balance NUMBER ,
22 p_additional_pla_balance NUMBER ,
23 p_other_pla_balance NUMBER ,
24 p_basic_excise_duty_amount NUMBER ,
25 p_add_excise_duty_amount NUMBER ,
26 p_oth_excise_duty_amount NUMBER ,
27 p_export_oriented_unit VARCHAR2 ,
28 p_register_code VARCHAR2 ,
29 p_delivery_id NUMBER ,
30 p_organization_id NUMBER ,
31 p_location_id NUMBER ,
32 p_cess_amount NUMBER ,
33 p_sh_cess_amount NUMBER, /* added by ssawant for bug 5989740 */
34 p_process_flag OUT NOCOPY VARCHAR2 ,
35 p_process_msg OUT NOCOPY VARCHAR2
36 )
37 RETURN VARCHAR2 ;
38
39 procedure process_deliveries
40 (
41 errbuf OUT NOCOPY VARCHAR2 ,
42 retcode OUT NOCOPY VARCHAR2 ,
43 pn_delivery_id IN NUMBER
44 );
45
46 END jai_om_wsh_pkg;