DBA Data[Home] [Help]

APPS.PA_YEAR_END_ROLLOVER_PKG dependencies on GL_SETS_OF_BOOKS

Line 172: l_Accounted_Period_Type GL_Sets_Of_Books.Accounted_Period_Type%TYPE;

168: l_UnSwept_Amount NUMBER;
169: l_Amount_with_no_budgetline NUMBER; /*Bug: 13598400 Added to hold the PA BC BALANCE amount which has no budget line in budget matrix */
170: l_Funds_Chk_Rsrv_Status VARCHAR2(1);
171:
172: l_Accounted_Period_Type GL_Sets_Of_Books.Accounted_Period_Type%TYPE;
173: l_New_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;
174: l_Work_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;
175: l_Work_Resource_Assign_ID PA_Resource_Assignments.Resource_Assignment_ID%TYPE;
176: l_Bslnd_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;

Line 192: l_Set_Of_Books_ID GL_Sets_Of_Books.Set_Of_Books_ID%TYPE;

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

Line 362: FROM GL_Sets_Of_Books

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

Line 1434: P_Set_Of_Books_ID IN GL_Sets_Of_Books.Set_Of_Books_ID%TYPE,

1430: -- first period details of a next year
1431: -------------------------------------------------------------------------------------
1432: PROCEDURE Get_Period_Details (
1433: P_Fiscal_Year IN NUMBER,
1434: P_Set_Of_Books_ID IN GL_Sets_Of_Books.Set_Of_Books_ID%TYPE,
1435: P_Accounted_Period_Type IN GL_Sets_Of_Books.Accounted_Period_Type%TYPE,
1436: X_Cur_Yr_Last_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1437: X_Cur_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1438: X_Cur_Yr_Last_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,

Line 1435: P_Accounted_Period_Type IN GL_Sets_Of_Books.Accounted_Period_Type%TYPE,

1431: -------------------------------------------------------------------------------------
1432: PROCEDURE Get_Period_Details (
1433: P_Fiscal_Year IN NUMBER,
1434: P_Set_Of_Books_ID IN GL_Sets_Of_Books.Set_Of_Books_ID%TYPE,
1435: P_Accounted_Period_Type IN GL_Sets_Of_Books.Accounted_Period_Type%TYPE,
1436: X_Cur_Yr_Last_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1437: X_Cur_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1438: X_Cur_Yr_Last_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1439: X_Cur_Yr_Last_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,