[Home] [Help]
PACKAGE: APPS.OKL_CNTR_GRP_BILLING_PVT
Source
1 PACKAGE OKL_CNTR_GRP_BILLING_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRCLBS.pls 120.2 2006/11/23 16:27:13 dpsingh 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 SUBTYPE tilv_rec_type is okl_til_pvt.tilv_rec_type;
16 SUBTYPE tilv_tbl_type is okl_til_pvt.tilv_tbl_type;
17
18 SUBTYPE tryv_rec_type IS okl_try_pvt.tryv_rec_type;
19 SUBTYPE tryv_tbl_type IS okl_try_pvt.tryv_tbl_type;
20
21 SUBTYPE taiv_rec_type IS okl_tai_pvt.taiv_rec_type;
22 SUBTYPE taiv_tbl_type IS okl_tai_pvt.taiv_tbl_type;
23
24 SUBTYPE tldv_rec_type IS Okl_Tld_Pvt.tldv_rec_type;
25 SUBTYPE tldv_tbl_type IS Okl_Tld_Pvt.tldv_tbl_type;
26
27 SUBTYPE Bill_Rec_Type IS oks_bill_util_pub.Bill_Rec_Type;
28 SUBTYPE Bill_Tbl_Type IS oks_bill_util_pub.Bill_Tbl_Type;
29
30 SUBTYPE crdg_rec_type IS CS_CTR_CAPTURE_READING_PUB.CTR_GRP_LOG_REC_TYPE;
31 SUBTYPe crdg_tbl_type IS CS_CTR_CAPTURE_READING_PUB.CTR_RDG_TBL_TYPE;
32 SUBTYPE prdg_tbl_type IS CS_CTR_CAPTURE_READING_PUB.PROP_RDG_TBL_TYPE;
33
34 ---------------------------------------------------------------------------
35 -- GLOBAL DATASTRUCTURES
36 ---------------------------------------------------------------------------
37 TYPE cntr_bill_rec_type IS RECORD (
38 clg_id NUMBER := Okl_Api.G_MISS_NUM,
39 counter_group OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
40 counter_number NUMBER := Okl_Api.G_MISS_NUM,
41 counter_name CS_COUNTERS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
42 contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
43 asset_number OKC_K_LINES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44 asset_serial_number OKX_ASSETS_V.SERIAL_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
45 asset_description OKX_ASSETS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
46 effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okl_Api.G_MISS_DATE,
47 effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okl_Api.G_MISS_DATE,
48 counter_reading NUMBER := Okl_Api.G_MISS_NUM,
49 counter_reading_date DATE := Okl_Api.G_MISS_DATE,
50 counter_bill_amount NUMBER := Okl_Api.G_MISS_NUM,
51 legal_entity_id NUMBER := Okl_Api.G_MISS_NUM
52 );
53 TYPE cntr_bill_tbl_type IS TABLE OF cntr_bill_rec_type
54 INDEX BY BINARY_INTEGER;
55
56
57 -- Global Variables
58 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CNTR_GRP_BILLING_PVT';
59 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
60 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
61 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
62 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
63 ------------------------------------------------------------------------------
64 --Global Exception
65 ------------------------------------------------------------------------------
66 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
67 ------------------------------------------------------------------------------
68
69 l_msg_data VARCHAR2(4000);
70
71 --PROCEDURE ADD_LANGUAGE;
72
73
74 PROCEDURE counter_grp_billing_calc(
75 p_api_version IN NUMBER
76 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY NUMBER
79 ,x_msg_data OUT NOCOPY VARCHAR2
80 ,p_cntr_bill_rec IN cntr_bill_rec_type
81 ,x_cntr_bill_rec OUT NOCOPY cntr_bill_rec_type
82 );
83
84 PROCEDURE counter_grp_billing_calc(
85 p_api_version IN NUMBER
86 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
87 ,x_return_status OUT NOCOPY VARCHAR2
88 ,x_msg_count OUT NOCOPY NUMBER
89 ,x_msg_data OUT NOCOPY VARCHAR2
90 ,p_cntr_bill_tbl IN cntr_bill_tbl_type
91 ,x_cntr_bill_tbl OUT NOCOPY cntr_bill_tbl_type
92 );
93
94 PROCEDURE counter_grp_billing_insert(
95 p_api_version IN NUMBER
96 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
97 ,x_return_status OUT NOCOPY VARCHAR2
98 ,x_msg_count OUT NOCOPY NUMBER
99 ,x_msg_data OUT NOCOPY VARCHAR2
100 ,p_cntr_bill_rec IN cntr_bill_rec_type
101 ,x_cntr_bill_rec OUT NOCOPY cntr_bill_rec_type
102 );
103
104 PROCEDURE counter_grp_billing_insert(
105 p_api_version IN NUMBER
106 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_msg_count OUT NOCOPY NUMBER
109 ,x_msg_data OUT NOCOPY VARCHAR2
110 ,p_cntr_bill_tbl IN cntr_bill_tbl_type
111 ,x_cntr_bill_tbl OUT NOCOPY cntr_bill_tbl_type
112 );
113
114 END OKL_CNTR_GRP_BILLING_PVT; -- Package spec