46: LV_Retirement_Rowid rowid;
47: LV_Created_By fa_mass_retirements.Created_By%TYPE;
48: LV_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
49: LV_Asset_Id fa_additions.asset_id%TYPE;
50: LV_Retirement_Status fa_retirements.status%TYPE;
51: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
52: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
53: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
54: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
47: LV_Created_By fa_mass_retirements.Created_By%TYPE;
48: LV_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
49: LV_Asset_Id fa_additions.asset_id%TYPE;
50: LV_Retirement_Status fa_retirements.status%TYPE;
51: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
52: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
53: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
54: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
55: LV_Units fa_retirements.units%TYPE;
48: LV_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
49: LV_Asset_Id fa_additions.asset_id%TYPE;
50: LV_Retirement_Status fa_retirements.status%TYPE;
51: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
52: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
53: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
54: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
55: LV_Units fa_retirements.units%TYPE;
56: LV_date_effective fa_retirements.date_effective%TYPE;
49: LV_Asset_Id fa_additions.asset_id%TYPE;
50: LV_Retirement_Status fa_retirements.status%TYPE;
51: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
52: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
53: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
54: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
55: LV_Units fa_retirements.units%TYPE;
56: LV_date_effective fa_retirements.date_effective%TYPE;
57: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
50: LV_Retirement_Status fa_retirements.status%TYPE;
51: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
52: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
53: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
54: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
55: LV_Units fa_retirements.units%TYPE;
56: LV_date_effective fa_retirements.date_effective%TYPE;
57: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
58: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
51: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
52: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
53: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
54: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
55: LV_Units fa_retirements.units%TYPE;
56: LV_date_effective fa_retirements.date_effective%TYPE;
57: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
58: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
59: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
52: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
53: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
54: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
55: LV_Units fa_retirements.units%TYPE;
56: LV_date_effective fa_retirements.date_effective%TYPE;
57: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
58: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
59: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
60: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
53: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
54: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
55: LV_Units fa_retirements.units%TYPE;
56: LV_date_effective fa_retirements.date_effective%TYPE;
57: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
58: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
59: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
60: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
61: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
54: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
55: LV_Units fa_retirements.units%TYPE;
56: LV_date_effective fa_retirements.date_effective%TYPE;
57: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
58: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
59: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
60: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
61: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
62: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
55: LV_Units fa_retirements.units%TYPE;
56: LV_date_effective fa_retirements.date_effective%TYPE;
57: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
58: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
59: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
60: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
61: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
62: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
63: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
56: LV_date_effective fa_retirements.date_effective%TYPE;
57: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
58: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
59: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
60: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
61: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
62: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
63: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
64: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
57: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
58: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
59: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
60: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
61: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
62: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
63: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
64: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
65: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
58: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
59: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
60: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
61: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
62: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
63: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
64: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
65: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
66: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
59: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
60: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
61: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
62: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
63: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
64: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
65: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
66: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
67: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
60: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
61: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
62: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
63: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
64: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
65: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
66: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
67: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
68: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
61: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
62: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
63: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
64: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
65: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
66: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
67: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
68: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
69: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
62: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
63: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
64: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
65: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
66: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
67: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
68: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
69: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
70: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;
63: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
64: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
65: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
66: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
67: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
68: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
69: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
70: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;
71:
64: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
65: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
66: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
67: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
68: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
69: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
70: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;
71:
72: LV_Precision NUMBER;
65: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
66: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
67: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
68: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
69: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
70: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;
71:
72: LV_Precision NUMBER;
73: LV_Ext_Precision NUMBER;
66: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
67: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
68: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
69: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
70: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;
71:
72: LV_Precision NUMBER;
73: LV_Ext_Precision NUMBER;
74: LV_Min_Acct_Unit NUMBER;
123: ret.reval_reserve_retired,
124: ret.unrevalued_cost_retired,
125: ret.book_type_code,
126: ihrd.current_cost
127: FROM fa_retirements ret,
128: fa_hr_retirement_details ihrd
129: WHERE ihrd.batch_id = x_batch_num
130: AND ret.retirement_id = ihrd.retirement_id
131: AND ret.transaction_header_id_out IS NULL