eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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) 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) 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) RETURN BOOLEAN;
23:
24: FUNCTION delete_asset_events

Line 22: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) 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) RETURN BOOLEAN;
23:
24: FUNCTION delete_asset_events
25: (px_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type
26: ,p_asset_type_rec IN fa_api_types.asset_type_rec_type

Line 25: (px_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type

21: p_validation_level IN NUMBER,
22: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
23:
24: FUNCTION delete_asset_events
25: (px_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type
26: ,p_asset_type_rec IN fa_api_types.asset_type_rec_type
27: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN;
28:
29: --*********************** Public procedures ******************************--

Line 26: ,p_asset_type_rec IN fa_api_types.asset_type_rec_type

22: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
23:
24: FUNCTION delete_asset_events
25: (px_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type
26: ,p_asset_type_rec IN fa_api_types.asset_type_rec_type
27: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN;
28:
29: --*********************** Public procedures ******************************--
30:

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

23:
24: FUNCTION delete_asset_events
25: (px_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type
26: ,p_asset_type_rec IN fa_api_types.asset_type_rec_type
27: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN;
28:
29: --*********************** Public procedures ******************************--
30:
31: PROCEDURE do_delete

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

37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40:
41: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) IS
42:
43: CURSOR c_tax_books IS
44: select distinct book_type_code
45: from fa_books

Line 56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

52: l_rate_count number := 0;
53: l_deprn_count number := 0;
54: l_count number := 0;
55:
56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
58: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
59:
60: -- used for tax book loop

Line 57: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

53: l_deprn_count number := 0;
54: l_count number := 0;
55:
56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
58: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
59:
60: -- used for tax book loop
61: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 58: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

54: l_count number := 0;
55:
56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
58: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
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;

Line 61: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

57: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
58: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
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 288: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

284: -- book calling the private api for each.
285:
286:
287: FUNCTION do_all_books
288: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
289: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
291: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
292: p_validation_level IN NUMBER

Line 289: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

285:
286:
287: FUNCTION do_all_books
288: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
289: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
291: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
292: p_validation_level IN NUMBER
293: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

Line 290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

286:
287: FUNCTION do_all_books
288: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
289: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
291: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
292: p_validation_level IN NUMBER
293: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
294:

Line 291: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

287: FUNCTION do_all_books
288: (px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
289: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
291: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
292: p_validation_level IN NUMBER
293: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
294:
295: -- used for calling private api for reporting books

Line 293: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

289: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
291: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
292: p_validation_level IN NUMBER
293: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
294:
295: -- used for calling private api for reporting books
296: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
297:

Line 296: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

292: p_validation_level IN NUMBER
293: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
294:
295: -- used for calling private api for reporting books
296: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
297:
298: l_period_rec FA_API_TYPES.period_rec_type;
299: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
300:

Line 298: l_period_rec FA_API_TYPES.period_rec_type;

294:
295: -- used for calling private api for reporting books
296: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
297:
298: l_period_rec FA_API_TYPES.period_rec_type;
299: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
300:
301: -- used for local runs
302: l_responsibility_id number;

Line 517: FUNCTION delete_asset_events (px_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

513: return FALSE;
514:
515: END do_all_books;
516:
517: FUNCTION delete_asset_events (px_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
518: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
519: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN IS
520:
521: del_err EXCEPTION;

Line 518: p_asset_type_rec IN fa_api_types.asset_type_rec_type,

514:
515: END do_all_books;
516:
517: FUNCTION delete_asset_events (px_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
518: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
519: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN IS
520:
521: del_err EXCEPTION;
522: l_calling_fn varchar2(80) := 'fa_delete_pub.delete_asset_events';

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

515: END do_all_books;
516:
517: FUNCTION delete_asset_events (px_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
518: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
519: p_log_level_rec IN fa_api_types.log_level_rec_type default null) RETURN BOOLEAN IS
520:
521: del_err EXCEPTION;
522: l_calling_fn varchar2(80) := 'fa_delete_pub.delete_asset_events';
523: