APPS.PA_BUDGET_FUND_PKG dependencies on PA_BC_BALANCES

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

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

Line 488: Delete pa_bc_balances

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

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

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

Line 526: delete from pa_bc_balances

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

Line 546: from pa_bc_balances

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

Line 581: insert into pa_bc_balances(

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

Line 619: from pa_bc_balances bal

615: bal.END_DATE,
616: bal.PARENT_MEMBER_ID,
617: bal.ACTUAL_PERIOD_TO_DATE,
618: bal.ENCUMB_PERIOD_TO_DATE
619: from pa_bc_balances bal
620: where budget_version_id = g_cost_prev_bvid
621: and trunc(start_date) = trunc(l_tab_periods(i).start_date)
622: and trunc(end_date) = trunc(l_tab_periods(i).end_date)
623: and l_tab_periods(i).closing_status = 'C'

Line 685: insert into pa_bc_balances(

681: l_date := SYSDATE;
682: x_ret_status := FND_API.G_RET_STS_SUCCESS;
683:
684: FORALL i in t_task_id.FIRST..t_task_id.LAST
685: insert into pa_bc_balances(
686: PROJECT_ID,
687: TASK_ID,
688: TOP_TASK_ID,
689: RESOURCE_LIST_MEMBER_ID,

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

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

Line 2657: Delete pa_bc_balances

2653: where budget_version_id = p_bud_ver_id;
2654:
2655: log_message(SQL%ROWCOUNT||' records updated');
2656:
2657: Delete pa_bc_balances
2658: where budget_version_id = p_bud_ver_id;
2659:
2660: log_message(SQL%ROWCOUNT||' records deleted');
2661: