DBA Data[Home] [Help]

APPS.FA_RETIREMENT_ADJUSTMENT_PUB dependencies on FA_API_TYPES

Line 11: g_log_level_rec fa_api_types.log_level_rec_type;

7: G_PKG_NAME CONSTANT varchar2(30) := 'FA_ADJUSTMENT_PUB';
8: G_API_NAME CONSTANT varchar2(30) := 'Adjustment API';
9: G_API_VERSION CONSTANT number := 1.0;
10:
11: g_log_level_rec fa_api_types.log_level_rec_type;
12:
13: --*********************** Private functions ******************************--
14: -- This private function calls fa_asset_val_pvt.validate_over_depreciate
15: -- to determine this retirement adjustment is valid or not

Line 17: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

13: --*********************** Private functions ******************************--
14: -- This private function calls fa_asset_val_pvt.validate_over_depreciate
15: -- to determine this retirement adjustment is valid or not
16: FUNCTION validate_over_depreciate
17: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
18: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
19: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
21: p_proceeds_of_sale NUMBER,

Line 18: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,

14: -- This private function calls fa_asset_val_pvt.validate_over_depreciate
15: -- to determine this retirement adjustment is valid or not
16: FUNCTION validate_over_depreciate
17: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
18: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
19: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
21: p_proceeds_of_sale NUMBER,
22: p_cost_of_removal NUMBER,

Line 19: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,

15: -- to determine this retirement adjustment is valid or not
16: FUNCTION validate_over_depreciate
17: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
18: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
19: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
21: p_proceeds_of_sale NUMBER,
22: p_cost_of_removal NUMBER,
23: p_log_level_rec IN fa_api_types.log_level_rec_type

Line 20: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,

16: FUNCTION validate_over_depreciate
17: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
18: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
19: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
21: p_proceeds_of_sale NUMBER,
22: p_cost_of_removal NUMBER,
23: p_log_level_rec IN fa_api_types.log_level_rec_type
24: ) RETURN BOOLEAN;

Line 23: p_log_level_rec IN fa_api_types.log_level_rec_type

19: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
21: p_proceeds_of_sale NUMBER,
22: p_cost_of_removal NUMBER,
23: p_log_level_rec IN fa_api_types.log_level_rec_type
24: ) RETURN BOOLEAN;
25:
26: FUNCTION do_all_books
27: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

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

23: p_log_level_rec IN fa_api_types.log_level_rec_type
24: ) RETURN BOOLEAN;
25:
26: FUNCTION do_all_books
27: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
28: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
29: p_cost_of_removal IN NUMBER,
30: p_proceeds IN NUMBER,
31: p_cost_of_removal_ccid IN NUMBER,

Line 28: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

24: ) RETURN BOOLEAN;
25:
26: FUNCTION do_all_books
27: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
28: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
29: p_cost_of_removal IN NUMBER,
30: p_proceeds IN NUMBER,
31: p_cost_of_removal_ccid IN NUMBER,
32: p_proceeds_ccid IN NUMBER,

Line 33: p_log_level_rec IN fa_api_types.log_level_rec_type

29: p_cost_of_removal IN NUMBER,
30: p_proceeds IN NUMBER,
31: p_cost_of_removal_ccid IN NUMBER,
32: p_proceeds_ccid IN NUMBER,
33: p_log_level_rec IN fa_api_types.log_level_rec_type
34: ) RETURN BOOLEAN;
35:
36:
37: --*********************** Public procedures ******************************--

Line 50: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49:
50: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
51: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
52: p_cost_of_removal IN NUMBER,
53: p_proceeds IN NUMBER,
54: p_cost_of_removal_ccid IN NUMBER DEFAULT NULL,

Line 51: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49:
50: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
51: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
52: p_cost_of_removal IN NUMBER,
53: p_proceeds IN NUMBER,
54: p_cost_of_removal_ccid IN NUMBER DEFAULT NULL,
55: p_proceeds_ccid IN NUMBER DEFAULT NULL

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

212: -- book calling the private api for each.
213:
214:
215: FUNCTION do_all_books
216: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
217: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
218: p_cost_of_removal IN NUMBER,
219: p_proceeds IN NUMBER,
220: p_cost_of_removal_ccid IN NUMBER,

Line 217: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

213:
214:
215: FUNCTION do_all_books
216: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
217: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
218: p_cost_of_removal IN NUMBER,
219: p_proceeds IN NUMBER,
220: p_cost_of_removal_ccid IN NUMBER,
221: p_proceeds_ccid IN NUMBER,

