DBA Data[Home] [Help]

APPS.FA_RET_TYPES dependencies on FA_RETIREMENTS

Line 13: retirement_id FA_RETIREMENTS.retirement_id%type,

9: --
10: -- Structures needed for gain/loss program
11: --
12: TYPE ret_struct is RECORD(
13: retirement_id FA_RETIREMENTS.retirement_id%type,
14: asset_id FA_RETIREMENTS.asset_id%type,
15: units_retired FA_RETIREMENTS.units%type,
16: stl_life FA_RETIREMENTS.stl_life_in_months%type,
17: itc_recapid FA_RETIREMENTS.itc_recapture_id%type,

Line 14: asset_id FA_RETIREMENTS.asset_id%type,

10: -- Structures needed for gain/loss program
11: --
12: TYPE ret_struct is RECORD(
13: retirement_id FA_RETIREMENTS.retirement_id%type,
14: asset_id FA_RETIREMENTS.asset_id%type,
15: units_retired FA_RETIREMENTS.units%type,
16: stl_life FA_RETIREMENTS.stl_life_in_months%type,
17: itc_recapid FA_RETIREMENTS.itc_recapture_id%type,
18: th_id_in FA_RETIREMENTS.transaction_header_id_in%type,

Line 15: units_retired FA_RETIREMENTS.units%type,

11: --
12: TYPE ret_struct is RECORD(
13: retirement_id FA_RETIREMENTS.retirement_id%type,
14: asset_id FA_RETIREMENTS.asset_id%type,
15: units_retired FA_RETIREMENTS.units%type,
16: stl_life FA_RETIREMENTS.stl_life_in_months%type,
17: itc_recapid FA_RETIREMENTS.itc_recapture_id%type,
18: th_id_in FA_RETIREMENTS.transaction_header_id_in%type,
19: stl_method_code FA_RETIREMENTS.stl_method_code%type,

Line 16: stl_life FA_RETIREMENTS.stl_life_in_months%type,

12: TYPE ret_struct is RECORD(
13: retirement_id FA_RETIREMENTS.retirement_id%type,
14: asset_id FA_RETIREMENTS.asset_id%type,
15: units_retired FA_RETIREMENTS.units%type,
16: stl_life FA_RETIREMENTS.stl_life_in_months%type,
17: itc_recapid FA_RETIREMENTS.itc_recapture_id%type,
18: th_id_in FA_RETIREMENTS.transaction_header_id_in%type,
19: stl_method_code FA_RETIREMENTS.stl_method_code%type,
20: status FA_RETIREMENTS.status%type,

Line 17: itc_recapid FA_RETIREMENTS.itc_recapture_id%type,

13: retirement_id FA_RETIREMENTS.retirement_id%type,
14: asset_id FA_RETIREMENTS.asset_id%type,
15: units_retired FA_RETIREMENTS.units%type,
16: stl_life FA_RETIREMENTS.stl_life_in_months%type,
17: itc_recapid FA_RETIREMENTS.itc_recapture_id%type,
18: th_id_in FA_RETIREMENTS.transaction_header_id_in%type,
19: stl_method_code FA_RETIREMENTS.stl_method_code%type,
20: status FA_RETIREMENTS.status%type,
21: wip_asset INTEGER,

Line 18: th_id_in FA_RETIREMENTS.transaction_header_id_in%type,

14: asset_id FA_RETIREMENTS.asset_id%type,
15: units_retired FA_RETIREMENTS.units%type,
16: stl_life FA_RETIREMENTS.stl_life_in_months%type,
17: itc_recapid FA_RETIREMENTS.itc_recapture_id%type,
18: th_id_in FA_RETIREMENTS.transaction_header_id_in%type,
19: stl_method_code FA_RETIREMENTS.stl_method_code%type,
20: status FA_RETIREMENTS.status%type,
21: wip_asset INTEGER,
22: cost_retired FA_RETIREMENTS.cost_retired%type,

Line 19: stl_method_code FA_RETIREMENTS.stl_method_code%type,

15: units_retired FA_RETIREMENTS.units%type,
16: stl_life FA_RETIREMENTS.stl_life_in_months%type,
17: itc_recapid FA_RETIREMENTS.itc_recapture_id%type,
18: th_id_in FA_RETIREMENTS.transaction_header_id_in%type,
19: stl_method_code FA_RETIREMENTS.stl_method_code%type,
20: status FA_RETIREMENTS.status%type,
21: wip_asset INTEGER,
22: cost_retired FA_RETIREMENTS.cost_retired%type,
23: rsv_retired NUMBER,

Line 20: status FA_RETIREMENTS.status%type,

16: stl_life FA_RETIREMENTS.stl_life_in_months%type,
17: itc_recapid FA_RETIREMENTS.itc_recapture_id%type,
18: th_id_in FA_RETIREMENTS.transaction_header_id_in%type,
19: stl_method_code FA_RETIREMENTS.stl_method_code%type,
20: status FA_RETIREMENTS.status%type,
21: wip_asset INTEGER,
22: cost_retired FA_RETIREMENTS.cost_retired%type,
23: rsv_retired NUMBER,
24: reval_rsv_retired FA_RETIREMENTS.reval_reserve_retired%type,

Line 22: cost_retired FA_RETIREMENTS.cost_retired%type,

18: th_id_in FA_RETIREMENTS.transaction_header_id_in%type,
19: stl_method_code FA_RETIREMENTS.stl_method_code%type,
20: status FA_RETIREMENTS.status%type,
21: wip_asset INTEGER,
22: cost_retired FA_RETIREMENTS.cost_retired%type,
23: rsv_retired NUMBER,
24: reval_rsv_retired FA_RETIREMENTS.reval_reserve_retired%type,
25: proceeds_of_sale FA_RETIREMENTS.proceeds_of_sale%type,
26: cost_of_removal FA_RETIREMENTS.cost_of_removal%type,

Line 24: reval_rsv_retired FA_RETIREMENTS.reval_reserve_retired%type,

20: status FA_RETIREMENTS.status%type,
21: wip_asset INTEGER,
22: cost_retired FA_RETIREMENTS.cost_retired%type,
23: rsv_retired NUMBER,
24: reval_rsv_retired FA_RETIREMENTS.reval_reserve_retired%type,
25: proceeds_of_sale FA_RETIREMENTS.proceeds_of_sale%type,
26: cost_of_removal FA_RETIREMENTS.cost_of_removal%type,
27: asset_number FA_ADDITIONS_B.asset_number%type,
28: date_retired FA_RETIREMENTS.date_retired%type,

Line 25: proceeds_of_sale FA_RETIREMENTS.proceeds_of_sale%type,

21: wip_asset INTEGER,
22: cost_retired FA_RETIREMENTS.cost_retired%type,
23: rsv_retired NUMBER,
24: reval_rsv_retired FA_RETIREMENTS.reval_reserve_retired%type,
25: proceeds_of_sale FA_RETIREMENTS.proceeds_of_sale%type,
26: cost_of_removal FA_RETIREMENTS.cost_of_removal%type,
27: asset_number FA_ADDITIONS_B.asset_number%type,
28: date_retired FA_RETIREMENTS.date_retired%type,
29: prorate_convention FA_RETIREMENTS.retirement_prorate_convention%type,

Line 26: cost_of_removal FA_RETIREMENTS.cost_of_removal%type,

22: cost_retired FA_RETIREMENTS.cost_retired%type,
23: rsv_retired NUMBER,
24: reval_rsv_retired FA_RETIREMENTS.reval_reserve_retired%type,
25: proceeds_of_sale FA_RETIREMENTS.proceeds_of_sale%type,
26: cost_of_removal FA_RETIREMENTS.cost_of_removal%type,
27: asset_number FA_ADDITIONS_B.asset_number%type,
28: date_retired FA_RETIREMENTS.date_retired%type,
29: prorate_convention FA_RETIREMENTS.retirement_prorate_convention%type,
30: date_effective FA_RETIREMENTS.date_effective%type,

Line 28: date_retired FA_RETIREMENTS.date_retired%type,

24: reval_rsv_retired FA_RETIREMENTS.reval_reserve_retired%type,
25: proceeds_of_sale FA_RETIREMENTS.proceeds_of_sale%type,
26: cost_of_removal FA_RETIREMENTS.cost_of_removal%type,
27: asset_number FA_ADDITIONS_B.asset_number%type,
28: date_retired FA_RETIREMENTS.date_retired%type,
29: prorate_convention FA_RETIREMENTS.retirement_prorate_convention%type,
30: date_effective FA_RETIREMENTS.date_effective%type,
31: book FA_RETIREMENTS.book_type_code%type,
32: dpr_evenly NUMBER,

Line 29: prorate_convention FA_RETIREMENTS.retirement_prorate_convention%type,

25: proceeds_of_sale FA_RETIREMENTS.proceeds_of_sale%type,
26: cost_of_removal FA_RETIREMENTS.cost_of_removal%type,
27: asset_number FA_ADDITIONS_B.asset_number%type,
28: date_retired FA_RETIREMENTS.date_retired%type,
29: prorate_convention FA_RETIREMENTS.retirement_prorate_convention%type,
30: date_effective FA_RETIREMENTS.date_effective%type,
31: book FA_RETIREMENTS.book_type_code%type,
32: dpr_evenly NUMBER,
33: retirement_type_code fa_retirements.retirement_type_code%type,

Line 30: date_effective FA_RETIREMENTS.date_effective%type,

26: cost_of_removal FA_RETIREMENTS.cost_of_removal%type,
27: asset_number FA_ADDITIONS_B.asset_number%type,
28: date_retired FA_RETIREMENTS.date_retired%type,
29: prorate_convention FA_RETIREMENTS.retirement_prorate_convention%type,
30: date_effective FA_RETIREMENTS.date_effective%type,
31: book FA_RETIREMENTS.book_type_code%type,
32: dpr_evenly NUMBER,
33: retirement_type_code fa_retirements.retirement_type_code%type,
34: gain_loss_amount number,

Line 31: book FA_RETIREMENTS.book_type_code%type,

27: asset_number FA_ADDITIONS_B.asset_number%type,
28: date_retired FA_RETIREMENTS.date_retired%type,
29: prorate_convention FA_RETIREMENTS.retirement_prorate_convention%type,
30: date_effective FA_RETIREMENTS.date_effective%type,
31: book FA_RETIREMENTS.book_type_code%type,
32: dpr_evenly NUMBER,
33: retirement_type_code fa_retirements.retirement_type_code%type,
34: gain_loss_amount number,
35: bonus_rsv_retired number,

Line 33: retirement_type_code fa_retirements.retirement_type_code%type,

29: prorate_convention FA_RETIREMENTS.retirement_prorate_convention%type,
30: date_effective FA_RETIREMENTS.date_effective%type,
31: book FA_RETIREMENTS.book_type_code%type,
32: dpr_evenly NUMBER,
33: retirement_type_code fa_retirements.retirement_type_code%type,
34: gain_loss_amount number,
35: bonus_rsv_retired number,
36: impair_rsv_retired number,
37: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,

Line 37: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,

33: retirement_type_code fa_retirements.retirement_type_code%type,
34: gain_loss_amount number,
35: bonus_rsv_retired number,
36: impair_rsv_retired number,
37: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,
38: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
39: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
40: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
41: reduction_rate FA_RETIREMENTS.reduction_rate%type,

Line 38: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,

34: gain_loss_amount number,
35: bonus_rsv_retired number,
36: impair_rsv_retired number,
37: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,
38: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
39: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
40: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
41: reduction_rate FA_RETIREMENTS.reduction_rate%type,
42: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,

Line 39: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,

35: bonus_rsv_retired number,
36: impair_rsv_retired number,
37: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,
38: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
39: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
40: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
41: reduction_rate FA_RETIREMENTS.reduction_rate%type,
42: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,
43: recapture_amount FA_RETIREMENTS.recapture_amount%type,

Line 40: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,

36: impair_rsv_retired number,
37: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,
38: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
39: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
40: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
41: reduction_rate FA_RETIREMENTS.reduction_rate%type,
42: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,
43: recapture_amount FA_RETIREMENTS.recapture_amount%type,
44: reserve_retired FA_RETIREMENTS.reserve_retired%type,

Line 41: reduction_rate FA_RETIREMENTS.reduction_rate%type,

37: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,
38: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
39: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
40: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
41: reduction_rate FA_RETIREMENTS.reduction_rate%type,
42: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,
43: recapture_amount FA_RETIREMENTS.recapture_amount%type,
44: reserve_retired FA_RETIREMENTS.reserve_retired%type,
45: mrc_sob_type_code varchar2(1),

Line 42: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,

38: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
39: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
40: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
41: reduction_rate FA_RETIREMENTS.reduction_rate%type,
42: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,
43: recapture_amount FA_RETIREMENTS.recapture_amount%type,
44: reserve_retired FA_RETIREMENTS.reserve_retired%type,
45: mrc_sob_type_code varchar2(1),
46: set_of_books_id FA_BOOK_CONTROLS.set_of_books_id%type

Line 43: recapture_amount FA_RETIREMENTS.recapture_amount%type,

39: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
40: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
41: reduction_rate FA_RETIREMENTS.reduction_rate%type,
42: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,
43: recapture_amount FA_RETIREMENTS.recapture_amount%type,
44: reserve_retired FA_RETIREMENTS.reserve_retired%type,
45: mrc_sob_type_code varchar2(1),
46: set_of_books_id FA_BOOK_CONTROLS.set_of_books_id%type
47: );

Line 44: reserve_retired FA_RETIREMENTS.reserve_retired%type,

40: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
41: reduction_rate FA_RETIREMENTS.reduction_rate%type,
42: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,
43: recapture_amount FA_RETIREMENTS.recapture_amount%type,
44: reserve_retired FA_RETIREMENTS.reserve_retired%type,
45: mrc_sob_type_code varchar2(1),
46: set_of_books_id FA_BOOK_CONTROLS.set_of_books_id%type
47: );
48: