1 package PA_BUDGET_UTILS2 AUTHID CURRENT_USER as
2 -- $Header: PAXBUTLS.pls 120.1 2005/08/19 17:10:49 mwasowic noship $
3
4 function check_budget_at_compl_exists (x_project_id in number,
5 x_task_id in number)
6 return varchar2;
7
8 procedure submit_budget (x_budget_version_id in number,
9 x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
10 x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
11 x_err_stack in out NOCOPY varchar2); --File.Sql.39 bug 4440895
12
13 procedure rework_budget (x_budget_version_id in number,
14 x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
15 x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
16 x_err_stack in out NOCOPY varchar2); --File.Sql.39 bug 4440895
17
18 /* Bug 2920954 - Added x_validation_mode parameter. This takes values R or U.
19 R - Restricted mode - Will return 1 when plannable element exists for x_task_id
20 U - Unrestricted mode - Will return 0 when plannable element exists in baselined version or
21 plan amounts exists for x_task_id plannable element */
22
23 function check_task_lowest_in_budgets (x_task_id in number,
24 x_top_task_id in number,
25 x_validation_mode in varchar2 default 'U' )
26 return number;
27
28 end PA_BUDGET_UTILS2 ;