DBA Data[Home] [Help]

APPS.PA_BUDGET_FUND_PKG dependencies on PA_PLSQL_DATATYPES

Line 431: l_BalRowIdTab PA_PLSQL_DATATYPES.RowidTabTyp;

427: l_end_date date;
428: l_tab_count number := 0;
429: l_tab_periods PA_FUNDS_CONTROL_UTILS.tab_closed_period;
430:
431: l_BalRowIdTab PA_PLSQL_DATATYPES.RowidTabTyp;
432:
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

Line 660: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,

656: PROCEDURE Create_bgt_lines_in_bc_balance(
657: p_set_of_books_id in number,
658: p_budget_version_id in number,
659: p_project_id in number,
660: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
661: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
662: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
663: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
664: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,

Line 661: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,

657: p_set_of_books_id in number,
658: p_budget_version_id in number,
659: p_project_id in number,
660: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
661: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
662: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
663: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
664: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
665: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,

Line 662: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,

658: p_budget_version_id in number,
659: p_project_id in number,
660: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
661: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
662: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
663: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
664: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
665: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
666: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,

Line 663: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,

659: p_project_id in number,
660: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
661: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
662: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
663: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
664: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
665: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
666: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
667: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,

Line 664: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,

660: t_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
661: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
662: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
663: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
664: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
665: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
666: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
667: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,
668: x_ret_status out NOCOPY varchar2,

Line 665: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,

661: t_top_task_id in PA_PLSQL_DATATYPES.IdTabTyp,
662: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
663: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
664: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
665: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
666: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
667: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,
668: x_ret_status out NOCOPY varchar2,
669: x_err_message_code out NOCOPY varchar2) is

Line 666: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,

662: t_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
663: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
664: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
665: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
666: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
667: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,
668: x_ret_status out NOCOPY varchar2,
669: x_err_message_code out NOCOPY varchar2) is
670:

Line 667: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,

663: t_parent_rlmi in PA_PLSQL_DATATYPES.IdTabTyp,
664: t_period in PA_PLSQL_DATATYPES.Char30TabTyp,
665: t_start_date in PA_PLSQL_DATATYPES.DateTabTyp,
666: t_end_date in PA_PLSQL_DATATYPES.DateTabTyp,
667: t_burden_cost in PA_PLSQL_DATATYPES.NumTabTyp,
668: x_ret_status out NOCOPY varchar2,
669: x_err_message_code out NOCOPY varchar2) is
670:
671: PRAGMA AUTONOMOUS_TRANSACTION;

Line 769: l_TaskTab PA_PLSQL_DATATYPES.IdTabTyp;

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;
773: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;

Line 770: l_TTaskTab PA_PLSQL_DATATYPES.IdTabTyp;

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;
773: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
774: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;

Line 771: l_RlmiTab PA_PLSQL_DATATYPES.IdTabTyp;

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;
773: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
774: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
775: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 772: l_PeriodTab PA_PLSQL_DATATYPES.Char30TabTyp;

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;
773: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
774: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
775: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
776: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 773: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;

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;
773: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
774: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
775: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
776: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
777:

Line 774: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;

770: l_TTaskTab PA_PLSQL_DATATYPES.IdTabTyp;
771: l_RlmiTab PA_PLSQL_DATATYPES.IdTabTyp;
772: l_PeriodTab PA_PLSQL_DATATYPES.Char30TabTyp;
773: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
774: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
775: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
776: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
777:
778: l_sob_id pa_implementations_all.set_of_books_id%TYPE;

Line 775: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;

771: l_RlmiTab PA_PLSQL_DATATYPES.IdTabTyp;
772: l_PeriodTab PA_PLSQL_DATATYPES.Char30TabTyp;
773: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
774: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
775: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
776: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
777:
778: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
779:

Line 776: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;

772: l_PeriodTab PA_PLSQL_DATATYPES.Char30TabTyp;
773: l_StDateTab PA_PLSQL_DATATYPES.DateTabTyp;
774: l_EdDateTab PA_PLSQL_DATATYPES.DateTabTyp;
775: l_ParMemTab PA_PLSQL_DATATYPES.IdTabTyp;
776: l_BurdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
777:
778: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
779:
780: BEGIN