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 PA_PROJECTS

Line 146: P_From_Project_Number IN PA_Projects_All.Segment1%TYPE,

142: -- -------------------------------------------------------------------------------------------------+
143: PROCEDURE Year_End_Rollover (
144: P_Closing_Year IN NUMBER, -- PA_Budget_Versions.Closing_Year%TYPE ?
145: P_Organization_ID IN PA_Organizations_V.Organization_ID%TYPE,
146: P_From_Project_Number IN PA_Projects_All.Segment1%TYPE,
147: P_To_Project_Number IN PA_Projects_All.Segment1%TYPE,
148: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,
149: X_Return_Status OUT NOCOPY VARCHAR2,
150: X_Msg_Count OUT NOCOPY NUMBER,

Line 147: P_To_Project_Number IN PA_Projects_All.Segment1%TYPE,

143: PROCEDURE Year_End_Rollover (
144: P_Closing_Year IN NUMBER, -- PA_Budget_Versions.Closing_Year%TYPE ?
145: P_Organization_ID IN PA_Organizations_V.Organization_ID%TYPE,
146: P_From_Project_Number IN PA_Projects_All.Segment1%TYPE,
147: P_To_Project_Number IN PA_Projects_All.Segment1%TYPE,
148: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,
149: X_Return_Status OUT NOCOPY VARCHAR2,
150: X_Msg_Count OUT NOCOPY NUMBER,
151: X_Msg_Data OUT NOCOPY VARCHAR2

Line 177: l_Project_ID PA_Projects_all.Project_ID%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;
177: l_Project_ID PA_Projects_all.Project_ID%TYPE;
178: l_Project_Completion_Date DATE;
179: l_Task_ID PA_Tasks.Task_ID%TYPE;
180: l_Budget_Type_Code PA_Budget_Types.Budget_Type_Code%TYPE;
181: l_Encumbrance_Type_ID GL_Encumbrance_Types.Encumbrance_Type_ID%TYPE;

Line 242: PA_Projects PROJ,

238: BEM.Entry_Level_Code Entry_Level_Code,
239: BCO.Balance_type Balance_Type
240: FROM
241: PA_Budgetary_Control_Options BCO,
242: PA_Projects PROJ,
243: PA_Budget_Versions BV,
244: PA_Budget_Entry_Methods BEM
245: WHERE
246: PROJ.Carrying_Out_organization_id =

Line 1609: P_Project_ID IN PA_Projects_all.Project_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,
1612: P_Raw_Cost_Flag IN PA_Budget_Entry_Methods.Raw_Cost_Flag%TYPE,
1613: P_Burdened_Cost_Flag IN PA_Budget_Entry_Methods.Burdened_Cost_Flag%TYPE,

Line 1676: FROM PA_Projects_All a, PA_Budget_Versions b, PA_Resource_Assignments c

1672:
1673: BEGIN
1674: SELECT Projfunc_Currency_Code
1675: INTO l_Txn_Curr_Code
1676: FROM PA_Projects_All a, PA_Budget_Versions b, PA_Resource_Assignments c
1677: WHERE a.Project_Id = b.Project_Id
1678: AND b.Budget_Version_Id = c.Budget_Version_Id
1679: AND c.Resource_Assignment_Id = P_Resource_Assignment_Id;
1680: EXCEPTION

Line 1839: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,

1835: -----------------------------------------------------------------------------------
1836: -- Create a Draft version of a Baselined Budget
1837: -----------------------------------------------------------------------------------
1838: PROCEDURE Create_Working_Budget (
1839: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1840: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
1841: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
1842: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,
1843: X_Work_Budget_Version_ID OUT NOCOPY PA_Budget_Versions.Budget_Version_ID%TYPE,

Line 2309: l_Project_ID PA_Projects_all.Project_ID%TYPE;

2305: IS
2306:
2307: -- Local Values
2308: l_Lock_Result NUMBER;
2309: l_Project_ID PA_Projects_all.Project_ID%TYPE;
2310: l_Budget_Type_Code PA_Budget_Types.Budget_Type_Code%TYPE;
2311:
2312: BEGIN
2313:

Line 2393: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,

2389: /* This function checks if PA_Budgetary_Control_Options.Yr_End_Rollover_Flag
2390: is already set to 'P' for the given Project and Budget Type combination.
2391: If yes, the function returns TRUE. Otherwise, the function returns FALSE */
2392: FUNCTION Is_Yr_End_Rollover_Running(
2393: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
2394: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE
2395: ) RETURN BOOLEAN
2396: IS
2397: l_Yr_End_Rollover_Flag PA_Budgetary_Control_Options.Yr_End_Rollover_Flag%TYPE := NULL;

Line 2416: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,

2412: /* This procedure updates PA_Budgetary_Control_Options.Yr_End_Rollover_Flag to 'P'
2413: in an autonomous transaction */
2414: PROCEDURE Upd_Yr_End_Rollover_Flag_To_P(
2415: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,
2416: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
2417: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE
2418: )
2419: IS
2420: PRAGMA AUTONOMOUS_TRANSACTION;