DBA Data[Home] [Help]

APPS.FA_TAX_RSV_ADJ_PUB dependencies on FA_API_TYPES

Line 14: g_log_level_rec fa_api_types.log_level_rec_type;

10: --*********************** Private functions ******************************--
11:
12: -- private declaration for books (mrc) wrapper
13:
14: g_log_level_rec fa_api_types.log_level_rec_type;
15: g_cip_cost number := 0;
16: g_cost number := 0;
17:
18: FUNCTION do_all_books

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

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

Line 20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

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

Line 21: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

17:
18: FUNCTION do_all_books
19: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
22: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,
25: p_calling_fn IN VARCHAR2

Line 22: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

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

Line 23: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

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

Line 24: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,

20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
22: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,
25: p_calling_fn IN VARCHAR2
26: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
27:
28:

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

22: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,
25: p_calling_fn IN VARCHAR2
26: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
27:
28:
29: FUNCTION is_amortized
30: (p_asset_id IN fa_books.asset_id%type,

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

30: (p_asset_id IN fa_books.asset_id%type,
31: p_book IN fa_book_controls.book_type_code%type,
32: p_period_counter IN number,
33: x_is_amortized OUT NOCOPY boolean
34: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
35:
36:
37: --*********************** Public procedures *****************************--
38:

Line 49: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48:
49: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
51: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type)
52: IS
53:

Line 50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48:
49: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
51: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type)
52: IS
53:
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 51: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type)

47: x_msg_data OUT NOCOPY VARCHAR2,
48:
49: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
51: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type)
52: IS
53:
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

Line 54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
51: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type)
52: IS
53:
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
56: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
57: l_asset_tax_rsv_adj_rec FA_API_TYPES.asset_tax_rsv_adj_rec_type;
58:

Line 55: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

51: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type)
52: IS
53:
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
56: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
57: l_asset_tax_rsv_adj_rec FA_API_TYPES.asset_tax_rsv_adj_rec_type;
58:
59: x_is_amortized Boolean;

Line 56: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

52: IS
53:
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
56: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
57: l_asset_tax_rsv_adj_rec FA_API_TYPES.asset_tax_rsv_adj_rec_type;
58:
59: x_is_amortized Boolean;
60: l_fully_rsv Boolean;

Line 57: l_asset_tax_rsv_adj_rec FA_API_TYPES.asset_tax_rsv_adj_rec_type;

53:
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
56: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
57: l_asset_tax_rsv_adj_rec FA_API_TYPES.asset_tax_rsv_adj_rec_type;
58:
59: x_is_amortized Boolean;
60: l_fully_rsv Boolean;
61:

Line 376: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN is

372: ( p_asset_id IN fa_books.asset_id%type
373: ,p_book IN fa_book_controls.book_type_code%type
374: ,p_period_counter IN number
375: ,x_is_amortized OUT NOCOPY boolean
376: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN is
377:
378: Cursor c_amort is
379: SELECT 1
380: FROM FA_TRANSACTION_HEADERS TH, FA_DEPRN_PERIODS DP

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

419: -- For MRC, it processes the primary and then loops through each reporting
420: -- book calling the private api for each.
421:
422: FUNCTION do_all_books
423: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
424: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
425: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
426: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
427: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

Line 424: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

420: -- book calling the private api for each.
421:
422: FUNCTION do_all_books
423: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
424: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
425: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
426: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
427: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
428: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,

Line 425: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

421:
422: FUNCTION do_all_books
423: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
424: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
425: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
426: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
427: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
428: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,
429: p_calling_fn IN VARCHAR2,

Line 426: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

422: FUNCTION do_all_books
423: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
424: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
425: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
426: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
427: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
428: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,
429: p_calling_fn IN VARCHAR2,
430: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

Line 427: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

423: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
424: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
425: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
426: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
427: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
428: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,
429: p_calling_fn IN VARCHAR2,
430: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
431:

Line 428: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,

424: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
425: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
426: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
427: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
428: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,
429: p_calling_fn IN VARCHAR2,
430: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
431:
432: l_asset_hdr_rec_mrc FA_API_TYPES.asset_hdr_rec_type;

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

426: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
427: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
428: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,
429: p_calling_fn IN VARCHAR2,
430: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
431:
432: l_asset_hdr_rec_mrc FA_API_TYPES.asset_hdr_rec_type;
433: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
434: l_period_rec FA_API_TYPES.period_rec_type;

Line 432: l_asset_hdr_rec_mrc FA_API_TYPES.asset_hdr_rec_type;

428: p_asset_tax_rsv_adj_rec IN FA_API_TYPES.asset_tax_rsv_adj_rec_type,
429: p_calling_fn IN VARCHAR2,
430: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
431:
432: l_asset_hdr_rec_mrc FA_API_TYPES.asset_hdr_rec_type;
433: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
434: l_period_rec FA_API_TYPES.period_rec_type;
435:
436: l_transaction_date date;

Line 433: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

429: p_calling_fn IN VARCHAR2,
430: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
431:
432: l_asset_hdr_rec_mrc FA_API_TYPES.asset_hdr_rec_type;
433: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
434: l_period_rec FA_API_TYPES.period_rec_type;
435:
436: l_transaction_date date;
437: l_fully_rsv boolean;

Line 434: l_period_rec FA_API_TYPES.period_rec_type;

430: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
431:
432: l_asset_hdr_rec_mrc FA_API_TYPES.asset_hdr_rec_type;
433: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
434: l_period_rec FA_API_TYPES.period_rec_type;
435:
436: l_transaction_date date;
437: l_fully_rsv boolean;
438: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;