[Home] [Help]
PACKAGE: APPS.OKL_BOOK_CONTROLLER_PVT
Source
1 PACKAGE OKL_BOOK_CONTROLLER_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRBCTS.pls 120.3.12010000.2 2009/08/28 04:38:17 rpillay ship $ */
3
4 -- Global variables for user hooks
5 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BOOK_CONTROLLER_PVT';
6 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7
8 -- Global variables for Tasks and Process Status
9 G_VALIDATE_CONTRACT CONSTANT VARCHAR2(10) := 'OKLBCTQA';
10 G_CALC_UPFRONT_TAX CONSTANT VARCHAR2(10) := 'OKLBCTUT';
11 G_PRICE_CONTRACT CONSTANT VARCHAR2(10) := 'OKLBCTST';
12 G_SUBMIT_CONTRACT CONSTANT VARCHAR2(10) := 'OKLBCTBK';
13
14 G_PROG_STS_PENDING CONSTANT VARCHAR2(10) := 'PENDING';
15 G_PROG_STS_RUNNING CONSTANT VARCHAR2(10) := 'RUNNING';
16 G_PROG_STS_COMPLETE CONSTANT VARCHAR2(10) := 'COMPLETE';
17 G_PROG_STS_ERROR CONSTANT VARCHAR2(10) := 'ERROR';
18
19 SUBTYPE bct_rec_type IS okl_bct_pvt.okl_bct_rec;
20 SUBTYPE bct_tbl_type IS okl_bct_pvt.okl_bct_tbl;
21
22 -----------------------------------------------------------------------------
23 -- PROCEDURE calculate_upfront_tax
24 -----------------------------------------------------------------------------
25 -- Start of comments
26 --
27 -- procedure Name : calculate_upfront_tax
28 -- Description : Procedure called from exec_controller_prg1
29 -- Business Rules :
30 -- Parameters : p_khr_id
31 -- Version : 1.0
32 -- History : XX-XXX-XXXX asahoo Created
33 -- End of comments
34
35 PROCEDURE calculate_upfront_tax(
36 p_errbuf OUT NOCOPY VARCHAR2,
37 p_retcode OUT NOCOPY NUMBER,
38 p_khr_id IN okc_k_headers_b.id%TYPE);
39
40 -----------------------------------------------------------------------------
41 -- PROCEDURE calc_upfronttax_nxtbtn
42 -----------------------------------------------------------------------------
43 -- Start of comments
44 --
45 -- Procedure Name : calc_upfronttax_nxtbtn
46 -- Description : Procedure to do validation when next button in Upfront
47 -- tax page is clicked.
48 -- Business Rules :
49 -- Parameters : p_khr_id
50 -- Version : 1.0
51 -- History : XX-XXX-XXXX asahoo Created
52 -- End of comments
53
54 PROCEDURE calc_upfronttax_nxtbtn(
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_khr_id IN okc_k_headers_b.id%TYPE);
61
62 -----------------------------------------------------------------------------
63 -- PROCEDURE validate_contract_nxtbtn
64 -----------------------------------------------------------------------------
65 -- Start of comments
66 --
67 -- Procedure Name : validate_contract_nxtbtn
68 -- Description : Procedure to do validation when next button in validate
69 -- contrtact page is clicked.
70 -- Business Rules :
71 -- Parameters : p_khr_id
72 -- Version : 1.0
73 -- History : XX-XXX-XXXX asahoo Created
74 -- End of comments
75
76 PROCEDURE validate_contract_nxtbtn(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_khr_id IN okc_k_headers_b.id%TYPE);
83
84 -----------------------------------------------------------------------------
85 -- PROCEDURE init_book_controller_trx
86 -----------------------------------------------------------------------------
87 -- Start of comments
88 --
89 -- Procedure Name : init_book_controller_trx
90 -- Description : Procedure to insert 4 records into OKL_BOOK_CONTROLLER_TRX
91 -- Called from OKL_CONTRACT_BOOK_PVT.execute_qa_check_list
92 -- Business Rules :
93 -- Parameters : p_khr_id
94 -- Version : 1.0
95 -- History : XX-XXX-XXXX asahoo Created
96 -- End of comments
97
98 PROCEDURE init_book_controller_trx(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_khr_id IN okc_k_headers_b.id%TYPE,
105 x_batch_number OUT NOCOPY NUMBER);
106
107 -----------------------------------------------------------------------------
108 -- PROCEDURE update_book_controller_trx
109 -----------------------------------------------------------------------------
110 -- Start of comments
111 --
112 -- Procedure Name : update_book_controller_trx
113 -- Description : Procedure to update status of records in OKL_BOOK_CONTROLLER_TRX table
114 -- Called from OKL_CONTRACT_BOOK_PVT.execute_qa_check_list
115 -- Business Rules :
116 -- Parameters : p_khr_id p_prog_short_name p_progress_status
117 -- Version : 1.0
118 -- History : XX-XXX-XXXX asahoo Created
119 -- End of comments
120
121 PROCEDURE update_book_controller_trx(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_khr_id IN okc_k_headers_b.id%TYPE,
128 p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,
129 p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
130 p_progress_status IN okl_book_controller_trx.progress_status%TYPE);
131
132 -----------------------------------------------------------------------------
133 -- PROCEDURE cancel_contract_activation
134 -----------------------------------------------------------------------------
135 -- Start of comments
136 --
137 -- Procedure Name : cancel_contract_activation
138 -- Description : Procedure to update status of contract header, line and records in okl_book_controller_trx table
139 -- Called from Authoring UI
140 -- Business Rules :
141 -- Parameters : p_khr_id
142 -- Version : 1.0
143 -- History : XX-XXX-XXXX asahoo Created
144 -- End of comments
145
146 PROCEDURE cancel_contract_activation(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_khr_id IN okc_k_headers_b.id%TYPE);
153
154 -----------------------------------------------------------------------------
155 -- PROCEDURE submit_controller_prg1
156 -----------------------------------------------------------------------------
157 -- Start of comments
158 --
159 -- Procedure Name : submit_controller_prg1
160 -- Description : Procedure to submit request for controller program 1
161 -- Business Rules :
162 -- Parameters : p_khr_id,p_cont_stage,p_draft_journal_entry
163 -- Version : 1.0
164 -- History : XX-XXX-XXXX vthiruva Created
165 -- End of comments
166 PROCEDURE submit_controller_prg1(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_khr_id IN okc_k_headers_b.id%TYPE,
173 p_cont_stage IN VARCHAR2,
174 p_draft_journal_entry IN VARCHAR2);
175
176 -----------------------------------------------------------------------------
177 -- PROCEDURE submit_controller_prg2
178 -----------------------------------------------------------------------------
179 -- Start of comments
180 --
181 -- Procedure Name : submit_controller_prg2
182 -- Description : Procedure to submit request for controller program 2.
183 -- Called from Approval workflow
184 -- Business Rules :
185 -- Parameters : p_khr_id
186 -- Version : 1.0
187 -- History : XX-XXX-XXXX vthiruva Created
188 -- End of comments
189 PROCEDURE submit_controller_prg2(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_khr_id IN okc_k_headers_b.id%TYPE);
196
197 -----------------------------------------------------------------------------
198 -- PROCEDURE exec_controller_prg1
199 -----------------------------------------------------------------------------
200 -- Start of comments
201 --
202 -- procedure Name : exec_controller_prg1
203 -- Description : Procedure called from concurrent request Controller
204 -- Program 1 to execute contract booking.
205 -- Business Rules :
206 -- Parameters : p_khr_id,p_cont_stage,p_draft_journal_entry
207 -- Version : 1.0
208 -- History : XX-XXX-XXXX vthiruva Created
209 -- End of comments
210 PROCEDURE exec_controller_prg1(
211 p_errbuf OUT NOCOPY VARCHAR2,
212 p_retcode OUT NOCOPY NUMBER,
213 p_khr_id IN okc_k_headers_b.id%TYPE,
214 p_cont_stage IN VARCHAR2,
215 p_draft_journal_entry IN VARCHAR2 DEFAULT 'NO',
216 p_called_from IN VARCHAR2 DEFAULT 'FORM');
217
218 -----------------------------------------------------------------------------
219 -- PROCEDURE exec_controller_prg2
220 -----------------------------------------------------------------------------
221 -- Start of comments
222 --
223 -- procedure Name : exec_controller_prg2
224 -- Description : Procedure called from concurrent request Controller
225 -- Program 2 to execute contract booking activation
226 -- Business Rules :
227 -- Parameters : p_khr_id
228 -- Version : 1.0
229 -- History : XX-XXX-XXXX vthiruva Created
230 -- End of comments
231 PROCEDURE exec_controller_prg2(
232 p_errbuf OUT NOCOPY VARCHAR2,
233 p_retcode OUT NOCOPY NUMBER,
234 p_khr_id IN okc_k_headers_b.id%TYPE);
235
236 -----------------------------------------------------------------------------
237 -- PROCEDURE execute_qa_check_list
238 -----------------------------------------------------------------------------
239 -- Start of comments
240 --
241 -- procedure Name : execute_qa_check_list
242 -- Description : Procedure called from QA Validation concurrent request
243 -- to execute QA Checklist
244 -- Business Rules :
245 -- Parameters : p_khr_id
246 -- Version : 1.0
247 -- History : XX-XXX-XXXX vthiruva Created
248 -- End of comments
249 PROCEDURE execute_qa_check_list(
250 p_errbuf OUT NOCOPY VARCHAR2,
251 p_retcode OUT NOCOPY NUMBER,
252 p_khr_id IN okc_k_headers_b.id%TYPE);
253
254 -----------------------------------------------------------------------------
255 -- PROCEDURE generate_streams
256 -----------------------------------------------------------------------------
257 -- Start of comments
258 --
259 -- procedure Name : generate_streams
260 -- Description : Procedure called from Stream Generation concurrent request
261 -- Business Rules :
262 -- Parameters : p_khr_id
263 -- Version : 1.0
264 -- History : XX-XXX-XXXX vthiruva Created
265 -- End of comments
266 PROCEDURE generate_streams(
267 p_errbuf OUT NOCOPY VARCHAR2,
268 p_retcode OUT NOCOPY NUMBER,
269 p_khr_id IN okc_k_headers_b.id%TYPE);
270
271 -----------------------------------------------------------------------------
272 -- PROCEDURE generate_journal_entries
273 -----------------------------------------------------------------------------
274 -- Start of comments
275 --
276 -- procedure Name : generate_journal_entries
277 -- Description : Procedure called from Draft Journal Entry concurrent request
278 -- Business Rules :
279 -- Parameters : p_khr_id
280 -- Version : 1.0
281 -- History : XX-XXX-XXXX vthiruva Created
282 -- End of comments
283 PROCEDURE generate_journal_entries(
284 p_errbuf OUT NOCOPY VARCHAR2,
285 p_retcode OUT NOCOPY NUMBER,
286 p_khr_id IN okc_k_headers_b.id%TYPE);
287
288 -----------------------------------------------------------------------------
289 -- PROCEDURE submit_for_approval
290 -----------------------------------------------------------------------------
291 -- Start of comments
292 --
293 -- procedure Name : submit_for_approval
294 -- Description : Procedure called from Approval concurrent request
295 -- Business Rules :
296 -- Parameters : p_khr_id
297 -- Version : 1.0
298 -- History : XX-XXX-XXXX vthiruva Created
299 -- End of comments
300 PROCEDURE submit_for_approval(
301 p_errbuf OUT NOCOPY VARCHAR2,
302 p_retcode OUT NOCOPY NUMBER,
303 p_khr_id IN okc_k_headers_b.id%TYPE);
304
305 -----------------------------------------------------------------------------
306 -- PROCEDURE activate_contract
307 -----------------------------------------------------------------------------
308 -- Start of comments
309 --
310 -- procedure Name : activate_contract
311 -- Description : Procedure called from Activation concurrent request
312 -- Business Rules :
313 -- Parameters : p_khr_id
314 -- Version : 1.0
315 -- History : XX-XXX-XXXX vthiruva Created
316 -- End of comments
317 PROCEDURE activate_contract(
318 p_errbuf OUT NOCOPY VARCHAR2,
319 p_retcode OUT NOCOPY NUMBER,
320 p_khr_id IN okc_k_headers_b.id%TYPE);
321
322 --Bug# 8798934
323 -----------------------------------------------------------------------------
324 -- FUNCTION is_prb_upgrade_required
325 -----------------------------------------------------------------------------
326 -- Start of comments
327 --
328 -- procedure Name : is_prb_upgrade_required
329 -- Description : Function called from Contract Activation Train -
330 -- Price and Submit UI
331 -- Business Rules :
332 -- Parameters : p_khr_id
333 -- Version : 1.0
334 -- History : XX-XXX-XXXX rpillay Created
335 -- End of comments
336 FUNCTION is_prb_upgrade_required(
337 p_khr_id IN NUMBER) RETURN VARCHAR2;
338
339 -----------------------------------------------------------------------------
340 -- PROCEDURE submit_prb_upgrade
341 -----------------------------------------------------------------------------
342 -- Start of comments
343 --
344 -- procedure Name : submit_prb_upgrade
345 -- Description : Procedure called from Upgrade button on
346 -- Contract Activation Train - Price and Submit UI
347 -- Business Rules :
348 -- Parameters : p_khr_id
349 -- Version : 1.0
350 -- History : XX-XXX-XXXX rpillay Created
351 -- End of comments
352 PROCEDURE submit_prb_upgrade(
353 p_api_version IN NUMBER,
354 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
355 x_return_status OUT NOCOPY VARCHAR2,
356 x_msg_count OUT NOCOPY NUMBER,
357 x_msg_data OUT NOCOPY VARCHAR2,
358 p_khr_id IN NUMBER,
359 x_request_numbers OUT NOCOPY VARCHAR2);
360
361 --Bug# 8798934
362
363 END OKL_BOOK_CONTROLLER_PVT;