1 PACKAGE PA_CC_TRANSFER_PRICE AUTHID CURRENT_USER AS
2 /* $Header: PAXCCTPS.pls 120.2 2007/02/09 05:28:27 anuagraw ship $ */
3
4 -------------------------------------------------------------------------------
5 -- Procedure
6 -- Get_Transfer_Price
7 -- Purpose
8 -- Called from Borrowed and Lent Process and IC Billing program
9 -- This procedure is overloaded procedure. This procedure accepts
10 -- amount,percentage (float) and Date datatypes as Varchar2 and does the
11 -- explicit conversion.
12
13 PROCEDURE Get_Transfer_Price
14 (
15 p_module_name IN VARCHAR2,
16 p_prvdr_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
17 p_recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
18 p_recvr_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
19 p_expnd_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
20 p_expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
21 p_expenditure_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
22 p_expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
23 p_expenditure_item_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
24 p_labor_non_labor_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
25 p_system_linkage_function IN PA_PLSQL_DATATYPES.Char30TabTyp,
26 p_task_id IN PA_PLSQL_DATATYPES.IdTabTyp,
27 p_tp_schedule_id IN PA_PLSQL_DATATYPES.IdTabTyp,
28 p_denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
29 p_project_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
30 --Start Added for devdrop2
31 p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
32 --End Added for devdrop2
33 p_revenue_distributed_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
34 p_processed_thru_date IN Date,
35 p_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
36 p_tp_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
37 p_denom_raw_cost_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
38 p_denom_burdened_cost_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
39 p_raw_revenue_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
40 p_project_id IN PA_PLSQL_DATATYPES.IdTabTyp,
41 p_quantity IN PA_PLSQL_DATATYPES.Char30TabTyp,
42 p_incurred_by_person_id IN PA_PLSQL_DATATYPES.IdTabTyp,
43 p_job_id IN PA_PLSQL_DATATYPES.IdTabTyp,
44 p_non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp,
45 p_nl_resource_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
46 p_pa_date IN PA_PLSQL_DATATYPES.Char30TabTyp
47 default PA_PLSQL_DATATYPES.EmptyChar30Tab,
48 p_array_size IN Number,
49 p_debug_mode IN Varchar2,
50 --Start Added for devdrop2
51 p_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
52 p_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
53 x_proj_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
54 x_proj_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
55 x_proj_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
56 x_proj_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
57 --
58 x_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
59 x_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
60 x_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
61 x_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
62 --End Added for devdrop2
63 x_denom_tp_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp,
64 x_denom_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
65 x_acct_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
66 x_acct_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
67 x_acct_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
68 x_acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
69 x_cc_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
70 x_tp_ind_compiled_set_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
71 x_tp_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
72 x_tp_base_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
73 x_tp_bill_markup_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
74 x_tp_schedule_line_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
75 x_tp_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
76 x_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
77 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
78 x_return_status OUT NOCOPY NUMBER ,
79 /* Bill rate Discount*/
80 p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp
81 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
82 p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp
83 DEFAULT PA_PLSQL_DATATYPES.EmptyChar1Tab,
84 p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp
85 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
86 p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp
87 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
88 /* bug#3221791 */
89 p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp
90 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
91 p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp
92 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
93 p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp
94 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
95 p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp
96 DEFAULT PA_PLSQL_DATATYPES.EmptyChar1Tab,
97 p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp
98 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
99 p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp
100 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
101 p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp
102 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
103 p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp
104 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
105 p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp
106 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
107 p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp
108 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
109 p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp
110 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
111 p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp
112 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
113 p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp
114 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
115 p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp
116 DEFAULT PA_PLSQL_DATATYPES.EmptyChar1Tab,
117
118 p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp
119 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
120 p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp
121 DEFAULT PA_PLSQL_DATATYPES.EmptyIdTab,
122 p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp
123 DEFAULT PA_PLSQL_DATATYPES.EmptyIdTab,
124 p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp
125 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
126 p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp
127 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
128 p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp
129 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
130 p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp
131 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
132 p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp
133 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
134 p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp
135 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
136 p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp
137 DEFAULT PA_PLSQL_DATATYPES.EmptyChar1Tab,
138 /* Added the two parameters for Doosan rate api enhancement */
139 p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
140 p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
141 p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
142 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
143
144 );
145
146 --------------------------------------------------------------------------------
147 -- Procedure
148 -- Get_Transfer_Price
149 -- Purpose
150 -- Called from Borrowed and Lent Process and IC Billing
151 -- It calculates Transfer Price
152
153 PROCEDURE Get_Transfer_Price
154 (
155 p_module_name IN VARCHAR2,
156 p_prvdr_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
157 p_recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
158 p_recvr_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
159 p_expnd_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
160 p_expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
161 p_expenditure_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
162 p_expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
163 p_expenditure_item_date IN PA_PLSQL_DATATYPES.DateTabTyp,
164 p_labor_non_labor_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
165 p_system_linkage_function IN PA_PLSQL_DATATYPES.Char30TabTyp,
166 p_task_id IN PA_PLSQL_DATATYPES.IdTabTyp,
167 p_tp_schedule_id IN PA_PLSQL_DATATYPES.IdTabTyp,
168 p_denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
169 p_project_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
170 --Start Added for devdrop2
171 p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
172 --End Added for devdrop2
173 p_revenue_distributed_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
174 p_processed_thru_date IN Date,
175 p_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
176 p_tp_fixed_date IN PA_PLSQL_DATATYPES.DateTabTyp,
177 p_denom_raw_cost_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
178 p_denom_burdened_cost_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
179 p_raw_revenue_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
180 p_project_id IN PA_PLSQL_DATATYPES.IdTabTyp,
181 p_quantity IN PA_PLSQL_DATATYPES.NumTabTyp,
182 p_incurred_by_person_id IN PA_PLSQL_DATATYPES.IdTabTyp,
183 p_job_id IN PA_PLSQL_DATATYPES.IdTabTyp,
184 p_non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp,
185 p_nl_resource_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
186 p_pa_date IN PA_PLSQL_DATATYPES.DateTabTyp
187 default PA_PLSQL_DATATYPES.EmptyDateTab,
188 p_array_size IN Number,
189 p_debug_mode IN Varchar2,
190 --Start Added for devdrop2
191 p_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
192 p_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
193 p_prvdr_operating_unit IN PA_PLSQL_DATATYPES.IdTabTyp
194 DEFAULT PA_PLSQL_DATATYPES.EmptyIDTab ,
195 --
196 x_proj_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
197 x_proj_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp,
198 x_proj_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
199 x_proj_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
200 --
201 x_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
202 x_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp,
203 x_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
204 x_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
205 --End Added for devdrop2
206 x_denom_tp_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp,
207 x_denom_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
208 x_acct_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
209 x_acct_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp,
210 x_acct_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
211 x_acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
212 x_cc_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
213 x_tp_ind_compiled_set_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
214 x_tp_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
215 x_tp_base_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
216 x_tp_bill_markup_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
217 x_tp_schedule_line_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
218 x_tp_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
219 x_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
220 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
221 x_return_status OUT NOCOPY NUMBER ,/*File.sql.39*/
222 /* Bill rate Discount*/
223 p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp
224 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
225 p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp
226 DEFAULT PA_PLSQL_DATATYPES.EmptyChar1Tab,
227 p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.NumTabTyp
228 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
229 p_raw_cost IN PA_PLSQL_DATATYPES.NumTabTyp
230 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
231 /* bug#3221791 */
232 p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp
233 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
234 p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.DateTabTyp
235 DEFAULT PA_PLSQL_DATATYPES.EmptyDateTab,
236 p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp
237 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
238 p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp
239 DEFAULT PA_PLSQL_DATATYPES.EmptyChar1Tab,
240 p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp
241 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
242 p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp
243 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
244 p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp
245 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
246 p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp
247 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
248 p_raw_cost_rate IN PA_PLSQL_DATATYPES.NumTabTyp
249 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
250 p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp
251 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
252 p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp
253 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
254 p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp
255 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
256 p_exp_raw_cost IN PA_PLSQL_DATATYPES.NumTabTyp
257 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
258 p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp
259 DEFAULT PA_PLSQL_DATATYPES.EmptyChar1Tab,
260
261 p_burden_cost IN PA_PLSQL_DATATYPES.NumTabTyp
262 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
263 p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp
264 DEFAULT PA_PLSQL_DATATYPES.EmptyIDTab,
265 p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp
266 DEFAULT PA_PLSQL_DATATYPES.EmptyIdTab,
267 p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp
268 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
269 p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp
270 DEFAULT PA_PLSQL_DATATYPES.EmptyChar30Tab,
271 p_nl_task_sch_date IN PA_PLSQL_DATATYPES.DateTabTyp
272 DEFAULT PA_PLSQL_DATATYPES.EmptyDateTab,
273 p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.DateTabTyp
274 DEFAULT PA_PLSQL_DATATYPES.EmptyDateTab,
275 p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp
276 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
277 p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp
278 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
279 p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp
280 DEFAULT PA_PLSQL_DATATYPES.EmptyChar1Tab,
281 /* Added the two parameters for Doosan rate api enhancement */
285 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
282 p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
283 p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
284 p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
286
287 );
288
289 --------------------------------------------------------------------------------
290 -- Set the global variables provider_org_id,cc_default_rate_type,
291 -- cc_default_rate_date etc.
292
293 PROCEDURE Get_Provider_Attributes (
294 p_prvdr_operating_unit IN PA_PLSQL_DATATYPES.IdTabTyp
295 DEFAULT PA_PLSQL_DATATYPES.EmptyIDTab,
296 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp )
297 ;
298 --------------------------------------------------------------------------------
299
300 PROCEDURE SET_GLOBAL_VARIABLES (
301 p_org_id IN NUMBER)
302 ;
303 --------------------------------------------------------------------------------
304
305 -- Validate the input parameters
306 -- Check if schedule_id is null
307 -- Mark the transactions where transfer price calculation not needed i.e they
308 -- are marked for only currency conversion.
309
310 PROCEDURE Validate_Array
311 (
312 p_prvdr_operating_unit IN PA_PLSQL_DATATYPES.IdTabTyp
313 DEFAULT PA_PLSQL_DATATYPES.EmptyIDTab ,
314 p_tp_schedule_id IN PA_PLSQL_DATATYPES.IdTabTyp,
315 p_denom_tp_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
316 p_acct_currency_code IN varchar2 ,
317 p_denom_transfer_price IN PA_PLSQL_DATATYPES.NumTabTyp,
318 p_acct_tp_rate_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
319 p_acct_tp_rate_date IN PA_PLSQL_DATATYPES.DateTabTyp,
320 p_acct_transfer_price IN PA_PLSQL_DATATYPES.NumTabTyp,
321 p_acct_tp_exchange_rate IN PA_PLSQL_DATATYPES.NumTabTyp,
322 x_compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
323 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
324 );
325
326 --------------------------------------------------------------------------------
327 -- Set the global variables for WHO columns i.e. G_created_by,G_creation_date
328 -- , G_last_updated_by,G_last_Update_date etc.
329
330 PROCEDURE Init_who_cols;
331
332 --------------------------------------------------------------------------------
333 -- Get Legal entity id of an operating unit
334
335 PROCEDURE Get_Legal_Entity (
336 p_org_id IN NUMBER,
337 x_legal_entity_id OUT NOCOPY NUMBER/*File.sql.39*/
338 );
339
340 --------------------------------------------------------------------------------
341 -- Get schedule_line_id given a schedule_id and processed_thru_date
342 -- Apply transfer price determination rules to identify schedule_line_id
343 -- for a given provider, receiver organization and operating unit combinations.
344 PROCEDURE Get_Schedule_Line(
345 p_expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
346 /* Start Added for 3118101 */
347 p_expenditure_item_date IN PA_PLSQL_DATATYPES.DateTabTyp,
348 /* End Added for 3118101 */
349 p_prvdr_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
350 p_recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
351 p_recvr_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
352 p_labor_non_labor_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
353 p_tp_schedule_id IN PA_PLSQL_DATATYPES.IdTabTyp,
354 p_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
355 --Start Added for devdrop2
356 p_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
357 --End Added for devdrop2
358 p_prvdr_operating_unit IN PA_PLSQL_DATATYPES.IdTabTyp
359 DEFAULT PA_PLSQL_DATATYPES.EmptyIDTab ,
360 /** Added for Org Forecasting **/
361 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
362 x_tp_schedule_line_id OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
363 x_tp_schedule_line_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
364 x_tp_rule_id OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp
365 );
366 --------------------------------------------------------------------------------
367 -- Get schedule_line_id from Lookup table
368 PROCEDURE Get_Schedule_Line_From_Lookup(
369 p_prvdr_organization_id IN Number,
370 p_recvr_org_id IN Number,
371 p_recvr_organization_id IN Number,
372 p_tp_schedule_id IN Number,
373 p_labor_flag IN Varchar2,
374 p_tp_amt_type_code IN Varchar2,
375 /* Start Added for 3118101 */
376 p_expenditure_item_date IN Date,
377 /* End Added for 3118101 */
378 x_tp_schedule_line_id OUT NOCOPY Number/*File.sql.39*/
379 );
380 --------------------------------------------------------------------------------
381 -- Determine schedule_line_id using transfer price rules - given a combination
382 -- of provider org, receiver org, provider ou and receiver ou.
383 PROCEDURE Determine_Schedule_Line(
384 p_prvdr_organization_id IN Number,
385 p_recvr_org_id IN Number,
386 p_recvr_organization_id IN Number,
387 p_tp_schedule_id IN Number,
388 p_labor_non_labor_flag IN Varchar2,
389 /* Start Added for 3118101 */
390 p_expenditure_item_date IN Date,
391 /* End Added for 3118101 */
395 x_tp_schedule_line_id OUT NOCOPY Number,/*File.sql.39*/
392 --Start Added for devdrop2
393 p_tp_amt_type_code IN Varchar2,
394 --End Added for devdrop2
396 x_tp_rule_id OUT NOCOPY Number,/*File.sql.39*/
397 x_percentage_applied OUT NOCOPY Number,/*File.sql.39*/
398 x_start_date_active OUT NOCOPY Date,/*File.sql.39*/
399 x_end_date_active OUT NOCOPY Date,/*File.sql.39*/
400 x_sort_order OUT NOCOPY Number, /*bug5753774*/
401 x_error_code IN OUT NOCOPY VARCHAR2/*File.sql.39*/
402 );
403 -------------------------------------------------------------------------------
404 -- Insert a row into Schedule Line lookup table.
405
406 PROCEDURE Insert_Schedule_Line_Into_Lkp(
407 p_prvdr_organization_id IN Number,
408 p_recvr_org_id IN Number,
409 p_recvr_organization_id IN Number,
410 p_tp_schedule_id IN Number,
411 p_tp_schedule_line_id IN Number,
412 p_labor_flag IN Varchar2,
413 p_tp_amt_type_code IN Varchar2,
414 p_start_date_active IN Date,
415 p_end_date_active IN Date,
416 p_sort_order IN Number, /*bug5753774*/
417 x_error_code IN OUT NOCOPY Varchar2 /*File.sql.39*/
418 );
419
420 -------------------------------------------------------------------------------
421 -- Get schedule_line attributes from pa_cc_tp_schedule_lines table
422
423 PROCEDURE Get_Schedule_Line_Attributes(
424 p_tp_schedule_line_id IN Number,
425 p_labor_flag IN Varchar2,
426 x_tp_rule_id OUT NOCOPY Number, /*File.sql.39*/
427 x_percentage_applied OUT NOCOPY Number, /*File.sql.39*/
428 x_error_code IN OUT NOCOPY VARCHAR2 /*File.sql.39*/
429 );
430 --------------------------------------------------------------------------------
431 PROCEDURE Get_Transfer_Price_Amount
432 (
433 p_tp_rule_id IN PA_PLSQL_DATATYPES.IdTabTyp,
434 p_expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
435 p_expenditure_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
436 p_expenditure_item_date IN PA_PLSQL_DATATYPES.DateTabTyp,
437 p_expnd_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
438 p_project_id IN PA_PLSQL_DATATYPES.IdTabTyp,
439 p_task_id IN PA_PLSQL_DATATYPES.IdTabTyp,
440 p_denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
441 p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
442 p_revenue_distributed_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
443 p_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
444 p_denom_raw_cost_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
445 p_denom_burdened_cost_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
446 p_raw_revenue_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
447 p_quantity IN PA_PLSQL_DATATYPES.NumTabTyp,
448 p_incurred_by_person_id IN PA_PLSQL_DATATYPES.IdTabTyp,
449 p_job_id IN PA_PLSQL_DATATYPES.IdTabTyp,
450 p_non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp,
451 p_nl_resource_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
452 p_system_linkage_function IN PA_PLSQL_DATATYPES.Char30TabTyp,
453 p_tp_schedule_line_percentage IN PA_PLSQL_DATATYPES.NumTabTyp,
454 p_tp_fixed_date IN PA_PLSQL_DATATYPES.DateTabTyp,
455 x_denom_tp_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp,
456 x_denom_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
457 x_cc_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
458 x_tp_ind_compiled_set_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
459 x_tp_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
460 x_tp_base_curr_code OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp,
461 x_tp_base_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
462 x_tp_bill_markup_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
463 x_tp_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
464 x_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
465 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
466 /* Bill rate Discount*/
467 p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
468 p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
469 p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.NumTabTyp,
470 p_raw_cost IN PA_PLSQL_DATATYPES.NumTabTyp,
471 p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* bug#3221791 */
472 p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.DateTabTyp,
473 p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
474 p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
475 p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp,
476 p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
477 p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
478 p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
479 p_raw_cost_rate IN PA_PLSQL_DATATYPES.NumTabTyp,
480 p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
481 p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
482 p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
483 p_exp_raw_cost IN PA_PLSQL_DATATYPES.NumTabTyp,
484 p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
485 p_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
486
487 p_burden_cost IN PA_PLSQL_DATATYPES.NumTabTyp,
491 p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
488 p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
489 p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
490 p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
492 p_nl_task_sch_date IN PA_PLSQL_DATATYPES.DateTabTyp,
493 p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.DateTabTyp,
494 p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
495 p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
496 p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
497 /* Added the two parameters for Doosan rate api enhancement */
498 p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
499 p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
500 p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
501 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
502
503 );
504 --------------------------------------------------------------------------------
505 -- Get rule attributes from pa_cc_tp_rules table
506
507 PROCEDURE Get_Rule_Attributes(
508 p_tp_rule_id IN PA_PLSQL_DATATYPES.IdTabTyp,
509 p_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
510 x_calc_method_code OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
511 x_cc_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
512 x_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
513 x_schedule_id OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
514 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
515 );
516 --------------------------------------------------------------------------------
517 -- Validate each transaction, set base amount, calculate Burdened Amount
518 -- if actual burdened amount is not given. Also, set the Basis_Compute_Flag,
519 -- Bill_Rate_Compute_Flag and Burden_Rate_Compute_flag appropriately
520 -- using calc_method_code
521
522 PROCEDURE Set_Base_Amount_And_Flag(
523 p_expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
524 p_expenditure_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
525 p_expenditure_item_date IN PA_PLSQL_DATATYPES.DateTabTyp,
526 p_expnd_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
527 P_project_id IN PA_PLSQL_DATATYPES.IdTabTyp,
528 p_task_id IN PA_PLSQL_DATATYPES.IdTabTyp,
529 p_fixed_date IN PA_PLSQL_DATATYPES.DateTabTyp,
530 p_calc_method_code IN PA_PLSQL_DATATYPES.Char1TabTyp,
531 p_cc_markup_base_code IN PA_PLSQL_DATATYPES.Char1TabTyp,
532 p_denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
533 p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
534 p_denom_raw_cost_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
535 p_denom_burdened_cost_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
536 p_raw_revenue_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
537 p_revenue_distributed_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
538 p_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
539 p_tp_ind_compiled_set_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
540 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
541 x_basis_compute_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
542 x_bill_rate_compute_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
543 x_burden_rate_compute_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
544 x_tp_base_curr_code OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp,
545 x_tp_base_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
546 /*Bill rate discount*/
547 p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
548 p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
549 p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.NumTabTyp,
550 p_quantity IN PA_PLSQL_DATATYPES.NumTabTyp,
551 p_person_id IN PA_PLSQL_DATATYPES.IdTabTyp,
552 p_raw_cost IN PA_PLSQL_DATATYPES.NumTabTyp,
553 p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* bug#3221791 */
554 p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.DateTabTyp,
555 p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
556 p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
557 p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp,
558 p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
559 p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
560 p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
561 p_raw_cost_rate IN PA_PLSQL_DATATYPES.NumTabTyp,
562 p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
563 p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
564 p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
565 p_exp_raw_cost IN PA_PLSQL_DATATYPES.NumTabTyp,
566 p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
567 p_sys_linkage_function IN PA_PLSQL_DATATYPES.Char30TabTyp,
568 p_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
569
570 p_burden_cost IN PA_PLSQL_DATATYPES.NumTabTyp,
571 p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
572 p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
576 p_nl_task_sch_date IN PA_PLSQL_DATATYPES.DateTabTyp,
573 p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
574 p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
575 p_non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp,
577 p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.DateTabTyp,
578 p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
579 p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
580 p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
581 /* Added the two parameters for Doosan rate api enhancement */
582 p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
583 p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
584 p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
585 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
586 );
587 -------------------------------------------------------------------------------
588 PROCEDURE Determine_Transfer_Price
589 (
590 p_expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
591 p_expnd_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
592 p_expenditure_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
593 p_expenditure_item_date IN PA_PLSQL_DATATYPES.DateTabTyp,
594 p_fixed_date IN PA_PLSQL_DATATYPES.DateTabTyp,
595 p_system_linkage_function IN PA_PLSQL_DATATYPES.Char30TabTyp,
596 p_task_id IN PA_PLSQL_DATATYPES.IdTabTyp,
597 p_tp_base_curr_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
598 p_tp_base_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
599 p_tp_schedule_line_percentage IN PA_PLSQL_DATATYPES.NumTabTyp,
600 p_tp_rule_percentage IN PA_PLSQL_DATATYPES.NumTabTyp,
601 p_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
602 p_quantity IN PA_PLSQL_DATATYPES.NumTabTyp,
603 p_incurred_by_person_id IN PA_PLSQL_DATATYPES.IdTabTyp,
604 p_job_id IN PA_PLSQL_DATATYPES.IdTabTyp,
605 p_rate_schedule_id IN PA_PLSQL_DATATYPES.IdTabTyp,
606 p_non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp,
607 p_basis_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
608 p_bill_rate_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
609 p_burden_rate_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
610 x_denom_tp_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp,
611 x_denom_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
612 x_tp_ind_compiled_set_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
613 x_tp_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
614 x_tp_bill_markup_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
615 x_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
616 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
617 );
618
619 --------------------------------------------------------------------------------
620 -- Get transfer price amount when calc_method_code is basis.
621
622 PROCEDURE Get_Basis_Amount(
623 p_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
624 p_tp_base_curr_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
625 p_tp_base_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
626 p_array_size IN Number,
627 x_denom_tp_curr_code OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp,
628 x_amount OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
629 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
630 );
631 -------------------------------------------------------------------------------
632 -- Get transfer price amount when calc_method_code is use burden rate schedule.
633 -- This procedure is basically a wrapper for PA_COST_PLUS.Get_Burden_Amount
634 -- in order to process array.
635
636 PROCEDURE Get_Burden_Amount(
637 p_array_size IN Number,
638 p_burden_schedule_id IN PA_PLSQL_DATATYPES.IdTabTyp,
639 p_expenditure_item_date IN PA_PLSQL_DATATYPES.DateTabTyp,
640 p_fixed_date IN PA_PLSQL_DATATYPES.DateTabTyp,
641 p_expenditure_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
642 p_organization_id IN PA_PLSQL_DATATYPES.IdTabTyp,
643 p_raw_amount_curr_code IN PA_PLSQL_DATATYPES.Char15TabTyp,
644 p_raw_amount IN PA_PLSQL_DATATYPES.NumTabTyp,
645 p_compute_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
646 x_computed_currency OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp,
647 x_burden_amount OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
648 x_compiled_set_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
649 x_error_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
650 );
651 ---------------------------------------------------------------------------------
652 Procedure Get_Burdening_Details(p_project_id IN NUMBER,
653 x_burdening_allowed OUT NOCOPY VARCHAR2, /*File.sql.39*/
654 x_burden_amt_display_method OUT NOCOPY VARCHAR2 /*File.sql.39*/
655 );
656 -------------------------------------------------------------------------------
657
658 PROCEDURE Get_business_group (
659 p_org_id IN NUMBER,
660 x_business_group_id OUT NOCOPY NUMBER/*File.sql.39*/
661 );
662 --------------------------------------------------------------------------------
663
664 /* Bug 3051110-Added for TP Enhancement, This procedure calculates the
665 Transfer Price Rate for the assignment id passed */
666
667 PROCEDURE Get_Initial_Transfer_Price
668 ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
672 ,x_transfer_pr_rate_curr OUT NOCOPY pa_project_assignments.transfer_pr_rate_curr%TYPE /*File.sql.39*/
669 ,p_start_date IN pa_project_assignments.start_date%TYPE
670 ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
671 ,x_transfer_price_rate OUT NOCOPY pa_project_assignments.transfer_price_rate%TYPE /*File.sql.39*/
673 ,x_return_status OUT NOCOPY VARCHAR2 /*File.sql.39*/
674 ,x_msg_data OUT NOCOPY VARCHAR2 /*File.sql.39*/
675 ,x_msg_count OUT NOCOPY Number /*File.sql.39*/
676 );
677
678 END PA_CC_TRANSFER_PRICE;
679
[Home] [Help]