1 PACKAGE PA_COST AUTHID CURRENT_USER as
2 /* $Header: PAXCSRTS.pls 120.1 2005/08/03 11:06:11 aaggarwa noship $ */
3
4
5 PROCEDURE Get_raw_cost(P_person_id IN NUMBER ,
6 P_expenditure_org_id IN NUMBER ,
7 P_expend_organization_id IN NUMBER , /*LCE changes*/
8 P_labor_Cost_Mult_Name IN VARCHAR2 ,
9 P_Item_date IN DATE ,
10 Px_exp_func_curr_code IN OUT NOCOPY VARCHAR2 ,
11 P_Quantity IN NUMBER ,
12 X_Raw_cost_rate OUT NOCOPY NUMBER ,
13 X_Raw_cost OUT NOCOPY NUMBER ,
14 x_return_status OUT NOCOPY VARCHAR2 ,
15 x_msg_count OUT NOCOPY NUMBER ,
16 x_msg_data OUT NOCOPY VARCHAR2
17 );
18
19
20 PROCEDURE Override_exp_organization(
21 P_item_date IN DATE,
22 P_person_id IN NUMBER,
23 P_project_id IN NUMBER,
24 P_incurred_by_organz_id IN NUMBER,
25 P_Expenditure_type IN VARCHAR2,
26 X_overr_to_organization_id OUT NOCOPY NUMBER,
27 x_return_status OUT NOCOPY VARCHAR2 ,
28 x_msg_count OUT NOCOPY NUMBER ,
29 x_msg_data OUT NOCOPY VARCHAR2
30 );
31
32
33 PROCEDURE Get_Burdened_cost(p_project_type IN VARCHAR2 ,
34 p_project_id IN NUMBER ,
35 p_task_id IN NUMBER ,
36 p_item_date IN DATE ,
37 p_expenditure_type IN VARCHAR2 ,
38 p_schedule_type IN VARCHAR2 ,
39 px_exp_func_curr_code IN OUT NOCOPY VARCHAR2 ,
40 p_Incurred_by_organz_id IN NUMBER ,
41 p_raw_cost IN NUMBER ,
42 p_raw_cost_rate IN NUMBER ,
43 p_quantity IN NUMBER ,
44 p_override_to_organz_id IN NUMBER ,
45 x_burden_cost OUT NOCOPY NUMBER ,
46 x_burden_cost_rate OUT NOCOPY NUMBER ,
47 x_return_status OUT NOCOPY VARCHAR2 ,
48 x_msg_count OUT NOCOPY NUMBER ,
49 x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 /* Changed the name of this proc from Get_proj_raw_Burdened_cost to
53 Get_projfunc_raw_Burdened_cost MCB II */
54 /* Changed the name of this proc from Get_projfunc_raw_Burdened_cost to
55 Get_Converted_Cost_Amounts for Org Forecasting */
56 PROCEDURE Get_Converted_Cost_Amounts(
57 P_exp_org_id IN NUMBER,
58 P_proj_org_id IN NUMBER,
59 P_project_id IN NUMBER,
60 P_task_id IN NUMBER,
61 P_item_date IN DATE,
62 p_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,/* Added */
63 /* for Org Forecasting */
64 px_txn_curr_code IN OUT NOCOPY VARCHAR2,/* Added for Org Forecasting */
65 px_raw_cost IN OUT NOCOPY NUMBER, /* Txn raw cost,chnage from IN */
66 /* to IN OUT for Org forecasting */
67 px_raw_cost_rate IN OUT NOCOPY NUMBER, /* Txn raw cost rate,change from IN to */
68 /* IN OUT for Org forecasting */
69 px_burden_cost IN OUT NOCOPY NUMBER, /* Txn burden cost,change from IN to */
70 /* IN OUT for Org forecasting */
71 px_burden_cost_rate IN OUT NOCOPY NUMBER, /* Txn burden cost rate,change from IN to
72 /* IN OUT for Org forecasting */
73 px_exp_func_curr_code IN OUT NOCOPY VARCHAR2,
74 px_exp_func_rate_date IN OUT NOCOPY DATE, /* Added for Org Forecasting */
75 px_exp_func_rate_type IN OUT NOCOPY VARCHAR2,/* Added for Org Forecasting */
76 px_exp_func_exch_rate IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
77 px_exp_func_cost IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
78 px_exp_func_cost_rate IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
79 px_exp_func_burden_cost IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
80 px_exp_func_burden_cost_rate IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
81 px_proj_func_curr_code IN OUT NOCOPY VARCHAR2,
82 px_projfunc_cost_rate_date IN OUT NOCOPY DATE, /* Added for Org Forecasting */
83 px_projfunc_cost_rate_type IN OUT NOCOPY VARCHAR2,/* Added for Org Forecasting */
84 px_projfunc_cost_exch_rate IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
85 px_projfunc_raw_cost IN OUT NOCOPY NUMBER , /* The following 4 para name changed for MCB II */
86 /* change from OUT to IN OUT for Org forecasting */
87 px_projfunc_raw_cost_rate IN OUT NOCOPY NUMBER , /* change from OUT to IN OUT for Org forecasting */
88 px_projfunc_burden_cost IN OUT NOCOPY NUMBER , /* change from OUT to IN OUT for Org forecasting */
89 px_projfunc_burden_cost_rate IN OUT NOCOPY NUMBER , /* change from OUT to IN OUT for Org forecasting */
90 px_project_curr_code IN OUT NOCOPY VARCHAR2,
91 px_project_rate_date IN OUT NOCOPY DATE, /* Added for Org Forecasting */
92 px_project_rate_type IN OUT NOCOPY VARCHAR2,/* Added for Org Forecasting */
93 px_project_exch_rate IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
94 px_project_cost IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
95 px_project_cost_rate IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
96 px_project_burden_cost IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
97 px_project_burden_cost_rate IN OUT NOCOPY NUMBER, /* Added for Org Forecasting */
98 x_return_status OUT NOCOPY VARCHAR2 ,
99 x_msg_count OUT NOCOPY NUMBER ,
100 x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103
104 FUNCTION Get_pa_date(P_item_date IN DATE,
105 P_expenditure_org_id IN NUMBER
106 )
107 return date;
108
109 FUNCTION Get_curr_code(p_org_id IN NUMBER
110 )
111 RETURN VARCHAR2;
112
113
114 PROCEDURE get_schedule_id( p_schedule_type IN VARCHAR2 ,
115 p_project_id IN NUMBER ,
116 p_task_id IN NUMBER ,
117 p_item_date IN DATE ,
118 p_exp_type IN VARCHAR2 ,
119 x_burden_sch_rev_id OUT NOCOPY NUMBER ,
120 x_burden_sch_fixed_date OUT NOCOPY DATE ,
121 x_return_status OUT NOCOPY VARCHAR2 ,
122 x_msg_count OUT NOCOPY NUMBER ,
123 x_msg_data OUT NOCOPY VARCHAR2
124 );
125
126
127
128 PROCEDURE Requirement_raw_cost(
129 p_forecast_cost_job_group_id IN NUMBER ,
130 p_forecast_cost_job_id IN NUMBER ,
131 p_proj_cost_job_group_id IN NUMBER ,
132 px_proj_cost_job_id IN OUT NOCOPY NUMBER ,
133 p_item_date IN DATE ,
134 p_job_cost_rate_sch_id IN NUMBER ,
135 p_schedule_date IN DATE ,
136 p_quantity IN NUMBER ,
137 p_cost_rate_multiplier IN NUMBER ,
138 p_org_id IN NUMBER ,
139 p_expend_organization_id IN NUMBER , /*LCE changes*/
140 /* p_projfunc_currency_code IN VARCHAR2, -- The following 4
141 px_projfunc_cost_rate_type IN OUT NOCOPY VARCHAR2, -- added for MCB2
142 px_projfunc_cost_rate_date IN OUT NOCOPY DATE,
143 px_projfunc_cost_exchange_rate IN OUT NOCOPY NUMBER ,
144 Commented for Org Forecasting */
145 x_raw_cost_rate OUT NOCOPY NUMBER ,
146 x_raw_cost OUT NOCOPY NUMBER ,
147 x_txn_currency_code OUT NOCOPY VARCHAR2 , /* Added for Org Forecasting */
148 x_return_status OUT NOCOPY VARCHAR2 ,
149 x_msg_count OUT NOCOPY NUMBER ,
150 x_msg_data OUT NOCOPY VARCHAR2
151 );
152
153
154 END PA_COST;