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

APPS.FA_CUA_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.31 2011/02/10 09:57:51 spooyath 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.31 2011/02/10 09:57:51 spooyath 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 44: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;

40: G_Set_of_Books_ID fa_book_controls.set_of_books_id%TYPE;
41: G_calc_gain_loss_flag varchar2(50) := FND_API.G_FALSE;
42: G_Distribution_id fa_distribution_history.distribution_id%TYPE;
43: -- bug 1857395
44: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
45: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;
46: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;
47: G_Recursion_Level VARCHAR2(1);
48: G_Created_By NUMBER(15) := FND_GLOBAL.USER_ID;

Line 45: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;

41: G_calc_gain_loss_flag varchar2(50) := FND_API.G_FALSE;
42: G_Distribution_id fa_distribution_history.distribution_id%TYPE;
43: -- bug 1857395
44: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
45: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;
46: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;
47: G_Recursion_Level VARCHAR2(1);
48: G_Created_By NUMBER(15) := FND_GLOBAL.USER_ID;
49: G_Creation_Date DATE := SYSDATE;

Line 46: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;

42: G_Distribution_id fa_distribution_history.distribution_id%TYPE;
43: -- bug 1857395
44: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
45: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;
46: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;
47: G_Recursion_Level VARCHAR2(1);
48: G_Created_By NUMBER(15) := FND_GLOBAL.USER_ID;
49: G_Creation_Date DATE := SYSDATE;
50: G_Varchar2_Dummy VARCHAR2(80);

Line 65: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;

61: --
62:
63: G_Subroutine_Fail EXCEPTION;
64: /* Start Bug 1300585 */
65: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;
66: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
67: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
68: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
69: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;

Line 66: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;

62:
63: G_Subroutine_Fail EXCEPTION;
64: /* Start Bug 1300585 */
65: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;
66: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
67: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
68: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
69: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
70: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;

Line 67: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;

63: G_Subroutine_Fail EXCEPTION;
64: /* Start Bug 1300585 */
65: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;
66: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
67: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
68: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
69: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
70: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
71: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;

Line 68: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;

64: /* Start Bug 1300585 */
65: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;
66: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
67: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
68: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
69: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
70: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
71: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
72: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;

Line 69: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;

65: G_TH_Attribute_Category fa_mass_Ext_retirements.TH_Attribute_Category%TYPE;
66: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
67: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
68: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
69: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
70: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
71: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
72: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
73: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;

Line 70: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;

66: G_TH_Attribute1 fa_mass_Ext_retirements.TH_Attribute1%TYPE;
67: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
68: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
69: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
70: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
71: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
72: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
73: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
74: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;

Line 71: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;

67: G_TH_Attribute2 fa_mass_Ext_retirements.TH_Attribute2%TYPE;
68: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
69: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
70: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
71: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
72: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
73: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
74: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
75: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;

Line 72: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;

68: G_TH_Attribute3 fa_mass_Ext_retirements.TH_Attribute3%TYPE;
69: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
70: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
71: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
72: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
73: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
74: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
75: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
76: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;

Line 73: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;

69: G_TH_Attribute4 fa_mass_Ext_retirements.TH_Attribute4%TYPE;
70: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
71: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
72: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
73: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
74: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
75: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
76: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
77: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;

Line 74: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;

70: G_TH_Attribute5 fa_mass_Ext_retirements.TH_Attribute5%TYPE;
71: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
72: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
73: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
74: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
75: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
76: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
77: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
78: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;

Line 75: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;

71: G_TH_Attribute6 fa_mass_Ext_retirements.TH_Attribute6%TYPE;
72: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
73: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
74: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
75: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
76: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
77: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
78: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
79: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;

Line 76: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;

72: G_TH_Attribute7 fa_mass_Ext_retirements.TH_Attribute7%TYPE;
73: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
74: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
75: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
76: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
77: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
78: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
79: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
80: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;

Line 77: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;

73: G_TH_Attribute8 fa_mass_Ext_retirements.TH_Attribute8%TYPE;
74: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
75: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
76: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
77: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
78: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
79: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
80: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
81: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;

Line 78: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;

74: G_TH_Attribute9 fa_mass_Ext_retirements.TH_Attribute9%TYPE;
75: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
76: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
77: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
78: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
79: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
80: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
81: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
82: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;

Line 79: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;

