DBA Data[Home] [Help]

APPS.PA_BUDGET_FUND_PKG dependencies on PA_PLSQL_DATATYPES

Line 435: l_BalRowIdTab PA_PLSQL_DATATYPES.RowidTabTyp;

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

Line 664: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,

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,

Line 665: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,

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,

Line 666: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,

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,

Line 667: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,

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,

Line 668: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 669: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,

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

Line 670: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,

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:

Line 671: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,

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;

Line 773: l_TaskTab PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 774: l_TTaskTab PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 775: l_RlmiTab PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 776: l_PeriodTab PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 777: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;

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:

Line 778: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;

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;

Line 779: l_ParMemTab 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;
783:

Line 780: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;

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