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_LINES

Line 276: PA_Budget_Lines BL,

272: ( BCBL.Actual_Period_To_Date + BCBL.Encumb_Period_To_Date) ) Transfer_Amount,
273: MAX(BL.START_DATE) Budget_period_start_date
274: FROM
275: PA_Resource_Assignments RA,
276: PA_Budget_Lines BL,
277: PA_BC_Balances BCBL
278: WHERE
279: RA.Budget_Version_ID = l_Bslnd_Budget_Version_ID
280: AND RA.Resource_Assignment_ID = BL.Resource_Assignment_ID

Line 1542: -- Update / Insert into PA_BUDGET_LINES

1538: P_Procedure_Name => 'Get_Period_Details');
1539: END Get_Period_Details;
1540:
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,

Line 1581: l_Txn_Curr_Code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;

1577: /* FPB2: MRC */
1578:
1579: -- Bug Fix: 4569365. Removed MRC code.
1580: -- l_Mrc_Exception EXCEPTION;
1581: l_Txn_Curr_Code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;
1582: --l_Budget_Line_Id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
1583:
1584: BEGIN
1585: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 1582: --l_Budget_Line_Id PA_BUDGET_LINES.BUDGET_LINE_ID%type;

1578:
1579: -- Bug Fix: 4569365. Removed MRC code.
1580: -- l_Mrc_Exception EXCEPTION;
1581: l_Txn_Curr_Code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;
1582: --l_Budget_Line_Id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
1583:
1584: BEGIN
1585: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
1586:

Line 1630: PA_Budget_Lines

1626: l_Txn_Curr_Code := NULL;
1627: END;
1628:
1629: UPDATE
1630: PA_Budget_Lines
1631: SET
1632: Burdened_Cost = NVL(Burdened_Cost,0) + l_Burdened_Transfer_Amount,
1633: Raw_Cost = NVL(Raw_Cost,0) + l_Raw_Transfer_Amount,
1634: Request_ID = P_Request_ID

Line 1655: PA_Budget_Lines

1651: -- Update without using code combination_id ...
1652: -- Case: Where there is a line that is already existing with
1653: -- a diff. code combination ..
1654: UPDATE
1655: PA_Budget_Lines
1656: SET
1657: Burdened_Cost = NVL(Burdened_Cost,0) + l_Burdened_Transfer_Amount,
1658: Raw_Cost = NVL(Raw_Cost,0) + l_Raw_Transfer_Amount,
1659: Request_ID = P_Request_ID

Line 1678: log_message('Year_End_Rollover: ' || 'Inserting into PA_BUDGET_LINES');

1674:
1675: IF l_Update_Count = 0 -- No Data Found ie. NO record are updated
1676: THEN
1677: IF P_DEBUG_MODE = 'Y' THEN
1678: log_message('Year_End_Rollover: ' || 'Inserting into PA_BUDGET_LINES');
1679: END IF;
1680: ---------------------------------------------------------------------------------+
1681: -- Insert a new Budget Lines data
1682: ---------------------------------------------------------------------------------+

Line 1686: PA_BUDGET_LINES_V_PKG.Insert_Row (

1682: ---------------------------------------------------------------------------------+
1683: IF P_DEBUG_MODE = 'Y' THEN
1684: log_message('Year_End_Rollover: ' || 'Raw Cost: '|| l_Raw_Cost ||' and Burdened Cost: '|| l_Burdened_Cost );
1685: END IF;
1686: PA_BUDGET_LINES_V_PKG.Insert_Row (
1687: X_ROWID => l_RowID,
1688: X_Resource_Assignment_Id => P_Resource_Assignment_ID,
1689: X_Budget_Version_Id => P_Budget_Version_ID,
1690: X_Project_Id => P_Project_ID,

Line 1765: END IF; -- End of inserting a new record into PA_BUDGET_LINES

1761: Raw_Cost = NVL(Raw_Cost,0) - l_Raw_Transfer_Amount,
1762: Burdened_Cost = NVL(Burdened_Cost,0) - l_Burdened_Transfer_Amount
1763: WHERE
1764: Budget_Version_ID = P_Budget_Version_ID;
1765: END IF; -- End of inserting a new record into PA_BUDGET_LINES
1766:
1767: RETURN;
1768: -- Bug Fix: 4569365. Removed MRC code.
1769: /* EXCEPTION

Line 1965: PA_Budget_Lines BL

1961: RA.Task_ID,
1962: BL.Code_Combination_ID,
1963: BL.Start_Date
1964: FROM PA_Resource_Assignments RA,
1965: PA_Budget_Lines BL
1966: WHERE RA.Resource_Assignment_ID = BL.Resource_Assignment_ID
1967: AND RA.Budget_Version_ID = P_Budget_Version_ID )
1968: LOOP
1969:

Line 1975: PA_Budget_Lines BL

1971: not be called. If amount fields are added to the below update, MRC apis need
1972: to be called to maintain MRC in budgets */
1973:
1974: UPDATE
1975: PA_Budget_Lines BL
1976: SET
1977: BL.Code_Combination_ID = i.Code_Combination_ID
1978: WHERE
1979: BL.Start_Date = i.Start_Date

Line 2098: -- pa_budget_lines, pa_resource_assignments)

2094: END Create_Working_Budget;
2095:
2096: -- -------------------------------------------------------------------+
2097: -- This procedure will create budget data in pa_bc_balances (from
2098: -- pa_budget_lines, pa_resource_assignments)
2099: -- -------------------------------------------------------------------+
2100:
2101: PROCEDURE Create_bc_balances(p_budget_version_id IN NUMBER,
2102: p_last_baselined_version_id IN NUMBER,

Line 2119: -- Budget lines from pa_budget_lines

2115: IF P_DEBUG_MODE = 'Y' THEN
2116: log_message('Create_bc_balances: Create pa_bc_balances - BGT');
2117: END IF;
2118:
2119: -- Budget lines from pa_budget_lines
2120: insert into pa_bc_balances(
2121: PROJECT_ID,
2122: TASK_ID,
2123: TOP_TASK_ID,

Line 2161: from pa_budget_lines pb,

2157: pb.burdened_cost,
2158: 0,
2159: 0,
2160: l_request_id
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