6: G_PKG_NAME CONSTANT varchar2(30) := 'FA_UNPLANNED_PUB';
7: G_API_NAME CONSTANT varchar2(30) := 'Unplanned API';
8: G_API_VERSION CONSTANT number := 1.0;
9:
10: g_log_level_rec fa_api_types.log_level_rec_type;
11:
12: --*********************** Private functions ******************************--
13:
14: -- private declaration for books (mrc) wrapper
13:
14: -- private declaration for books (mrc) wrapper
15:
16: FUNCTION do_all_books
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
21: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14: -- private declaration for books (mrc) wrapper
15:
16: FUNCTION do_all_books
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
21: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
22: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
15:
16: FUNCTION do_all_books
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
21: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
22: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
23: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
16: FUNCTION do_all_books
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
21: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
22: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
23: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
24:
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
21: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
22: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
23: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
24:
25:
18: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
21: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
22: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
23: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
24:
25:
26: --*********************** Public procedures ******************************--
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
21: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
22: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
23: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
24:
25:
26: --*********************** Public procedures ******************************--
27:
33: p_calling_fn IN VARCHAR2 := NULL,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
38: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
39: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
40:
41: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
38: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
39: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
40:
41: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
42: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
38: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
39: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
40:
41: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
42: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
43: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
37: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
38: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
39: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
40:
41: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
42: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
43: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
44:
45: l_orig_set_of_books_id number;
38: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
39: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
40:
41: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
42: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
43: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
44:
45: l_orig_set_of_books_id number;
46: l_orig_currency_context varchar2(64);
39: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
40:
41: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
42: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
43: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
44:
45: l_orig_set_of_books_id number;
46: l_orig_currency_context varchar2(64);
47:
326: -- book calling the private api for each.
327:
328:
329: FUNCTION do_all_books
330: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
331: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
332: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
334: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
327:
328:
329: FUNCTION do_all_books
330: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
331: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
332: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
334: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
335: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
328:
329: FUNCTION do_all_books
330: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
331: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
332: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
334: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
335: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
336: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
329: FUNCTION do_all_books
330: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
331: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
332: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
334: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
335: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
336: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
337:
330: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
331: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
332: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
334: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
335: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
336: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
337:
338: -- used for calling private api for reporting books
331: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
332: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
334: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
335: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
336: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
337:
338: -- used for calling private api for reporting books
339: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
332: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
334: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
335: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
336: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
337:
338: -- used for calling private api for reporting books
339: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
340: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
335: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type,
336: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
337:
338: -- used for calling private api for reporting books
339: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
340: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
341: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
342:
343: -- used for retrieving "old" and "new" structs from private api calls
336: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
337:
338: -- used for calling private api for reporting books
339: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
340: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
341: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
342:
343: -- used for retrieving "old" and "new" structs from private api calls
344: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
337:
338: -- used for calling private api for reporting books
339: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
340: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
341: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
342:
343: -- used for retrieving "old" and "new" structs from private api calls
344: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
345: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
340: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
341: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
342:
343: -- used for retrieving "old" and "new" structs from private api calls
344: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
345: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
346:
347: l_unplanned_deprn_rec FA_API_TYPES.unplanned_deprn_rec_type;
348:
341: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
342:
343: -- used for retrieving "old" and "new" structs from private api calls
344: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
345: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
346:
347: l_unplanned_deprn_rec FA_API_TYPES.unplanned_deprn_rec_type;
348:
349: l_reporting_flag varchar2(1);
343: -- used for retrieving "old" and "new" structs from private api calls
344: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
345: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
346:
347: l_unplanned_deprn_rec FA_API_TYPES.unplanned_deprn_rec_type;
348:
349: l_reporting_flag varchar2(1);
350: l_period_rec FA_API_TYPES.period_rec_type;
351: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
346:
347: l_unplanned_deprn_rec FA_API_TYPES.unplanned_deprn_rec_type;
348:
349: l_reporting_flag varchar2(1);
350: l_period_rec FA_API_TYPES.period_rec_type;
351: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
352:
353: -- used for local runs
354: l_responsibility_id number;
376: l_status boolean;
377: l_rowid rowid;
378:
379: -- Track Member
380: l_grp_trans_rec FA_API_TYPES.trans_rec_type;
381: l_grp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
382: l_grp_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
383: l_grp_asset_type_rec FA_API_TYPES.asset_type_rec_type;
384: l_grp_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
377: l_rowid rowid;
378:
379: -- Track Member
380: l_grp_trans_rec FA_API_TYPES.trans_rec_type;
381: l_grp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
382: l_grp_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
383: l_grp_asset_type_rec FA_API_TYPES.asset_type_rec_type;
384: l_grp_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
385: l_grp_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
378:
379: -- Track Member
380: l_grp_trans_rec FA_API_TYPES.trans_rec_type;
381: l_grp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
382: l_grp_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
383: l_grp_asset_type_rec FA_API_TYPES.asset_type_rec_type;
384: l_grp_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
385: l_grp_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
386: l_grp_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
379: -- Track Member
380: l_grp_trans_rec FA_API_TYPES.trans_rec_type;
381: l_grp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
382: l_grp_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
383: l_grp_asset_type_rec FA_API_TYPES.asset_type_rec_type;
384: l_grp_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
385: l_grp_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
386: l_grp_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
387: l_grp_deprn_basis_rule VARCHAR2(4);
380: l_grp_trans_rec FA_API_TYPES.trans_rec_type;
381: l_grp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
382: l_grp_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
383: l_grp_asset_type_rec FA_API_TYPES.asset_type_rec_type;
384: l_grp_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
385: l_grp_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
386: l_grp_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
387: l_grp_deprn_basis_rule VARCHAR2(4);
388: l_grp_rate_source_rule VARCHAR2(10);
381: l_grp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
382: l_grp_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
383: l_grp_asset_type_rec FA_API_TYPES.asset_type_rec_type;
384: l_grp_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
385: l_grp_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
386: l_grp_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
387: l_grp_deprn_basis_rule VARCHAR2(4);
388: l_grp_rate_source_rule VARCHAR2(10);
389: l_ret_code number;
382: l_grp_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
383: l_grp_asset_type_rec FA_API_TYPES.asset_type_rec_type;
384: l_grp_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
385: l_grp_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
386: l_grp_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
387: l_grp_deprn_basis_rule VARCHAR2(4);
388: l_grp_rate_source_rule VARCHAR2(10);
389: l_ret_code number;
390: l_group_level_override VARCHAR2(1) := 'Y';