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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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),
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
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: );
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: