eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_STD_TYPES dependencies on FA_DEPRN_SUMMARY

Line 71: deprn_rsv FA_DEPRN_SUMMARY.Deprn_Reserve%TYPE,

67: TYPE dpr_struct IS RECORD (
68: adj_cost FA_BOOKS.Adjusted_Cost%TYPE,
69: rec_cost FA_BOOKS.Recoverable_Cost%TYPE,
70: reval_amo_basis FA_BOOKS.Reval_Amortization_Basis%TYPE,
71: deprn_rsv FA_DEPRN_SUMMARY.Deprn_Reserve%TYPE,
72: reval_rsv FA_DEPRN_SUMMARY.Reval_Reserve%TYPE,
73: adj_rate FA_BOOKS.Adjusted_Rate%TYPE,
74: rate_adj_factor FA_BOOKS.Rate_Adjustment_Factor%TYPE,
75: capacity FA_BOOKS.Production_Capacity%TYPE,

Line 72: reval_rsv FA_DEPRN_SUMMARY.Reval_Reserve%TYPE,

68: adj_cost FA_BOOKS.Adjusted_Cost%TYPE,
69: rec_cost FA_BOOKS.Recoverable_Cost%TYPE,
70: reval_amo_basis FA_BOOKS.Reval_Amortization_Basis%TYPE,
71: deprn_rsv FA_DEPRN_SUMMARY.Deprn_Reserve%TYPE,
72: reval_rsv FA_DEPRN_SUMMARY.Reval_Reserve%TYPE,
73: adj_rate FA_BOOKS.Adjusted_Rate%TYPE,
74: rate_adj_factor FA_BOOKS.Rate_Adjustment_Factor%TYPE,
75: capacity FA_BOOKS.Production_Capacity%TYPE,
76: adj_capacity FA_BOOKS.Adjusted_Capacity%TYPE,

Line 77: ltd_prod FA_DEPRN_SUMMARY.Ltd_Production%TYPE,

73: adj_rate FA_BOOKS.Adjusted_Rate%TYPE,
74: rate_adj_factor FA_BOOKS.Rate_Adjustment_Factor%TYPE,
75: capacity FA_BOOKS.Production_Capacity%TYPE,
76: adj_capacity FA_BOOKS.Adjusted_Capacity%TYPE,
77: ltd_prod FA_DEPRN_SUMMARY.Ltd_Production%TYPE,
78: asset_num FA_ADDITIONS.Asset_Number%TYPE,
79: calendar_type FA_CALENDAR_TYPES.Calendar_Type%TYPE,
80: ceil_name FA_BOOKS.Ceiling_Name%TYPE,
81: bonus_rule FA_BOOKS.Bonus_Rule%TYPE,

Line 99: prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,

95: rsv_known_flag BOOLEAN,
96: salvage_value FA_BOOKS.Salvage_Value%TYPE,
97: pc_life_end FA_BOOKS.Period_Counter_Life_Complete%TYPE,
98: adj_rec_cost FA_BOOKS.Adjusted_Recoverable_Cost%TYPE,
99: prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
100: deprn_rounding_flag FA_BOOKS.Annual_Deprn_Rounding_Flag%TYPE,
101: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,
102: used_by_adjustment BOOLEAN,
103: ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,

Line 101: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,

97: pc_life_end FA_BOOKS.Period_Counter_Life_Complete%TYPE,
98: adj_rec_cost FA_BOOKS.Adjusted_Recoverable_Cost%TYPE,
99: prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
100: deprn_rounding_flag FA_BOOKS.Annual_Deprn_Rounding_Flag%TYPE,
101: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,
102: used_by_adjustment BOOLEAN,
103: ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,
104: short_fiscal_year_flag FA_BOOKS.short_fiscal_year_flag%TYPE,
105: conversion_date FA_BOOKS.conversion_date%TYPE,

Line 103: ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,

99: prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
100: deprn_rounding_flag FA_BOOKS.Annual_Deprn_Rounding_Flag%TYPE,
101: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,
102: used_by_adjustment BOOLEAN,
103: ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,
104: short_fiscal_year_flag FA_BOOKS.short_fiscal_year_flag%TYPE,
105: conversion_date FA_BOOKS.conversion_date%TYPE,
106: prorate_date FA_BOOKS.prorate_date%TYPE,
107: orig_deprn_start_date FA_BOOKS.original_deprn_start_date%TYPE,

Line 110: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON

106: prorate_date FA_BOOKS.prorate_date%TYPE,
107: orig_deprn_start_date FA_BOOKS.original_deprn_start_date%TYPE,
108: old_adj_cost FA_BOOKS.old_adjusted_cost%TYPE,
109: formula_factor FA_BOOKS.formula_factor%TYPE,
110: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
111: bonus_ytd_deprn FA_DEPRN_SUMMARY.Bonus_Ytd_Deprn%TYPE,
112: bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
113: prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
114: mrc_sob_type_code VARCHAR2(1),

Line 111: bonus_ytd_deprn FA_DEPRN_SUMMARY.Bonus_Ytd_Deprn%TYPE,

107: orig_deprn_start_date FA_BOOKS.original_deprn_start_date%TYPE,
108: old_adj_cost FA_BOOKS.old_adjusted_cost%TYPE,
109: formula_factor FA_BOOKS.formula_factor%TYPE,
110: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
111: bonus_ytd_deprn FA_DEPRN_SUMMARY.Bonus_Ytd_Deprn%TYPE,
112: bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
113: prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
114: mrc_sob_type_code VARCHAR2(1),
115: tracking_method FA_BOOKS.Tracking_Method%TYPE,

Line 112: bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,

108: old_adj_cost FA_BOOKS.old_adjusted_cost%TYPE,
109: formula_factor FA_BOOKS.formula_factor%TYPE,
110: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
111: bonus_ytd_deprn FA_DEPRN_SUMMARY.Bonus_Ytd_Deprn%TYPE,
112: bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
113: prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
114: mrc_sob_type_code VARCHAR2(1),
115: tracking_method FA_BOOKS.Tracking_Method%TYPE,
116: allocate_to_fully_ret_flag FA_BOOKS.Allocate_to_Fully_Ret_Flag%TYPE,

Line 113: prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,

109: formula_factor FA_BOOKS.formula_factor%TYPE,
110: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
111: bonus_ytd_deprn FA_DEPRN_SUMMARY.Bonus_Ytd_Deprn%TYPE,
112: bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
113: prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
114: mrc_sob_type_code VARCHAR2(1),
115: tracking_method FA_BOOKS.Tracking_Method%TYPE,
116: allocate_to_fully_ret_flag FA_BOOKS.Allocate_to_Fully_Ret_Flag%TYPE,
117: allocate_to_fully_rsv_flag FA_BOOKS.Allocate_to_Fully_Rsv_Flag%TYPE,

Line 127: impairment_exp FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,

123: over_depreciate_option FA_BOOKS.Over_Depreciate_Option%TYPE,
124: super_group_id FA_BOOKS.super_group_id%TYPE,
125: cost FA_BOOKS.cost%TYPE,
126: asset_type FA_ADDITIONS_B.ASSET_TYPE%TYPE,
127: impairment_exp FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,
128: ytd_impairment FA_DEPRN_SUMMARY.YTD_IMPAIRMENT%TYPE,
129: impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
130: calc_catchup BOOLEAN, -- Bug 5738004
131: cost_frac NUMBER, -- Bug 5948890

Line 128: ytd_impairment FA_DEPRN_SUMMARY.YTD_IMPAIRMENT%TYPE,

124: super_group_id FA_BOOKS.super_group_id%TYPE,
125: cost FA_BOOKS.cost%TYPE,
126: asset_type FA_ADDITIONS_B.ASSET_TYPE%TYPE,
127: impairment_exp FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,
128: ytd_impairment FA_DEPRN_SUMMARY.YTD_IMPAIRMENT%TYPE,
129: impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
130: calc_catchup BOOLEAN, -- Bug 5738004
131: cost_frac NUMBER, -- Bug 5948890
132: transaction_type_code FA_TRANSACTION_HEADERS.Transaction_Type_Code%TYPE -- Bug:6665510

Line 129: impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,

125: cost FA_BOOKS.cost%TYPE,
126: asset_type FA_ADDITIONS_B.ASSET_TYPE%TYPE,
127: impairment_exp FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,
128: ytd_impairment FA_DEPRN_SUMMARY.YTD_IMPAIRMENT%TYPE,
129: impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
130: calc_catchup BOOLEAN, -- Bug 5738004
131: cost_frac NUMBER, -- Bug 5948890
132: transaction_type_code FA_TRANSACTION_HEADERS.Transaction_Type_Code%TYPE -- Bug:6665510
133: );