75: G_TH_Attribute10 fa_mass_Ext_retirements.TH_Attribute10%TYPE;
76: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
77: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
78: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
79: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
80: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
81: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
82: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
83: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;

Line 80: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;

76: G_TH_Attribute11 fa_mass_Ext_retirements.TH_Attribute11%TYPE;
77: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
78: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
79: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
80: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
81: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
82: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
83: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
84: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;

Line 81: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;

77: G_TH_Attribute12 fa_mass_Ext_retirements.TH_Attribute12%TYPE;
78: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
79: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
80: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
81: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
82: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
83: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
84: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
85: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;

Line 82: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;

78: G_TH_Attribute13 fa_mass_Ext_retirements.TH_Attribute13%TYPE;
79: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
80: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
81: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
82: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
83: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
84: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
85: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
86: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;

Line 83: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;

79: G_TH_Attribute14 fa_mass_Ext_retirements.TH_Attribute14%TYPE;
80: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
81: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
82: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
83: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
84: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
85: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
86: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
87: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;

Line 84: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;

80: G_TH_Attribute15 fa_mass_Ext_retirements.TH_Attribute15%TYPE;
81: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
82: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
83: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
84: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
85: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
86: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
87: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
88: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;

Line 85: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;

81: G_Attribute_Category fa_mass_Ext_retirements.Attribute_Category%TYPE;
82: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
83: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
84: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
85: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
86: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
87: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
88: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
89: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;

Line 86: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;

82: G_Attribute1 fa_mass_Ext_retirements.Attribute1%TYPE;
83: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
84: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
85: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
86: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
87: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
88: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
89: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
90: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;

Line 87: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;

83: G_Attribute2 fa_mass_Ext_retirements.Attribute2%TYPE;
84: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
85: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
86: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
87: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
88: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
89: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
90: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
91: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;

Line 88: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;

84: G_Attribute3 fa_mass_Ext_retirements.Attribute3%TYPE;
85: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
86: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
87: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
88: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
89: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
90: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
91: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
92: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;

Line 89: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;

85: G_Attribute4 fa_mass_Ext_retirements.Attribute4%TYPE;
86: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
87: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
88: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
89: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
90: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
91: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
92: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
93: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;

Line 90: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;

86: G_Attribute5 fa_mass_Ext_retirements.Attribute5%TYPE;
87: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
88: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
89: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
90: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
91: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
92: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
93: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
94: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;

Line 91: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;

87: G_Attribute6 fa_mass_Ext_retirements.Attribute6%TYPE;
88: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
89: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
90: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
91: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
92: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
93: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
94: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
95: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;

Line 92: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;

88: G_Attribute7 fa_mass_Ext_retirements.Attribute7%TYPE;
89: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
90: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
91: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
92: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
93: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
94: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
95: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;
96: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;

Line 93: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;

89: G_Attribute8 fa_mass_Ext_retirements.Attribute8%TYPE;
90: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
91: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
92: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
93: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
94: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
95: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;
96: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;
97:

Line 94: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;

90: G_Attribute9 fa_mass_Ext_retirements.Attribute9%TYPE;
91: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
92: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
93: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
94: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
95: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;
96: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;
97:
98: /* End of bug 1300585*/

Line 95: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;

91: G_Attribute10 fa_mass_Ext_retirements.Attribute10%TYPE;
92: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
93: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
94: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
95: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;
96: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;
97:
98: /* End of bug 1300585*/
99:

Line 96: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;

92: G_Attribute11 fa_mass_Ext_retirements.Attribute11%TYPE;
93: G_Attribute12 fa_mass_Ext_retirements.Attribute12%TYPE;
94: G_Attribute13 fa_mass_Ext_retirements.Attribute13%TYPE;
95: G_Attribute14 fa_mass_Ext_retirements.Attribute14%TYPE;
96: G_Attribute15 fa_mass_Ext_retirements.Attribute15%TYPE;
97:
98: /* End of bug 1300585*/
99:
100: G_fatal_error boolean := FALSE;

Line 192: FROM fa_mass_Ext_retirements mer,

188: mer.recognize_gain_loss,/*Bug 8647381 *//* Bug 8483118(R12) and 8206076(11i) - Start */
189: bks.recapture_reserve_flag,
190: bks.limit_proceeds_flag,
191: bks.terminal_gain_loss /* Bug 8483118(R12) and 8206076(11i) - End */
192: FROM fa_mass_Ext_retirements mer,
193: fa_books bks,
194: fa_additions_b ad,
195: fa_book_controls fbc,
196: gl_sets_of_books sob

