DBA Data[Home] [Help]

APPS.FA_REVALUATION_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_REVALUATION_PUB';
7: G_API_NAME CONSTANT varchar2(30) := 'Revaluation API';
8: G_API_VERSION CONSTANT number := 1.0;
9:
10: g_log_level_rec fa_api_types.log_level_rec_type;
11:
12:
13: --*********************** Private functions ******************************--
14:

Line 21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

17: g_cip_cost number := 0;
18: g_cost number := 0;
19:
20: FUNCTION do_all_books
21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

Line 22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

18: g_cost number := 0;
19:
20: FUNCTION do_all_books
21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,

Line 23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

19:
20: FUNCTION do_all_books
21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
27: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;

Line 24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

20: FUNCTION do_all_books
21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
27: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
28:

Line 25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
27: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
28:
29:

Line 26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,

22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
27: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
28:
29:
30: --*********************** Public procedures ******************************--

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

23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
27: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
28:
29:
30: --*********************** Public procedures ******************************--
31:

Line 42: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41:
42: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type) IS
45:
46: l_reporting_flag varchar2(1);

Line 43: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41:
42: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type) IS
45:
46: l_reporting_flag varchar2(1);
47:

Line 44: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type) IS

40: x_msg_data OUT NOCOPY VARCHAR2,
41:
42: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type) IS
45:
46: l_reporting_flag varchar2(1);
47:
48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

Line 48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

44: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type) IS
45:
46: l_reporting_flag varchar2(1);
47:
48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:

Line 49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

45:
46: l_reporting_flag varchar2(1);
47:
48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

Line 50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

46: l_reporting_flag varchar2(1);
47:
48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

47:
48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
56:
57: -- used to store original sob info upon entry into api

Line 54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
56:
57: -- used to store original sob info upon entry into api
58: l_orig_set_of_books_id number;

Line 55: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
56:
57: -- used to store original sob info upon entry into api
58: l_orig_set_of_books_id number;
59: l_orig_currency_context varchar2(64);

Line 279: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

275: -- book calling the private api for each.
276:
277:
278: FUNCTION do_all_books
279: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
280: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
281: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
282: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
283: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

Line 280: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

276:
277:
278: FUNCTION do_all_books
279: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
280: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
281: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
282: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
283: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
284: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,

Line 281: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

277:
278: FUNCTION do_all_books
279: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
280: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
281: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
282: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
283: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
284: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
285: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

Line 282: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

278: FUNCTION do_all_books
279: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
280: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
281: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
282: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
283: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
284: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
285: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
286:

Line 283: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

279: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
280: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
281: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
282: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
283: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
284: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
285: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
286:
287: -- used for calling private api for reporting books

Line 284: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,

280: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
281: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
282: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
283: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
284: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
285: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
286:
287: -- used for calling private api for reporting books
288: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 285: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

281: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
282: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
283: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
284: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
285: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
286:
287: -- used for calling private api for reporting books
288: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
289:

Line 288: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

284: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
285: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
286:
287: -- used for calling private api for reporting books
288: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
289:
290: -- used for retrieving "old" and "new" structs from private api calls
291: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
292: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;

Line 291: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;

287: -- used for calling private api for reporting books
288: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
289:
290: -- used for retrieving "old" and "new" structs from private api calls
291: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
292: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
293:
294: l_reporting_flag varchar2(1);
295:

Line 292: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;

288: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
289:
290: -- used for retrieving "old" and "new" structs from private api calls
291: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
292: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
293:
294: l_reporting_flag varchar2(1);
295:
296: l_period_rec FA_API_TYPES.period_rec_type;

Line 296: l_period_rec FA_API_TYPES.period_rec_type;

292: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
293:
294: l_reporting_flag varchar2(1);
295:
296: l_period_rec FA_API_TYPES.period_rec_type;
297: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
298:
299: l_transaction_date date;
300: