6: G_PKG_NAME CONSTANT varchar2(30) := 'FA_DELETION_PUB';
7: G_API_NAME CONSTANT varchar2(30) := 'Deletion 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_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
18: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
19: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: p_validation_level IN NUMBER,
14: -- private declaration for books (mrc) wrapper
15:
16: FUNCTION do_all_books
17: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
18: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
19: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: p_validation_level IN NUMBER,
22: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN;
15:
16: FUNCTION do_all_books
17: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
18: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
19: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: p_validation_level IN NUMBER,
22: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN;
23:
16: FUNCTION do_all_books
17: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
18: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
19: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: p_validation_level IN NUMBER,
22: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN;
23:
24:
18: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
19: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: p_validation_level IN NUMBER,
22: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN;
23:
24:
25: --*********************** Public procedures ******************************--
26:
32: p_calling_fn IN VARCHAR2,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
35: x_msg_data OUT NOCOPY VARCHAR2,
36: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) IS
37:
38: CURSOR c_tax_books IS
39: select distinct book_type_code
40: from fa_books
47: l_rate_count number := 0;
48: l_deprn_count number := 0;
49: l_count number := 0;
50:
51: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
52: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
53: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
54:
55:
48: l_deprn_count number := 0;
49: l_count number := 0;
50:
51: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
52: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
53: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
54:
55:
56: -- used to store original sob info upon entry into api
49: l_count number := 0;
50:
51: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
52: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
53: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
54:
55:
56: -- used to store original sob info upon entry into api
57: l_orig_set_of_books_id number;
57: l_orig_set_of_books_id number;
58: l_orig_currency_context varchar2(64);
59:
60: -- used for tax book loop
61: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
62: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
63: l_tax_index NUMBER; -- index for tax loop
64:
65: l_calling_fn VARCHAR2(35) := 'fa_deletion_pub.do_delete';
306: -- book calling the private api for each.
307:
308:
309: FUNCTION do_all_books
310: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
311: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
312: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
313: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
314: p_validation_level IN NUMBER,
307:
308:
309: FUNCTION do_all_books
310: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
311: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
312: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
313: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
314: p_validation_level IN NUMBER,
315: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN IS
308:
309: FUNCTION do_all_books
310: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
311: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
312: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
313: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
314: p_validation_level IN NUMBER,
315: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN IS
316:
309: FUNCTION do_all_books
310: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
311: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
312: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
313: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
314: p_validation_level IN NUMBER,
315: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN IS
316:
317: -- used for calling private api for reporting books
311: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
312: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
313: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
314: p_validation_level IN NUMBER,
315: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN IS
316:
317: -- used for calling private api for reporting books
318: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
319:
314: p_validation_level IN NUMBER,
315: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN IS
316:
317: -- used for calling private api for reporting books
318: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
319:
320: l_period_rec FA_API_TYPES.period_rec_type;
321: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
322:
316:
317: -- used for calling private api for reporting books
318: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
319:
320: l_period_rec FA_API_TYPES.period_rec_type;
321: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
322:
323: -- used for local runs
324: l_responsibility_id number;