DBA Data[Home] [Help]

APPS.FA_RET_TYPES dependencies on FA_RETIREMENTS

Line 11: retirement_id FA_RETIREMENTS.retirement_id%type,

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

Line 12: asset_id FA_RETIREMENTS.asset_id%type,

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

Line 13: units_retired FA_RETIREMENTS.units%type,

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

Line 14: stl_life FA_RETIREMENTS.stl_life_in_months%type,

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

Line 15: itc_recapid FA_RETIREMENTS.itc_recapture_id%type,

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

Line 16: th_id_in FA_RETIREMENTS.transaction_header_id_in%type,

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

Line 17: stl_method_code FA_RETIREMENTS.stl_method_code%type,

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

Line 18: status FA_RETIREMENTS.status%type,

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

Line 20: cost_retired FA_RETIREMENTS.cost_retired%type,

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

Line 22: reval_rsv_retired FA_RETIREMENTS.reval_reserve_retired%type,

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

Line 23: proceeds_of_sale FA_RETIREMENTS.proceeds_of_sale%type,

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

Line 24: cost_of_removal FA_RETIREMENTS.cost_of_removal%type,

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

Line 26: date_retired FA_RETIREMENTS.date_retired%type,

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

Line 27: prorate_convention FA_RETIREMENTS.retirement_prorate_convention%type,

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

Line 28: date_effective FA_RETIREMENTS.date_effective%type,

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

Line 29: book FA_RETIREMENTS.book_type_code%type,

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

Line 31: retirement_type_code fa_retirements.retirement_type_code%type,

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

Line 34: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,

30: dpr_evenly NUMBER,
31: retirement_type_code fa_retirements.retirement_type_code%type,
32: gain_loss_amount number,
33: bonus_rsv_retired number,
34: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,
35: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
36: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
37: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
38: reduction_rate FA_RETIREMENTS.reduction_rate%type,

Line 35: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,

31: retirement_type_code fa_retirements.retirement_type_code%type,
32: gain_loss_amount number,
33: bonus_rsv_retired number,
34: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,
35: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
36: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
37: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
38: reduction_rate FA_RETIREMENTS.reduction_rate%type,
39: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,

Line 36: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,

32: gain_loss_amount number,
33: bonus_rsv_retired number,
34: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,
35: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
36: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
37: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
38: reduction_rate FA_RETIREMENTS.reduction_rate%type,
39: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,
40: recapture_amount FA_RETIREMENTS.recapture_amount%type,

Line 37: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,

33: bonus_rsv_retired number,
34: recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,
35: recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
36: limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
37: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
38: reduction_rate FA_RETIREMENTS.reduction_rate%type,
39: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,
40: recapture_amount FA_RETIREMENTS.recapture_amount%type,
41: reserve_retired FA_RETIREMENTS.reserve_retired%type,

Line 38: reduction_rate FA_RETIREMENTS.reduction_rate%type,

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

Line 39: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,

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

Line 40: recapture_amount FA_RETIREMENTS.recapture_amount%type,

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

Line 41: reserve_retired FA_RETIREMENTS.reserve_retired%type,

37: terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
38: reduction_rate FA_RETIREMENTS.reduction_rate%type,
39: eofy_reserve FA_RETIREMENTS.eofy_reserve%type,
40: recapture_amount FA_RETIREMENTS.recapture_amount%type,
41: reserve_retired FA_RETIREMENTS.reserve_retired%type,
42: mrc_sob_type_code varchar2(1)
43: );
44:
45: TYPE book_struct is RECORD(