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.

[Home] [Help]

APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on FA_MASS_EXT_RETIREMENTS

Line 5: G_Mass_External_Retire_Id fa_mass_Ext_retirements.Mass_External_Retire_Id%TYPE;

1: PACKAGE BODY FA_CUA_MASS_EXT_RET_PKG AS
2: /* $Header: FACXTREMB.pls 120.22 2005/11/11 07:39:35 tdewanga ship $
3:
4: /* Global Variables holding Mass External Retirements Information */
5: G_Mass_External_Retire_Id fa_mass_Ext_retirements.Mass_External_Retire_Id%TYPE;
6: G_Book_Type_Code fa_mass_Ext_retirements.Book_Type_Code%TYPE;
7: G_Batch_Name fa_mass_Ext_retirements.Batch_Name%TYPE;
8: G_Asset_Id fa_mass_Ext_retirements.Asset_Id%TYPE;
9: G_Transaction_Name fa_mass_Ext_retirements.Transaction_Name%TYPE;

Line 6: G_Book_Type_Code fa_mass_Ext_retirements.Book_Type_Code%TYPE;

2: /* $Header: FACXTREMB.pls 120.22 2005/11/11 07:39:35 tdewanga ship $
3:
4: /* Global Variables holding Mass External Retirements Information */
5: G_Mass_External_Retire_Id fa_mass_Ext_retirements.Mass_External_Retire_Id%TYPE;
6: G_Book_Type_Code fa_mass_Ext_retirements.Book_Type_Code%TYPE;
7: G_Batch_Name fa_mass_Ext_retirements.Batch_Name%TYPE;
8: G_Asset_Id fa_mass_Ext_retirements.Asset_Id%TYPE;
9: G_Transaction_Name fa_mass_Ext_retirements.Transaction_Name%TYPE;
10: G_Date_Retired fa_mass_Ext_retirements.Date_Retired%TYPE;

Line 7: G_Batch_Name fa_mass_Ext_retirements.Batch_Name%TYPE;

3:
4: /* Global Variables holding Mass External Retirements Information */
5: G_Mass_External_Retire_Id fa_mass_Ext_retirements.Mass_External_Retire_Id%TYPE;
6: G_Book_Type_Code fa_mass_Ext_retirements.Book_Type_Code%TYPE;
7: G_Batch_Name fa_mass_Ext_retirements.Batch_Name%TYPE;
8: G_Asset_Id fa_mass_Ext_retirements.Asset_Id%TYPE;
9: G_Transaction_Name fa_mass_Ext_retirements.Transaction_Name%TYPE;
10: G_Date_Retired fa_mass_Ext_retirements.Date_Retired%TYPE;
11: G_Cost_Retired fa_mass_Ext_retirements.Cost_Retired%TYPE;

Line 8: G_Asset_Id fa_mass_Ext_retirements.Asset_Id%TYPE;

4: /* Global Variables holding Mass External Retirements Information */
5: G_Mass_External_Retire_Id fa_mass_Ext_retirements.Mass_External_Retire_Id%TYPE;
6: G_Book_Type_Code fa_mass_Ext_retirements.Book_Type_Code%TYPE;
7: G_Batch_Name fa_mass_Ext_retirements.Batch_Name%TYPE;
8: G_Asset_Id fa_mass_Ext_retirements.Asset_Id%TYPE;
9: G_Transaction_Name fa_mass_Ext_retirements.Transaction_Name%TYPE;
10: G_Date_Retired fa_mass_Ext_retirements.Date_Retired%TYPE;
11: G_Cost_Retired fa_mass_Ext_retirements.Cost_Retired%TYPE;
12: G_Retirement_Prorate_Conv fa_mass_Ext_retirements.Retirement_Prorate_Convention%TYPE;

Line 9: G_Transaction_Name fa_mass_Ext_retirements.Transaction_Name%TYPE;

