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_BUDGET_VERSIONS

Line 29: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,

25: -------------------------------------------------------------------------------------
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,

Line 144: P_Closing_Year IN NUMBER, -- PA_Budget_Versions.Closing_Year%TYPE ?

140: END Upd_Ins_Budget_Acct_Line;
141:
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,

Line 172: l_New_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;

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;
176: l_Project_ID PA_Projects_all.Project_ID%TYPE;

Line 173: l_Work_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;

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;
176: l_Project_ID PA_Projects_all.Project_ID%TYPE;
177: l_Project_Completion_Date DATE;

Line 175: l_Bslnd_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;

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;
176: l_Project_ID PA_Projects_all.Project_ID%TYPE;
177: l_Project_Completion_Date DATE;
178: l_Task_ID PA_Tasks.Task_ID%TYPE;
179: l_Budget_Type_Code PA_Budget_Types.Budget_Type_Code%TYPE;

Line 242: PA_Budget_Versions BV,

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

Line 691: PA_Budget_Versions BV,

687: RA.Resource_Assignment_ID
688: INTO
689: l_Work_Resource_Assign_ID
690: FROM
691: PA_Budget_Versions BV,
692: PA_Resource_Assignments RA
693: WHERE
694: RA.resource_list_member_id = l_Resource_List_Member_ID
695: AND RA.Budget_Version_ID = l_Work_Budget_Version_ID

Line 1009: FROM PA_Budget_Versions

1005: -- Get the latest Baselined Budget Version ID
1006: BEGIN
1007: SELECT Budget_Version_ID
1008: INTO l_New_Budget_Version_ID
1009: FROM PA_Budget_Versions
1010: WHERE Project_ID = l_Project_ID
1011: AND Budget_Type_Code = l_Budget_Type_Code
1012: AND Current_Flag = 'Y'
1013: AND Budget_Status_Code = 'B';

Line 1236: UPDATE PA_Budget_Versions

1232: log_message('Year_End_Rollover: ' || 'Updated Budget Version Record');
1233: END IF;
1234:
1235: l_Change_Reason_Code := 'YEAR END BUDGET ROLLOVER';
1236: UPDATE PA_Budget_Versions
1237: SET Change_Reason_Code = l_Change_Reason_Code
1238: WHERE Budget_Version_ID = l_New_Budget_Version_ID ;
1239:
1240: IF SQL%ROWCOUNT = 0 THEN

Line 1545: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,

1541: -------------------------------------------------------------------------------------
1542: -- Update / Insert into PA_BUDGET_LINES
1543: -------------------------------------------------------------------------------------
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,

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

1615:
1616: BEGIN
1617: SELECT Projfunc_Currency_Code
1618: INTO l_Txn_Curr_Code
1619: FROM PA_Projects_All a, PA_Budget_Versions b, PA_Resource_Assignments c
1620: WHERE a.Project_Id = b.Project_Id
1621: AND b.Budget_Version_Id = c.Budget_Version_Id
1622: AND c.Resource_Assignment_Id = P_Resource_Assignment_Id;
1623: EXCEPTION

Line 1759: PA_Budget_Versions

1755: to be called to maintain MRC in budgets */
1756:
1757: -- Updating Budget Version Amounts
1758: UPDATE
1759: PA_Budget_Versions
1760: SET
1761: Raw_Cost = NVL(Raw_Cost,0) - l_Raw_Transfer_Amount,
1762: Burdened_Cost = NVL(Burdened_Cost,0) - l_Burdened_Transfer_Amount
1763: WHERE

Line 1784: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,

1780: -----------------------------------------------------------------------------------
1781: PROCEDURE Create_Working_Budget (
1782: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1783: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
1784: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
1785: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,
1786: X_Work_Budget_Version_ID OUT NOCOPY PA_Budget_Versions.Budget_Version_ID%TYPE,
1787: X_Return_Status OUT NOCOPY VARCHAR2,
1788: X_Msg_Count OUT NOCOPY NUMBER,

Line 1786: X_Work_Budget_Version_ID OUT NOCOPY PA_Budget_Versions.Budget_Version_ID%TYPE,

1782: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1783: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
1784: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
1785: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,
1786: X_Work_Budget_Version_ID OUT NOCOPY PA_Budget_Versions.Budget_Version_ID%TYPE,
1787: X_Return_Status OUT NOCOPY VARCHAR2,
1788: X_Msg_Count OUT NOCOPY NUMBER,
1789: X_Msg_Data OUT NOCOPY VARCHAR2
1790: )

Line 1794: l_Work_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;

1790: )
1791: IS
1792:
1793: -- Local Variables
1794: l_Work_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;
1795: l_Lock_Name VARCHAR2(100);
1796:
1797: l_Exist_Flag NUMBER;
1798:

Line 1827: PA_Budget_Versions

1823: 1
1824: INTO
1825: l_Exist_Flag
1826: FROM
1827: PA_Budget_Versions
1828: WHERE
1829: Project_ID = P_Project_ID
1830: AND Budget_Type_Code = P_Budget_Type_Code
1831: AND Budget_Status_Code = 'W' ;

Line 1938: PA_BUDGET_VERSIONS

1934: Budget_Version_ID
1935: INTO
1936: X_Work_Budget_Version_ID
1937: FROM
1938: PA_BUDGET_VERSIONS
1939: WHERE
1940: Project_ID = P_Project_ID
1941: AND Budget_Type_Code = P_Budget_Type_Code
1942: AND Budget_Status_Code = 'W';

Line 2165: pa_budget_versions pbv

2161: from pa_budget_lines pb,
2162: pa_resource_assignments pa,
2163: pa_tasks pt,
2164: pa_resource_list_members rm,
2165: pa_budget_versions pbv
2166: where pbv.budget_version_id = p_budget_version_id
2167: and pa.resource_assignment_id = pb.resource_assignment_id
2168: and pa.task_id = pt.task_id (+)
2169: and pa.budget_version_id = pbv.budget_version_id

Line 2243: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,

2239: -------------------------------------------------------------------------------------
2240: -- Update the message name for a Budget Version that was failed due to some reason
2241: -------------------------------------------------------------------------------------
2242: PROCEDURE Year_End_Rollover_Log (
2243: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
2244: P_Message_Name IN FND_New_Messages.Message_Name%TYPE,
2245: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,
2246: P_Lock_Name IN VARCHAR2
2247: )

Line 2280: PA_Budget_Versions

2276: INTO
2277: l_Project_ID,
2278: l_Budget_Type_Code
2279: FROM
2280: PA_Budget_Versions
2281: WHERE
2282: Budget_Version_ID = P_Budget_Version_ID;
2283: EXCEPTION
2284: WHEN NO_DATA_FOUND THEN

Line 2286: log_message('Year_End_Rollover: ' || 'No Data Found in PA_Budget_Versions');

2282: Budget_Version_ID = P_Budget_Version_ID;
2283: EXCEPTION
2284: WHEN NO_DATA_FOUND THEN
2285: IF P_DEBUG_MODE = 'Y' THEN
2286: log_message('Year_End_Rollover: ' || 'No Data Found in PA_Budget_Versions');
2287: END IF;
2288: END;
2289:
2290: -- Update the Budget Version record