14: x_return_status OUT NOCOPY NUMBER) IS
15:
16: -- Local Variables holding Mass Retirements Information
17: l_Retirement_Rowid VARCHAR2(30);
18: l_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
19: l_Reinstate_Request_Id fa_mass_retirements.Reinstate_Request_Id%TYPE;
20: l_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
21: l_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
22:
15:
16: -- Local Variables holding Mass Retirements Information
17: l_Retirement_Rowid VARCHAR2(30);
18: l_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
19: l_Reinstate_Request_Id fa_mass_retirements.Reinstate_Request_Id%TYPE;
20: l_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
21: l_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
22:
23: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
16: -- Local Variables holding Mass Retirements Information
17: l_Retirement_Rowid VARCHAR2(30);
18: l_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
19: l_Reinstate_Request_Id fa_mass_retirements.Reinstate_Request_Id%TYPE;
20: l_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
21: l_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
22:
23: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
24: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
17: l_Retirement_Rowid VARCHAR2(30);
18: l_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
19: l_Reinstate_Request_Id fa_mass_retirements.Reinstate_Request_Id%TYPE;
20: l_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
21: l_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
22:
23: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
24: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
25:
67: fmr.retire_request_id,
68: fmr.book_type_code,
69: ffy.start_date,
70: ffy.end_date
71: FROM fa_mass_retirements fmr,
72: fa_book_controls fbc,
73: fa_fiscal_year ffy
74: WHERE fmr.mass_retirement_id = p_Mass_Retirement_Id
75: AND fmr.book_type_code = fbc.book_type_code