Line 404: from fa_mass_ext_retirements

400:
401: Cursor c_dhident is
402: select nvl(count(*),0)
403: into g_test_ident_distributions
404: from fa_mass_ext_retirements
405: where batch_name = G_batch_name
406: and review_status = 'POST'
407: and asset_id = g_asset_id
408: group by code_combination_id, location_id, assigned_to

Line 792: from fa_mass_ext_retirements

788:
789:
790: select count(*)
791: into g_num_of_distributions
792: from fa_mass_ext_retirements
793: where batch_name = G_batch_name
794: and review_status = 'POST'
795: and asset_id = g_asset_id
796: and code_combination_id is not null

Line 811: from fa_mass_ext_retirements

807: g_single_dist_array := 'NO';
808:
809: select count(*)
810: into g_num_of_identical
811: from fa_mass_ext_retirements
812: where batch_name = G_batch_name
813: and review_status = 'POST'
814: and asset_id = g_asset_id
815: and code_combination_id is not null;

Line 1291: UPDATE fa_mass_Ext_retirements

1287: END IF;
1288:
1289: end if; -- num_of_distribution
1290:
1291: UPDATE fa_mass_Ext_retirements
1292: SET review_status = 'POSTED',
1293: -- bugfix 2442439 retirement_id = lv_ret_id
1294: retirement_id = l_asset_retire_rec.retirement_id,
1295: last_update_date = sysdate,

Line 1320: UPDATE fa_mass_Ext_retirements

1316: if (g_log_level_rec.statement_level) then
1317: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1318: end if;
1319:
1320: UPDATE fa_mass_Ext_retirements
1321: SET review_status = 'ERROR',
1322: last_update_date = sysdate,
1323: last_updated_by = fnd_global.user_id,
1324: last_update_login = fnd_global.login_id

Line 1352: UPDATE fa_mass_Ext_retirements

1348: if(g_log_level_rec.statement_level) then
1349: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1350: end if;
1351:
1352: UPDATE fa_mass_Ext_retirements
1353: SET review_status = 'ERROR',
1354: last_update_date = sysdate,
1355: last_updated_by = fnd_global.user_id,
1356: last_update_login = fnd_global.login_id

Line 1395: UPDATE fa_mass_Ext_retirements

1391: if(g_log_level_rec.statement_level) then
1392: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1393: end if;
1394:
1395: UPDATE fa_mass_Ext_retirements
1396: SET review_status = 'ERROR',
1397: last_update_date = sysdate,
1398: last_updated_by = fnd_global.user_id,
1399: last_update_login = fnd_global.login_id

Line 1425: UPDATE fa_mass_Ext_retirements

1421: if(g_log_level_rec.statement_level) then
1422: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1423: end if;
1424:
1425: UPDATE fa_mass_Ext_retirements
1426: SET review_status = 'ERROR',
1427: last_update_date = sysdate,
1428: last_updated_by = fnd_global.user_id,
1429: last_update_login = fnd_global.login_id

Line 1491: UPDATE fa_mass_Ext_retirements

1487: WHEN pending_batch THEN
1488:
1489: FND_CONCURRENT.AF_COMMIT;
1490:
1491: UPDATE fa_mass_Ext_retirements
1492: SET review_status = 'ERROR',
1493: last_update_date = sysdate,
1494: last_updated_by = fnd_global.user_id,
1495: last_update_login = fnd_global.login_id

Line 1580: from fa_mass_ext_retirements

1576: RETCODE OUT NOCOPY VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1577:
1578: Cursor Assets_C is
1579: select Mass_External_Retire_ID
1580: from fa_mass_ext_retirements
1581: where review_status in ('DELETE','POSTED')
1582: for update nowait;
1583:
1584: LV_Mass_External_Retire_ID NUMBER;

Line 1603: Delete from fa_mass_ext_retirements

1599: Delete from fa_ext_inv_retirements
1600: where mass_external_retire_id = LV_Mass_External_Retire_ID;
1601: end if;
1602:
1603: Delete from fa_mass_ext_retirements
1604: where mass_external_retire_id = LV_Mass_External_Retire_ID;
1605:
1606: End Loop;
1607: