[Home] [Help]
PACKAGE: APPS.OKL_UBB_PVT
Source
1 PACKAGE OKL_UBB_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRUBBS.pls 115.4 2003/10/20 20:49:49 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 TYPE bill_stat_rec_type IS RECORD (
16 transaction_type VARCHAR2(200),
17 last_bill_date DATE,
18 last_schedule_bill_date DATE);
19
20 TYPE bill_stat_tbl_type IS TABLE OF bill_stat_rec_type
21 INDEX BY BINARY_INTEGER;
22
23 SUBTYPE tilv_rec_type is okl_til_pvt.tilv_rec_type;
24 SUBTYPE tilv_tbl_type is okl_til_pvt.tilv_tbl_type;
25
26 SUBTYPE tryv_rec_type IS okl_try_pvt.tryv_rec_type;
27 SUBTYPE tryv_tbl_type IS okl_try_pvt.tryv_tbl_type;
28
29 SUBTYPE taiv_rec_type IS okl_tai_pvt.taiv_rec_type;
30 SUBTYPE taiv_tbl_type IS okl_tai_pvt.taiv_tbl_type;
31
32 SUBTYPE tldv_rec_type IS Okl_Tld_Pvt.tldv_rec_type;
33 SUBTYPE tldv_tbl_type IS Okl_Tld_Pvt.tldv_tbl_type;
34
35
36 -- Global Variables
37 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_UBB_PVT';
38 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
39 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
40 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
41 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
42 ------------------------------------------------------------------------------
43 --Global Exception
44 ------------------------------------------------------------------------------
45 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
46 ------------------------------------------------------------------------------
47
48 l_msg_data VARCHAR2(4000);
49
50 --PROCEDURE ADD_LANGUAGE;
51
52
53 PROCEDURE calculate_ubb_amount(
54 p_api_version IN NUMBER
55 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 PROCEDURE bill_service_contract(
62 p_api_version IN NUMBER
63 ,p_init_msg_list IN VARCHAR2
64 ,x_return_status OUT NOCOPY VARCHAR2
65 ,x_msg_count OUT NOCOPY NUMBER
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 ,p_contract_number IN VARCHAR2
68 );
69
70 PROCEDURE billing_status(
71 p_api_version IN NUMBER
72 ,p_init_msg_list IN VARCHAR2
73 ,x_return_status OUT NOCOPY VARCHAR2
74 ,x_msg_count OUT NOCOPY NUMBER
75 ,x_msg_data OUT NOCOPY VARCHAR2
76 ,x_bill_stat_tbl OUT NOCOPY bill_stat_tbl_type
77 ,p_khr_id IN NUMBER
78 ,p_transaction_date IN DATE
79 );
80
81 END OKL_UBB_PVT; -- Package spec
82
83