APPS.PA_YEAR_END_ROLLOVER_PKG dependencies on PA_BC_BALANCES

Line 278: PA_BC_Balances BCBL

274: MAX(BL.START_DATE) Budget_period_start_date
275: FROM
276: PA_Resource_Assignments RA,
277: PA_Budget_Lines BL,
278: PA_BC_Balances BCBL
279: WHERE
280: RA.Budget_Version_ID = l_Bslnd_Budget_Version_ID
281: AND RA.Resource_Assignment_ID = BL.Resource_Assignment_ID
282: AND BCBL.Start_Date = BL.Start_Date

Line 333: -- from PA_BC_PACKETS to PA_BC_BALANCES

329: END IF;
330:
331: -----------------------------------------------------------------------------------+
332: -- Invoke the Sweeper process to sweep all the encumbrance etries
333: -- from PA_BC_PACKETS to PA_BC_BALANCES
334: -----------------------------------------------------------------------------------+
335: PA_Sweeper.Update_Act_Enc_Balance (
336: X_Return_Status => l_Return_Status,
337: X_Error_Message_Code => l_Msg_Data

Line 688: log_message('Year_End_Rollover: ' || 'Fetching amounts from PA_BC_BALANCES for the periods missing budget lines');

684: l_Amount_with_no_budgetline := 0;
685:
686: BEGIN
687: IF P_DEBUG_MODE = 'Y' THEN
688: log_message('Year_End_Rollover: ' || 'Fetching amounts from PA_BC_BALANCES for the periods missing budget lines');
689: log_message('Year_End_Rollover: ' || 'Budget_Version_ID : ' || l_Work_Budget_Version_ID );
690: log_message('Year_End_Rollover: ' || 'Project_ID : ' || l_Project_ID );
691: log_message('Year_End_Rollover: ' || 'Top_Task_ID : ' || l_Top_Task_ID );
692: END IF;

Line 699: PA_BC_BALANCES bcbl

695: SUM( bcbl.Actual_Period_To_Date + bcbl.Encumb_Period_To_Date)
696: INTO
697: l_Amount_with_no_budgetline
698: FROM
699: PA_BC_BALANCES bcbl
700: WHERE
701: bcbl.Budget_Version_ID = l_Bslnd_Budget_Version_ID
702: AND bcbl.balance_type <> 'BGT'
703: AND bcbl.Project_ID = l_Project_ID

Line 2154: -- This procedure will create budget data in pa_bc_balances (from

2150: P_Lock_Name => l_Lock_Name );
2151: END Create_Working_Budget;
2152:
2153: -- -------------------------------------------------------------------+
2154: -- This procedure will create budget data in pa_bc_balances (from
2155: -- pa_budget_lines, pa_resource_assignments)
2156: -- -------------------------------------------------------------------+
2157:
2158: PROCEDURE Create_bc_balances(p_budget_version_id IN NUMBER,

Line 2173: log_message('Create_bc_balances: Create pa_bc_balances - BGT');

2169: l_user := FND_GLOBAL.LOGIN_ID;
2170: l_request_id := FND_GLOBAL.conc_request_id;
2171:
2172: IF P_DEBUG_MODE = 'Y' THEN
2173: log_message('Create_bc_balances: Create pa_bc_balances - BGT');
2174: END IF;
2175:
2176: -- Budget lines from pa_budget_lines
2177: insert into pa_bc_balances(

Line 2177: insert into pa_bc_balances(

2173: log_message('Create_bc_balances: Create pa_bc_balances - BGT');
2174: END IF;
2175:
2176: -- Budget lines from pa_budget_lines
2177: insert into pa_bc_balances(
2178: PROJECT_ID,
2179: TASK_ID,
2180: TOP_TASK_ID,
2181: RESOURCE_LIST_MEMBER_ID,

Line 2230: log_message('Create_bc_balances: Create pa_bc_balances - Transaction data');

2226: and pa.budget_version_id = pbv.budget_version_id
2227: and rm.resource_list_member_id = pa.resource_list_member_id;
2228:
2229: IF P_DEBUG_MODE = 'Y' THEN
2230: log_message('Create_bc_balances: Create pa_bc_balances - Transaction data');
2231: END IF;
2232:
2233: -- Transaction data from the last baselined version ..
2234: INSERT INTO

Line 2235: PA_BC_Balances (

2231: END IF;
2232:
2233: -- Transaction data from the last baselined version ..
2234: INSERT INTO
2235: PA_BC_Balances (
2236: Project_ID,
2237: Task_ID,
2238: Resource_List_Member_ID,
2239: Set_Of_Books_ID,

Line 2285: PA_BC_BALANCES

2281: Actual_Period_To_Date,
2282: Budget_period_To_Date,
2283: Encumb_Period_To_Date
2284: FROM
2285: PA_BC_BALANCES
2286: WHERE
2287: Budget_Version_ID = p_last_baselined_version_id
2288: AND Balance_Type <> 'BGT' ;
2289: