1 PACKAGE OKL_AM_UTIL_PVT AS
2 /* $Header: OKLRAMUS.pls 120.14 2007/10/15 08:45:53 prasjain noship $ */
3
4
5 ---------------------------------------------------------------------------
6 -- GLOBAL DATASTRUCTURES
7 ---------------------------------------------------------------------------
8
9 SUBTYPE p_bind_var_tbl IS JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
10 SUBTYPE p_bind_val_tbl IS JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
11 SUBTYPE p_bind_type_tbl IS JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
12 SUBTYPE qtev_rec_type IS okl_trx_quotes_pub.qtev_rec_type;
13
14 TYPE where_rec_type IS RECORD (
15 column_name VARCHAR2(30),
16 operation VARCHAR2(30) DEFAULT '=',
17 condition_value VARCHAR2(80));
18
19 TYPE jtf_object_rec_type IS RECORD (
20 object_code VARCHAR2(80),
21 id1 VARCHAR2(80),
22 id2 VARCHAR2(80),
23 name VARCHAR2(320),
24 description VARCHAR2(2000),
25 other_values VARCHAR2(4000));
26
27 TYPE select_tbl_type IS TABLE OF VARCHAR2(2000)
28 INDEX BY BINARY_INTEGER;
29
30 TYPE where_tbl_type IS TABLE OF where_rec_type
31 INDEX BY BINARY_INTEGER;
32
33 TYPE jtf_object_tbl_type IS TABLE OF jtf_object_rec_type
34 INDEX BY BINARY_INTEGER;
35
36 TYPE recipient_tbl IS TABLE OF VARCHAR2(100)
37 INDEX BY BINARY_INTEGER;
38 ---------------------------------------------------------------------------
39 -- GLOBAL VARIABLES
40 ---------------------------------------------------------------------------
41
42 g_empty_select_tbl select_tbl_type;
43 g_empty_where_tbl where_tbl_type;
44 G_DELIM CONSTANT VARCHAR2(1) := ';';
45
46 G_DEBUG_LEVEL CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
47 G_NORMAL_LEVEL CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
48
49 ---------------------------------------------------------------------------
50 -- GLOBAL MESSAGE CONSTANTS FOR ERROR HANDLING
51 ---------------------------------------------------------------------------
52
53 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
54 G_APP2_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
55 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_UTIL_PVT';
56 G_API_VERSION CONSTANT NUMBER := 1;
57 G_API_NAME CONSTANT VARCHAR2(30) := 'OKL_AM_UTIL_PVT';
58 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
59 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
60 G_INVALID_VALUE1 CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
61 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
62 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
63 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
64 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
65 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
66 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
67 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68 G_LEN_CHK CONSTANT VARCHAR2(200) := 'OKC_LENGTH_EXCEEDS';
69 G_NOTFOUND CONSTANT VARCHAR2(200) := 'OKC_VIEW_NOT_FOUND';
70 G_VIEW_TOKEN CONSTANT VARCHAR2(200) := 'G_VIEW_TOKEN';
71 G_EXCEPTION_HALT_PROCESS EXCEPTION;
72 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
73 ---------------------------------------------------------------------------
74 -- Procedures and Functions
75 ---------------------------------------------------------------------------
76
77 -- Return asset quantity
78 FUNCTION get_asset_quantity (p_cle_id IN NUMBER) RETURN NUMBER;
79
80 -- Depending on Quote Type, returns contract_id
81 -- of either Lease contract or its Program
82 FUNCTION get_rule_chr_id (p_qtev_rec IN qtev_rec_type) RETURN NUMBER;
83
84 -- Initialize transaction record for Installed Base calls
85 PROCEDURE initialize_txn_rec (
86 px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec);
87
88 -- Return system org_id
89 FUNCTION get_okl_org_id RETURN NUMBER;
90
91 -- Return contract org_id
92 FUNCTION get_chr_org_id (p_chr_id IN NUMBER) RETURN NUMBER;
93
94 -- Return contract currency_code
95 FUNCTION get_chr_currency (p_chr_id IN NUMBER) RETURN VARCHAR2;
96
97 -- Gets information about currency
98 PROCEDURE get_currency_info (
99 p_currency_code IN VARCHAR2,
100 x_precision OUT NOCOPY NUMBER,
101 x_min_acc_unit OUT NOCOPY NUMBER);
102
103 -- Gets the transaction type id for the transaction name
104 PROCEDURE get_transaction_id (
105 p_try_name IN VARCHAR2,
106 p_language IN VARCHAR2 DEFAULT 'US',
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_try_id OUT NOCOPY NUMBER);
109
110 -- Gets stream type id for stream type code
111 PROCEDURE get_stream_type_id (
112 p_sty_code IN VARCHAR2,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_sty_id OUT NOCOPY NUMBER);
115
116 -- Returns Bill_To Site_Use record
117 PROCEDURE get_bill_to_address (
118 p_contract_id IN NUMBER,
119 p_message_yn IN BOOLEAN DEFAULT TRUE,
120 x_bill_to_address_rec OUT NOCOPY okx_cust_site_uses_v%ROWTYPE,
121 x_return_status OUT NOCOPY VARCHAR2);
122
123 -- Return full descriptions for message tokens
124 FUNCTION set_token (
125 p_token1_type IN VARCHAR2,
126 p_token1_value IN VARCHAR2,
127 p_token2_type IN VARCHAR2 DEFAULT NULL,
128 p_token2_value IN VARCHAR2 DEFAULT NULL,
129 p_token2_new_value IN VARCHAR2 DEFAULT NULL)
130 RETURN VARCHAR2;
131
132 -- Put messages on stack
133 PROCEDURE set_message (
134 p_app_name IN VARCHAR2 DEFAULT OKL_API.G_APP_NAME,
135 p_msg_name IN VARCHAR2,
136 p_msg_level IN NUMBER DEFAULT G_NORMAL_LEVEL,
137 p_token1 IN VARCHAR2 DEFAULT NULL,
138 p_token1_value IN VARCHAR2 DEFAULT NULL,
139 p_token2 IN VARCHAR2 DEFAULT NULL,
140 p_token2_value IN VARCHAR2 DEFAULT NULL,
141 p_token3 IN VARCHAR2 DEFAULT NULL,
142 p_token3_value IN VARCHAR2 DEFAULT NULL,
143 p_token4 IN VARCHAR2 DEFAULT NULL,
144 p_token4_value IN VARCHAR2 DEFAULT NULL,
145 p_token5 IN VARCHAR2 DEFAULT NULL,
146 p_token5_value IN VARCHAR2 DEFAULT NULL,
147 p_token6 IN VARCHAR2 DEFAULT NULL,
148 p_token6_value IN VARCHAR2 DEFAULT NULL,
149 p_token7 IN VARCHAR2 DEFAULT NULL,
150 p_token7_value IN VARCHAR2 DEFAULT NULL,
151 p_token8 IN VARCHAR2 DEFAULT NULL,
152 p_token8_value IN VARCHAR2 DEFAULT NULL,
153 p_token9 IN VARCHAR2 DEFAULT NULL,
154 p_token9_value IN VARCHAR2 DEFAULT NULL,
155 p_token10 IN VARCHAR2 DEFAULT NULL,
156 p_token10_value IN VARCHAR2 DEFAULT NULL);
157
158 -- Add message indicating invalid rule setup
159 PROCEDURE set_invalid_rule_message (
160 p_rgd_code IN VARCHAR2,
161 p_rdf_code IN VARCHAR2);
162
163 -- Get rule information for a rule
164 PROCEDURE get_rule_record (
165 p_rgd_code IN VARCHAR2,
166 p_rdf_code IN VARCHAR2,
167 p_chr_id IN NUMBER,
168 p_cle_id IN NUMBER,
169 p_rgd_id IN NUMBER DEFAULT NULL,
170 p_message_yn IN BOOLEAN DEFAULT TRUE,
171 x_rulv_rec OUT NOCOPY okl_rule_pub.rulv_rec_type,
172 x_return_status OUT NOCOPY VARCHAR2);
173
174 -- Get rule information for a rule and return message stack
175 PROCEDURE get_rule_record (
176 p_rgd_code IN VARCHAR2,
177 p_rdf_code IN VARCHAR2,
178 p_chr_id IN NUMBER,
179 p_cle_id IN NUMBER,
180 p_message_yn IN BOOLEAN DEFAULT TRUE,
181 x_rulv_rec OUT NOCOPY okl_rule_pub.rulv_rec_type,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY VARCHAR2,
184 x_msg_data OUT NOCOPY VARCHAR2);
185
186 -- Request Formula Engine to execute a formula
187 PROCEDURE get_formula_value (
188 p_formula_name IN OKL_FORMULAE_B.name%TYPE,
189 p_chr_id IN OKC_K_HEADERS_B.id%TYPE,
190 p_cle_id IN OKL_K_LINES.id%TYPE,
191 p_additional_parameters IN
192 okl_execute_formula_pub.ctxt_val_tbl_type DEFAULT
193 okl_execute_formula_pub.g_additional_parameters_null,
194 x_formula_value OUT NOCOPY NUMBER,
195 x_return_status OUT NOCOPY VARCHAR2);
196
197 -- Return formula string of a formula
198 -- It can be used for validation - if NULL is returned,
199 -- then a formula does not exist or can not be evaluated
200 FUNCTION get_formula_string (
201 p_formula_name IN VARCHAR2)
202 RETURN VARCHAR2;
203
204 -- Save messages from stack into transaction message table
205 PROCEDURE process_messages(
206 p_trx_source_table IN OKL_TRX_MSGS.trx_source_table%TYPE,
207 p_trx_id IN OKL_TRX_MSGS.trx_id%TYPE,
208 x_return_status OUT NOCOPY VARCHAR2);
209
210 -- Return details of JTF object
211 PROCEDURE get_object_details (
212 p_object_code IN VARCHAR2,
213 p_object_id1 IN VARCHAR2 DEFAULT NULL,
214 p_object_id2 IN VARCHAR2 DEFAULT '#',
215 p_check_status IN VARCHAR2 DEFAULT 'N',
216 p_other_select IN select_tbl_type DEFAULT g_empty_select_tbl,
217 p_other_where IN where_tbl_type DEFAULT g_empty_where_tbl,
218 x_object_tbl OUT NOCOPY jtf_object_tbl_type,
219 x_return_status OUT NOCOPY VARCHAR2);
220
221 -- Return Name of JTF Object
222 FUNCTION get_jtf_object_name (
223 p_object_code IN VARCHAR2,
224 p_object_id1 IN VARCHAR2,
225 p_object_id2 IN VARCHAR2 DEFAULT '#')
226 RETURN VARCHAR2;
227
228 -- Return a value of a column in JTF Object
229 FUNCTION get_jtf_object_column (
230 p_column IN VARCHAR2,
231 p_object_code IN VARCHAR2,
232 p_object_id1 IN VARCHAR2,
233 p_object_id2 IN VARCHAR2 DEFAULT '#')
234 RETURN VARCHAR2;
235
236 -- Return Name of JTF Object pointed by Contract Rule
237 FUNCTION get_rule_field_value (
238 p_rgd_code IN VARCHAR2,
239 p_rdf_code IN VARCHAR2,
240 p_chr_id IN NUMBER,
241 p_cle_id IN NUMBER,
242 p_object_type IN VARCHAR2 DEFAULT 'OBJECT1')
243 RETURN VARCHAR2;
244
245 -- Return contract program partner
246 FUNCTION get_program_partner (p_chr_id IN NUMBER) RETURN VARCHAR2;
247
248 -- Execute a fulfillment request
249 PROCEDURE EXECUTE_FULFILLMENT_REQUEST(
250 p_api_version IN NUMBER
251 , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
252 , x_return_status OUT NOCOPY VARCHAR2
253 , x_msg_count OUT NOCOPY NUMBER
254 , x_msg_data OUT NOCOPY VARCHAR2
255 , p_ptm_code IN VARCHAR2
256 , p_agent_id IN NUMBER
257 , p_transaction_id IN NUMBER
258 , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259 , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260 , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261 , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262 , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263 , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
264 , p_pt_bind_names IN p_bind_var_tbl
265 , p_pt_bind_values IN p_bind_val_tbl
266 , p_pt_bind_types IN p_bind_type_tbl
267 ) ;
268
269 -- Procedure to add a view for checking length into global table - from OKC_UTIL
270 Procedure add_view(
271 p_view_name IN VARCHAR2,
272 x_return_status OUT NOCOPY VARCHAR2);
273
274 -- checks length of a varchar2 column - from OKC_UTIL
275 Procedure check_length(
276 p_view_name IN VARCHAR2,
277 p_col_name IN VARCHAR2,
278 p_col_value IN VARCHAR2,
279 x_return_status OUT NOCOPY VARCHAR2);
280
281 -- checks length of a number column - from OKC_UTIL
282 Procedure check_length(
283 p_view_name IN VARCHAR2,
284 p_col_name IN VARCHAR2,
285 p_col_value IN NUMBER,
286 x_return_status OUT NOCOPY VARCHAR2);
287
288 -- Return Lookup Meaning - Check Status and Date only if p_validate_yn is 'Y'
289 FUNCTION get_lookup_meaning (
290 p_lookup_type IN VARCHAR2,
291 p_lookup_code IN VARCHAR2,
292 p_validate_yn IN VARCHAR2 DEFAULT 'N')
293 RETURN VARCHAR2;
294
295 -- Return attribute label
296 FUNCTION get_ak_attribute (
297 p_code IN VARCHAR2)
298 RETURN VARCHAR2;
299
300 -- Indicates if any messages exist
301 FUNCTION get_trx_msgs_yn (
302 p_trx_table IN VARCHAR2,
303 p_trx_id IN NUMBER)
304 RETURN VARCHAR2;
305
306 -- Return quote amount
307 FUNCTION get_quote_amount (
308 p_quote_id IN NUMBER)
309 RETURN NUMBER;
310
311 -- Return WorkFlow event name
312 FUNCTION get_wf_event_name(
313 p_wf_process_type IN VARCHAR2,
314 p_wf_process_name IN VARCHAR2,
315 x_return_status OUT NOCOPY VARCHAR2)
316 RETURN VARCHAR2;
317
318
319 -- RMUNJULU -- Bug # 2484327 Added these rec types, tbl types and procedures
320 -- for asset level termination
321
322 -- RMUNJULU 30-DEC-02 2484327 Added consolidated_yn
323 TYPE quote_rec_type IS RECORD (
324 id NUMBER,
325 quote_number NUMBER,
326 contract_number VARCHAR2(30),
327 partial_yn VARCHAR2(1),
328 consolidated_yn VARCHAR2(1), -- RMUNJULU 30-DEC-02 2699412 Added
329 qst_code VARCHAR2(30),
330 qtp_code VARCHAR2(30));
331
332 TYPE quote_tbl_type IS TABLE OF quote_rec_type INDEX BY BINARY_INTEGER;
333
334
335 TYPE trn_rec_type IS RECORD (
336 id NUMBER,
337 trx_number NUMBER,
338 tsu_code VARCHAR2(30),
339 tcn_type VARCHAR2(30),
340 quote_number NUMBER,
341 contract_number VARCHAR2(30),
342 partial_yn VARCHAR2(1),
343 qst_code VARCHAR2(30),
344 qtp_code VARCHAR2(30));
345
346 TYPE trn_tbl_type IS TABLE OF trn_rec_type INDEX BY BINARY_INTEGER;
347
348 -- Return accepted quotes for the Contract
349 PROCEDURE get_contract_quotes (
350 p_khr_id IN NUMBER,
351 x_quote_tbl OUT NOCOPY quote_tbl_type,
352 x_return_status OUT NOCOPY VARCHAR2);
353
354 -- Return accepted quotes for the Asset
355 PROCEDURE get_line_quotes (
356 p_kle_id IN NUMBER,
357 x_quote_tbl OUT NOCOPY quote_tbl_type,
358 x_return_status OUT NOCOPY VARCHAR2);
359
360 -- Return unprocessed termination transactions for the Contract
361 PROCEDURE get_contract_transactions (
362 p_khr_id IN NUMBER,
363 x_trn_tbl OUT NOCOPY trn_tbl_type,
364 x_return_status OUT NOCOPY VARCHAR2);
365
366 -- Return unprocessed termination transactions for the Asset
367 PROCEDURE get_line_transactions (
368 p_kle_id IN NUMBER,
369 x_trn_tbl OUT NOCOPY trn_tbl_type,
370 x_return_status OUT NOCOPY VARCHAR2);
371
372 -- Return accepted non transaction quotes for the Contract
373 PROCEDURE get_non_trn_contract_quotes (
374 p_khr_id IN NUMBER,
375 x_quote_tbl OUT NOCOPY quote_tbl_type,
376 x_return_status OUT NOCOPY VARCHAR2);
377
378
379 -- DAPATEL -- Bug # 2484327 Added these procedures for multi-currency
380
381 -- Return functional currency code
382 FUNCTION get_functional_currency RETURN VARCHAR2;
383
384 -- Return currency code for a given ORG ID
385 FUNCTION get_currency_code(p_org_id IN NUMBER) RETURN VARCHAR2;
386
387 -- Return the functional currency code and ORG ID
388 PROCEDURE get_func_currency_org(x_org_id OUT NOCOPY NUMBER
389 ,x_currency_code OUT NOCOPY VARCHAR2);
390
391 -- Return the contract currency code and ORG ID for a given Contract ID
392 PROCEDURE get_chr_currency_org(p_chr_id IN NUMBER
393 ,x_org_id OUT NOCOPY NUMBER
394 ,x_currency_code OUT NOCOPY VARCHAR2);
395
396 -- This function returns the user profile option name for a profile
397 FUNCTION get_user_profile_option_name(p_profile_option_name IN VARCHAR2,
398 x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
399
400 -- DAPATEL 23-DEC-02 2667636 - Created for multi-currency
401 -- This function converts an amount to the contract currency
402 FUNCTION convert_to_contract_currency(p_khr_id IN NUMBER,
403 p_trx_date IN DATE,
404 p_amount IN NUMBER) RETURN NUMBER;
405 --
406 -- RMUNJULU 30-DEC-02 2484327 Added
407 -- Return all termination quotes for the Asset
408 PROCEDURE get_all_term_quotes_for_line (
409 p_kle_id IN NUMBER,
410 x_quote_tbl OUT NOCOPY quote_tbl_type,
411 x_return_status OUT NOCOPY VARCHAR2) ;
412
413 -- SECHAWLA 14-FEB-03 2749690 Added this function to calculate the net investment value
414 FUNCTION get_net_investment( p_khr_id IN NUMBER,
415 p_kle_id IN NUMBER DEFAULT NULL,
416 p_quote_id IN NUMBER, -- rmunjulu LOANS_ENHANCEMENT
417 p_message_yn IN BOOLEAN,
418 p_proration_factor IN NUMBER DEFAULT NULL, -- added : Bug 6030917 : prasjain
419 x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER;
420
421 -- BAKUCHIB 19-FEB-03 2757368 Added this function to get the party name
422 --for a given contract id and Role code. Line id is optional
423 FUNCTION get_party_name(
424 p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
425 p_rle_code IN OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE,
426 p_kle_id IN OKL_K_HEADERS.ID%TYPE DEFAULT NULL)
427 RETURN VARCHAR2;
428
429 -- SPILLAIP 06-OCT-03 3115478 Added
430 -- ALL EXISTING QUOTES MUST BE INVALIDATED WHEN A CONTRACT IS REBOOKED
431 PROCEDURE get_all_term_qte_for_contract (
432 p_khr_id IN NUMBER,
433 x_quote_tbl OUT NOCOPY quote_tbl_type,
434 x_return_status OUT NOCOPY VARCHAR2) ;
435
436 -- RMUNJULU 3510740
437 FUNCTION get_actual_asset_residual (
438 p_khr_id IN NUMBER,
439 p_kle_id IN NUMBER) RETURN NUMBER;
440
441 -- rmunjulu EDAT -- new function to get sum of anticipated billing
442 FUNCTION get_anticipated_bill (p_qte_id IN NUMBER) RETURN NUMBER ;
443
444 -- rmunjulu 4299668 Added
445 FUNCTION get_asset_net_book_value (
446 p_kle_id IN NUMBER,
447 p_transaction_date IN DATE DEFAULT NULL) RETURN NUMBER;
448
449 -- rmunjulu Sales_Tax_Enhancement
450 -- This function returns the tax amount for the tax TRX_ID
451 -- TRX_ID can be quote_id, ar_inv_trx_id
452 FUNCTION get_tax_amount (
453 p_tax_trx_id IN NUMBER) RETURN NUMBER;
454
455 -- rmunjulu LOANS_ENHANCEMENTS get product details
456 PROCEDURE get_contract_product_details (
457 p_khr_id IN NUMBER,
458 x_deal_type OUT NOCOPY VARCHAR2,
459 x_rev_rec_method OUT NOCOPY VARCHAR2,
460 x_int_cal_basis OUT NOCOPY VARCHAR2,
461 x_tax_owner OUT NOCOPY VARCHAR2,
462 x_return_status OUT NOCOPY VARCHAR2);
463
464 -- rmunjulu LOANS_ENHANCEMENTS get excess loan payment amount
465 FUNCTION get_excess_loan_payment (
466 p_khr_id IN NUMBER,
467 x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER;
468
469 -- rmunjulu BUYOUT_2 check full termination transaction being processed.
470 FUNCTION check_full_term_in_progress (
471 p_khr_id IN NUMBER,
472 x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
473 --asawanka added
474 FUNCTION get_latest_alc_tax (
475 p_top_line_id IN NUMBER) RETURN NUMBER;
476 FUNCTION get_latest_alc_serialized_flag (
477 p_top_line_id IN NUMBER) RETURN VARCHAR2;
478 FUNCTION get_latest_alc_req_id (
479 p_top_line_id IN NUMBER) RETURN NUMBER;
480 FUNCTION get_latest_alc_eff_date (
481 p_top_line_id IN NUMBER) RETURN DATE;
482 FUNCTION get_latest_alc_req_sts (
483 p_top_line_id IN NUMBER) RETURN VARCHAR2;
484 FUNCTION get_latest_alc_trx_id (
485 p_top_line_id IN NUMBER) RETURN NUMBER;
486
487
488 --rbruno bug 6185552 start
489
490 FUNCTION get_fa_nbv (
491 p_chr_id IN OKC_K_HEADERS_B.ID%TYPE
492 ,p_asset_id IN NUMBER
493 ) RETURN NUMBER;
494
495 --rbruno bug 6185552 end
496
497 END OKL_AM_UTIL_PVT;