5: G_Mass_External_Retire_Id fa_mass_Ext_retirements.Mass_External_Retire_Id%TYPE;
6: G_Book_Type_Code fa_mass_Ext_retirements.Book_Type_Code%TYPE;
7: G_Batch_Name fa_mass_Ext_retirements.Batch_Name%TYPE;
8: G_Asset_Id fa_mass_Ext_retirements.Asset_Id%TYPE;
9: G_Transaction_Name fa_mass_Ext_retirements.Transaction_Name%TYPE;
10: G_Date_Retired fa_mass_Ext_retirements.Date_Retired%TYPE;
11: G_Cost_Retired fa_mass_Ext_retirements.Cost_Retired%TYPE;
12: G_Retirement_Prorate_Conv fa_mass_Ext_retirements.Retirement_Prorate_Convention%TYPE;
13: G_Units fa_mass_Ext_retirements.Units%TYPE;

Line 10: G_Date_Retired fa_mass_Ext_retirements.Date_Retired%TYPE;

6: G_Book_Type_Code fa_mass_Ext_retirements.Book_Type_Code%TYPE;
7: G_Batch_Name fa_mass_Ext_retirements.Batch_Name%TYPE;
8: G_Asset_Id fa_mass_Ext_retirements.Asset_Id%TYPE;
9: G_Transaction_Name fa_mass_Ext_retirements.Transaction_Name%TYPE;
10: G_Date_Retired fa_mass_Ext_retirements.Date_Retired%TYPE;
11: G_Cost_Retired fa_mass_Ext_retirements.Cost_Retired%TYPE;
12: G_Retirement_Prorate_Conv fa_mass_Ext_retirements.Retirement_Prorate_Convention%TYPE;
13: G_Units fa_mass_Ext_retirements.Units%TYPE;
14: G_Cost_Of_Removal fa_mass_Ext_retirements.Cost_Of_Removal%TYPE;

Line 11: G_Cost_Retired fa_mass_Ext_retirements.Cost_Retired%TYPE;

7: G_Batch_Name fa_mass_Ext_retirements.Batch_Name%TYPE;
8: G_Asset_Id fa_mass_Ext_retirements.Asset_Id%TYPE;
9: G_Transaction_Name fa_mass_Ext_retirements.Transaction_Name%TYPE;
10: G_Date_Retired fa_mass_Ext_retirements.Date_Retired%TYPE;
11: G_Cost_Retired fa_mass_Ext_retirements.Cost_Retired%TYPE;
12: G_Retirement_Prorate_Conv fa_mass_Ext_retirements.Retirement_Prorate_Convention%TYPE;
13: G_Units fa_mass_Ext_retirements.Units%TYPE;
14: G_Cost_Of_Removal fa_mass_Ext_retirements.Cost_Of_Removal%TYPE;
15: G_Proceeds_Of_Sale fa_mass_Ext_retirements.Proceeds_Of_Sale%TYPE;

Line 12: G_Retirement_Prorate_Conv fa_mass_Ext_retirements.Retirement_Prorate_Convention%TYPE;

8: G_Asset_Id fa_mass_Ext_retirements.Asset_Id%TYPE;
9: G_Transaction_Name fa_mass_Ext_retirements.Transaction_Name%TYPE;
10: G_Date_Retired fa_mass_Ext_retirements.Date_Retired%TYPE;
11: G_Cost_Retired fa_mass_Ext_retirements.Cost_Retired%TYPE;
12: G_Retirement_Prorate_Conv fa_mass_Ext_retirements.Retirement_Prorate_Convention%TYPE;
13: G_Units fa_mass_Ext_retirements.Units%TYPE;
14: G_Cost_Of_Removal fa_mass_Ext_retirements.Cost_Of_Removal%TYPE;
15: G_Proceeds_Of_Sale fa_mass_Ext_retirements.Proceeds_Of_Sale%TYPE;
16: G_Retirement_Type_Code fa_mass_Ext_retirements.Retirement_Type_Code%TYPE;

Line 13: G_Units fa_mass_Ext_retirements.Units%TYPE;

9: G_Transaction_Name fa_mass_Ext_retirements.Transaction_Name%TYPE;
10: G_Date_Retired fa_mass_Ext_retirements.Date_Retired%TYPE;
11: G_Cost_Retired fa_mass_Ext_retirements.Cost_Retired%TYPE;
12: G_Retirement_Prorate_Conv fa_mass_Ext_retirements.Retirement_Prorate_Convention%TYPE;
13: G_Units fa_mass_Ext_retirements.Units%TYPE;
14: G_Cost_Of_Removal fa_mass_Ext_retirements.Cost_Of_Removal%TYPE;
15: G_Proceeds_Of_Sale fa_mass_Ext_retirements.Proceeds_Of_Sale%TYPE;
16: G_Retirement_Type_Code fa_mass_Ext_retirements.Retirement_Type_Code%TYPE;
17: G_Reference_Num fa_mass_Ext_retirements.Reference_Num%TYPE;

Line 14: G_Cost_Of_Removal fa_mass_Ext_retirements.Cost_Of_Removal%TYPE;

10: G_Date_Retired fa_mass_Ext_retirements.Date_Retired%TYPE;
11: G_Cost_Retired fa_mass_Ext_retirements.Cost_Retired%TYPE;
12: G_Retirement_Prorate_Conv fa_mass_Ext_retirements.Retirement_Prorate_Convention%TYPE;
13: G_Units fa_mass_Ext_retirements.Units%TYPE;
14: G_Cost_Of_Removal fa_mass_Ext_retirements.Cost_Of_Removal%TYPE;
15: G_Proceeds_Of_Sale fa_mass_Ext_retirements.Proceeds_Of_Sale%TYPE;
16: G_Retirement_Type_Code fa_mass_Ext_retirements.Retirement_Type_Code%TYPE;
17: G_Reference_Num fa_mass_Ext_retirements.Reference_Num%TYPE;
18: G_Sold_To fa_mass_Ext_retirements.Sold_To%TYPE;

Line 15: G_Proceeds_Of_Sale fa_mass_Ext_retirements.Proceeds_Of_Sale%TYPE;

11: G_Cost_Retired fa_mass_Ext_retirements.Cost_Retired%TYPE;
12: G_Retirement_Prorate_Conv fa_mass_Ext_retirements.Retirement_Prorate_Convention%TYPE;
13: G_Units fa_mass_Ext_retirements.Units%TYPE;
14: G_Cost_Of_Removal fa_mass_Ext_retirements.Cost_Of_Removal%TYPE;
15: G_Proceeds_Of_Sale fa_mass_Ext_retirements.Proceeds_Of_Sale%TYPE;
16: G_Retirement_Type_Code fa_mass_Ext_retirements.Retirement_Type_Code%TYPE;
17: G_Reference_Num fa_mass_Ext_retirements.Reference_Num%TYPE;
18: G_Sold_To fa_mass_Ext_retirements.Sold_To%TYPE;
19: G_Trade_In_Asset_Id fa_mass_Ext_retirements.Trade_In_Asset_Id%TYPE;

Line 16: G_Retirement_Type_Code fa_mass_Ext_retirements.Retirement_Type_Code%TYPE;

12: G_Retirement_Prorate_Conv fa_mass_Ext_retirements.Retirement_Prorate_Convention%TYPE;
13: G_Units fa_mass_Ext_retirements.Units%TYPE;
14: G_Cost_Of_Removal fa_mass_Ext_retirements.Cost_Of_Removal%TYPE;
15: G_Proceeds_Of_Sale fa_mass_Ext_retirements.Proceeds_Of_Sale%TYPE;
16: G_Retirement_Type_Code fa_mass_Ext_retirements.Retirement_Type_Code%TYPE;
17: G_Reference_Num fa_mass_Ext_retirements.Reference_Num%TYPE;
18: G_Sold_To fa_mass_Ext_retirements.Sold_To%TYPE;
19: G_Trade_In_Asset_Id fa_mass_Ext_retirements.Trade_In_Asset_Id%TYPE;
20: G_Stl_Method_Code fa_mass_Ext_retirements.Stl_Method_Code%TYPE;

Line 17: G_Reference_Num fa_mass_Ext_retirements.Reference_Num%TYPE;

13: G_Units fa_mass_Ext_retirements.Units%TYPE;
14: G_Cost_Of_Removal fa_mass_Ext_retirements.Cost_Of_Removal%TYPE;
15: G_Proceeds_Of_Sale fa_mass_Ext_retirements.Proceeds_Of_Sale%TYPE;
16: G_Retirement_Type_Code fa_mass_Ext_retirements.Retirement_Type_Code%TYPE;
17: G_Reference_Num fa_mass_Ext_retirements.Reference_Num%TYPE;
18: G_Sold_To fa_mass_Ext_retirements.Sold_To%TYPE;
19: G_Trade_In_Asset_Id fa_mass_Ext_retirements.Trade_In_Asset_Id%TYPE;
20: G_Stl_Method_Code fa_mass_Ext_retirements.Stl_Method_Code%TYPE;
21: G_Stl_Life_In_Months fa_mass_Ext_retirements.Stl_Life_In_Months%TYPE;

Line 18: G_Sold_To fa_mass_Ext_retirements.Sold_To%TYPE;

14: G_Cost_Of_Removal fa_mass_Ext_retirements.Cost_Of_Removal%TYPE;
15: G_Proceeds_Of_Sale fa_mass_Ext_retirements.Proceeds_Of_Sale%TYPE;
16: G_Retirement_Type_Code fa_mass_Ext_retirements.Retirement_Type_Code%TYPE;
17: G_Reference_Num fa_mass_Ext_retirements.Reference_Num%TYPE;
18: G_Sold_To fa_mass_Ext_retirements.Sold_To%TYPE;
19: G_Trade_In_Asset_Id fa_mass_Ext_retirements.Trade_In_Asset_Id%TYPE;
20: G_Stl_Method_Code fa_mass_Ext_retirements.Stl_Method_Code%TYPE;
21: G_Stl_Life_In_Months fa_mass_Ext_retirements.Stl_Life_In_Months%TYPE;
22: G_Stl_Deprn_Amount fa_mass_Ext_retirements.Stl_Deprn_Amount%TYPE;

Line 19: G_Trade_In_Asset_Id fa_mass_Ext_retirements.Trade_In_Asset_Id%TYPE;

15: G_Proceeds_Of_Sale fa_mass_Ext_retirements.Proceeds_Of_Sale%TYPE;
16: G_Retirement_Type_Code fa_mass_Ext_retirements.Retirement_Type_Code%TYPE;
17: G_Reference_Num fa_mass_Ext_retirements.Reference_Num%TYPE;
18: G_Sold_To fa_mass_Ext_retirements.Sold_To%TYPE;
19: G_Trade_In_Asset_Id fa_mass_Ext_retirements.Trade_In_Asset_Id%TYPE;
20: G_Stl_Method_Code fa_mass_Ext_retirements.Stl_Method_Code%TYPE;
21: G_Stl_Life_In_Months fa_mass_Ext_retirements.Stl_Life_In_Months%TYPE;
22: G_Stl_Deprn_Amount fa_mass_Ext_retirements.Stl_Deprn_Amount%TYPE;
23: G_Itc_Recaptured fa_retirements.Itc_Recaptured%TYPE;

Line 20: G_Stl_Method_Code fa_mass_Ext_retirements.Stl_Method_Code%TYPE;

16: G_Retirement_Type_Code fa_mass_Ext_retirements.Retirement_Type_Code%TYPE;
17: G_Reference_Num fa_mass_Ext_retirements.Reference_Num%TYPE;
18: G_Sold_To fa_mass_Ext_retirements.Sold_To%TYPE;
19: G_Trade_In_Asset_Id fa_mass_Ext_retirements.Trade_In_Asset_Id%TYPE;
20: G_Stl_Method_Code fa_mass_Ext_retirements.Stl_Method_Code%TYPE;
21: G_Stl_Life_In_Months fa_mass_Ext_retirements.Stl_Life_In_Months%TYPE;
22: G_Stl_Deprn_Amount fa_mass_Ext_retirements.Stl_Deprn_Amount%TYPE;
23: G_Itc_Recaptured fa_retirements.Itc_Recaptured%TYPE;
24: G_Itc_Recapture_Id fa_retirements.Itc_Recapture_Id%TYPE;

