1 PACKAGE PA_FORECAST_REVENUE AUTHID CURRENT_USER as
2 /* $Header: PARFRTRS.pls 120.1 2005/08/19 16:52:26 mwasowic noship $ */
3
4 PROCEDURE Get_Rev_Amt ( p_project_id IN NUMBER,
5 p_task_id IN NUMBER DEFAULT NULL,
6 p_bill_rate_multiplier IN NUMBER DEFAULT NULL,
7 p_quantity IN NUMBER,
8 p_person_id IN NUMBER,
9 p_raw_cost IN NUMBER DEFAULT NULL,
10 p_item_date IN DATE,
11 p_labor_schdl_discnt IN NUMBER DEFAULT NULL,
12 p_labor_bill_rate_org_id IN NUMBER DEFAULT NULL,
13 p_labor_std_bill_rate_schdl IN VARCHAR2 DEFAULT NULL,
14 p_labor_schdl_fixed_date IN DATE DEFAULT NULL,
15 p_bill_job_grp_id IN NUMBER DEFAULT NULL,
16 p_forecast_item_id IN NUMBER DEFAULT NULL,
17 p_labor_sch_type IN VARCHAR2 DEFAULT NULL,
18 p_project_org_id IN NUMBER DEFAULT NULL,
19 p_project_type IN VARCHAR2 DEFAULT NULL,
20 p_expenditure_type IN VARCHAR2 DEFAULT NULL ,
21 p_exp_func_curr_code IN VARCHAR2 DEFAULT NULL,
22 p_incurred_by_organz_id IN NUMBER DEFAULT NULL,
23 p_raw_cost_rate IN NUMBER DEFAULT NULL,
24 p_override_to_organz_id IN NUMBER DEFAULT NULL,
25 p_forecast_job_id IN NUMBER DEFAULT NULL /* Required in case of Requirement, added for Assignment override */,
26 p_forecast_job_group_id IN NUMBER DEFAULT NULL /* Required in case of Requirement , added for Assignment override */,
27 p_expenditure_org_id IN NUMBER DEFAULT NULL /* Required in case of Requirement , added for Assignment override */ ,
28 p_expenditure_organization_id IN NUMBER DEFAULT NULL /* Required in case of Requirement , added for Assignment override */,
29 p_check_error_flag IN VARCHAR2 DEFAULT 'Y', /* added for bug 2218386 */
30
31 x_bill_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
32 x_raw_revenue OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
33 x_rev_currency_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34 x_markup_percentage OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
35 x_return_status OUT NOCOPY VARCHAR2, /* added for Assignment override */ --File.Sql.39 bug 4440895
36 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
37 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
38
39 --
40 -- Procedure : Get_Rev_Amt
41 -- Purpose :This procedure will calculate the raw revenue and bill amount from one of the 12
42 -- criterias on the basis of passed parameters
43 -- Parameters :
44 --
45
46 END PA_FORECAST_REVENUE;