431: l_end_date date;
432: l_tab_count number := 0;
433: l_tab_periods PA_FUNDS_CONTROL_UTILS.tab_closed_period;
434:
435: l_BalRowIdTab PA_PLSQL_DATATYPES.RowidTabTyp;
436:
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
660: PROCEDURE Create_bgt_lines_in_bc_balance(
661: p_set_of_books_id in number,
662: p_budget_version_id in number,
663: p_project_id in number,
664: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
665: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
666: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
667: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
668: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
661: p_set_of_books_id in number,
662: p_budget_version_id in number,
663: p_project_id in number,
664: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
665: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
666: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
667: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
668: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
669: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
662: p_budget_version_id in number,
663: p_project_id in number,
664: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
665: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
666: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
667: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
668: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
669: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
670: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
663: p_project_id in number,
664: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
665: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
666: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
667: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
668: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
669: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
670: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
671: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,
664: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
665: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
666: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
667: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
668: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
669: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
670: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
671: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,
672: x_ret_status out NOCOPY varchar2,
665: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
666: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
667: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
668: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
669: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
670: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
671: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,
672: x_ret_status out NOCOPY varchar2,
673: x_err_message_code out NOCOPY varchar2) is
666: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
667: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
668: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
669: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
670: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
671: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,
672: x_ret_status out NOCOPY varchar2,
673: x_err_message_code out NOCOPY varchar2) is
674:
667: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
668: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
669: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
670: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
671: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,
672: x_ret_status out NOCOPY varchar2,
673: x_err_message_code out NOCOPY varchar2) is
674:
675: PRAGMA AUTONOMOUS_TRANSACTION;
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;
777: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
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;
777: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
778: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
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;
777: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
778: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
779: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
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;
777: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
778: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
779: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
780: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
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;
777: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
778: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
779: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
780: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
781:
774: l_TTaskTab PA_PLSQL_DATATYPES.IdTabTyp;
775: l_RlmiTab PA_PLSQL_DATATYPES.IdTabTyp;
776: l_PeriodTab PA_PLSQL_DATATYPES.Char30TabTyp;
777: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
778: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
779: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
780: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
781:
782: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
775: l_RlmiTab PA_PLSQL_DATATYPES.IdTabTyp;
776: l_PeriodTab PA_PLSQL_DATATYPES.Char30TabTyp;
777: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
778: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
779: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
780: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
781:
782: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
783:
776: l_PeriodTab PA_PLSQL_DATATYPES.Char30TabTyp;
777: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
778: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
779: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
780: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
781:
782: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
783:
784: BEGIN