Line 21: G_Stl_Life_In_Months fa_mass_Ext_retirements.Stl_Life_In_Months%TYPE;

17: G_Reference_Num fa_mass_Ext_retirements.Reference_Num%TYPE;
18: G_Sold_To fa_mass_Ext_retirements.Sold_To%TYPE;
19: G_Trade_In_Asset_Id fa_mass_Ext_retirements.Trade_In_Asset_Id%TYPE;
20: G_Stl_Method_Code fa_mass_Ext_retirements.Stl_Method_Code%TYPE;
21: G_Stl_Life_In_Months fa_mass_Ext_retirements.Stl_Life_In_Months%TYPE;
22: G_Stl_Deprn_Amount fa_mass_Ext_retirements.Stl_Deprn_Amount%TYPE;
23: G_Itc_Recaptured fa_retirements.Itc_Recaptured%TYPE;
24: G_Itc_Recapture_Id fa_retirements.Itc_Recapture_Id%TYPE;
25: G_Current_Units fa_asset_history.Units%TYPE;

Line 22: G_Stl_Deprn_Amount fa_mass_Ext_retirements.Stl_Deprn_Amount%TYPE;

18: G_Sold_To fa_mass_Ext_retirements.Sold_To%TYPE;
19: G_Trade_In_Asset_Id fa_mass_Ext_retirements.Trade_In_Asset_Id%TYPE;
20: G_Stl_Method_Code fa_mass_Ext_retirements.Stl_Method_Code%TYPE;
21: G_Stl_Life_In_Months fa_mass_Ext_retirements.Stl_Life_In_Months%TYPE;
22: G_Stl_Deprn_Amount fa_mass_Ext_retirements.Stl_Deprn_Amount%TYPE;
23: G_Itc_Recaptured fa_retirements.Itc_Recaptured%TYPE;
24: G_Itc_Recapture_Id fa_retirements.Itc_Recapture_Id%TYPE;
25: G_Current_Units fa_asset_history.Units%TYPE;
26: G_Asset_Number fa_additions_b.asset_number%TYPE;

Line 38: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;

34: G_Set_of_Books_ID fa_book_controls.set_of_books_id%TYPE;
35: G_calc_gain_loss_flag varchar2(50) := FND_API.G_FALSE;
36: G_Distribution_id fa_distribution_history.distribution_id%TYPE;
37: -- bug 1857395
38: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
39: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;
40: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;
41: G_Recursion_Level VARCHAR2(1);
42: G_Created_By NUMBER(15) := FND_GLOBAL.USER_ID;

Line 39: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;

35: G_calc_gain_loss_flag varchar2(50) := FND_API.G_FALSE;
36: G_Distribution_id fa_distribution_history.distribution_id%TYPE;
37: -- bug 1857395
38: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
39: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;
40: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;
41: G_Recursion_Level VARCHAR2(1);
42: G_Created_By NUMBER(15) := FND_GLOBAL.USER_ID;
43: G_Creation_Date DATE := SYSDATE;

Line 40: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;

36: G_Distribution_id fa_distribution_history.distribution_id%TYPE;
37: -- bug 1857395
38: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
39: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;
40: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;
41: G_Recursion_Level VARCHAR2(1);
42: G_Created_By NUMBER(15) := FND_GLOBAL.USER_ID;
43: G_Creation_Date DATE := SYSDATE;
44: G_Varchar2_Dummy VARCHAR2(80);

Line 59: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;

55: --
56:
57: G_Subroutine_Fail EXCEPTION;
58: /* Start Bug 1300585 */
59: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;
60: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
61: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
62: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
63: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;

Line 60: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;

56:
57: G_Subroutine_Fail EXCEPTION;
58: /* Start Bug 1300585 */
59: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;
60: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
61: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
62: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
63: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
64: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;

Line 61: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;

57: G_Subroutine_Fail EXCEPTION;
58: /* Start Bug 1300585 */
59: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;
60: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
61: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
62: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
63: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
64: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
65: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;

