1 package PA_BUDGET_CHECK_PVT AUTHID CURRENT_USER as
2 /*$Header: PAPMBCVS.pls 120.3.12020000.2 2013/03/06 09:43:03 admarath 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 G_PA_END_DATE DATE; -- Added for the bug 13344742
13
14
15 --Locking exception
16 ROW_ALREADY_LOCKED EXCEPTION;
17 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
18
19 --Package constant used for package version validation
20
21 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
22
23 PROCEDURE get_valid_period_dates_Pvt
24 ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25 ,p_project_id IN NUMBER
26 ,p_task_id IN NUMBER
27 ,p_time_phased_type_code IN VARCHAR2
28 ,p_entry_level_code IN VARCHAR2
29 ,p_period_name_in IN VARCHAR2
30 ,p_budget_start_date_in IN DATE
31 ,p_budget_end_date_in IN DATE
32 ,p_period_name_out OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33 ,p_budget_start_date_out OUT NOCOPY DATE --File.Sql.39 bug 4440895
34 ,p_budget_end_date_out OUT NOCOPY DATE --File.Sql.39 bug 4440895
35
36 -- Bug 3986129: FP.M Web ADI Dev changes, new parameters
37 ,p_context IN VARCHAR2 DEFAULT NULL
38 ,p_calling_model_context IN VARCHAR2 DEFAULT 'FINPLANMODEL'
39 ,x_error_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
40
41 PROCEDURE check_entry_method_flags_Pvt
42 ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43 ,p_budget_amount_code IN VARCHAR2
44 ,p_budget_entry_method_code IN VARCHAR2
45 ,p_quantity IN NUMBER
46 ,p_raw_cost IN NUMBER
47 ,p_burdened_cost IN NUMBER
48 ,p_revenue IN NUMBER
49
50 --Parameters for finplan model
51 ,p_version_type IN VARCHAR2 := NULL
52 ,P_allow_qty_flag IN VARCHAR2 := NULL
53 ,P_allow_raw_cost_flag IN VARCHAR2 := NULL
54 ,P_allow_burdened_cost_flag IN VARCHAR2 := NULL
55 ,P_allow_revenue_flag IN VARCHAR2 := NULL
56
57 -- Bug 3986129: FP.M Web ADI Dev changes, new parameters
58 ,p_context IN VARCHAR2 DEFAULT NULL
59 ,p_raw_cost_rate IN NUMBER DEFAULT NULL
60 ,p_burdened_cost_rate IN NUMBER DEFAULT NULL
61 ,p_bill_rate IN NUMBER DEFAULT NULL
62 ,p_allow_raw_cost_rate_flag IN VARCHAR2 DEFAULT NULL
63 ,p_allow_burd_cost_rate_flag IN VARCHAR2 DEFAULT NULL
64 ,p_allow_bill_rate_flag IN VARCHAR2 DEFAULT NULL
65 ,x_webadi_error_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
66
67
68 -- Bug 3986129: FP.M Web ADI Dev changes, new api
69 PROCEDURE validate_uom_passed
70 ( p_context IN VARCHAR2 DEFAULT 'WEBADI',
71 p_res_list_mem_id IN pa_resource_list_members.resource_list_member_id%TYPE,
72 p_uom_passed IN pa_resource_list_members.unit_of_measure%TYPE,
73 x_error_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
74 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
75 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
76 x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
77
78
79 --added the below function for the bug 13344742.
80
81 FUNCTION Get_project_end_date RETURN DATE;
82
83 end PA_BUDGET_CHECK_PVT;