Line 165: new_reval_rsv FA_DEPRN_SUMMARY.Reval_Reserve%TYPE,

161: --
162: TYPE dpr_out_struct IS RECORD (
163: new_deprn_rsv FA_DEPRN_DETAIL.Deprn_reserve%TYPE,
164: new_adj_cost FA_BOOKS.Adjusted_Cost%TYPE,
165: new_reval_rsv FA_DEPRN_SUMMARY.Reval_Reserve%TYPE,
166: new_reval_amo_basis FA_BOOKS.Reval_Amortization_Basis%TYPE,
167: new_adj_capacity FA_BOOKS.Adjusted_Capacity%TYPE,
168: new_ltd_prod FA_DEPRN_SUMMARY.Ltd_Production%TYPE,
169: deprn_exp FA_DEPRN_DETAIL.Reval_deprn_expense%TYPE,

Line 168: new_ltd_prod FA_DEPRN_SUMMARY.Ltd_Production%TYPE,

164: new_adj_cost FA_BOOKS.Adjusted_Cost%TYPE,
165: new_reval_rsv FA_DEPRN_SUMMARY.Reval_Reserve%TYPE,
166: new_reval_amo_basis FA_BOOKS.Reval_Amortization_Basis%TYPE,
167: new_adj_capacity FA_BOOKS.Adjusted_Capacity%TYPE,
168: new_ltd_prod FA_DEPRN_SUMMARY.Ltd_Production%TYPE,
169: deprn_exp FA_DEPRN_DETAIL.Reval_deprn_expense%TYPE,
170: reval_exp FA_DEPRN_DETAIL.Reval_deprn_expense%TYPE,
171: reval_amo FA_DEPRN_DETAIL.Reval_amortization%TYPE,
172: prod FA_DISTRIBUTION_HISTORY.Units_Assigned%TYPE,

Line 182: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON

178: alternate_deprn_factor_used
179: NUMBER,
180: full_rsv_flag BOOLEAN,
181: life_comp_flag BOOLEAN,
182: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
183: impairment_exp FA_DEPRN_SUMMARY.Impairment_Amount%TYPE,
184: new_prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
185: new_bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
186: new_prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,

Line 183: impairment_exp FA_DEPRN_SUMMARY.Impairment_Amount%TYPE,

179: NUMBER,
180: full_rsv_flag BOOLEAN,
181: life_comp_flag BOOLEAN,
182: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
183: impairment_exp FA_DEPRN_SUMMARY.Impairment_Amount%TYPE,
184: new_prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
185: new_bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
186: new_prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
187: new_impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,

Line 184: new_prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,

180: full_rsv_flag BOOLEAN,
181: life_comp_flag BOOLEAN,
182: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
183: impairment_exp FA_DEPRN_SUMMARY.Impairment_Amount%TYPE,
184: new_prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
185: new_bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
186: new_prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
187: new_impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
188: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,

Line 185: new_bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,

181: life_comp_flag BOOLEAN,
182: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
183: impairment_exp FA_DEPRN_SUMMARY.Impairment_Amount%TYPE,
184: new_prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
185: new_bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
186: new_prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
187: new_impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
188: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,
189: new_ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,

Line 186: new_prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,

182: bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
183: impairment_exp FA_DEPRN_SUMMARY.Impairment_Amount%TYPE,
184: new_prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
185: new_bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
186: new_prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
187: new_impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
188: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,
189: new_ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,
190: new_eofy_reserve FA_BOOKS.eofy_reserve%TYPE

Line 187: new_impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,

183: impairment_exp FA_DEPRN_SUMMARY.Impairment_Amount%TYPE,
184: new_prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
185: new_bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
186: new_prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
187: new_impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
188: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,
189: new_ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,
190: new_eofy_reserve FA_BOOKS.eofy_reserve%TYPE
191: );

Line 188: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,

184: new_prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
185: new_bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
186: new_prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
187: new_impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
188: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,
189: new_ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,
190: new_eofy_reserve FA_BOOKS.eofy_reserve%TYPE
191: );
192: --

Line 189: new_ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,

185: new_bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
186: new_prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
187: new_impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
188: deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,
189: new_ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,
190: new_eofy_reserve FA_BOOKS.eofy_reserve%TYPE
191: );
192: --
193: -- bonus? necessary? from fa_cde_pkg:if so we need to add to dpr_out_struct.

Line 199: -- FA_DEPRN_SUMMARY tables

195:
196:
197: -- Usage : Used to store depreciaton info for an asset
198: -- Arguments : Union of all columns in FA_DEPRN_DETAIL and
199: -- FA_DEPRN_SUMMARY tables
200: --
201: TYPE fa_deprn_row_struct IS RECORD (
202: asset_id NUMBER,
203: book VARCHAR2(15),