1 PACKAGE PA_FORECAST_COST as
2 /* $Header: PARFRTCS.pls 120.1 2005/08/19 16:52:19 mwasowic noship $ */
3
4
5 PROCEDURE Get_raw_cost(P_person_id IN NUMBER ,
6 P_expenditure_org_id IN NUMBER ,
7 P_labor_Cost_Mult_Name IN VARCHAR2 ,
8 P_Item_date IN DATE ,
9 P_exp_func_curr_code IN OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
10 P_Quantity IN NUMBER ,
11 X_Raw_cost_rate OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
12 X_Raw_cost OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
13 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
14 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
15 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
16 );
17
18
19 PROCEDURE Override_exp_organization(
20 P_item_date IN DATE,
21 P_person_id IN NUMBER,
22 P_project_id IN NUMBER,
23 P_incurred_by_organz_id IN NUMBER,
24 P_Expenditure_type IN VARCHAR2,
25 X_overr_to_organization_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
26 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
27 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
28 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
29 );
30
31
32 PROCEDURE Get_Burden_cost(p_project_type IN VARCHAR2 ,
33 p_project_id IN NUMBER ,
34 p_task_id IN NUMBER ,
35 p_item_date IN DATE ,
36 p_expenditure_type IN VARCHAR2 ,
37 p_schedule_type IN VARCHAR2 ,
38 p_exp_func_curr_code IN OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
39 p_Incurred_by_organz_id IN NUMBER ,
40 p_raw_cost IN NUMBER ,
41 p_raw_cost_rate IN NUMBER ,
42 p_quantity IN NUMBER ,
43 p_override_to_organz_id IN NUMBER ,
44 x_burden_cost OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
45 x_burden_cost_rate OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
46 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
47 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
48 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49 );
50
51 PROCEDURE Get_proj_raw_Burden_cost(P_exp_org_id IN NUMBER ,
52 P_proj_org_id IN NUMBER ,
53 P_project_id IN NUMBER ,
54 P_task_id IN NUMBER ,
55 P_item_date IN DATE ,
56 P_exp_func_curr_code IN OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
57 p_proj_func_curr_code IN OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
58 p_raw_cost IN NUMBER ,
59 p_burden_cost IN NUMBER ,
60 x_proj_raw_cost OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
61 x_proj_raw_cost_rate OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
62 x_proj_burden_cost OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
63 x_proj_burden_cost_rate OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
64 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
65 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
66 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67 );
68
69
70 FUNCTION Get_pa_date(P_item_date IN DATE,
71 P_expenditure_org_id IN NUMBER
72 )
73 return date;
74
75 FUNCTION Get_curr_code(p_org_id IN NUMBER
76 )
77 RETURN VARCHAR2;
78
79
80 PROCEDURE get_schedule_id( p_schedule_type IN VARCHAR2 ,
81 p_project_id IN NUMBER ,
82 p_task_id IN NUMBER ,
83 p_item_date IN DATE ,
84 p_exp_type IN VARCHAR2 ,
85 x_burden_sch_rev_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
86 x_burden_sch_fixed_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
87 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
88 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
89 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90 );
91
92 PROCEDURE requirement_raw_cost(
93 p_forecast_cost_job_group_id IN NUMBER ,
94 p_forecast_cost_job_id IN NUMBER ,
95 p_proj_cost_job_group_id IN NUMBER ,
96 p_proj_cost_job_id IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
97 p_item_date IN DATE ,
98 p_job_cost_rate_sch_id IN NUMBER ,
99 p_schedule_date IN DATE ,
100 p_quantity IN NUMBER ,
101 p_cost_rate_multiplier IN NUMBER ,
102 x_raw_cost_rate OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
103 x_raw_cost OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
104 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
105 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
106 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
107 );
108
109 END PA_FORECAST_COST;