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: g_release number := fa_cache_pkg.fazarel_release;
12:
13: --*********************** Private functions ******************************--
14:
14:
15: -- private declaration for books (mrc) wrapper
16:
17: FUNCTION do_all_books
18: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
19: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
20: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15: -- private declaration for books (mrc) wrapper
16:
17: FUNCTION do_all_books
18: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
19: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
20: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
23: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
16:
17: FUNCTION do_all_books
18: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
19: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
20: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
23: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
24: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
17: FUNCTION do_all_books
18: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
19: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
20: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
23: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
24: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
25:
18: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
19: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
20: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
23: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
24: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
25:
26:
19: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
20: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
23: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
24: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
25:
26:
27: --*********************** Public procedures ******************************--
20: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
23: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
24: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
25:
26:
27: --*********************** Public procedures ******************************--
28:
34: p_calling_fn IN VARCHAR2 := NULL,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
39: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
40: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
41:
42: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
39: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
40: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
41:
42: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
43: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
39: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
40: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
41:
42: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
43: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
44: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
38: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
39: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
40: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
41:
42: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
43: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
44: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
45:
46: l_reporting_flag VARCHAR2(1);
39: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
40: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
41:
42: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
43: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
44: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
45:
46: l_reporting_flag VARCHAR2(1);
47:
40: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type) IS
41:
42: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
43: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
44: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
45:
46: l_reporting_flag VARCHAR2(1);
47:
48: l_calling_fn VARCHAR2(35) := 'fa_unplanned_pub.do_unplanned';
325: -- book calling the private api for each.
326:
327:
328: FUNCTION do_all_books
329: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
330: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
332: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
333: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
326:
327:
328: FUNCTION do_all_books
329: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
330: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
332: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
333: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
334: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
327:
328: FUNCTION do_all_books
329: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
330: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
332: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
333: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
334: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
335: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
328: FUNCTION do_all_books
329: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
330: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
332: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
333: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
334: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
335: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
336:
329: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
330: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
332: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
333: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
334: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
335: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
336:
337: -- used for calling private api for reporting books
330: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
332: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
333: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
334: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
335: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
336:
337: -- used for calling private api for reporting books
338: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
332: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
333: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
334: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
335: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
336:
337: -- used for calling private api for reporting books
338: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
339: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
334: p_unplanned_deprn_rec IN FA_API_TYPES.unplanned_deprn_rec_type
335: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
336:
337: -- used for calling private api for reporting books
338: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
339: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
340: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
341:
342: -- used for retrieving "old" and "new" structs from private api calls
335: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
336:
337: -- used for calling private api for reporting books
338: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
339: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
340: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
341:
342: -- used for retrieving "old" and "new" structs from private api calls
343: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
336:
337: -- used for calling private api for reporting books
338: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
339: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
340: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
341:
342: -- used for retrieving "old" and "new" structs from private api calls
343: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
344: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
339: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
340: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
341:
342: -- used for retrieving "old" and "new" structs from private api calls
343: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
344: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
345:
346: l_unplanned_deprn_rec FA_API_TYPES.unplanned_deprn_rec_type;
347:
340: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
341:
342: -- used for retrieving "old" and "new" structs from private api calls
343: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
344: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
345:
346: l_unplanned_deprn_rec FA_API_TYPES.unplanned_deprn_rec_type;
347:
348: l_reporting_flag varchar2(1);
342: -- used for retrieving "old" and "new" structs from private api calls
343: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
344: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
345:
346: l_unplanned_deprn_rec FA_API_TYPES.unplanned_deprn_rec_type;
347:
348: l_reporting_flag varchar2(1);
349: l_period_rec FA_API_TYPES.period_rec_type;
350: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
345:
346: l_unplanned_deprn_rec FA_API_TYPES.unplanned_deprn_rec_type;
347:
348: l_reporting_flag varchar2(1);
349: l_period_rec FA_API_TYPES.period_rec_type;
350: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
351:
352: -- used for local runs
353: l_responsibility_id number;
376: l_rowid rowid;
377: l_primary_cost number;
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_primary_cost number;
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';