Line 62: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;

58: /* Start Bug 1300585 */
59: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;
60: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
61: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
62: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
63: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
64: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
65: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
66: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;

Line 63: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;

59: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;
60: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
61: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
62: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
63: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
64: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
65: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
66: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
67: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;

Line 64: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;

60: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
61: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
62: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
63: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
64: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
65: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
66: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
67: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
68: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;

Line 65: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;

61: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
62: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
63: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
64: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
65: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
66: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
67: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
68: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
69: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;

Line 66: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;

62: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
63: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
64: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
65: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
66: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
67: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
68: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
69: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
70: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;

Line 67: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;

63: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
64: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
65: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
66: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
67: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
68: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
69: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
70: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
71: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;

Line 68: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;

64: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
65: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
66: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
67: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
68: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
69: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
70: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
71: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
72: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;

Line 69: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;

65: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
66: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
67: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
68: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
69: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
70: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
71: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
72: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
73: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;

Line 70: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;

66: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
67: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
68: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
69: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
70: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
71: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
72: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
73: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
74: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;

Line 71: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;

67: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
68: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
69: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
70: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
71: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
72: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
73: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
74: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
75: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;

Line 72: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;

68: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
69: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
70: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
71: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
72: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
73: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
74: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
75: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
76: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;

Line 73: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;

69: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
70: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
71: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
72: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
73: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
74: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
75: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
76: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
77: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;

Line 74: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;

70: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
71: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
72: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
73: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
74: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
75: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
76: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
77: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
78: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;

Line 75: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;

71: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
72: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
73: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
74: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
75: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
76: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
77: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
78: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
79: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;

Line 76: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;

72: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
73: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
74: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
75: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
76: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
77: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
78: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
79: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
80: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;

Line 77: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;

73: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
74: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
75: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
76: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
77: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
78: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
79: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
80: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
81: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;

Line 78: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;

74: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
75: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
76: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
77: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
78: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
79: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
80: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
81: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
82: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;

Line 79: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;

75: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
76: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
77: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
78: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
79: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
80: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
81: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
82: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
83: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;

Line 80: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;

76: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
77: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
78: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
79: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
80: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
81: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
82: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
83: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
84: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;

Line 81: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;

77: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
78: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
79: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
80: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
81: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
82: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
83: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
84: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
85: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;

Line 82: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;

78: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
79: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
80: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
81: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
82: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
83: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
84: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
85: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
86: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;

Line 83: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;

79: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
80: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
81: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
82: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
83: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
84: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
85: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
86: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
87: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;

Line 84: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;

80: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
81: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
82: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
83: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
84: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
85: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
86: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
87: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
88: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;

Line 85: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;

81: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
82: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
83: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
84: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
85: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
86: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
87: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
88: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
89: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;

Line 86: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;

82: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
83: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
84: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
85: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
86: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
87: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
88: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
89: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;
90: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;

Line 87: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;

83: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
84: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
85: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
86: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
87: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
88: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
89: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;
90: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;
91: /* End of bug 1300585*/

Line 88: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;

84: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
85: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
86: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
87: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
88: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
89: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;
90: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;
91: /* End of bug 1300585*/
92:

Line 89: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;

85: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
86: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
87: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
88: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
89: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;
90: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;
91: /* End of bug 1300585*/
92:
93: G_fatal_error boolean := FALSE;

Line 90: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;

86: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
87: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
88: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
89: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;
90: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;
91: /* End of bug 1300585*/
92:
93: G_fatal_error boolean := FALSE;
94: G_failure_count number := 0;

Line 182: FROM fa_mass_Ext_retirements mer,

178: mer.attribute12,
179: mer.attribute13,
180: mer.attribute14,
181: mer.attribute15
182: FROM fa_mass_Ext_retirements mer,
183: fa_books bks,
184: fa_additions_b ad,
185: fa_book_controls fbc,
186: gl_sets_of_books sob

Line 389: from fa_mass_ext_retirements

