1 PACKAGE PA_RATE_PVT_PKG AUTHID CURRENT_USER as
2 /* $Header: PAXRTPVS.pls 120.1 2005/08/19 17:19:38 mwasowic noship $ */
3
4
5 TYPE ProjAmt_Record IS RECORD ( period_name pa_rep_period_dates_v.period_name%TYPE,
6 Amount NUMBER,
7 start_date pa_rep_period_dates_v.start_date%TYPE,
8 end_date pa_rep_period_dates_v.end_date%TYPE);
9
10 TYPE ProjAmt_TabTyp IS TABLE OF ProjAmt_Record INDEX BY BINARY_INTEGER;
11
12 /* Declaring global varible , which is going to be used to check whether the error from
13 Rate api is going to be added into the stack or not.
14 This is added for bug 2218386 */
15
16 G_add_error_to_stack_flag VARCHAR2(1);
17
18 /* Added 47 parameters for Org Forecasting */
19 /* Name changed from project to project functional for MCB2 */
20 PROCEDURE get_item_amount(
21 p_calling_mode IN VARCHAR2 ,
22 p_rate_calc_date IN DATE ,
23 p_item_id IN NUMBER ,
24 p_project_id IN NUMBER ,
25 p_quantity IN NUMBER ,
26 p_forecast_job_id IN NUMBER DEFAULT NULL,
27 p_forecast_job_group_id IN NUMBER DEFAULT NULL,
28 p_person_id IN NUMBER DEFAULT NULL,
29 p_expenditure_org_id IN NUMBER DEFAULT NULL,
30 p_expenditure_type IN VARCHAR2 DEFAULT NULL,
31 p_expenditure_organization_id IN NUMBER DEFAULT NULL,
32 p_project_org_id IN NUMBER DEFAULT NULL,
33 p_labor_cost_multi_name IN VARCHAR2 DEFAULT NULL,
34 p_expenditure_currency_code IN VARCHAR2 DEFAULT NULL,
35 p_proj_cost_job_group_id IN NUMBER DEFAULT NULL,
36 p_job_cost_rate_schedule_id IN NUMBER DEFAULT NULL,
37 p_project_type IN VARCHAR2 DEFAULT NULL,
38 p_task_id IN NUMBER DEFAULT NULL,
39 p_bill_rate_multiplier IN NUMBER DEFAULT NULL,
40 p_project_bill_job_group_id IN NUMBER DEFAULT NULL,
41 p_emp_bill_rate_schedule_id IN NUMBER DEFAULT NULL,
42 p_job_bill_rate_schedule_id IN NUMBER DEFAULT NULL,
43 p_distribution_rule IN VARCHAR2 DEFAULT NULL,
44 p_forecast_item_id IN NUMBER DEFAULT NULL, /* added para for bug 2212852 */
45 p_forecasting_type IN VARCHAR2 DEFAULT 'PROJECT_FORECASTING', /* added para for */
46 /* bug 2212852 */
47 p_amount_calc_mode IN VARCHAR2, /* Added for Org Forecasting */
48 P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,/* Added */
49 /* for Org Forecasting */
50 p_assign_precedes_task IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
51 p_labor_schdl_discnt IN NUMBER DEFAULT NULL, /* Added for Org Forecasting */
52 p_labor_bill_rate_org_id IN NUMBER DEFAULT NULL, /* Added for Org Forecasting */
53 p_labor_std_bill_rate_schdl IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
54 p_labor_schedule_fixed_date IN DATE DEFAULT NULL, /* Added for Org Forecasting */
55 p_labor_sch_type IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
56 p_projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
57 p_projfunc_rev_rt_dt_code IN VARCHAR2, /* Added for Org Forecasting */
58 p_projfunc_rev_rt_date IN DATE, /* Added for Org Forecasting */
59 p_projfunc_rev_rt_type IN VARCHAR2, /* Added for Org Forecasting */
60 p_projfunc_rev_exch_rt IN NUMBER, /* Added for Org Forecasting */
61 p_projfunc_cst_rt_date IN DATE, /* Added for Org Forecasting */
62 p_projfunc_cst_rt_type IN VARCHAR2, /* Added for Org Forecasting */
63 x_projfunc_bill_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
64 x_projfunc_raw_revenue OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
65 x_projfunc_rev_rt_date OUT NOCOPY DATE, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
66 x_projfunc_rev_rt_type OUT NOCOPY VARCHAR2, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
67 x_projfunc_rev_exch_rt OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
68 x_projfunc_raw_cost OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69 x_projfunc_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
70 x_projfunc_burdened_cost OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
71 x_projfunc_burdened_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
72 x_projfunc_cst_rt_date OUT NOCOPY DATE, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
73 x_projfunc_cst_rt_type OUT NOCOPY VARCHAR2, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
74 x_projfunc_cst_exch_rt OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
75 p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
76 p_project_rev_rt_dt_code IN VARCHAR2, /* Added for org Forecasting */
77 p_project_rev_rt_date IN DATE, /* Added for org Forecasting */
78 p_project_rev_rt_type IN VARCHAR2, /* Added for org Forecasting */
79 p_project_rev_exch_rt IN NUMBER, /* Added for org Forecasting */
80 p_project_cst_rt_date IN DATE, /* Added for org Forecasting */
81 p_project_cst_rt_type IN VARCHAR2, /* Added for org Forecasting */
82 x_project_bill_rt OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
83 x_project_raw_revenue OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
84 x_project_rev_rt_date OUT NOCOPY DATE, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
85 x_project_rev_rt_type OUT NOCOPY VARCHAR2, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
86 x_project_rev_exch_rt OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
87 x_project_raw_cst OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
88 x_project_raw_cst_rt OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
89 x_project_burdned_cst OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
90 x_project_burdned_cst_rt OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
91 x_project_cst_rt_date OUT NOCOPY DATE, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
92 x_project_cst_rt_type OUT NOCOPY VARCHAR2, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
93 x_project_cst_exch_rt OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
94 x_exp_func_curr_code OUT NOCOPY VARCHAR2, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
95 x_exp_func_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
96 x_exp_func_raw_cost OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
97 x_exp_func_burdened_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
98 x_exp_func_burdened_cost OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
99 x_exp_func_cst_rt_date OUT NOCOPY DATE, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
100 x_exp_func_cst_rt_type OUT NOCOPY VARCHAR2, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
101 x_exp_func_cst_exch_rt OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
102 x_cst_txn_curr_code OUT NOCOPY VARCHAR2, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
103 x_txn_raw_cst_rt OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
104 x_txn_raw_cst OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
105 x_txn_burdned_cst_rt OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
106 x_txn_burdned_cst OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
107 x_rev_txn_curr_code OUT NOCOPY VARCHAR2, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
108 x_txn_rev_bill_rt OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
109 x_txn_rev_raw_revenue OUT NOCOPY NUMBER, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
110 x_error_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
111 x_rev_rejct_reason OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
112 x_cost_rejct_reason OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
113 x_burdened_rejct_reason OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
114 x_others_rejct_reason OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
115 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
116 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
117 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
118
119
120 --
121 -- Procedure : get_item_amount
122 -- Purpose : This procedure contains consolidated procedure and function to
123 -- calculate the raw cost, burdened cost and raw revenue
124 -- Parameters :
125 --
126
127 PROCEDURE calc_event_based_revenue(
128 p_project_id IN NUMBER ,
129 p_rev_amt IN NUMBER,
130 p_completion_date IN DATE,
131 p_project_currency_code IN VARCHAR2, -- The following 6
132 p_projfunc_currency_code IN VARCHAR2,
133 p_projfunc_bil_rate_date_code IN VARCHAR2, -- columns have been
134 px_projfunc_bil_rate_type IN OUT NOCOPY VARCHAR2, -- added for MCB2 --File.Sql.39 bug 4440895
135 px_projfunc_bil_rate_date IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
136 px_projfunc_bil_exchange_rate IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
137 x_error_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
138 x_projfunc_revenue_tab OUT NOCOPY PA_RATE_PVT_PKG.ProjAmt_TabTyp); --File.Sql.39 bug 4440895
139
140
141 --
142 -- Procedure : calc_event_based_revenue
143 -- Purpose : This procedure will calculate the revenue for fixed price in event based rule.
144 -- Parameters :
145 --
146
147
148 PROCEDURE calc_cost_based_revenue(
149 p_project_id IN NUMBER ,
150 p_rev_amt IN NUMBER ,
151 p_projfunc_cost_tab IN PA_RATE_PVT_PKG.ProjAmt_TabTyp,
152 p_project_currency_code IN VARCHAR2, -- The following 6
153 p_projfunc_currency_code IN VARCHAR2,
154 p_projfunc_bil_rate_date_code IN VARCHAR2, -- columns have been
155 px_projfunc_bil_rate_type IN OUT NOCOPY VARCHAR2, -- added for MCB2 --File.Sql.39 bug 4440895
156 px_projfunc_bil_rate_date IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
157 px_projfunc_bil_exchange_rate IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
158 x_projfunc_revenue_tab OUT NOCOPY PA_RATE_PVT_PKG.ProjAmt_TabTyp, --File.Sql.39 bug 4440895
159 x_error_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
160
161
162 --
163 -- Procedure : calc_cost_based_revenue
164 -- Purpose : This procedure will calculate the revenue for fixed price in cost based rule.
165 -- Parameters :
166 --
167
168 PROCEDURE get_revenue_generation_method( p_project_id IN NUMBER DEFAULT NULL,
169 p_distribution_rule IN VARCHAR2 DEFAULT NULL,
170 x_rev_gen_method OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
171 x_error_msg OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
172
173 --
174 -- Procedure : get_revenue_generation_method
175 -- Purpose :This procedure will return that whta type of the project is this on the basis
176 -- of passed project id
177 -- Parameters :
178 --
179 /* Added 20 new parameters for Org Forecasting */
180 PROCEDURE get_initial_bill_rate(
181 p_assignment_type IN VARCHAR2 ,
182 p_asgn_start_date IN DATE ,
183 p_project_id IN NUMBER ,
184 p_quantity IN NUMBER ,
185 p_expenditure_org_id IN NUMBER ,
186 p_expenditure_type IN VARCHAR2 ,
187 p_expenditure_organization_id IN NUMBER ,
188 p_person_id IN NUMBER DEFAULT NULL,
189 p_assignment_id IN NUMBER DEFAULT NULL,
190 p_forecast_job_id IN NUMBER DEFAULT NULL,
191 p_forecast_job_group_id IN NUMBER DEFAULT NULL,
192 p_project_org_id IN NUMBER DEFAULT NULL,
193 p_expenditure_currency_code IN VARCHAR2 DEFAULT NULL,
194 p_project_type IN VARCHAR2 DEFAULT NULL,
195 p_task_id IN NUMBER DEFAULT NULL,
196 p_bill_rate_multiplier IN NUMBER DEFAULT NULL,
197 p_project_bill_job_group_id IN NUMBER DEFAULT NULL,
198 p_emp_bill_rate_schedule_id IN NUMBER DEFAULT NULL,
199 p_job_bill_rate_schedule_id IN NUMBER DEFAULT NULL,
200 p_job_cost_rate_schedule_id IN NUMBER DEFAULT NULL,
201 p_proj_cost_job_group_id IN NUMBER DEFAULT NULL,
202 p_calculate_cost_flag IN VARCHAR2 DEFAULT 'Y', /* Added to fix bug 2162965 */
203 p_forecast_item_id IN NUMBER DEFAULT NULL, /* Added para for bug 2212852 */
204 p_forecasting_type IN VARCHAR2 DEFAULT 'PROJECT_FORECASTING', /* added para for bug 2212852 */
205 p_assign_precedes_task IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
206 p_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE DEFAULT NULL,/* Added */
207 /* for Org Forecasting */
208 p_labor_schdl_discnt IN NUMBER DEFAULT NULL, /* Added for Org Forecasting */
209 p_labor_bill_rate_org_id IN NUMBER DEFAULT NULL, /* Added for Org Forecasting */
210 p_labor_std_bill_rate_schdl IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
211 p_labor_schedule_fixed_date IN DATE DEFAULT NULL, /* Added for Org Forecasting */
212 p_labor_sch_type IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
213 p_projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
214 p_projfunc_rev_rt_dt_code IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
215 p_projfunc_rev_rt_date IN DATE DEFAULT NULL, /* Added for Org Forecasting */
216 p_projfunc_rev_rt_type IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
217 p_projfunc_rev_exch_rt IN NUMBER DEFAULT NULL, /* Added for Org Forecasting */
218 p_projfunc_cst_rt_date IN DATE DEFAULT NULL, /* Added for Org Forecasting */
219 p_projfunc_cst_rt_type IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
220 p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
221 p_project_rev_rt_dt_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
222 p_project_rev_rt_date IN DATE DEFAULT NULL, /* Added for org Forecasting */
223 p_project_rev_rt_type IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
224 p_project_rev_exch_rt IN NUMBER DEFAULT NULL, /* Added for org Forecasting */
225 p_project_cst_rt_date IN DATE DEFAULT NULL, /* Added for org Forecasting */
226 p_project_cst_rt_type IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
227 x_projfunc_bill_rate OUT NOCOPY NUMBER /* Changed for MCb2 */, --File.Sql.39 bug 4440895
228 x_projfunc_raw_revenue OUT NOCOPY NUMBER /* Changed for MCb2 */, --File.Sql.39 bug 4440895
229 x_rev_currency_code OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
230 x_markup_percentage OUT NOCOPY NUMBER /* Added for Assignment Override */, --File.Sql.39 bug 4440895
231 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
232 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
233 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
234
235
236 --
237 -- Procedure : get_initial_bill_rate
238 -- Purpose :This procedure will calculate the initial bill rate for Assignment and Requirement
239 -- Parameters :
240 --
241 /* Added 47 new paramaters Org Forecasting */
242 PROCEDURE calc_rate_amount(
243 p_calling_mode IN VARCHAR2 , /* possible values 'ASSIGNMENT','ROLE','UNASSIGNED' */
244 /* for Org forecasting */
245 p_rate_calc_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp ,
246 p_asgn_start_date IN DATE ,
247 p_item_id IN NUMBER ,
248 p_project_id IN NUMBER ,
249 p_quantity_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
250 p_forecast_job_id IN NUMBER DEFAULT NULL,
251 p_forecast_job_group_id IN NUMBER DEFAULT NULL,
252 p_person_id IN NUMBER DEFAULT NULL,
253 p_expenditure_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
254 p_expenditure_type IN VARCHAR2 DEFAULT NULL,
255 p_expenditure_orgz_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp ,
256 p_project_org_id IN NUMBER DEFAULT NULL,
257 p_labor_cost_multi_name IN VARCHAR2 DEFAULT NULL,
258 p_proj_cost_job_group_id IN NUMBER DEFAULT NULL,
259 p_job_cost_rate_schedule_id IN NUMBER DEFAULT NULL,
260 p_project_type IN VARCHAR2 DEFAULT NULL,
261 p_task_id IN NUMBER DEFAULT NULL,
262 p_bill_rate_multiplier IN NUMBER DEFAULT NULL,
263 p_project_bill_job_group_id IN NUMBER DEFAULT NULL,
264 p_emp_bill_rate_schedule_id IN NUMBER DEFAULT NULL,
265 p_job_bill_rate_schedule_id IN NUMBER DEFAULT NULL,
266 p_distribution_rule IN VARCHAR2 DEFAULT NULL,
267 p_amount_calc_mode IN VARCHAR2 DEFAULT 'ALL',/*Possible values 'ALL','COST','REVENUE' */
268 /* Added fro Org Forecasting*/
269 P_system_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp,/* Added */
270 /* for Org Forecasting */
271 p_assign_precedes_task IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
272 p_labor_schdl_discnt IN NUMBER DEFAULT NULL, /* Added for Org Forecasting */
273 p_labor_bill_rate_org_id IN NUMBER DEFAULT NULL, /* Added for Org Forecasting */
274 p_labor_std_bill_rate_schdl IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
275 p_labor_schedule_fixed_date IN DATE DEFAULT NULL, /* Added for Org Forecasting */
276 p_labor_sch_type IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
277 p_forecast_item_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp, /* Added para for bug 2212852 */
278 p_forecasting_type IN VARCHAR2 DEFAULT 'PROJECT_FORECASTING',/*Added par for bug2212852*/
279 p_projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
280 p_projfunc_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
281 p_projfunc_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
282 p_projfunc_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
283 p_projfunc_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for Org Forecasting */
284 p_projfunc_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
285 p_projfunc_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
286 x_projfunc_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
287 x_projfunc_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
288 x_projfunc_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
289 x_projfunc_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
290 x_projfunc_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
291 x_projfunc_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
292 x_projfunc_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
293 x_projfunc_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
294 x_projfunc_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
295 x_projfunc_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
296 x_projfunc_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
297 x_projfunc_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
298 p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
299 p_project_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
300 p_project_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
301 p_project_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
302 p_project_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */
303 p_project_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
304 p_project_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
305 x_project_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
306 x_project_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
307 x_project_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
308 x_project_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
309 x_project_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
310 x_project_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
311 x_project_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
312 x_project_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
313 x_project_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
314 x_project_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
315 x_project_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
316 x_project_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
317 x_exp_func_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
318 x_exp_func_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
319 x_exp_func_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
320 x_exp_func_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
321 x_exp_func_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
322 x_exp_func_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
323 x_exp_func_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
324 x_exp_func_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
325 x_cst_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
326 x_txn_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
327 x_txn_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
328 x_txn_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
329 x_txn_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
330 x_rev_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
331 x_txn_rev_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
332 x_txn_rev_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
333 x_error_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
334 x_rev_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
335 x_cst_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
336 x_burdned_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
337 x_others_rejct_reason_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed for Org Forecasting */ --File.Sql.39 bug 4440895
338 /* from OUT to IN OUT */
339 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
340 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
341 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
342
343
344
345 --
346 -- Procedure : calc_rate_amount
347 -- Purpose : This procedure will calculate the bill rate for Assignment and Requirement for all period
348 -- Parameters : Table of Record and Scalar
349 --
350
351
352 /* Added for performance bug 2691192, it replaces the use of view pa_rep_period_dates_v */
353 PROCEDURE get_rep_period_dates(
354 p_period_type IN VARCHAR2 ,
355 p_completion_date IN DATE,
356 x_period_year OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
357 x_period_name OUT NOCOPY gl_periods.period_name%TYPE, --File.Sql.39 bug 4440895
358 x_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
359 x_end_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
360 x_error_value OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
361
362
363 --
364 -- Procedure : get_rep_period_dates
365 -- Purpose : This procedure will display information about period types such as the name of
366 -- the period and the start and end dates.';
367 -- Parameters :
368 --
369
370 END PA_RATE_PVT_PKG;
371