Line 222: p_log_level_rec IN fa_api_types.log_level_rec_type

218: p_cost_of_removal IN NUMBER,
219: p_proceeds IN NUMBER,
220: p_cost_of_removal_ccid IN NUMBER,
221: p_proceeds_ccid IN NUMBER,
222: p_log_level_rec IN fa_api_types.log_level_rec_type
223: ) RETURN BOOLEAN IS
224:
225:
226: -- used for new source asset

Line 227: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

223: ) RETURN BOOLEAN IS
224:
225:
226: -- used for new source asset
227: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
228: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
229: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
230: l_asset_type_rec fa_api_types.asset_type_rec_type;
231: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

Line 228: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

224:
225:
226: -- used for new source asset
227: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
228: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
229: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
230: l_asset_type_rec fa_api_types.asset_type_rec_type;
231: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
232: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;

Line 229: l_asset_desc_rec fa_api_types.asset_desc_rec_type;

225:
226: -- used for new source asset
227: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
228: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
229: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
230: l_asset_type_rec fa_api_types.asset_type_rec_type;
231: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
232: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
233: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;

Line 230: l_asset_type_rec fa_api_types.asset_type_rec_type;

226: -- used for new source asset
227: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
228: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
229: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
230: l_asset_type_rec fa_api_types.asset_type_rec_type;
231: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
232: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
233: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
234: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;

Line 231: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

227: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
228: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
229: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
230: l_asset_type_rec fa_api_types.asset_type_rec_type;
231: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
232: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
233: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
234: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
235: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;

Line 232: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;

228: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
229: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
230: l_asset_type_rec fa_api_types.asset_type_rec_type;
231: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
232: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
233: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
234: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
235: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
236:

Line 233: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;

229: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
230: l_asset_type_rec fa_api_types.asset_type_rec_type;
231: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
232: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
233: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
234: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
235: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
236:
237: l_proceeds number;

Line 234: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;

230: l_asset_type_rec fa_api_types.asset_type_rec_type;
231: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
232: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
233: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
234: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
235: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
236:
237: l_proceeds number;
238: l_cost_of_removal number;

Line 235: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;

231: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
232: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
233: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
234: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
235: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
236:
237: l_proceeds number;
238: l_cost_of_removal number;
239:

Line 242: l_period_rec FA_API_TYPES.period_rec_type;

238: l_cost_of_removal number;
239:
240: l_primary_cost number; -- ??? use ???
241:
242: l_period_rec FA_API_TYPES.period_rec_type;
243: l_rsob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
244: l_reporting_flag varchar2(1);
245:
246: l_exchange_rate number;

Line 256: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

252: l_calling_fn VARCHAR2(35) := 'fa_ret_adj_pub.do_all_books';
253: ret_adj_err exception;
254:
255: --Secondary Chnages
256: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
257: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;
258: l_secondary_sob_id number;
259:
260: BEGIN

Line 257: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;

253: ret_adj_err exception;
254:
255: --Secondary Chnages
256: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
257: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;
258: l_secondary_sob_id number;
259:
260: BEGIN
261:

Line 574: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

570:
571: end do_all_books;
572:
573: FUNCTION validate_over_depreciate
574: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
575: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
576: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
577: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
578: p_proceeds_of_sale NUMBER,

Line 575: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,

571: end do_all_books;
572:
573: FUNCTION validate_over_depreciate
574: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
575: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
576: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
577: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
578: p_proceeds_of_sale NUMBER,
579: p_cost_of_removal NUMBER,

Line 576: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,

572:
573: FUNCTION validate_over_depreciate
574: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
575: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
576: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
577: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
578: p_proceeds_of_sale NUMBER,
579: p_cost_of_removal NUMBER,
580: p_log_level_rec IN fa_api_types.log_level_rec_type) RETURN BOOLEAN IS

Line 577: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,

573: FUNCTION validate_over_depreciate
574: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
575: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
576: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
577: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
578: p_proceeds_of_sale NUMBER,
579: p_cost_of_removal NUMBER,
580: p_log_level_rec IN fa_api_types.log_level_rec_type) RETURN BOOLEAN IS
581:

Line 580: p_log_level_rec IN fa_api_types.log_level_rec_type) RETURN BOOLEAN IS

576: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
577: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
578: p_proceeds_of_sale NUMBER,
579: p_cost_of_removal NUMBER,
580: p_log_level_rec IN fa_api_types.log_level_rec_type) RETURN BOOLEAN IS
581:
582: l_deprn_reserve_new NUMBER := 0;
583: BEGIN
584: