APPS.PA_BUDGET_FUND_PKG dependencies on PA_BC_BALANCES

Line 441: from pa_bc_balances a, pa_budgetary_control_options pbco, pa_budget_versions pbv

437: --cursor to delete all versions prior to the latest baselined balance records if the
438: --budget has been baselined before.
439: cursor c_delbal(p_bdgt_ctrl_type in varchar2, p_bdgt_ver in number) is
440: select a.rowid
441: from pa_bc_balances a, pa_budgetary_control_options pbco, pa_budget_versions pbv
442: where pbv.budget_version_id <> p_bdgt_ver
443: and a.project_id = pbco.project_id
444: and a.project_id = pbv.project_id
445: and a.budget_version_id = pbv.budget_version_id

Line 492: Delete pa_bc_balances

488: --This is to make sure that existing balance records for the draft version id due to
489: --a failure in the budget baselining process will be deleted
490: log_message('Create_txn_lines_in_bc_balance:'|| 'Delete draft budget version- '||p_draft_budget_version_id);
491:
492: Delete pa_bc_balances
493: where budget_version_id = p_draft_budget_version_id;
494:
495: log_message('Create_txn_lines_in_bc_balance:'||SQL%ROWCOUNT||' records deleted from pa_bc_balances');
496:

Line 495: log_message('Create_txn_lines_in_bc_balance:'||SQL%ROWCOUNT||' records deleted from pa_bc_balances');

491:
492: Delete pa_bc_balances
493: where budget_version_id = p_draft_budget_version_id;
494:
495: log_message('Create_txn_lines_in_bc_balance:'||SQL%ROWCOUNT||' records deleted from pa_bc_balances');
496:
497: -- -------------------------------------------------------------------------------------------------+
498: IF (g_processing_mode = 'BASELINE' and g_cost_rebaseline_flag = 'Y') then -- II
499:

Line 530: delete from pa_bc_balances

526:
527: log_message('Create_txn_lines_in_bc_balance:'||l_BalRowIdTab.count||' records being deleted');
528:
529: FORALL j in l_BalRowIdTab.first..l_BalRowIdTab.last
530: delete from pa_bc_balances
531: where rowid = l_BalRowIdTab(j);
532:
533: exit when c_delbal%notfound;
534: END LOOP;

Line 550: from pa_bc_balances

546:
547: Begin
548: select min(start_date), max(end_date)
549: into l_start_date, l_end_date
550: from pa_bc_balances
551: where project_id = p_project_id
552: and budget_version_id = g_cost_prev_bvid;
553: Exception
554: when no_data_found then

Line 585: insert into pa_bc_balances(

581: FOR i in 1..l_tab_count LOOP
582: log_message('Create_txn_lines_in_bc_balance:St,End and Status = ' ||l_tab_periods(i).start_date||':'||
583: l_tab_periods(i).end_date||':'||l_tab_periods(i).closing_status);
584:
585: insert into pa_bc_balances(
586: PROJECT_ID,
587: TASK_ID,
588: TOP_TASK_ID,
589: RESOURCE_LIST_MEMBER_ID,

Line 623: from pa_bc_balances bal

619: bal.END_DATE,
620: bal.PARENT_MEMBER_ID,
621: bal.ACTUAL_PERIOD_TO_DATE,
622: bal.ENCUMB_PERIOD_TO_DATE
623: from pa_bc_balances bal
624: where budget_version_id = g_cost_prev_bvid
625: and trunc(start_date) = trunc(l_tab_periods(i).start_date)
626: and trunc(end_date) = trunc(l_tab_periods(i).end_date)
627: and l_tab_periods(i).closing_status = 'C'

Line 689: insert into pa_bc_balances(

685: l_date := SYSDATE;
686: x_ret_status := FND_API.G_RET_STS_SUCCESS;
687:
688: FORALL i in t_task_id.FIRST..t_task_id.LAST
689: insert into pa_bc_balances(
690: PROJECT_ID,
691: TASK_ID,
692: TOP_TASK_ID,
693: RESOURCE_LIST_MEMBER_ID,

Line 772: --Tables to insert BGT lines into pa_bc_balances.

768: and pa.task_id = pt.task_id (+)
769: and pa.budget_version_id = pbv.budget_version_id
770: and rm.resource_list_member_id = pa.resource_list_member_id;
771:
772: --Tables to insert BGT lines into pa_bc_balances.
773: l_TaskTab PA_PLSQL_DATATYPES.IdTabTyp;
774: l_TTaskTab PA_PLSQL_DATATYPES.IdTabTyp;
775: l_RlmiTab PA_PLSQL_DATATYPES.IdTabTyp;
776: l_PeriodTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2764: Delete pa_bc_balances

2760: where budget_version_id = p_bud_ver_id;
2761:
2762: log_message(SQL%ROWCOUNT||' records updated');
2763:
2764: Delete pa_bc_balances
2765: where budget_version_id = p_bud_ver_id;
2766:
2767: log_message(SQL%ROWCOUNT||' records deleted');
2768: