1 package PA_BUDGET_CHECK_PVT as
2 /*$Header: PAPMBCVS.pls 120.2 2005/08/19 16:41:55 mwasowic ship $*/
3
4 --Package constant used for package version validation
5
6 --Global constants to be used in error messages
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_BUDGET_PUB';
8 G_BUDGET_CODE CONSTANT VARCHAR2(6) := 'BUDGET';
9 G_PROJECT_CODE CONSTANT VARCHAR2(7) := 'PROJECT';
10 G_TASK_CODE CONSTANT VARCHAR2(4) := 'TASK';
11 G_RESOURCE_CODE CONSTANT VARCHAR2(8) := 'RESOURCE';
12
13 --Locking exception
14 ROW_ALREADY_LOCKED EXCEPTION;
15 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
16
17 --Package constant used for package version validation
18
19 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
20
21 PROCEDURE get_valid_period_dates_Pvt
22 ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23 ,p_project_id IN NUMBER
24 ,p_task_id IN NUMBER
25 ,p_time_phased_type_code IN VARCHAR2
26 ,p_entry_level_code IN VARCHAR2
27 ,p_period_name_in IN VARCHAR2
28 ,p_budget_start_date_in IN DATE
29 ,p_budget_end_date_in IN DATE
30 ,p_period_name_out OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
31 ,p_budget_start_date_out OUT NOCOPY DATE --File.Sql.39 bug 4440895
32 ,p_budget_end_date_out OUT NOCOPY DATE --File.Sql.39 bug 4440895
33
34 -- Bug 3986129: FP.M Web ADI Dev changes, new parameters
35 ,p_context IN VARCHAR2 DEFAULT NULL
36 ,p_calling_model_context IN VARCHAR2 DEFAULT 'FINPLANMODEL'
37 ,x_error_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
38
39 PROCEDURE check_entry_method_flags_Pvt
40 ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
41 ,p_budget_amount_code IN VARCHAR2
42 ,p_budget_entry_method_code IN VARCHAR2
43 ,p_quantity IN NUMBER
44 ,p_raw_cost IN NUMBER
45 ,p_burdened_cost IN NUMBER
46 ,p_revenue IN NUMBER
47
48 --Parameters for finplan model
49 ,p_version_type IN VARCHAR2 := NULL
50 ,P_allow_qty_flag IN VARCHAR2 := NULL
51 ,P_allow_raw_cost_flag IN VARCHAR2 := NULL
52 ,P_allow_burdened_cost_flag IN VARCHAR2 := NULL
53 ,P_allow_revenue_flag IN VARCHAR2 := NULL
54
55 -- Bug 3986129: FP.M Web ADI Dev changes, new parameters
56 ,p_context IN VARCHAR2 DEFAULT NULL
57 ,p_raw_cost_rate IN NUMBER DEFAULT NULL
58 ,p_burdened_cost_rate IN NUMBER DEFAULT NULL
59 ,p_bill_rate IN NUMBER DEFAULT NULL
60 ,p_allow_raw_cost_rate_flag IN VARCHAR2 DEFAULT NULL
61 ,p_allow_burd_cost_rate_flag IN VARCHAR2 DEFAULT NULL
62 ,p_allow_bill_rate_flag IN VARCHAR2 DEFAULT NULL
63 ,x_webadi_error_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
64
65
66 -- Bug 3986129: FP.M Web ADI Dev changes, new api
67 PROCEDURE validate_uom_passed
68 ( p_context IN VARCHAR2 DEFAULT 'WEBADI',
69 p_res_list_mem_id IN pa_resource_list_members.resource_list_member_id%TYPE,
70 p_uom_passed IN pa_resource_list_members.unit_of_measure%TYPE,
71 x_error_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
72 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
73 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
74 x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
75
76 end PA_BUDGET_CHECK_PVT;