DBA Data[Home] [Help]

APPS.PA_YEAR_END_ROLLOVER_PKG dependencies on GL_PERIODS

Line 30: P_Period_Name IN GL_Periods.Period_Name%TYPE,

26: -- Insert/Update the Budget Summary Account details
27: -------------------------------------------------------------------------------------
28: PROCEDURE Upd_Ins_Budget_Acct_Line (
29: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
30: P_Period_Name IN GL_Periods.Period_Name%TYPE,
31: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
32: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
33: P_Transfer_Amount IN NUMBER,
34: P_CCID IN GL_Code_Combinations.Code_Combination_ID%TYPE,

Line 31: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,

27: -------------------------------------------------------------------------------------
28: PROCEDURE Upd_Ins_Budget_Acct_Line (
29: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
30: P_Period_Name IN GL_Periods.Period_Name%TYPE,
31: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
32: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
33: P_Transfer_Amount IN NUMBER,
34: P_CCID IN GL_Code_Combinations.Code_Combination_ID%TYPE,
35: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,

Line 32: P_Period_End_Date IN GL_Periods.End_Date%TYPE,

28: PROCEDURE Upd_Ins_Budget_Acct_Line (
29: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
30: P_Period_Name IN GL_Periods.Period_Name%TYPE,
31: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
32: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
33: P_Transfer_Amount IN NUMBER,
34: P_CCID IN GL_Code_Combinations.Code_Combination_ID%TYPE,
35: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,
36: X_Return_Status OUT NOCOPY VARCHAR2,

Line 193: l_Cur_Yr_Last_Prd_Name GL_Periods.Period_Name%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;
197: l_Next_Yr_First_Prd_Name GL_Periods.Period_Name%TYPE;

Line 194: l_Cur_Yr_First_Prd_Start_Dt GL_Periods.Start_Date%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;
197: l_Next_Yr_First_Prd_Name GL_Periods.Period_Name%TYPE;
198: l_Next_Yr_First_Prd_Start_Dt GL_Periods.Start_Date%TYPE;

Line 195: l_Cur_Yr_Last_Prd_Start_Dt GL_Periods.Start_Date%TYPE;

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;
197: l_Next_Yr_First_Prd_Name GL_Periods.Period_Name%TYPE;
198: l_Next_Yr_First_Prd_Start_Dt GL_Periods.Start_Date%TYPE;
199: l_Next_Yr_First_Prd_End_Dt GL_Periods.End_Date%TYPE;

Line 196: l_Cur_Yr_Last_Prd_End_Dt GL_Periods.End_Date%TYPE;

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;
197: l_Next_Yr_First_Prd_Name GL_Periods.Period_Name%TYPE;
198: l_Next_Yr_First_Prd_Start_Dt GL_Periods.Start_Date%TYPE;
199: l_Next_Yr_First_Prd_End_Dt GL_Periods.End_Date%TYPE;
200:

Line 197: l_Next_Yr_First_Prd_Name GL_Periods.Period_Name%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;
197: l_Next_Yr_First_Prd_Name GL_Periods.Period_Name%TYPE;
198: l_Next_Yr_First_Prd_Start_Dt GL_Periods.Start_Date%TYPE;
199: l_Next_Yr_First_Prd_End_Dt GL_Periods.End_Date%TYPE;
200:
201:

Line 198: l_Next_Yr_First_Prd_Start_Dt GL_Periods.Start_Date%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;
197: l_Next_Yr_First_Prd_Name GL_Periods.Period_Name%TYPE;
198: l_Next_Yr_First_Prd_Start_Dt GL_Periods.Start_Date%TYPE;
199: l_Next_Yr_First_Prd_End_Dt GL_Periods.End_Date%TYPE;
200:
201:
202: l_Return_Status VARCHAR2(100);

Line 199: l_Next_Yr_First_Prd_End_Dt GL_Periods.End_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;
197: l_Next_Yr_First_Prd_Name GL_Periods.Period_Name%TYPE;
198: l_Next_Yr_First_Prd_Start_Dt GL_Periods.Start_Date%TYPE;
199: l_Next_Yr_First_Prd_End_Dt GL_Periods.End_Date%TYPE;
200:
201:
202: l_Return_Status VARCHAR2(100);
203: l_Msg_Count NUMBER;

Line 1079: -- ## Call Budget account generator ..to insert the zero $ budget lines (for missed GL periods)

1075: l_Message_Name := 'PA_BC_BASLN_BDGT_ERR';
1076: RAISE l_SUBMIT_BASELINE_ERR;
1077: END;
1078:
1079: -- ## Call Budget account generator ..to insert the zero $ budget lines (for missed GL periods)
1080: -- ## and generate the acccount for these lines
1081: -- ## Note: Use Gen_Acct_All_Lines which is a non-autonomous procedure as the
1082: -- ## baselined budget is not saved yet.
1083:

Line 1436: X_Cur_Yr_Last_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,

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,
1440: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,

Line 1437: X_Cur_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,

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,
1440: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1441: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,

Line 1438: X_Cur_Yr_Last_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,

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,
1440: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1441: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1442: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,

Line 1439: X_Cur_Yr_Last_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%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,
1440: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1441: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1442: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,
1443: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1440: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%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,
1440: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1441: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1442: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,
1443: X_Return_Status OUT NOCOPY VARCHAR2,
1444: X_Msg_Count OUT NOCOPY NUMBER,

Line 1441: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%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,
1440: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1441: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1442: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,
1443: X_Return_Status OUT NOCOPY VARCHAR2,
1444: X_Msg_Count OUT NOCOPY NUMBER,
1445: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1442: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_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,
1440: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1441: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1442: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,
1443: X_Return_Status OUT NOCOPY VARCHAR2,
1444: X_Msg_Count OUT NOCOPY NUMBER,
1445: X_Msg_Data OUT NOCOPY VARCHAR2
1446: )

Line 1605: P_Period_Name IN GL_Periods.Period_Name%TYPE,

1601: PROCEDURE Upd_Ins_Budget_Line (
1602: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
1603: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
1604: P_Resource_Assignment_ID IN OUT NOCOPY PA_Resource_Assignments.Resource_Assignment_ID%TYPE,
1605: P_Period_Name IN GL_Periods.Period_Name%TYPE,
1606: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
1607: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
1608: P_Transfer_Amount IN NUMBER,
1609: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,

Line 1606: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,

1602: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
1603: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
1604: P_Resource_Assignment_ID IN OUT NOCOPY PA_Resource_Assignments.Resource_Assignment_ID%TYPE,
1605: P_Period_Name IN GL_Periods.Period_Name%TYPE,
1606: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
1607: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
1608: P_Transfer_Amount IN NUMBER,
1609: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1610: P_Task_ID IN PA_Tasks.Task_ID%TYPE,

Line 1607: P_Period_End_Date IN GL_Periods.End_Date%TYPE,

1603: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
1604: P_Resource_Assignment_ID IN OUT NOCOPY PA_Resource_Assignments.Resource_Assignment_ID%TYPE,
1605: P_Period_Name IN GL_Periods.Period_Name%TYPE,
1606: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
1607: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
1608: P_Transfer_Amount IN NUMBER,
1609: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1610: P_Task_ID IN PA_Tasks.Task_ID%TYPE,
1611: P_Resource_List_Member_ID IN PA_Resource_List_Members.Resource_List_Member_ID%TYPE,