APPS.PA_YEAR_END_ROLLOVER_PKG dependencies on GL_SETS_OF_BOOKS

Line 171: l_Accounted_Period_Type GL_Sets_Of_Books.Accounted_Period_Type%TYPE;

167: l_Transfer_Amount NUMBER;
168: l_UnSwept_Amount NUMBER;
169: l_Funds_Chk_Rsrv_Status VARCHAR2(1);
170:
171: l_Accounted_Period_Type GL_Sets_Of_Books.Accounted_Period_Type%TYPE;
172: l_New_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;
173: l_Work_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;
174: l_Work_Resource_Assign_ID PA_Resource_Assignments.Resource_Assignment_ID%TYPE;
175: l_Bslnd_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;

Line 191: l_Set_Of_Books_ID GL_Sets_Of_Books.Set_Of_Books_ID%TYPE;

187: l_CCID GL_Code_Combinations.Code_Combination_ID%TYPE;
188: l_New_CCID GL_Code_Combinations.Code_Combination_ID%TYPE;
189:
190: --
191: l_Set_Of_Books_ID GL_Sets_Of_Books.Set_Of_Books_ID%TYPE;
192: l_Cur_Yr_Last_Prd_Name GL_Periods.Period_Name%TYPE;
193: l_Cur_Yr_First_Prd_Start_Dt GL_Periods.Start_Date%TYPE;
194: l_Cur_Yr_Last_Prd_Start_Dt GL_Periods.Start_Date%TYPE;
195: l_Cur_Yr_Last_Prd_End_Dt GL_Periods.End_Date%TYPE;

Line 361: FROM GL_Sets_Of_Books

357: END IF;
358:
359: SELECT Accounted_Period_Type
360: INTO l_Accounted_Period_Type
361: FROM GL_Sets_Of_Books
362: WHERE Set_Of_Books_ID = l_Set_Of_Books_ID ;
363:
364: IF P_DEBUG_MODE = 'Y' THEN
365: log_message('Year_End_Rollover: ' || 'Accounted Period Type : ' || l_Accounted_Period_Type);

Line 1377: P_Set_Of_Books_ID IN GL_Sets_Of_Books.Set_Of_Books_ID%TYPE,

1373: -- first period details of a next year
1374: -------------------------------------------------------------------------------------
1375: PROCEDURE Get_Period_Details (
1376: P_Fiscal_Year IN NUMBER,
1377: P_Set_Of_Books_ID IN GL_Sets_Of_Books.Set_Of_Books_ID%TYPE,
1378: P_Accounted_Period_Type IN GL_Sets_Of_Books.Accounted_Period_Type%TYPE,
1379: X_Cur_Yr_Last_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1380: X_Cur_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1381: X_Cur_Yr_Last_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,

Line 1378: P_Accounted_Period_Type IN GL_Sets_Of_Books.Accounted_Period_Type%TYPE,

1374: -------------------------------------------------------------------------------------
1375: PROCEDURE Get_Period_Details (
1376: P_Fiscal_Year IN NUMBER,
1377: P_Set_Of_Books_ID IN GL_Sets_Of_Books.Set_Of_Books_ID%TYPE,
1378: P_Accounted_Period_Type IN GL_Sets_Of_Books.Accounted_Period_Type%TYPE,
1379: X_Cur_Yr_Last_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1380: X_Cur_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1381: X_Cur_Yr_Last_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1382: X_Cur_Yr_Last_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,