[Home] [Help]
PACKAGE: APPS.OKS_BILLING_PROFILES_PUB
Source
1 PACKAGE OKS_BILLING_PROFILES_PUB AS
2 /* $Header: OKSPBPES.pls 120.1 2005/10/05 03:26:29 mchoudha noship $ */
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
28 G_APP_NAME_OKC CONSTANT VARCHAR2(3) := 'OKC';
29 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
30 ---------------------------------------------------------------------------
31
32 -- GLOBAL EXCEPTION
33 ---------------------------------------------------------------------------
34 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
35 ---------------------------------------------------------------------------
36
37 -- GLOBAL VARIABLES
38 ---------------------------------------------------------------------------
39 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BILLING_PROFILE_PUB';
40 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
41
42 g_bpev_rec bpev_rec_type;
43 ---------------------------------------------------------------------------
44 -- Procedures and Functions
45 ---------------------------------------------------------------------------
46
47 PROCEDURE add_language;
48 PROCEDURE insert_row(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_bpev_rec IN bpev_rec_type,
55 x_bpev_rec OUT NOCOPY bpev_rec_type);
56
57 PROCEDURE insert_row(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_bpev_tbl IN bpev_tbl_type,
64 x_bpev_tbl OUT NOCOPY bpev_tbl_type);
65
66 PROCEDURE lock_row(
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_bpev_rec IN bpev_rec_type);
73
74 PROCEDURE lock_row(
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_bpev_tbl IN bpev_tbl_type);
81
82 PROCEDURE update_row(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_bpev_rec IN bpev_rec_type,
89 x_bpev_rec OUT NOCOPY bpev_rec_type);
90
91 PROCEDURE update_row(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_bpev_tbl IN bpev_tbl_type,
98 x_bpev_tbl OUT NOCOPY bpev_tbl_type);
99
100 PROCEDURE delete_row(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_bpev_rec IN bpev_rec_type);
107
108 PROCEDURE delete_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_bpev_tbl IN bpev_tbl_type);
115
116 PROCEDURE validate_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_bpev_rec IN bpev_rec_type);
123
124 PROCEDURE validate_row(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_bpev_tbl IN bpev_tbl_type);
131
132
133
134 TYPE Billing_profile_rec Is Record(
135 cle_Id NUMBER,
136 chr_Id NUMBER,
137 Billing_Profile_Id NUMBER,
138 Start_Date DATE,
139 End_Date DATE);
140
141 TYPE Stream_Level_rec Is Record(
142 --slh
143 Chr_Id NUMBER,
144 Cle_Id NUMBER,
145 Billing_type VARCHAR2 (450), --Rule_Information1
146 Rule_Information_Category VARCHAR2 (90), --Rule_Information_Category
147 stream_type_id1 VARCHAR2 (40), --Object1_Id1
148 stream_type_id2 VARCHAR2 (200), --Object1_Id2
149 slh_timeval_id1 VARCHAR2 (40), --Object2_Id1
150 slh_timeval_id2 VARCHAR2 (200), --Object2_Id2
151 stream_tp_code VARCHAR2 (30), --Jtot_Object1_Code
152 slh_timeval_code VARCHAR2 (30), --Jtot_Object2_Code
153 --sll
154 seq_no VARCHAR2 (450), -- RULE_INFORMATION1
155 Start_Date VARCHAR2 (450), -- RULE_INFORMATION2
156 amount VARCHAR2 (450), -- RULE_INFORMATION6
157 sll_Rule_Information_Category VARCHAR2 (90),
158 sll_Object1_Id1 VARCHAR2 (40),
159 sll_Object1_Id2 VARCHAR2 (200),
160 sll_Jtot_Object1_Code VARCHAR2 (30),
161 target_quantity VARCHAR2 (450), --rule_information3
162 duration VARCHAR2 (450), --rule_information4, UOM/PERIOD
163 Interface_Offset VARCHAR2 (450), --rule_information7
164 Invoice_Offset VARCHAR2 (450), --rule_information8
165 timeunit VARCHAR2 (40), --Object1_Id1, UOM
166 Invoice_Rule_Id NUMBER, --INVOICE_OBJECT1_ID1 of oks_billing_profiles_v
167 --sum 01,jul
168 Account_Rule_Id NUMBER --ACCOUNT_OBJECT1_ID1 of oks_billing_profiles_v
169 --sum 01,jul
170
171
172 );
173
174
175
176 Type Stream_Level_tbl is TABLE OF Stream_Level_rec INDEX BY binary_integer;
177
178 PROCEDURE Get_Billing_Schedule(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 p_billing_profile_rec IN Billing_profile_rec,
182 x_sll_tbl_out OUT NOCOPY Stream_Level_tbl,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2 );
186
187
188 END OKS_BILLING_PROFILES_PUB;