[Home] [Help]
PACKAGE: APPS.OKS_BILLING_PROFILES_PUB
Source
1 PACKAGE OKS_BILLING_PROFILES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPBPES.pls 120.1.12010000.2 2008/12/22 04:47:07 cgopinee ship $ */
3
4
5 SUBTYPE bpev_rec_type IS oks_bpe_pvt.bpev_rec_type;
6 SUBTYPE bpev_tbl_type IS oks_bpe_pvt.bpev_tbl_type;
7 SUBTYPE bpe_rec_type IS oks_bpe_pvt.bpe_rec_type;
8 SUBTYPE bpe_tbl_type IS oks_bpe_pvt.bpe_tbl_type;
9
10 ---------------------------------------------------------------------------
11 -- GLOBAL_MESSAGE_CONSTANTS
12 ---------------------------------------------------------------------------
13 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
14 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
15 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
24 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
27 G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.OKS_BILLING_PROFILES_PUB';
28
29 G_APP_NAME_OKC CONSTANT VARCHAR2(3) := 'OKC';
30 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
31 ---------------------------------------------------------------------------
32
33 -- GLOBAL EXCEPTION
34 ---------------------------------------------------------------------------
35 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
36 ---------------------------------------------------------------------------
37
38 -- GLOBAL VARIABLES
39 ---------------------------------------------------------------------------
40 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BILLING_PROFILE_PUB';
41 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
42
46 ---------------------------------------------------------------------------
43 g_bpev_rec bpev_rec_type;
44 ---------------------------------------------------------------------------
45 -- Procedures and Functions
47
48 PROCEDURE add_language;
49 PROCEDURE insert_row(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_bpev_rec IN bpev_rec_type,
56 x_bpev_rec OUT NOCOPY bpev_rec_type);
57
58 PROCEDURE insert_row(
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_bpev_tbl IN bpev_tbl_type,
65 x_bpev_tbl OUT NOCOPY bpev_tbl_type);
66
67 PROCEDURE lock_row(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_bpev_rec IN bpev_rec_type);
74
75 PROCEDURE lock_row(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_bpev_tbl IN bpev_tbl_type);
82
83 PROCEDURE update_row(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_bpev_rec IN bpev_rec_type,
90 x_bpev_rec OUT NOCOPY bpev_rec_type);
91
92 PROCEDURE update_row(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_bpev_tbl IN bpev_tbl_type,
99 x_bpev_tbl OUT NOCOPY bpev_tbl_type);
100
101 PROCEDURE delete_row(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_bpev_rec IN bpev_rec_type);
108
109 PROCEDURE delete_row(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_bpev_tbl IN bpev_tbl_type);
116
117 PROCEDURE validate_row(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_bpev_rec IN bpev_rec_type);
124
125 PROCEDURE validate_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_bpev_tbl IN bpev_tbl_type);
132
133
134
135 TYPE Billing_profile_rec Is Record(
136 cle_Id NUMBER,
137 chr_Id NUMBER,
138 Billing_Profile_Id NUMBER,
139 Start_Date DATE,
140 End_Date DATE);
141
142 TYPE Stream_Level_rec Is Record(
143 --slh
144 Chr_Id NUMBER,
145 Cle_Id NUMBER,
146 Billing_type VARCHAR2 (450), --Rule_Information1
147 Rule_Information_Category VARCHAR2 (90), --Rule_Information_Category
148 stream_type_id1 VARCHAR2 (40), --Object1_Id1
149 stream_type_id2 VARCHAR2 (200), --Object1_Id2
150 slh_timeval_id1 VARCHAR2 (40), --Object2_Id1
151 slh_timeval_id2 VARCHAR2 (200), --Object2_Id2
152 stream_tp_code VARCHAR2 (30), --Jtot_Object1_Code
153 slh_timeval_code VARCHAR2 (30), --Jtot_Object2_Code
154 --sll
155 seq_no VARCHAR2 (450), -- RULE_INFORMATION1
156 Start_Date VARCHAR2 (450), -- RULE_INFORMATION2
157 amount VARCHAR2 (450), -- RULE_INFORMATION6
158 sll_Rule_Information_Category VARCHAR2 (90),
159 sll_Object1_Id1 VARCHAR2 (40),
160 sll_Object1_Id2 VARCHAR2 (200),
161 sll_Jtot_Object1_Code VARCHAR2 (30),
162 target_quantity VARCHAR2 (450), --rule_information3
163 duration VARCHAR2 (450), --rule_information4, UOM/PERIOD
164 Interface_Offset VARCHAR2 (450), --rule_information7
165 Invoice_Offset VARCHAR2 (450), --rule_information8
166 timeunit VARCHAR2 (40), --Object1_Id1, UOM
167 Invoice_Rule_Id NUMBER, --INVOICE_OBJECT1_ID1 of oks_billing_profiles_v
168 --sum 01,jul
169 Account_Rule_Id NUMBER --ACCOUNT_OBJECT1_ID1 of oks_billing_profiles_v
170 --sum 01,jul
171
172
173 );
174
175
176
177 Type Stream_Level_tbl is TABLE OF Stream_Level_rec INDEX BY binary_integer;
178
179 PROCEDURE Get_Billing_Schedule(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 p_billing_profile_rec IN Billing_profile_rec,
183 x_sll_tbl_out OUT NOCOPY Stream_Level_tbl,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2 );
187
188
189 END OKS_BILLING_PROFILES_PUB;