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.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 192: l_Cur_Yr_Last_Prd_Name GL_Periods.Period_Name%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;
196: l_Next_Yr_First_Prd_Name GL_Periods.Period_Name%TYPE;

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

Line 194: l_Cur_Yr_Last_Prd_Start_Dt GL_Periods.Start_Date%TYPE;

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

Line 195: l_Cur_Yr_Last_Prd_End_Dt GL_Periods.End_Date%TYPE;

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

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

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

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

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

1018: l_Message_Name := 'PA_BC_BASLN_BDGT_ERR';
1019: RAISE l_SUBMIT_BASELINE_ERR;
1020: END;
1021:
1022: -- ## Call Budget account generator ..to insert the zero $ budget lines (for missed GL periods)
1023: -- ## and generate the acccount for these lines
1024: -- ## Note: Use Gen_Acct_All_Lines which is a non-autonomous procedure as the
1025: -- ## baselined budget is not saved yet.
1026:

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

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

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

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

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

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,
1383: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1384: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1385: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,

Line 1382: X_Cur_Yr_Last_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%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,
1383: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1384: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1385: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,
1386: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1383: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%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,
1383: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1384: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1385: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,
1386: X_Return_Status OUT NOCOPY VARCHAR2,
1387: X_Msg_Count OUT NOCOPY NUMBER,

Line 1384: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%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,
1383: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1384: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1385: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,
1386: X_Return_Status OUT NOCOPY VARCHAR2,
1387: X_Msg_Count OUT NOCOPY NUMBER,
1388: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1385: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_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,
1383: X_Next_Yr_First_Prd_Name OUT NOCOPY GL_Periods.Period_Name%TYPE,
1384: X_Next_Yr_First_Prd_Start_Dt OUT NOCOPY GL_Periods.Start_Date%TYPE,
1385: X_Next_Yr_First_Prd_End_Dt OUT NOCOPY GL_Periods.End_Date%TYPE,
1386: X_Return_Status OUT NOCOPY VARCHAR2,
1387: X_Msg_Count OUT NOCOPY NUMBER,
1388: X_Msg_Data OUT NOCOPY VARCHAR2
1389: )

Line 1548: P_Period_Name IN GL_Periods.Period_Name%TYPE,

1544: PROCEDURE Upd_Ins_Budget_Line (
1545: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
1546: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
1547: P_Resource_Assignment_ID IN OUT NOCOPY PA_Resource_Assignments.Resource_Assignment_ID%TYPE,
1548: P_Period_Name IN GL_Periods.Period_Name%TYPE,
1549: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
1550: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
1551: P_Transfer_Amount IN NUMBER,
1552: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,

Line 1549: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,

1545: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
1546: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
1547: P_Resource_Assignment_ID IN OUT NOCOPY PA_Resource_Assignments.Resource_Assignment_ID%TYPE,
1548: P_Period_Name IN GL_Periods.Period_Name%TYPE,
1549: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
1550: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
1551: P_Transfer_Amount IN NUMBER,
1552: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1553: P_Task_ID IN PA_Tasks.Task_ID%TYPE,

Line 1550: P_Period_End_Date IN GL_Periods.End_Date%TYPE,

1546: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
1547: P_Resource_Assignment_ID IN OUT NOCOPY PA_Resource_Assignments.Resource_Assignment_ID%TYPE,
1548: P_Period_Name IN GL_Periods.Period_Name%TYPE,
1549: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
1550: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
1551: P_Transfer_Amount IN NUMBER,
1552: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1553: P_Task_ID IN PA_Tasks.Task_ID%TYPE,
1554: P_Resource_List_Member_ID IN PA_Resource_List_Members.Resource_List_Member_ID%TYPE,