385:
386: Cursor c_dhident is
387: select nvl(count(*),0)
388: into g_test_ident_distributions
389: from fa_mass_ext_retirements
390: where batch_name = G_batch_name
391: and review_status = 'POST'
392: and asset_id = g_asset_id
393: group by code_combination_id, location_id, assigned_to

Line 760: from fa_mass_ext_retirements

756:
757:
758: select count(*)
759: into g_num_of_distributions
760: from fa_mass_ext_retirements
761: where batch_name = G_batch_name
762: and review_status = 'POST'
763: and asset_id = g_asset_id
764: and code_combination_id is not null

Line 772: from fa_mass_ext_retirements

768: g_single_dist_array := 'NO';
769:
770: select count(*)
771: into g_num_of_identical
772: from fa_mass_ext_retirements
773: where batch_name = G_batch_name
774: and review_status = 'POST'
775: and asset_id = g_asset_id
776: and code_combination_id is not null;

Line 1234: UPDATE fa_mass_Ext_retirements

1230: END IF;
1231:
1232: end if; -- num_of_distribution
1233:
1234: UPDATE fa_mass_Ext_retirements
1235: SET review_status = 'POSTED',
1236: -- bugfix 2442439 retirement_id = lv_ret_id
1237: retirement_id = l_asset_retire_rec.retirement_id,
1238: last_update_date = sysdate,

Line 1263: UPDATE fa_mass_Ext_retirements

1259: -- if (g_log_level_rec.statement_level) then
1260: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1261: -- end if;
1262:
1263: UPDATE fa_mass_Ext_retirements
1264: SET review_status = 'ERROR',
1265: last_update_date = sysdate,
1266: last_updated_by = fnd_global.user_id,
1267: last_update_login = fnd_global.login_id

Line 1296: UPDATE fa_mass_Ext_retirements

1292: -- if( g_log_level_rec.statement_level) then
1293: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1294: -- end if;
1295:
1296: UPDATE fa_mass_Ext_retirements
1297: SET review_status = 'ERROR',
1298: last_update_date = sysdate,
1299: last_updated_by = fnd_global.user_id,
1300: last_update_login = fnd_global.login_id

Line 1339: UPDATE fa_mass_Ext_retirements

1335: -- if( g_log_level_rec.statement_level) then
1336: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1337: -- end if;
1338:
1339: UPDATE fa_mass_Ext_retirements
1340: SET review_status = 'ERROR',
1341: last_update_date = sysdate,
1342: last_updated_by = fnd_global.user_id,
1343: last_update_login = fnd_global.login_id

Line 1370: UPDATE fa_mass_Ext_retirements

1366: -- if(g_log_level_rec.statement_level) then
1367: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1368: -- end if;
1369:
1370: UPDATE fa_mass_Ext_retirements
1371: SET review_status = 'ERROR',
1372: last_update_date = sysdate,
1373: last_updated_by = fnd_global.user_id,
1374: last_update_login = fnd_global.login_id

Line 1436: UPDATE fa_mass_Ext_retirements

1432: WHEN pending_batch THEN
1433:
1434: FND_CONCURRENT.AF_ROLLBACK;
1435:
1436: UPDATE fa_mass_Ext_retirements
1437: SET review_status = 'ERROR',
1438: last_update_date = sysdate,
1439: last_updated_by = fnd_global.user_id,
1440: last_update_login = fnd_global.login_id

Line 1525: from fa_mass_ext_retirements

1521: RETCODE OUT NOCOPY VARCHAR2) IS
1522:
1523: Cursor Assets_C is
1524: select Mass_External_Retire_ID
1525: from fa_mass_ext_retirements
1526: where review_status in ('DELETE','POSTED')
1527: for update nowait;
1528:
1529: LV_Mass_External_Retire_ID NUMBER;

Line 1548: Delete from fa_mass_ext_retirements

1544: Delete from fa_ext_inv_retirements
1545: where mass_external_retire_id = LV_Mass_External_Retire_ID;
1546: end if;
1547:
1548: Delete from fa_mass_ext_retirements
1549: where mass_external_retire_id = LV_Mass_External_Retire_ID;
1550:
1551: End Loop;
1552: