3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: -- Global Variables holding Mass Retirements Information
7: G_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
8: G_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
9: G_Retire_Subcomponents fa_mass_retirements.Retire_Subcomponents_Flag%TYPE;
10: G_Status fa_mass_retirements.Status%TYPE;
11: G_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: -- Global Variables holding Mass Retirements Information
7: G_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
8: G_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
9: G_Retire_Subcomponents fa_mass_retirements.Retire_Subcomponents_Flag%TYPE;
10: G_Status fa_mass_retirements.Status%TYPE;
11: G_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
12: G_Retirement_Date fa_mass_retirements.Retirement_Date%TYPE;
5:
6: -- Global Variables holding Mass Retirements Information
7: G_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
8: G_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
9: G_Retire_Subcomponents fa_mass_retirements.Retire_Subcomponents_Flag%TYPE;
10: G_Status fa_mass_retirements.Status%TYPE;
11: G_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
12: G_Retirement_Date fa_mass_retirements.Retirement_Date%TYPE;
13: G_Proceeds_Of_Sale fa_mass_retirements.Proceeds_Of_Sale%TYPE;
6: -- Global Variables holding Mass Retirements Information
7: G_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
8: G_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
9: G_Retire_Subcomponents fa_mass_retirements.Retire_Subcomponents_Flag%TYPE;
10: G_Status fa_mass_retirements.Status%TYPE;
11: G_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
12: G_Retirement_Date fa_mass_retirements.Retirement_Date%TYPE;
13: G_Proceeds_Of_Sale fa_mass_retirements.Proceeds_Of_Sale%TYPE;
14: G_Cost_Of_Removal fa_mass_retirements.Cost_Of_Removal%TYPE;
7: G_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
8: G_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
9: G_Retire_Subcomponents fa_mass_retirements.Retire_Subcomponents_Flag%TYPE;
10: G_Status fa_mass_retirements.Status%TYPE;
11: G_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
12: G_Retirement_Date fa_mass_retirements.Retirement_Date%TYPE;
13: G_Proceeds_Of_Sale fa_mass_retirements.Proceeds_Of_Sale%TYPE;
14: G_Cost_Of_Removal fa_mass_retirements.Cost_Of_Removal%TYPE;
15: G_Transaction_Name fa_mass_retirements.Description%TYPE;
8: G_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
9: G_Retire_Subcomponents fa_mass_retirements.Retire_Subcomponents_Flag%TYPE;
10: G_Status fa_mass_retirements.Status%TYPE;
11: G_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
12: G_Retirement_Date fa_mass_retirements.Retirement_Date%TYPE;
13: G_Proceeds_Of_Sale fa_mass_retirements.Proceeds_Of_Sale%TYPE;
14: G_Cost_Of_Removal fa_mass_retirements.Cost_Of_Removal%TYPE;
15: G_Transaction_Name fa_mass_retirements.Description%TYPE;
16: G_Retirement_Type_Code fa_mass_retirements.Retirement_Type_Code%TYPE;
9: G_Retire_Subcomponents fa_mass_retirements.Retire_Subcomponents_Flag%TYPE;
10: G_Status fa_mass_retirements.Status%TYPE;
11: G_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
12: G_Retirement_Date fa_mass_retirements.Retirement_Date%TYPE;
13: G_Proceeds_Of_Sale fa_mass_retirements.Proceeds_Of_Sale%TYPE;
14: G_Cost_Of_Removal fa_mass_retirements.Cost_Of_Removal%TYPE;
15: G_Transaction_Name fa_mass_retirements.Description%TYPE;
16: G_Retirement_Type_Code fa_mass_retirements.Retirement_Type_Code%TYPE;
17: G_Asset_Type fa_mass_retirements.Asset_Type%TYPE;
10: G_Status fa_mass_retirements.Status%TYPE;
11: G_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
12: G_Retirement_Date fa_mass_retirements.Retirement_Date%TYPE;
13: G_Proceeds_Of_Sale fa_mass_retirements.Proceeds_Of_Sale%TYPE;
14: G_Cost_Of_Removal fa_mass_retirements.Cost_Of_Removal%TYPE;
15: G_Transaction_Name fa_mass_retirements.Description%TYPE;
16: G_Retirement_Type_Code fa_mass_retirements.Retirement_Type_Code%TYPE;
17: G_Asset_Type fa_mass_retirements.Asset_Type%TYPE;
18: G_Location_Id fa_mass_retirements.Location_Id%TYPE;
11: G_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
12: G_Retirement_Date fa_mass_retirements.Retirement_Date%TYPE;
13: G_Proceeds_Of_Sale fa_mass_retirements.Proceeds_Of_Sale%TYPE;
14: G_Cost_Of_Removal fa_mass_retirements.Cost_Of_Removal%TYPE;
15: G_Transaction_Name fa_mass_retirements.Description%TYPE;
16: G_Retirement_Type_Code fa_mass_retirements.Retirement_Type_Code%TYPE;
17: G_Asset_Type fa_mass_retirements.Asset_Type%TYPE;
18: G_Location_Id fa_mass_retirements.Location_Id%TYPE;
19: G_Employee_Id fa_mass_retirements.Employee_Id%TYPE;
12: G_Retirement_Date fa_mass_retirements.Retirement_Date%TYPE;
13: G_Proceeds_Of_Sale fa_mass_retirements.Proceeds_Of_Sale%TYPE;
14: G_Cost_Of_Removal fa_mass_retirements.Cost_Of_Removal%TYPE;
15: G_Transaction_Name fa_mass_retirements.Description%TYPE;
16: G_Retirement_Type_Code fa_mass_retirements.Retirement_Type_Code%TYPE;
17: G_Asset_Type fa_mass_retirements.Asset_Type%TYPE;
18: G_Location_Id fa_mass_retirements.Location_Id%TYPE;
19: G_Employee_Id fa_mass_retirements.Employee_Id%TYPE;
20: G_Category_Id fa_mass_retirements.Category_Id%TYPE;
13: G_Proceeds_Of_Sale fa_mass_retirements.Proceeds_Of_Sale%TYPE;
14: G_Cost_Of_Removal fa_mass_retirements.Cost_Of_Removal%TYPE;
15: G_Transaction_Name fa_mass_retirements.Description%TYPE;
16: G_Retirement_Type_Code fa_mass_retirements.Retirement_Type_Code%TYPE;
17: G_Asset_Type fa_mass_retirements.Asset_Type%TYPE;
18: G_Location_Id fa_mass_retirements.Location_Id%TYPE;
19: G_Employee_Id fa_mass_retirements.Employee_Id%TYPE;
20: G_Category_Id fa_mass_retirements.Category_Id%TYPE;
21: G_Asset_Key_Id fa_mass_retirements.Asset_Key_Id%TYPE;
14: G_Cost_Of_Removal fa_mass_retirements.Cost_Of_Removal%TYPE;
15: G_Transaction_Name fa_mass_retirements.Description%TYPE;
16: G_Retirement_Type_Code fa_mass_retirements.Retirement_Type_Code%TYPE;
17: G_Asset_Type fa_mass_retirements.Asset_Type%TYPE;
18: G_Location_Id fa_mass_retirements.Location_Id%TYPE;
19: G_Employee_Id fa_mass_retirements.Employee_Id%TYPE;
20: G_Category_Id fa_mass_retirements.Category_Id%TYPE;
21: G_Asset_Key_Id fa_mass_retirements.Asset_Key_Id%TYPE;
22: G_From_Asset_Number fa_mass_retirements.From_Asset_Number%TYPE;
15: G_Transaction_Name fa_mass_retirements.Description%TYPE;
16: G_Retirement_Type_Code fa_mass_retirements.Retirement_Type_Code%TYPE;
17: G_Asset_Type fa_mass_retirements.Asset_Type%TYPE;
18: G_Location_Id fa_mass_retirements.Location_Id%TYPE;
19: G_Employee_Id fa_mass_retirements.Employee_Id%TYPE;
20: G_Category_Id fa_mass_retirements.Category_Id%TYPE;
21: G_Asset_Key_Id fa_mass_retirements.Asset_Key_Id%TYPE;
22: G_From_Asset_Number fa_mass_retirements.From_Asset_Number%TYPE;
23: G_To_Asset_Number fa_mass_retirements.To_Asset_Number%TYPE;
16: G_Retirement_Type_Code fa_mass_retirements.Retirement_Type_Code%TYPE;
17: G_Asset_Type fa_mass_retirements.Asset_Type%TYPE;
18: G_Location_Id fa_mass_retirements.Location_Id%TYPE;
19: G_Employee_Id fa_mass_retirements.Employee_Id%TYPE;
20: G_Category_Id fa_mass_retirements.Category_Id%TYPE;
21: G_Asset_Key_Id fa_mass_retirements.Asset_Key_Id%TYPE;
22: G_From_Asset_Number fa_mass_retirements.From_Asset_Number%TYPE;
23: G_To_Asset_Number fa_mass_retirements.To_Asset_Number%TYPE;
24: G_From_DPIS fa_mass_retirements.From_Date_Placed_In_Service%TYPE;
17: G_Asset_Type fa_mass_retirements.Asset_Type%TYPE;
18: G_Location_Id fa_mass_retirements.Location_Id%TYPE;
19: G_Employee_Id fa_mass_retirements.Employee_Id%TYPE;
20: G_Category_Id fa_mass_retirements.Category_Id%TYPE;
21: G_Asset_Key_Id fa_mass_retirements.Asset_Key_Id%TYPE;
22: G_From_Asset_Number fa_mass_retirements.From_Asset_Number%TYPE;
23: G_To_Asset_Number fa_mass_retirements.To_Asset_Number%TYPE;
24: G_From_DPIS fa_mass_retirements.From_Date_Placed_In_Service%TYPE;
25: G_To_DPIS fa_mass_retirements.To_Date_Placed_In_Service%TYPE;
18: G_Location_Id fa_mass_retirements.Location_Id%TYPE;
19: G_Employee_Id fa_mass_retirements.Employee_Id%TYPE;
20: G_Category_Id fa_mass_retirements.Category_Id%TYPE;
21: G_Asset_Key_Id fa_mass_retirements.Asset_Key_Id%TYPE;
22: G_From_Asset_Number fa_mass_retirements.From_Asset_Number%TYPE;
23: G_To_Asset_Number fa_mass_retirements.To_Asset_Number%TYPE;
24: G_From_DPIS fa_mass_retirements.From_Date_Placed_In_Service%TYPE;
25: G_To_DPIS fa_mass_retirements.To_Date_Placed_In_Service%TYPE;
26: G_Created_By fa_mass_retirements.Created_By%TYPE;
19: G_Employee_Id fa_mass_retirements.Employee_Id%TYPE;
20: G_Category_Id fa_mass_retirements.Category_Id%TYPE;
21: G_Asset_Key_Id fa_mass_retirements.Asset_Key_Id%TYPE;
22: G_From_Asset_Number fa_mass_retirements.From_Asset_Number%TYPE;
23: G_To_Asset_Number fa_mass_retirements.To_Asset_Number%TYPE;
24: G_From_DPIS fa_mass_retirements.From_Date_Placed_In_Service%TYPE;
25: G_To_DPIS fa_mass_retirements.To_Date_Placed_In_Service%TYPE;
26: G_Created_By fa_mass_retirements.Created_By%TYPE;
27: -- G_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
20: G_Category_Id fa_mass_retirements.Category_Id%TYPE;
21: G_Asset_Key_Id fa_mass_retirements.Asset_Key_Id%TYPE;
22: G_From_Asset_Number fa_mass_retirements.From_Asset_Number%TYPE;
23: G_To_Asset_Number fa_mass_retirements.To_Asset_Number%TYPE;
24: G_From_DPIS fa_mass_retirements.From_Date_Placed_In_Service%TYPE;
25: G_To_DPIS fa_mass_retirements.To_Date_Placed_In_Service%TYPE;
26: G_Created_By fa_mass_retirements.Created_By%TYPE;
27: -- G_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
28: G_From_Cost fa_mass_retirements.from_cost%TYPE;
21: G_Asset_Key_Id fa_mass_retirements.Asset_Key_Id%TYPE;
22: G_From_Asset_Number fa_mass_retirements.From_Asset_Number%TYPE;
23: G_To_Asset_Number fa_mass_retirements.To_Asset_Number%TYPE;
24: G_From_DPIS fa_mass_retirements.From_Date_Placed_In_Service%TYPE;
25: G_To_DPIS fa_mass_retirements.To_Date_Placed_In_Service%TYPE;
26: G_Created_By fa_mass_retirements.Created_By%TYPE;
27: -- G_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
28: G_From_Cost fa_mass_retirements.from_cost%TYPE;
29: G_To_Cost fa_mass_retirements.to_cost%TYPE;
22: G_From_Asset_Number fa_mass_retirements.From_Asset_Number%TYPE;
23: G_To_Asset_Number fa_mass_retirements.To_Asset_Number%TYPE;
24: G_From_DPIS fa_mass_retirements.From_Date_Placed_In_Service%TYPE;
25: G_To_DPIS fa_mass_retirements.To_Date_Placed_In_Service%TYPE;
26: G_Created_By fa_mass_retirements.Created_By%TYPE;
27: -- G_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
28: G_From_Cost fa_mass_retirements.from_cost%TYPE;
29: G_To_Cost fa_mass_retirements.to_cost%TYPE;
30: G_Fully_Rsvd_Flag fa_mass_retirements.include_fully_rsvd_flag%TYPE;
23: G_To_Asset_Number fa_mass_retirements.To_Asset_Number%TYPE;
24: G_From_DPIS fa_mass_retirements.From_Date_Placed_In_Service%TYPE;
25: G_To_DPIS fa_mass_retirements.To_Date_Placed_In_Service%TYPE;
26: G_Created_By fa_mass_retirements.Created_By%TYPE;
27: -- G_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
28: G_From_Cost fa_mass_retirements.from_cost%TYPE;
29: G_To_Cost fa_mass_retirements.to_cost%TYPE;
30: G_Fully_Rsvd_Flag fa_mass_retirements.include_fully_rsvd_flag%TYPE;
31: G_model_number fa_mass_retirements.model_number%TYPE;
24: G_From_DPIS fa_mass_retirements.From_Date_Placed_In_Service%TYPE;
25: G_To_DPIS fa_mass_retirements.To_Date_Placed_In_Service%TYPE;
26: G_Created_By fa_mass_retirements.Created_By%TYPE;
27: -- G_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
28: G_From_Cost fa_mass_retirements.from_cost%TYPE;
29: G_To_Cost fa_mass_retirements.to_cost%TYPE;
30: G_Fully_Rsvd_Flag fa_mass_retirements.include_fully_rsvd_flag%TYPE;
31: G_model_number fa_mass_retirements.model_number%TYPE;
32: G_serial_number fa_mass_retirements.serial_number%TYPE;
25: G_To_DPIS fa_mass_retirements.To_Date_Placed_In_Service%TYPE;
26: G_Created_By fa_mass_retirements.Created_By%TYPE;
27: -- G_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
28: G_From_Cost fa_mass_retirements.from_cost%TYPE;
29: G_To_Cost fa_mass_retirements.to_cost%TYPE;
30: G_Fully_Rsvd_Flag fa_mass_retirements.include_fully_rsvd_flag%TYPE;
31: G_model_number fa_mass_retirements.model_number%TYPE;
32: G_serial_number fa_mass_retirements.serial_number%TYPE;
33: G_tag_number fa_mass_retirements.tag_number%TYPE;
26: G_Created_By fa_mass_retirements.Created_By%TYPE;
27: -- G_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
28: G_From_Cost fa_mass_retirements.from_cost%TYPE;
29: G_To_Cost fa_mass_retirements.to_cost%TYPE;
30: G_Fully_Rsvd_Flag fa_mass_retirements.include_fully_rsvd_flag%TYPE;
31: G_model_number fa_mass_retirements.model_number%TYPE;
32: G_serial_number fa_mass_retirements.serial_number%TYPE;
33: G_tag_number fa_mass_retirements.tag_number%TYPE;
34: G_manufacturer_name fa_mass_retirements.manufacturer_name%TYPE;
27: -- G_Last_Update_Login fa_mass_retirements.Last_Update_Login%TYPE;
28: G_From_Cost fa_mass_retirements.from_cost%TYPE;
29: G_To_Cost fa_mass_retirements.to_cost%TYPE;
30: G_Fully_Rsvd_Flag fa_mass_retirements.include_fully_rsvd_flag%TYPE;
31: G_model_number fa_mass_retirements.model_number%TYPE;
32: G_serial_number fa_mass_retirements.serial_number%TYPE;
33: G_tag_number fa_mass_retirements.tag_number%TYPE;
34: G_manufacturer_name fa_mass_retirements.manufacturer_name%TYPE;
35: G_units fa_mass_retirements.units_to_retire%TYPE;
28: G_From_Cost fa_mass_retirements.from_cost%TYPE;
29: G_To_Cost fa_mass_retirements.to_cost%TYPE;
30: G_Fully_Rsvd_Flag fa_mass_retirements.include_fully_rsvd_flag%TYPE;
31: G_model_number fa_mass_retirements.model_number%TYPE;
32: G_serial_number fa_mass_retirements.serial_number%TYPE;
33: G_tag_number fa_mass_retirements.tag_number%TYPE;
34: G_manufacturer_name fa_mass_retirements.manufacturer_name%TYPE;
35: G_units fa_mass_retirements.units_to_retire%TYPE;
36: G_Attribute1 fa_mass_retirements.attribute1%TYPE;
29: G_To_Cost fa_mass_retirements.to_cost%TYPE;
30: G_Fully_Rsvd_Flag fa_mass_retirements.include_fully_rsvd_flag%TYPE;
31: G_model_number fa_mass_retirements.model_number%TYPE;
32: G_serial_number fa_mass_retirements.serial_number%TYPE;
33: G_tag_number fa_mass_retirements.tag_number%TYPE;
34: G_manufacturer_name fa_mass_retirements.manufacturer_name%TYPE;
35: G_units fa_mass_retirements.units_to_retire%TYPE;
36: G_Attribute1 fa_mass_retirements.attribute1%TYPE;
37: G_Attribute2 fa_mass_retirements.attribute2%TYPE;
30: G_Fully_Rsvd_Flag fa_mass_retirements.include_fully_rsvd_flag%TYPE;
31: G_model_number fa_mass_retirements.model_number%TYPE;
32: G_serial_number fa_mass_retirements.serial_number%TYPE;
33: G_tag_number fa_mass_retirements.tag_number%TYPE;
34: G_manufacturer_name fa_mass_retirements.manufacturer_name%TYPE;
35: G_units fa_mass_retirements.units_to_retire%TYPE;
36: G_Attribute1 fa_mass_retirements.attribute1%TYPE;
37: G_Attribute2 fa_mass_retirements.attribute2%TYPE;
38: G_Attribute3 fa_mass_retirements.attribute3%TYPE;
31: G_model_number fa_mass_retirements.model_number%TYPE;
32: G_serial_number fa_mass_retirements.serial_number%TYPE;
33: G_tag_number fa_mass_retirements.tag_number%TYPE;
34: G_manufacturer_name fa_mass_retirements.manufacturer_name%TYPE;
35: G_units fa_mass_retirements.units_to_retire%TYPE;
36: G_Attribute1 fa_mass_retirements.attribute1%TYPE;
37: G_Attribute2 fa_mass_retirements.attribute2%TYPE;
38: G_Attribute3 fa_mass_retirements.attribute3%TYPE;
39: G_Attribute4 fa_mass_retirements.attribute4%TYPE;
32: G_serial_number fa_mass_retirements.serial_number%TYPE;
33: G_tag_number fa_mass_retirements.tag_number%TYPE;
34: G_manufacturer_name fa_mass_retirements.manufacturer_name%TYPE;
35: G_units fa_mass_retirements.units_to_retire%TYPE;
36: G_Attribute1 fa_mass_retirements.attribute1%TYPE;
37: G_Attribute2 fa_mass_retirements.attribute2%TYPE;
38: G_Attribute3 fa_mass_retirements.attribute3%TYPE;
39: G_Attribute4 fa_mass_retirements.attribute4%TYPE;
40: G_Attribute5 fa_mass_retirements.attribute5%TYPE;
33: G_tag_number fa_mass_retirements.tag_number%TYPE;
34: G_manufacturer_name fa_mass_retirements.manufacturer_name%TYPE;
35: G_units fa_mass_retirements.units_to_retire%TYPE;
36: G_Attribute1 fa_mass_retirements.attribute1%TYPE;
37: G_Attribute2 fa_mass_retirements.attribute2%TYPE;
38: G_Attribute3 fa_mass_retirements.attribute3%TYPE;
39: G_Attribute4 fa_mass_retirements.attribute4%TYPE;
40: G_Attribute5 fa_mass_retirements.attribute5%TYPE;
41: G_Attribute6 fa_mass_retirements.attribute6%TYPE;
34: G_manufacturer_name fa_mass_retirements.manufacturer_name%TYPE;
35: G_units fa_mass_retirements.units_to_retire%TYPE;
36: G_Attribute1 fa_mass_retirements.attribute1%TYPE;
37: G_Attribute2 fa_mass_retirements.attribute2%TYPE;
38: G_Attribute3 fa_mass_retirements.attribute3%TYPE;
39: G_Attribute4 fa_mass_retirements.attribute4%TYPE;
40: G_Attribute5 fa_mass_retirements.attribute5%TYPE;
41: G_Attribute6 fa_mass_retirements.attribute6%TYPE;
42: G_Attribute7 fa_mass_retirements.attribute7%TYPE;
35: G_units fa_mass_retirements.units_to_retire%TYPE;
36: G_Attribute1 fa_mass_retirements.attribute1%TYPE;
37: G_Attribute2 fa_mass_retirements.attribute2%TYPE;
38: G_Attribute3 fa_mass_retirements.attribute3%TYPE;
39: G_Attribute4 fa_mass_retirements.attribute4%TYPE;
40: G_Attribute5 fa_mass_retirements.attribute5%TYPE;
41: G_Attribute6 fa_mass_retirements.attribute6%TYPE;
42: G_Attribute7 fa_mass_retirements.attribute7%TYPE;
43: G_Attribute8 fa_mass_retirements.attribute8%TYPE;
36: G_Attribute1 fa_mass_retirements.attribute1%TYPE;
37: G_Attribute2 fa_mass_retirements.attribute2%TYPE;
38: G_Attribute3 fa_mass_retirements.attribute3%TYPE;
39: G_Attribute4 fa_mass_retirements.attribute4%TYPE;
40: G_Attribute5 fa_mass_retirements.attribute5%TYPE;
41: G_Attribute6 fa_mass_retirements.attribute6%TYPE;
42: G_Attribute7 fa_mass_retirements.attribute7%TYPE;
43: G_Attribute8 fa_mass_retirements.attribute8%TYPE;
44: G_Attribute9 fa_mass_retirements.attribute9%TYPE;
37: G_Attribute2 fa_mass_retirements.attribute2%TYPE;
38: G_Attribute3 fa_mass_retirements.attribute3%TYPE;
39: G_Attribute4 fa_mass_retirements.attribute4%TYPE;
40: G_Attribute5 fa_mass_retirements.attribute5%TYPE;
41: G_Attribute6 fa_mass_retirements.attribute6%TYPE;
42: G_Attribute7 fa_mass_retirements.attribute7%TYPE;
43: G_Attribute8 fa_mass_retirements.attribute8%TYPE;
44: G_Attribute9 fa_mass_retirements.attribute9%TYPE;
45: G_Attribute10 fa_mass_retirements.attribute10%TYPE;
38: G_Attribute3 fa_mass_retirements.attribute3%TYPE;
39: G_Attribute4 fa_mass_retirements.attribute4%TYPE;
40: G_Attribute5 fa_mass_retirements.attribute5%TYPE;
41: G_Attribute6 fa_mass_retirements.attribute6%TYPE;
42: G_Attribute7 fa_mass_retirements.attribute7%TYPE;
43: G_Attribute8 fa_mass_retirements.attribute8%TYPE;
44: G_Attribute9 fa_mass_retirements.attribute9%TYPE;
45: G_Attribute10 fa_mass_retirements.attribute10%TYPE;
46: G_Attribute11 fa_mass_retirements.attribute11%TYPE;
39: G_Attribute4 fa_mass_retirements.attribute4%TYPE;
40: G_Attribute5 fa_mass_retirements.attribute5%TYPE;
41: G_Attribute6 fa_mass_retirements.attribute6%TYPE;
42: G_Attribute7 fa_mass_retirements.attribute7%TYPE;
43: G_Attribute8 fa_mass_retirements.attribute8%TYPE;
44: G_Attribute9 fa_mass_retirements.attribute9%TYPE;
45: G_Attribute10 fa_mass_retirements.attribute10%TYPE;
46: G_Attribute11 fa_mass_retirements.attribute11%TYPE;
47: G_Attribute12 fa_mass_retirements.attribute12%TYPE;
40: G_Attribute5 fa_mass_retirements.attribute5%TYPE;
41: G_Attribute6 fa_mass_retirements.attribute6%TYPE;
42: G_Attribute7 fa_mass_retirements.attribute7%TYPE;
43: G_Attribute8 fa_mass_retirements.attribute8%TYPE;
44: G_Attribute9 fa_mass_retirements.attribute9%TYPE;
45: G_Attribute10 fa_mass_retirements.attribute10%TYPE;
46: G_Attribute11 fa_mass_retirements.attribute11%TYPE;
47: G_Attribute12 fa_mass_retirements.attribute12%TYPE;
48: G_Attribute13 fa_mass_retirements.attribute13%TYPE;
41: G_Attribute6 fa_mass_retirements.attribute6%TYPE;
42: G_Attribute7 fa_mass_retirements.attribute7%TYPE;
43: G_Attribute8 fa_mass_retirements.attribute8%TYPE;
44: G_Attribute9 fa_mass_retirements.attribute9%TYPE;
45: G_Attribute10 fa_mass_retirements.attribute10%TYPE;
46: G_Attribute11 fa_mass_retirements.attribute11%TYPE;
47: G_Attribute12 fa_mass_retirements.attribute12%TYPE;
48: G_Attribute13 fa_mass_retirements.attribute13%TYPE;
49: G_Attribute14 fa_mass_retirements.attribute14%TYPE;
42: G_Attribute7 fa_mass_retirements.attribute7%TYPE;
43: G_Attribute8 fa_mass_retirements.attribute8%TYPE;
44: G_Attribute9 fa_mass_retirements.attribute9%TYPE;
45: G_Attribute10 fa_mass_retirements.attribute10%TYPE;
46: G_Attribute11 fa_mass_retirements.attribute11%TYPE;
47: G_Attribute12 fa_mass_retirements.attribute12%TYPE;
48: G_Attribute13 fa_mass_retirements.attribute13%TYPE;
49: G_Attribute14 fa_mass_retirements.attribute14%TYPE;
50: G_Attribute15 fa_mass_retirements.attribute15%TYPE;
43: G_Attribute8 fa_mass_retirements.attribute8%TYPE;
44: G_Attribute9 fa_mass_retirements.attribute9%TYPE;
45: G_Attribute10 fa_mass_retirements.attribute10%TYPE;
46: G_Attribute11 fa_mass_retirements.attribute11%TYPE;
47: G_Attribute12 fa_mass_retirements.attribute12%TYPE;
48: G_Attribute13 fa_mass_retirements.attribute13%TYPE;
49: G_Attribute14 fa_mass_retirements.attribute14%TYPE;
50: G_Attribute15 fa_mass_retirements.attribute15%TYPE;
51: G_Attribute_category_code fa_mass_retirements.attribute_category_code%TYPE;
44: G_Attribute9 fa_mass_retirements.attribute9%TYPE;
45: G_Attribute10 fa_mass_retirements.attribute10%TYPE;
46: G_Attribute11 fa_mass_retirements.attribute11%TYPE;
47: G_Attribute12 fa_mass_retirements.attribute12%TYPE;
48: G_Attribute13 fa_mass_retirements.attribute13%TYPE;
49: G_Attribute14 fa_mass_retirements.attribute14%TYPE;
50: G_Attribute15 fa_mass_retirements.attribute15%TYPE;
51: G_Attribute_category_code fa_mass_retirements.attribute_category_code%TYPE;
52: G_Segment1_Low fa_mass_retirements.segment1_low%TYPE;
45: G_Attribute10 fa_mass_retirements.attribute10%TYPE;
46: G_Attribute11 fa_mass_retirements.attribute11%TYPE;
47: G_Attribute12 fa_mass_retirements.attribute12%TYPE;
48: G_Attribute13 fa_mass_retirements.attribute13%TYPE;
49: G_Attribute14 fa_mass_retirements.attribute14%TYPE;
50: G_Attribute15 fa_mass_retirements.attribute15%TYPE;
51: G_Attribute_category_code fa_mass_retirements.attribute_category_code%TYPE;
52: G_Segment1_Low fa_mass_retirements.segment1_low%TYPE;
53: G_Segment2_Low fa_mass_retirements.segment2_low%TYPE;
46: G_Attribute11 fa_mass_retirements.attribute11%TYPE;
47: G_Attribute12 fa_mass_retirements.attribute12%TYPE;
48: G_Attribute13 fa_mass_retirements.attribute13%TYPE;
49: G_Attribute14 fa_mass_retirements.attribute14%TYPE;
50: G_Attribute15 fa_mass_retirements.attribute15%TYPE;
51: G_Attribute_category_code fa_mass_retirements.attribute_category_code%TYPE;
52: G_Segment1_Low fa_mass_retirements.segment1_low%TYPE;
53: G_Segment2_Low fa_mass_retirements.segment2_low%TYPE;
54: G_Segment3_Low fa_mass_retirements.segment3_low%TYPE;
47: G_Attribute12 fa_mass_retirements.attribute12%TYPE;
48: G_Attribute13 fa_mass_retirements.attribute13%TYPE;
49: G_Attribute14 fa_mass_retirements.attribute14%TYPE;
50: G_Attribute15 fa_mass_retirements.attribute15%TYPE;
51: G_Attribute_category_code fa_mass_retirements.attribute_category_code%TYPE;
52: G_Segment1_Low fa_mass_retirements.segment1_low%TYPE;
53: G_Segment2_Low fa_mass_retirements.segment2_low%TYPE;
54: G_Segment3_Low fa_mass_retirements.segment3_low%TYPE;
55: G_Segment4_Low fa_mass_retirements.segment4_low%TYPE;
48: G_Attribute13 fa_mass_retirements.attribute13%TYPE;
49: G_Attribute14 fa_mass_retirements.attribute14%TYPE;
50: G_Attribute15 fa_mass_retirements.attribute15%TYPE;
51: G_Attribute_category_code fa_mass_retirements.attribute_category_code%TYPE;
52: G_Segment1_Low fa_mass_retirements.segment1_low%TYPE;
53: G_Segment2_Low fa_mass_retirements.segment2_low%TYPE;
54: G_Segment3_Low fa_mass_retirements.segment3_low%TYPE;
55: G_Segment4_Low fa_mass_retirements.segment4_low%TYPE;
56: G_Segment5_Low fa_mass_retirements.segment5_low%TYPE;
49: G_Attribute14 fa_mass_retirements.attribute14%TYPE;
50: G_Attribute15 fa_mass_retirements.attribute15%TYPE;
51: G_Attribute_category_code fa_mass_retirements.attribute_category_code%TYPE;
52: G_Segment1_Low fa_mass_retirements.segment1_low%TYPE;
53: G_Segment2_Low fa_mass_retirements.segment2_low%TYPE;
54: G_Segment3_Low fa_mass_retirements.segment3_low%TYPE;
55: G_Segment4_Low fa_mass_retirements.segment4_low%TYPE;
56: G_Segment5_Low fa_mass_retirements.segment5_low%TYPE;
57: G_Segment6_Low fa_mass_retirements.segment6_low%TYPE;
50: G_Attribute15 fa_mass_retirements.attribute15%TYPE;
51: G_Attribute_category_code fa_mass_retirements.attribute_category_code%TYPE;
52: G_Segment1_Low fa_mass_retirements.segment1_low%TYPE;
53: G_Segment2_Low fa_mass_retirements.segment2_low%TYPE;
54: G_Segment3_Low fa_mass_retirements.segment3_low%TYPE;
55: G_Segment4_Low fa_mass_retirements.segment4_low%TYPE;
56: G_Segment5_Low fa_mass_retirements.segment5_low%TYPE;
57: G_Segment6_Low fa_mass_retirements.segment6_low%TYPE;
58: G_Segment7_Low fa_mass_retirements.segment7_low%TYPE;
51: G_Attribute_category_code fa_mass_retirements.attribute_category_code%TYPE;
52: G_Segment1_Low fa_mass_retirements.segment1_low%TYPE;
53: G_Segment2_Low fa_mass_retirements.segment2_low%TYPE;
54: G_Segment3_Low fa_mass_retirements.segment3_low%TYPE;
55: G_Segment4_Low fa_mass_retirements.segment4_low%TYPE;
56: G_Segment5_Low fa_mass_retirements.segment5_low%TYPE;
57: G_Segment6_Low fa_mass_retirements.segment6_low%TYPE;
58: G_Segment7_Low fa_mass_retirements.segment7_low%TYPE;
59: G_Segment8_Low fa_mass_retirements.segment8_low%TYPE;
52: G_Segment1_Low fa_mass_retirements.segment1_low%TYPE;
53: G_Segment2_Low fa_mass_retirements.segment2_low%TYPE;
54: G_Segment3_Low fa_mass_retirements.segment3_low%TYPE;
55: G_Segment4_Low fa_mass_retirements.segment4_low%TYPE;
56: G_Segment5_Low fa_mass_retirements.segment5_low%TYPE;
57: G_Segment6_Low fa_mass_retirements.segment6_low%TYPE;
58: G_Segment7_Low fa_mass_retirements.segment7_low%TYPE;
59: G_Segment8_Low fa_mass_retirements.segment8_low%TYPE;
60: G_Segment9_Low fa_mass_retirements.segment9_low%TYPE;
53: G_Segment2_Low fa_mass_retirements.segment2_low%TYPE;
54: G_Segment3_Low fa_mass_retirements.segment3_low%TYPE;
55: G_Segment4_Low fa_mass_retirements.segment4_low%TYPE;
56: G_Segment5_Low fa_mass_retirements.segment5_low%TYPE;
57: G_Segment6_Low fa_mass_retirements.segment6_low%TYPE;
58: G_Segment7_Low fa_mass_retirements.segment7_low%TYPE;
59: G_Segment8_Low fa_mass_retirements.segment8_low%TYPE;
60: G_Segment9_Low fa_mass_retirements.segment9_low%TYPE;
61: G_Segment10_Low fa_mass_retirements.segment10_low%TYPE;
54: G_Segment3_Low fa_mass_retirements.segment3_low%TYPE;
55: G_Segment4_Low fa_mass_retirements.segment4_low%TYPE;
56: G_Segment5_Low fa_mass_retirements.segment5_low%TYPE;
57: G_Segment6_Low fa_mass_retirements.segment6_low%TYPE;
58: G_Segment7_Low fa_mass_retirements.segment7_low%TYPE;
59: G_Segment8_Low fa_mass_retirements.segment8_low%TYPE;
60: G_Segment9_Low fa_mass_retirements.segment9_low%TYPE;
61: G_Segment10_Low fa_mass_retirements.segment10_low%TYPE;
62: G_Segment11_Low fa_mass_retirements.segment11_low%TYPE;
55: G_Segment4_Low fa_mass_retirements.segment4_low%TYPE;
56: G_Segment5_Low fa_mass_retirements.segment5_low%TYPE;
57: G_Segment6_Low fa_mass_retirements.segment6_low%TYPE;
58: G_Segment7_Low fa_mass_retirements.segment7_low%TYPE;
59: G_Segment8_Low fa_mass_retirements.segment8_low%TYPE;
60: G_Segment9_Low fa_mass_retirements.segment9_low%TYPE;
61: G_Segment10_Low fa_mass_retirements.segment10_low%TYPE;
62: G_Segment11_Low fa_mass_retirements.segment11_low%TYPE;
63: G_Segment12_Low fa_mass_retirements.segment12_low%TYPE;
56: G_Segment5_Low fa_mass_retirements.segment5_low%TYPE;
57: G_Segment6_Low fa_mass_retirements.segment6_low%TYPE;
58: G_Segment7_Low fa_mass_retirements.segment7_low%TYPE;
59: G_Segment8_Low fa_mass_retirements.segment8_low%TYPE;
60: G_Segment9_Low fa_mass_retirements.segment9_low%TYPE;
61: G_Segment10_Low fa_mass_retirements.segment10_low%TYPE;
62: G_Segment11_Low fa_mass_retirements.segment11_low%TYPE;
63: G_Segment12_Low fa_mass_retirements.segment12_low%TYPE;
64: G_Segment13_Low fa_mass_retirements.segment13_low%TYPE;
57: G_Segment6_Low fa_mass_retirements.segment6_low%TYPE;
58: G_Segment7_Low fa_mass_retirements.segment7_low%TYPE;
59: G_Segment8_Low fa_mass_retirements.segment8_low%TYPE;
60: G_Segment9_Low fa_mass_retirements.segment9_low%TYPE;
61: G_Segment10_Low fa_mass_retirements.segment10_low%TYPE;
62: G_Segment11_Low fa_mass_retirements.segment11_low%TYPE;
63: G_Segment12_Low fa_mass_retirements.segment12_low%TYPE;
64: G_Segment13_Low fa_mass_retirements.segment13_low%TYPE;
65: G_Segment14_Low fa_mass_retirements.segment14_low%TYPE;
58: G_Segment7_Low fa_mass_retirements.segment7_low%TYPE;
59: G_Segment8_Low fa_mass_retirements.segment8_low%TYPE;
60: G_Segment9_Low fa_mass_retirements.segment9_low%TYPE;
61: G_Segment10_Low fa_mass_retirements.segment10_low%TYPE;
62: G_Segment11_Low fa_mass_retirements.segment11_low%TYPE;
63: G_Segment12_Low fa_mass_retirements.segment12_low%TYPE;
64: G_Segment13_Low fa_mass_retirements.segment13_low%TYPE;
65: G_Segment14_Low fa_mass_retirements.segment14_low%TYPE;
66: G_Segment15_Low fa_mass_retirements.segment15_low%TYPE;
59: G_Segment8_Low fa_mass_retirements.segment8_low%TYPE;
60: G_Segment9_Low fa_mass_retirements.segment9_low%TYPE;
61: G_Segment10_Low fa_mass_retirements.segment10_low%TYPE;
62: G_Segment11_Low fa_mass_retirements.segment11_low%TYPE;
63: G_Segment12_Low fa_mass_retirements.segment12_low%TYPE;
64: G_Segment13_Low fa_mass_retirements.segment13_low%TYPE;
65: G_Segment14_Low fa_mass_retirements.segment14_low%TYPE;
66: G_Segment15_Low fa_mass_retirements.segment15_low%TYPE;
67: G_Segment16_Low fa_mass_retirements.segment16_low%TYPE;
60: G_Segment9_Low fa_mass_retirements.segment9_low%TYPE;
61: G_Segment10_Low fa_mass_retirements.segment10_low%TYPE;
62: G_Segment11_Low fa_mass_retirements.segment11_low%TYPE;
63: G_Segment12_Low fa_mass_retirements.segment12_low%TYPE;
64: G_Segment13_Low fa_mass_retirements.segment13_low%TYPE;
65: G_Segment14_Low fa_mass_retirements.segment14_low%TYPE;
66: G_Segment15_Low fa_mass_retirements.segment15_low%TYPE;
67: G_Segment16_Low fa_mass_retirements.segment16_low%TYPE;
68: G_Segment17_Low fa_mass_retirements.segment17_low%TYPE;
61: G_Segment10_Low fa_mass_retirements.segment10_low%TYPE;
62: G_Segment11_Low fa_mass_retirements.segment11_low%TYPE;
63: G_Segment12_Low fa_mass_retirements.segment12_low%TYPE;
64: G_Segment13_Low fa_mass_retirements.segment13_low%TYPE;
65: G_Segment14_Low fa_mass_retirements.segment14_low%TYPE;
66: G_Segment15_Low fa_mass_retirements.segment15_low%TYPE;
67: G_Segment16_Low fa_mass_retirements.segment16_low%TYPE;
68: G_Segment17_Low fa_mass_retirements.segment17_low%TYPE;
69: G_Segment18_Low fa_mass_retirements.segment18_low%TYPE;
62: G_Segment11_Low fa_mass_retirements.segment11_low%TYPE;
63: G_Segment12_Low fa_mass_retirements.segment12_low%TYPE;
64: G_Segment13_Low fa_mass_retirements.segment13_low%TYPE;
65: G_Segment14_Low fa_mass_retirements.segment14_low%TYPE;
66: G_Segment15_Low fa_mass_retirements.segment15_low%TYPE;
67: G_Segment16_Low fa_mass_retirements.segment16_low%TYPE;
68: G_Segment17_Low fa_mass_retirements.segment17_low%TYPE;
69: G_Segment18_Low fa_mass_retirements.segment18_low%TYPE;
70: G_Segment19_Low fa_mass_retirements.segment19_low%TYPE;
63: G_Segment12_Low fa_mass_retirements.segment12_low%TYPE;
64: G_Segment13_Low fa_mass_retirements.segment13_low%TYPE;
65: G_Segment14_Low fa_mass_retirements.segment14_low%TYPE;
66: G_Segment15_Low fa_mass_retirements.segment15_low%TYPE;
67: G_Segment16_Low fa_mass_retirements.segment16_low%TYPE;
68: G_Segment17_Low fa_mass_retirements.segment17_low%TYPE;
69: G_Segment18_Low fa_mass_retirements.segment18_low%TYPE;
70: G_Segment19_Low fa_mass_retirements.segment19_low%TYPE;
71: G_Segment20_Low fa_mass_retirements.segment20_low%TYPE;
64: G_Segment13_Low fa_mass_retirements.segment13_low%TYPE;
65: G_Segment14_Low fa_mass_retirements.segment14_low%TYPE;
66: G_Segment15_Low fa_mass_retirements.segment15_low%TYPE;
67: G_Segment16_Low fa_mass_retirements.segment16_low%TYPE;
68: G_Segment17_Low fa_mass_retirements.segment17_low%TYPE;
69: G_Segment18_Low fa_mass_retirements.segment18_low%TYPE;
70: G_Segment19_Low fa_mass_retirements.segment19_low%TYPE;
71: G_Segment20_Low fa_mass_retirements.segment20_low%TYPE;
72: G_Segment21_Low fa_mass_retirements.segment21_low%TYPE;
65: G_Segment14_Low fa_mass_retirements.segment14_low%TYPE;
66: G_Segment15_Low fa_mass_retirements.segment15_low%TYPE;
67: G_Segment16_Low fa_mass_retirements.segment16_low%TYPE;
68: G_Segment17_Low fa_mass_retirements.segment17_low%TYPE;
69: G_Segment18_Low fa_mass_retirements.segment18_low%TYPE;
70: G_Segment19_Low fa_mass_retirements.segment19_low%TYPE;
71: G_Segment20_Low fa_mass_retirements.segment20_low%TYPE;
72: G_Segment21_Low fa_mass_retirements.segment21_low%TYPE;
73: G_Segment22_Low fa_mass_retirements.segment22_low%TYPE;
66: G_Segment15_Low fa_mass_retirements.segment15_low%TYPE;
67: G_Segment16_Low fa_mass_retirements.segment16_low%TYPE;
68: G_Segment17_Low fa_mass_retirements.segment17_low%TYPE;
69: G_Segment18_Low fa_mass_retirements.segment18_low%TYPE;
70: G_Segment19_Low fa_mass_retirements.segment19_low%TYPE;
71: G_Segment20_Low fa_mass_retirements.segment20_low%TYPE;
72: G_Segment21_Low fa_mass_retirements.segment21_low%TYPE;
73: G_Segment22_Low fa_mass_retirements.segment22_low%TYPE;
74: G_Segment23_Low fa_mass_retirements.segment23_low%TYPE;
67: G_Segment16_Low fa_mass_retirements.segment16_low%TYPE;
68: G_Segment17_Low fa_mass_retirements.segment17_low%TYPE;
69: G_Segment18_Low fa_mass_retirements.segment18_low%TYPE;
70: G_Segment19_Low fa_mass_retirements.segment19_low%TYPE;
71: G_Segment20_Low fa_mass_retirements.segment20_low%TYPE;
72: G_Segment21_Low fa_mass_retirements.segment21_low%TYPE;
73: G_Segment22_Low fa_mass_retirements.segment22_low%TYPE;
74: G_Segment23_Low fa_mass_retirements.segment23_low%TYPE;
75: G_Segment24_Low fa_mass_retirements.segment24_low%TYPE;
68: G_Segment17_Low fa_mass_retirements.segment17_low%TYPE;
69: G_Segment18_Low fa_mass_retirements.segment18_low%TYPE;
70: G_Segment19_Low fa_mass_retirements.segment19_low%TYPE;
71: G_Segment20_Low fa_mass_retirements.segment20_low%TYPE;
72: G_Segment21_Low fa_mass_retirements.segment21_low%TYPE;
73: G_Segment22_Low fa_mass_retirements.segment22_low%TYPE;
74: G_Segment23_Low fa_mass_retirements.segment23_low%TYPE;
75: G_Segment24_Low fa_mass_retirements.segment24_low%TYPE;
76: G_Segment25_Low fa_mass_retirements.segment25_low%TYPE;
69: G_Segment18_Low fa_mass_retirements.segment18_low%TYPE;
70: G_Segment19_Low fa_mass_retirements.segment19_low%TYPE;
71: G_Segment20_Low fa_mass_retirements.segment20_low%TYPE;
72: G_Segment21_Low fa_mass_retirements.segment21_low%TYPE;
73: G_Segment22_Low fa_mass_retirements.segment22_low%TYPE;
74: G_Segment23_Low fa_mass_retirements.segment23_low%TYPE;
75: G_Segment24_Low fa_mass_retirements.segment24_low%TYPE;
76: G_Segment25_Low fa_mass_retirements.segment25_low%TYPE;
77: G_Segment26_Low fa_mass_retirements.segment26_low%TYPE;
70: G_Segment19_Low fa_mass_retirements.segment19_low%TYPE;
71: G_Segment20_Low fa_mass_retirements.segment20_low%TYPE;
72: G_Segment21_Low fa_mass_retirements.segment21_low%TYPE;
73: G_Segment22_Low fa_mass_retirements.segment22_low%TYPE;
74: G_Segment23_Low fa_mass_retirements.segment23_low%TYPE;
75: G_Segment24_Low fa_mass_retirements.segment24_low%TYPE;
76: G_Segment25_Low fa_mass_retirements.segment25_low%TYPE;
77: G_Segment26_Low fa_mass_retirements.segment26_low%TYPE;
78: G_Segment27_Low fa_mass_retirements.segment27_low%TYPE;
71: G_Segment20_Low fa_mass_retirements.segment20_low%TYPE;
72: G_Segment21_Low fa_mass_retirements.segment21_low%TYPE;
73: G_Segment22_Low fa_mass_retirements.segment22_low%TYPE;
74: G_Segment23_Low fa_mass_retirements.segment23_low%TYPE;
75: G_Segment24_Low fa_mass_retirements.segment24_low%TYPE;
76: G_Segment25_Low fa_mass_retirements.segment25_low%TYPE;
77: G_Segment26_Low fa_mass_retirements.segment26_low%TYPE;
78: G_Segment27_Low fa_mass_retirements.segment27_low%TYPE;
79: G_Segment28_Low fa_mass_retirements.segment28_low%TYPE;
72: G_Segment21_Low fa_mass_retirements.segment21_low%TYPE;
73: G_Segment22_Low fa_mass_retirements.segment22_low%TYPE;
74: G_Segment23_Low fa_mass_retirements.segment23_low%TYPE;
75: G_Segment24_Low fa_mass_retirements.segment24_low%TYPE;
76: G_Segment25_Low fa_mass_retirements.segment25_low%TYPE;
77: G_Segment26_Low fa_mass_retirements.segment26_low%TYPE;
78: G_Segment27_Low fa_mass_retirements.segment27_low%TYPE;
79: G_Segment28_Low fa_mass_retirements.segment28_low%TYPE;
80: G_Segment29_Low fa_mass_retirements.segment29_low%TYPE;
73: G_Segment22_Low fa_mass_retirements.segment22_low%TYPE;
74: G_Segment23_Low fa_mass_retirements.segment23_low%TYPE;
75: G_Segment24_Low fa_mass_retirements.segment24_low%TYPE;
76: G_Segment25_Low fa_mass_retirements.segment25_low%TYPE;
77: G_Segment26_Low fa_mass_retirements.segment26_low%TYPE;
78: G_Segment27_Low fa_mass_retirements.segment27_low%TYPE;
79: G_Segment28_Low fa_mass_retirements.segment28_low%TYPE;
80: G_Segment29_Low fa_mass_retirements.segment29_low%TYPE;
81: G_Segment30_Low fa_mass_retirements.segment30_low%TYPE;
74: G_Segment23_Low fa_mass_retirements.segment23_low%TYPE;
75: G_Segment24_Low fa_mass_retirements.segment24_low%TYPE;
76: G_Segment25_Low fa_mass_retirements.segment25_low%TYPE;
77: G_Segment26_Low fa_mass_retirements.segment26_low%TYPE;
78: G_Segment27_Low fa_mass_retirements.segment27_low%TYPE;
79: G_Segment28_Low fa_mass_retirements.segment28_low%TYPE;
80: G_Segment29_Low fa_mass_retirements.segment29_low%TYPE;
81: G_Segment30_Low fa_mass_retirements.segment30_low%TYPE;
82: G_Segment1_High fa_mass_retirements.segment1_high%TYPE;
75: G_Segment24_Low fa_mass_retirements.segment24_low%TYPE;
76: G_Segment25_Low fa_mass_retirements.segment25_low%TYPE;
77: G_Segment26_Low fa_mass_retirements.segment26_low%TYPE;
78: G_Segment27_Low fa_mass_retirements.segment27_low%TYPE;
79: G_Segment28_Low fa_mass_retirements.segment28_low%TYPE;
80: G_Segment29_Low fa_mass_retirements.segment29_low%TYPE;
81: G_Segment30_Low fa_mass_retirements.segment30_low%TYPE;
82: G_Segment1_High fa_mass_retirements.segment1_high%TYPE;
83: G_Segment2_High fa_mass_retirements.segment2_high%TYPE;
76: G_Segment25_Low fa_mass_retirements.segment25_low%TYPE;
77: G_Segment26_Low fa_mass_retirements.segment26_low%TYPE;
78: G_Segment27_Low fa_mass_retirements.segment27_low%TYPE;
79: G_Segment28_Low fa_mass_retirements.segment28_low%TYPE;
80: G_Segment29_Low fa_mass_retirements.segment29_low%TYPE;
81: G_Segment30_Low fa_mass_retirements.segment30_low%TYPE;
82: G_Segment1_High fa_mass_retirements.segment1_high%TYPE;
83: G_Segment2_High fa_mass_retirements.segment2_high%TYPE;
84: G_Segment3_High fa_mass_retirements.segment3_high%TYPE;
77: G_Segment26_Low fa_mass_retirements.segment26_low%TYPE;
78: G_Segment27_Low fa_mass_retirements.segment27_low%TYPE;
79: G_Segment28_Low fa_mass_retirements.segment28_low%TYPE;
80: G_Segment29_Low fa_mass_retirements.segment29_low%TYPE;
81: G_Segment30_Low fa_mass_retirements.segment30_low%TYPE;
82: G_Segment1_High fa_mass_retirements.segment1_high%TYPE;
83: G_Segment2_High fa_mass_retirements.segment2_high%TYPE;
84: G_Segment3_High fa_mass_retirements.segment3_high%TYPE;
85: G_Segment4_High fa_mass_retirements.segment4_high%TYPE;
78: G_Segment27_Low fa_mass_retirements.segment27_low%TYPE;
79: G_Segment28_Low fa_mass_retirements.segment28_low%TYPE;
80: G_Segment29_Low fa_mass_retirements.segment29_low%TYPE;
81: G_Segment30_Low fa_mass_retirements.segment30_low%TYPE;
82: G_Segment1_High fa_mass_retirements.segment1_high%TYPE;
83: G_Segment2_High fa_mass_retirements.segment2_high%TYPE;
84: G_Segment3_High fa_mass_retirements.segment3_high%TYPE;
85: G_Segment4_High fa_mass_retirements.segment4_high%TYPE;
86: G_Segment5_High fa_mass_retirements.segment5_high%TYPE;
79: G_Segment28_Low fa_mass_retirements.segment28_low%TYPE;
80: G_Segment29_Low fa_mass_retirements.segment29_low%TYPE;
81: G_Segment30_Low fa_mass_retirements.segment30_low%TYPE;
82: G_Segment1_High fa_mass_retirements.segment1_high%TYPE;
83: G_Segment2_High fa_mass_retirements.segment2_high%TYPE;
84: G_Segment3_High fa_mass_retirements.segment3_high%TYPE;
85: G_Segment4_High fa_mass_retirements.segment4_high%TYPE;
86: G_Segment5_High fa_mass_retirements.segment5_high%TYPE;
87: G_Segment6_High fa_mass_retirements.segment6_high%TYPE;
80: G_Segment29_Low fa_mass_retirements.segment29_low%TYPE;
81: G_Segment30_Low fa_mass_retirements.segment30_low%TYPE;
82: G_Segment1_High fa_mass_retirements.segment1_high%TYPE;
83: G_Segment2_High fa_mass_retirements.segment2_high%TYPE;
84: G_Segment3_High fa_mass_retirements.segment3_high%TYPE;
85: G_Segment4_High fa_mass_retirements.segment4_high%TYPE;
86: G_Segment5_High fa_mass_retirements.segment5_high%TYPE;
87: G_Segment6_High fa_mass_retirements.segment6_high%TYPE;
88: G_Segment7_High fa_mass_retirements.segment7_high%TYPE;
81: G_Segment30_Low fa_mass_retirements.segment30_low%TYPE;
82: G_Segment1_High fa_mass_retirements.segment1_high%TYPE;
83: G_Segment2_High fa_mass_retirements.segment2_high%TYPE;
84: G_Segment3_High fa_mass_retirements.segment3_high%TYPE;
85: G_Segment4_High fa_mass_retirements.segment4_high%TYPE;
86: G_Segment5_High fa_mass_retirements.segment5_high%TYPE;
87: G_Segment6_High fa_mass_retirements.segment6_high%TYPE;
88: G_Segment7_High fa_mass_retirements.segment7_high%TYPE;
89: G_Segment8_High fa_mass_retirements.segment8_high%TYPE;
82: G_Segment1_High fa_mass_retirements.segment1_high%TYPE;
83: G_Segment2_High fa_mass_retirements.segment2_high%TYPE;
84: G_Segment3_High fa_mass_retirements.segment3_high%TYPE;
85: G_Segment4_High fa_mass_retirements.segment4_high%TYPE;
86: G_Segment5_High fa_mass_retirements.segment5_high%TYPE;
87: G_Segment6_High fa_mass_retirements.segment6_high%TYPE;
88: G_Segment7_High fa_mass_retirements.segment7_high%TYPE;
89: G_Segment8_High fa_mass_retirements.segment8_high%TYPE;
90: G_Segment9_High fa_mass_retirements.segment9_high%TYPE;
83: G_Segment2_High fa_mass_retirements.segment2_high%TYPE;
84: G_Segment3_High fa_mass_retirements.segment3_high%TYPE;
85: G_Segment4_High fa_mass_retirements.segment4_high%TYPE;
86: G_Segment5_High fa_mass_retirements.segment5_high%TYPE;
87: G_Segment6_High fa_mass_retirements.segment6_high%TYPE;
88: G_Segment7_High fa_mass_retirements.segment7_high%TYPE;
89: G_Segment8_High fa_mass_retirements.segment8_high%TYPE;
90: G_Segment9_High fa_mass_retirements.segment9_high%TYPE;
91: G_Segment10_High fa_mass_retirements.segment10_high%TYPE;
84: G_Segment3_High fa_mass_retirements.segment3_high%TYPE;
85: G_Segment4_High fa_mass_retirements.segment4_high%TYPE;
86: G_Segment5_High fa_mass_retirements.segment5_high%TYPE;
87: G_Segment6_High fa_mass_retirements.segment6_high%TYPE;
88: G_Segment7_High fa_mass_retirements.segment7_high%TYPE;
89: G_Segment8_High fa_mass_retirements.segment8_high%TYPE;
90: G_Segment9_High fa_mass_retirements.segment9_high%TYPE;
91: G_Segment10_High fa_mass_retirements.segment10_high%TYPE;
92: G_Segment11_High fa_mass_retirements.segment11_high%TYPE;
85: G_Segment4_High fa_mass_retirements.segment4_high%TYPE;
86: G_Segment5_High fa_mass_retirements.segment5_high%TYPE;
87: G_Segment6_High fa_mass_retirements.segment6_high%TYPE;
88: G_Segment7_High fa_mass_retirements.segment7_high%TYPE;
89: G_Segment8_High fa_mass_retirements.segment8_high%TYPE;
90: G_Segment9_High fa_mass_retirements.segment9_high%TYPE;
91: G_Segment10_High fa_mass_retirements.segment10_high%TYPE;
92: G_Segment11_High fa_mass_retirements.segment11_high%TYPE;
93: G_Segment12_High fa_mass_retirements.segment12_high%TYPE;
86: G_Segment5_High fa_mass_retirements.segment5_high%TYPE;
87: G_Segment6_High fa_mass_retirements.segment6_high%TYPE;
88: G_Segment7_High fa_mass_retirements.segment7_high%TYPE;
89: G_Segment8_High fa_mass_retirements.segment8_high%TYPE;
90: G_Segment9_High fa_mass_retirements.segment9_high%TYPE;
91: G_Segment10_High fa_mass_retirements.segment10_high%TYPE;
92: G_Segment11_High fa_mass_retirements.segment11_high%TYPE;
93: G_Segment12_High fa_mass_retirements.segment12_high%TYPE;
94: G_Segment13_High fa_mass_retirements.segment13_high%TYPE;
87: G_Segment6_High fa_mass_retirements.segment6_high%TYPE;
88: G_Segment7_High fa_mass_retirements.segment7_high%TYPE;
89: G_Segment8_High fa_mass_retirements.segment8_high%TYPE;
90: G_Segment9_High fa_mass_retirements.segment9_high%TYPE;
91: G_Segment10_High fa_mass_retirements.segment10_high%TYPE;
92: G_Segment11_High fa_mass_retirements.segment11_high%TYPE;
93: G_Segment12_High fa_mass_retirements.segment12_high%TYPE;
94: G_Segment13_High fa_mass_retirements.segment13_high%TYPE;
95: G_Segment14_High fa_mass_retirements.segment14_high%TYPE;
88: G_Segment7_High fa_mass_retirements.segment7_high%TYPE;
89: G_Segment8_High fa_mass_retirements.segment8_high%TYPE;
90: G_Segment9_High fa_mass_retirements.segment9_high%TYPE;
91: G_Segment10_High fa_mass_retirements.segment10_high%TYPE;
92: G_Segment11_High fa_mass_retirements.segment11_high%TYPE;
93: G_Segment12_High fa_mass_retirements.segment12_high%TYPE;
94: G_Segment13_High fa_mass_retirements.segment13_high%TYPE;
95: G_Segment14_High fa_mass_retirements.segment14_high%TYPE;
96: G_Segment15_High fa_mass_retirements.segment15_high%TYPE;
89: G_Segment8_High fa_mass_retirements.segment8_high%TYPE;
90: G_Segment9_High fa_mass_retirements.segment9_high%TYPE;
91: G_Segment10_High fa_mass_retirements.segment10_high%TYPE;
92: G_Segment11_High fa_mass_retirements.segment11_high%TYPE;
93: G_Segment12_High fa_mass_retirements.segment12_high%TYPE;
94: G_Segment13_High fa_mass_retirements.segment13_high%TYPE;
95: G_Segment14_High fa_mass_retirements.segment14_high%TYPE;
96: G_Segment15_High fa_mass_retirements.segment15_high%TYPE;
97: G_Segment16_High fa_mass_retirements.segment16_high%TYPE;
90: G_Segment9_High fa_mass_retirements.segment9_high%TYPE;
91: G_Segment10_High fa_mass_retirements.segment10_high%TYPE;
92: G_Segment11_High fa_mass_retirements.segment11_high%TYPE;
93: G_Segment12_High fa_mass_retirements.segment12_high%TYPE;
94: G_Segment13_High fa_mass_retirements.segment13_high%TYPE;
95: G_Segment14_High fa_mass_retirements.segment14_high%TYPE;
96: G_Segment15_High fa_mass_retirements.segment15_high%TYPE;
97: G_Segment16_High fa_mass_retirements.segment16_high%TYPE;
98: G_Segment17_High fa_mass_retirements.segment17_high%TYPE;
91: G_Segment10_High fa_mass_retirements.segment10_high%TYPE;
92: G_Segment11_High fa_mass_retirements.segment11_high%TYPE;
93: G_Segment12_High fa_mass_retirements.segment12_high%TYPE;
94: G_Segment13_High fa_mass_retirements.segment13_high%TYPE;
95: G_Segment14_High fa_mass_retirements.segment14_high%TYPE;
96: G_Segment15_High fa_mass_retirements.segment15_high%TYPE;
97: G_Segment16_High fa_mass_retirements.segment16_high%TYPE;
98: G_Segment17_High fa_mass_retirements.segment17_high%TYPE;
99: G_Segment18_High fa_mass_retirements.segment18_high%TYPE;
92: G_Segment11_High fa_mass_retirements.segment11_high%TYPE;
93: G_Segment12_High fa_mass_retirements.segment12_high%TYPE;
94: G_Segment13_High fa_mass_retirements.segment13_high%TYPE;
95: G_Segment14_High fa_mass_retirements.segment14_high%TYPE;
96: G_Segment15_High fa_mass_retirements.segment15_high%TYPE;
97: G_Segment16_High fa_mass_retirements.segment16_high%TYPE;
98: G_Segment17_High fa_mass_retirements.segment17_high%TYPE;
99: G_Segment18_High fa_mass_retirements.segment18_high%TYPE;
100: G_Segment19_High fa_mass_retirements.segment19_high%TYPE;
93: G_Segment12_High fa_mass_retirements.segment12_high%TYPE;
94: G_Segment13_High fa_mass_retirements.segment13_high%TYPE;
95: G_Segment14_High fa_mass_retirements.segment14_high%TYPE;
96: G_Segment15_High fa_mass_retirements.segment15_high%TYPE;
97: G_Segment16_High fa_mass_retirements.segment16_high%TYPE;
98: G_Segment17_High fa_mass_retirements.segment17_high%TYPE;
99: G_Segment18_High fa_mass_retirements.segment18_high%TYPE;
100: G_Segment19_High fa_mass_retirements.segment19_high%TYPE;
101: G_Segment20_High fa_mass_retirements.segment20_high%TYPE;
94: G_Segment13_High fa_mass_retirements.segment13_high%TYPE;
95: G_Segment14_High fa_mass_retirements.segment14_high%TYPE;
96: G_Segment15_High fa_mass_retirements.segment15_high%TYPE;
97: G_Segment16_High fa_mass_retirements.segment16_high%TYPE;
98: G_Segment17_High fa_mass_retirements.segment17_high%TYPE;
99: G_Segment18_High fa_mass_retirements.segment18_high%TYPE;
100: G_Segment19_High fa_mass_retirements.segment19_high%TYPE;
101: G_Segment20_High fa_mass_retirements.segment20_high%TYPE;
102: G_Segment21_High fa_mass_retirements.segment21_high%TYPE;
95: G_Segment14_High fa_mass_retirements.segment14_high%TYPE;
96: G_Segment15_High fa_mass_retirements.segment15_high%TYPE;
97: G_Segment16_High fa_mass_retirements.segment16_high%TYPE;
98: G_Segment17_High fa_mass_retirements.segment17_high%TYPE;
99: G_Segment18_High fa_mass_retirements.segment18_high%TYPE;
100: G_Segment19_High fa_mass_retirements.segment19_high%TYPE;
101: G_Segment20_High fa_mass_retirements.segment20_high%TYPE;
102: G_Segment21_High fa_mass_retirements.segment21_high%TYPE;
103: G_Segment22_High fa_mass_retirements.segment22_high%TYPE;
96: G_Segment15_High fa_mass_retirements.segment15_high%TYPE;
97: G_Segment16_High fa_mass_retirements.segment16_high%TYPE;
98: G_Segment17_High fa_mass_retirements.segment17_high%TYPE;
99: G_Segment18_High fa_mass_retirements.segment18_high%TYPE;
100: G_Segment19_High fa_mass_retirements.segment19_high%TYPE;
101: G_Segment20_High fa_mass_retirements.segment20_high%TYPE;
102: G_Segment21_High fa_mass_retirements.segment21_high%TYPE;
103: G_Segment22_High fa_mass_retirements.segment22_high%TYPE;
104: G_Segment23_High fa_mass_retirements.segment23_high%TYPE;
97: G_Segment16_High fa_mass_retirements.segment16_high%TYPE;
98: G_Segment17_High fa_mass_retirements.segment17_high%TYPE;
99: G_Segment18_High fa_mass_retirements.segment18_high%TYPE;
100: G_Segment19_High fa_mass_retirements.segment19_high%TYPE;
101: G_Segment20_High fa_mass_retirements.segment20_high%TYPE;
102: G_Segment21_High fa_mass_retirements.segment21_high%TYPE;
103: G_Segment22_High fa_mass_retirements.segment22_high%TYPE;
104: G_Segment23_High fa_mass_retirements.segment23_high%TYPE;
105: G_Segment24_High fa_mass_retirements.segment24_high%TYPE;
98: G_Segment17_High fa_mass_retirements.segment17_high%TYPE;
99: G_Segment18_High fa_mass_retirements.segment18_high%TYPE;
100: G_Segment19_High fa_mass_retirements.segment19_high%TYPE;
101: G_Segment20_High fa_mass_retirements.segment20_high%TYPE;
102: G_Segment21_High fa_mass_retirements.segment21_high%TYPE;
103: G_Segment22_High fa_mass_retirements.segment22_high%TYPE;
104: G_Segment23_High fa_mass_retirements.segment23_high%TYPE;
105: G_Segment24_High fa_mass_retirements.segment24_high%TYPE;
106: G_Segment25_High fa_mass_retirements.segment25_high%TYPE;
99: G_Segment18_High fa_mass_retirements.segment18_high%TYPE;
100: G_Segment19_High fa_mass_retirements.segment19_high%TYPE;
101: G_Segment20_High fa_mass_retirements.segment20_high%TYPE;
102: G_Segment21_High fa_mass_retirements.segment21_high%TYPE;
103: G_Segment22_High fa_mass_retirements.segment22_high%TYPE;
104: G_Segment23_High fa_mass_retirements.segment23_high%TYPE;
105: G_Segment24_High fa_mass_retirements.segment24_high%TYPE;
106: G_Segment25_High fa_mass_retirements.segment25_high%TYPE;
107: G_Segment26_High fa_mass_retirements.segment26_high%TYPE;
100: G_Segment19_High fa_mass_retirements.segment19_high%TYPE;
101: G_Segment20_High fa_mass_retirements.segment20_high%TYPE;
102: G_Segment21_High fa_mass_retirements.segment21_high%TYPE;
103: G_Segment22_High fa_mass_retirements.segment22_high%TYPE;
104: G_Segment23_High fa_mass_retirements.segment23_high%TYPE;
105: G_Segment24_High fa_mass_retirements.segment24_high%TYPE;
106: G_Segment25_High fa_mass_retirements.segment25_high%TYPE;
107: G_Segment26_High fa_mass_retirements.segment26_high%TYPE;
108: G_Segment27_High fa_mass_retirements.segment27_high%TYPE;
101: G_Segment20_High fa_mass_retirements.segment20_high%TYPE;
102: G_Segment21_High fa_mass_retirements.segment21_high%TYPE;
103: G_Segment22_High fa_mass_retirements.segment22_high%TYPE;
104: G_Segment23_High fa_mass_retirements.segment23_high%TYPE;
105: G_Segment24_High fa_mass_retirements.segment24_high%TYPE;
106: G_Segment25_High fa_mass_retirements.segment25_high%TYPE;
107: G_Segment26_High fa_mass_retirements.segment26_high%TYPE;
108: G_Segment27_High fa_mass_retirements.segment27_high%TYPE;
109: G_Segment28_High fa_mass_retirements.segment28_high%TYPE;
102: G_Segment21_High fa_mass_retirements.segment21_high%TYPE;
103: G_Segment22_High fa_mass_retirements.segment22_high%TYPE;
104: G_Segment23_High fa_mass_retirements.segment23_high%TYPE;
105: G_Segment24_High fa_mass_retirements.segment24_high%TYPE;
106: G_Segment25_High fa_mass_retirements.segment25_high%TYPE;
107: G_Segment26_High fa_mass_retirements.segment26_high%TYPE;
108: G_Segment27_High fa_mass_retirements.segment27_high%TYPE;
109: G_Segment28_High fa_mass_retirements.segment28_high%TYPE;
110: G_Segment29_High fa_mass_retirements.segment29_high%TYPE;
103: G_Segment22_High fa_mass_retirements.segment22_high%TYPE;
104: G_Segment23_High fa_mass_retirements.segment23_high%TYPE;
105: G_Segment24_High fa_mass_retirements.segment24_high%TYPE;
106: G_Segment25_High fa_mass_retirements.segment25_high%TYPE;
107: G_Segment26_High fa_mass_retirements.segment26_high%TYPE;
108: G_Segment27_High fa_mass_retirements.segment27_high%TYPE;
109: G_Segment28_High fa_mass_retirements.segment28_high%TYPE;
110: G_Segment29_High fa_mass_retirements.segment29_high%TYPE;
111: G_Segment30_High fa_mass_retirements.segment30_high%TYPE;
104: G_Segment23_High fa_mass_retirements.segment23_high%TYPE;
105: G_Segment24_High fa_mass_retirements.segment24_high%TYPE;
106: G_Segment25_High fa_mass_retirements.segment25_high%TYPE;
107: G_Segment26_High fa_mass_retirements.segment26_high%TYPE;
108: G_Segment27_High fa_mass_retirements.segment27_high%TYPE;
109: G_Segment28_High fa_mass_retirements.segment28_high%TYPE;
110: G_Segment29_High fa_mass_retirements.segment29_high%TYPE;
111: G_Segment30_High fa_mass_retirements.segment30_high%TYPE;
112:
105: G_Segment24_High fa_mass_retirements.segment24_high%TYPE;
106: G_Segment25_High fa_mass_retirements.segment25_high%TYPE;
107: G_Segment26_High fa_mass_retirements.segment26_high%TYPE;
108: G_Segment27_High fa_mass_retirements.segment27_high%TYPE;
109: G_Segment28_High fa_mass_retirements.segment28_high%TYPE;
110: G_Segment29_High fa_mass_retirements.segment29_high%TYPE;
111: G_Segment30_High fa_mass_retirements.segment30_high%TYPE;
112:
113:
106: G_Segment25_High fa_mass_retirements.segment25_high%TYPE;
107: G_Segment26_High fa_mass_retirements.segment26_high%TYPE;
108: G_Segment27_High fa_mass_retirements.segment27_high%TYPE;
109: G_Segment28_High fa_mass_retirements.segment28_high%TYPE;
110: G_Segment29_High fa_mass_retirements.segment29_high%TYPE;
111: G_Segment30_High fa_mass_retirements.segment30_high%TYPE;
112:
113:
114: G_Extend_Search VARCHAR2(10);
107: G_Segment26_High fa_mass_retirements.segment26_high%TYPE;
108: G_Segment27_High fa_mass_retirements.segment27_high%TYPE;
109: G_Segment28_High fa_mass_retirements.segment28_high%TYPE;
110: G_Segment29_High fa_mass_retirements.segment29_high%TYPE;
111: G_Segment30_High fa_mass_retirements.segment30_high%TYPE;
112:
113:
114: G_Extend_Search VARCHAR2(10);
115: G_Mode VARCHAR2(30);
2764:
2765: Delete from fa_mass_ext_retirements
2766: Where batch_name = g_batch_name;
2767:
2768: Update fa_mass_retirements
2769: Set status = 'ON_HOLD'
2770: Where mass_retirement_id = G_Mass_Retirement_id;
2771:
2772: p_suxess_no := 0;
2805: '','');
2806:
2807: END LOOP;
2808:
2809: Update fa_mass_retirements
2810: Set status = 'CREATED_RET'
2811: Where mass_retirement_id = G_Mass_Retirement_id;
2812:
2813: End if; -- remaining_units.
2980: fmr.to_cost,
2981: fmr.include_fully_rsvd_flag,
2982: fmr.group_asset_id, -- crl, no reason to break out
2983: fmr.group_association
2984: FROM fa_mass_retirements fmr,
2985: fa_book_controls fbc,
2986: gl_sets_of_books sob
2987: WHERE fmr.mass_retirement_id = p_Mass_Retirement_Id
2988: AND fmr.book_type_code = fbc.book_type_code
4184: -- X_Total_Count_Retired := G_Total_Count_Retired;
4185:
4186: -- update the status so we can post the batch
4187: if nvl(g_units,0) = 0 then -- status already inserted in allocate_units.
4188: update fa_mass_retirements
4189: set status = 'CREATED_RET'
4190: where mass_retirement_id = G_Mass_Retirement_ID;
4191: end if;
4192:
4255: commit;
4256: retcode := 0;
4257: WHEN error_found then
4258: rollback;
4259: update fa_mass_retirements
4260: set status = 'FAILED_CRE'
4261: where mass_retirement_id = G_Mass_Retirement_ID;
4262: commit;
4263: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
4276: retcode := 2;
4277:
4278: WHEN others THEN
4279: rollback;
4280: update fa_mass_retirements
4281: set status = 'FAILED_CRE'
4282: where mass_retirement_id = G_Mass_Retirement_ID;
4283: commit;
4284: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);