[Home] [Help]
PACKAGE: APPS.OKL_UBB_PUB
Source
1 PACKAGE OKL_UBB_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPUBBS.pls 115.5 2003/10/20 20:49:25 sanahuja noship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person Date Comments
11 -- --------- ------ ------------------------------------------
12 -- Enter package declarations as shown below
13
14 ------------------------------------------------------------------------------
15 -- Global Variables
16 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_UBB_PUB';
17 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
18 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
20 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
21 ------------------------------------------------------------------------------
22 --Global Exception
23 ------------------------------------------------------------------------------
24 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
25 ------------------------------------------------------------------------------
26
27 l_msg_data VARCHAR2(4000);
28
29 SUBTYPE bill_stat_tbl_type is OKL_UBB_PVT.bill_stat_tbl_type;
30
31 --PROCEDURE ADD_LANGUAGE;
32
33 --Object type procedure for calling calculate_late_charge
34
35 PROCEDURE calculate_ubb_amount(
36 p_api_version IN NUMBER
37 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43
44 PROCEDURE calculate_ubb_amount( ERRBUF OUT NOCOPY VARCHAR2,
45 RETCODE OUT NOCOPY VARCHAR2 ,
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
48 ) ;
49
50 PROCEDURE bill_service_contract(
51 p_api_version IN NUMBER
52 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_msg_count OUT NOCOPY NUMBER
55 ,x_msg_data OUT NOCOPY VARCHAR2
56 ,p_contract_number IN VARCHAR2
57 );
58
59 PROCEDURE bill_service_contract( ERRBUF OUT NOCOPY VARCHAR2,
60 RETCODE OUT NOCOPY NUMBER ,
61 p_contract_number IN VARCHAR2
62 ) ;
63
64 PROCEDURE billing_status(
65 p_api_version IN NUMBER
66 ,p_init_msg_list IN VARCHAR2
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 ,x_bill_stat_tbl OUT NOCOPY bill_stat_tbl_type
71 ,p_khr_id IN NUMBER
72 ,p_transaction_date IN DATE
73 );
74
75 END OKL_UBB_PUB; -- Package spec
76
77