DBA Data[Home] [Help]

APPS.FA_DELETION_PUB dependencies on FA_API_TYPES

Line 10: g_log_level_rec FA_API_TYPES.log_level_rec_type;

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

Line 17: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

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,

Line 18: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

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;

Line 19: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

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:

Line 20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

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:

Line 22: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN;

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:

Line 36: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) IS

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

Line 51: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

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:

Line 52: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

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

Line 53: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

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;

Line 61: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

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';

Line 310: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

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,

Line 311: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

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

Line 312: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

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:

Line 313: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

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

Line 315: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN IS

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:

Line 318: l_asset_hdr_rec FA_API_TYPES.asset_hdr_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:
320: l_period_rec FA_API_TYPES.period_rec_type;
321: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
322:

Line 320: l_period_rec FA_API_TYPES.period_rec_type;

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;