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_CUA_HR_REINSTATEMENTS_PKG dependencies on FA_RETIREMENTS

Line 52: LV_Retirement_Status fa_retirements.status%TYPE;

48: LV_Retirement_Rowid rowid;
49: LV_Created_By fa_mass_retirements.Created_By%TYPE;
50: LV_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
51: LV_Asset_Id fa_additions.asset_id%TYPE;
52: LV_Retirement_Status fa_retirements.status%TYPE;
53: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
54: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
55: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
56: LV_Cost_Retired fa_retirements.cost_retired%TYPE;

Line 53: LV_Retirement_Id fa_retirements.retirement_id%TYPE;

49: LV_Created_By fa_mass_retirements.Created_By%TYPE;
50: LV_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
51: LV_Asset_Id fa_additions.asset_id%TYPE;
52: LV_Retirement_Status fa_retirements.status%TYPE;
53: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
54: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
55: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
56: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
57: LV_Units fa_retirements.units%TYPE;

Line 54: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;

50: LV_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
51: LV_Asset_Id fa_additions.asset_id%TYPE;
52: LV_Retirement_Status fa_retirements.status%TYPE;
53: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
54: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
55: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
56: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
57: LV_Units fa_retirements.units%TYPE;
58: LV_date_effective fa_retirements.date_effective%TYPE;

Line 55: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;

51: LV_Asset_Id fa_additions.asset_id%TYPE;
52: LV_Retirement_Status fa_retirements.status%TYPE;
53: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
54: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
55: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
56: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
57: LV_Units fa_retirements.units%TYPE;
58: LV_date_effective fa_retirements.date_effective%TYPE;
59: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;

Line 56: LV_Cost_Retired fa_retirements.cost_retired%TYPE;

52: LV_Retirement_Status fa_retirements.status%TYPE;
53: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
54: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
55: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
56: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
57: LV_Units fa_retirements.units%TYPE;
58: LV_date_effective fa_retirements.date_effective%TYPE;
59: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
60: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;

Line 57: LV_Units fa_retirements.units%TYPE;

53: LV_Retirement_Id fa_retirements.retirement_id%TYPE;
54: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
55: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
56: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
57: LV_Units fa_retirements.units%TYPE;
58: LV_date_effective fa_retirements.date_effective%TYPE;
59: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
60: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
61: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;

Line 58: LV_date_effective fa_retirements.date_effective%TYPE;

54: LV_Transaction_Header_In fa_retirements.transaction_header_id_in%TYPE;
55: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
56: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
57: LV_Units fa_retirements.units%TYPE;
58: LV_date_effective fa_retirements.date_effective%TYPE;
59: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
60: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
61: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
62: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;

Line 59: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;

55: LV_Transaction_Header_out fa_retirements.transaction_header_id_out%TYPE;
56: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
57: LV_Units fa_retirements.units%TYPE;
58: LV_date_effective fa_retirements.date_effective%TYPE;
59: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
60: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
61: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
62: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
63: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;

Line 60: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;

56: LV_Cost_Retired fa_retirements.cost_retired%TYPE;
57: LV_Units fa_retirements.units%TYPE;
58: LV_date_effective fa_retirements.date_effective%TYPE;
59: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
60: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
61: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
62: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
63: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
64: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;

Line 61: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;

57: LV_Units fa_retirements.units%TYPE;
58: LV_date_effective fa_retirements.date_effective%TYPE;
59: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
60: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
61: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
62: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
63: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
64: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
65: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;

Line 62: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;

58: LV_date_effective fa_retirements.date_effective%TYPE;
59: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
60: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
61: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
62: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
63: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
64: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
65: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
66: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;

Line 63: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;

59: LV_Ret_Prorate_Convention fa_retirements.retirement_prorate_convention%TYPE;
60: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
61: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
62: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
63: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
64: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
65: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
66: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
67: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;

Line 64: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;

60: LV_Nbv_Retired fa_retirements.nbv_retired%TYPE;
61: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
62: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
63: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
64: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
65: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
66: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
67: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
68: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;

Line 65: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;

61: LV_Gain_Loss_Amount fa_retirements.gain_loss_amount%TYPE;
62: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
63: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
64: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
65: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
66: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
67: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
68: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
69: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;

Line 66: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;

62: LV_Proceeds_Of_Sale fa_retirements.proceeds_of_sale%TYPE;
63: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
64: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
65: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
66: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
67: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
68: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
69: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
70: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;

Line 67: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;

63: LV_Cost_Of_Removal fa_retirements.cost_of_removal%TYPE;
64: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
65: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
66: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
67: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
68: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
69: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
70: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
71: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;

Line 68: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;

64: LV_Gain_Loss_Type_Code fa_retirements.gain_loss_type_code%TYPE;
65: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
66: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
67: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
68: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
69: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
70: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
71: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
72: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;

Line 69: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;

65: LV_Retirement_Type_Code fa_retirements.retirement_type_code%TYPE;
66: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
67: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
68: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
69: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
70: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
71: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
72: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;
73:

Line 70: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;

66: LV_Itc_Recaptured fa_retirements.itc_recaptured%TYPE;
67: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
68: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
69: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
70: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
71: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
72: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;
73:
74: LV_Precision NUMBER;

Line 71: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;

67: LV_Itc_Recapture_Id fa_retirements.itc_recapture_id%TYPE;
68: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
69: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
70: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
71: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
72: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;
73:
74: LV_Precision NUMBER;
75: LV_Ext_Precision NUMBER;

Line 72: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;

68: LV_Stl_Method_Code fa_retirements.stl_method_code%TYPE;
69: LV_Stl_Life_In_Months fa_retirements.stl_life_in_months%TYPE;
70: LV_Stl_Deprn_Amount fa_retirements.stl_deprn_amount%TYPE;
71: LV_Reval_Reserve_Retired fa_retirements.reval_reserve_retired%TYPE;
72: LV_Unrevalued_Cost_Retired fa_retirements.unrevalued_cost_retired%TYPE;
73:
74: LV_Precision NUMBER;
75: LV_Ext_Precision NUMBER;
76: LV_Min_Acct_Unit NUMBER;

Line 129: FROM fa_retirements ret,

125: ret.reval_reserve_retired,
126: ret.unrevalued_cost_retired,
127: ret.book_type_code,
128: ihrd.current_cost
129: FROM fa_retirements ret,
130: fa_hr_retirement_details ihrd
131: WHERE ihrd.batch_id = x_batch_num
132: AND ret.retirement_id = ihrd.retirement_id
133: AND ret.transaction_header_id_out IS NULL