1 PACKAGE PA_REVENUE AUTHID CURRENT_USER as
2 /* $Header: PAXBLRTS.pls 120.1 2005/08/19 17:09:37 mwasowic noship $ */
3
4 PROCEDURE Requirement_Rev_Amt (
5 p_project_id IN NUMBER,
6 p_task_id IN NUMBER,
7 p_bill_rate_multiplier IN NUMBER,
8 p_quantity IN NUMBER,
9 p_raw_cost IN NUMBER,
10 p_item_date IN DATE,
11 p_project_bill_job_grp_id IN NUMBER,
12 p_labor_schdl_discnt IN NUMBER,
13 p_labor_bill_rate_org_id IN NUMBER,
14 p_labor_std_bill_rate_schdl IN VARCHAR2,
15 p_labor_schdl_fixed_date IN DATE,
16 p_forecast_job_id IN NUMBER,
17 p_forecast_job_grp_id IN NUMBER,
18 p_labor_sch_type IN VARCHAR2,
19 p_item_id IN NUMBER DEFAULT NULL, /* change from forecast item id */
20 /* to item id for bug 2212852 */
21 p_project_org_id IN NUMBER,
22 p_job_bill_rate_schedule_id IN NUMBER,
23 p_project_type IN VARCHAR2,
24 p_expenditure_type IN VARCHAR2,
25 px_exp_func_curr_code IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
26 p_incurred_by_organz_id IN NUMBER,
27 p_raw_cost_rate IN NUMBER,
28 p_override_to_organz_id IN NUMBER,
29 p_exp_raw_cost IN NUMBER,
30 p_expenditure_org_id IN NUMBER,
31 p_projfunc_currency_code IN VARCHAR2,/* Added for MCB2 */
32 p_assignment_precedes_task IN VARCHAR2, /* Added for Asgmt overide */
33 p_forecast_item_id IN NUMBER DEFAULT NULL, /* added para for bug 2212852 */
34 p_forecasting_type IN VARCHAR2 DEFAULT 'PROJECT_FORECASTING', /* added para for bug 2212852 */
35 p_sys_linkage_function IN VARCHAR2 , /* Added for Org Forecasting */
36 px_project_bill_job_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
37 x_bill_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
38 x_raw_revenue OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
39 x_markup_percentage OUT NOCOPY NUMBER,/* Added for Asgmt overide */ --File.Sql.39 bug 4440895
40 x_txn_currency_code OUT NOCOPY VARCHAR2, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
41 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
42 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
43 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
44
45
46
47 --
48 -- Procedure : Requirement_Rev_Amt
49 -- Purpose : This procedure will calculate the bill rate and raw revenue from one of
50 -- the given criteria's on the basis of passed parameters
51 -- Parameters :
52 --
53
54
55 PROCEDURE Assignment_Rev_Amt(
56 p_project_id IN NUMBER,
57 p_task_id IN NUMBER DEFAULT NULL,
58 p_bill_rate_multiplier IN NUMBER DEFAULT NULL,
59 p_quantity IN NUMBER,
60 p_person_id IN NUMBER,
61 p_raw_cost IN NUMBER DEFAULT NULL,
62 p_item_date IN DATE,
63 p_labor_schdl_discnt IN NUMBER DEFAULT NULL,
64 p_labor_bill_rate_org_id IN NUMBER DEFAULT NULL,
65 p_labor_std_bill_rate_schdl IN VARCHAR2 DEFAULT NULL,
66 p_labor_schdl_fixed_date IN DATE DEFAULT NULL,
67 p_bill_job_grp_id IN NUMBER DEFAULT NULL,
68 p_item_id IN NUMBER DEFAULT NULL, /* change from forecast item id */
69 /* to item id for bug 2212852 */
70 p_labor_sch_type IN VARCHAR2 DEFAULT NULL,
71 p_project_org_id IN NUMBER DEFAULT NULL,
72 p_project_type IN VARCHAR2 DEFAULT NULL,
73 p_expenditure_type IN VARCHAR2 DEFAULT NULL,
74 p_exp_func_curr_code IN VARCHAR2 DEFAULT NULL,
75 p_incurred_by_organz_id IN NUMBER DEFAULT NULL,
76 p_raw_cost_rate IN NUMBER DEFAULT NULL,
77 p_override_to_organz_id IN NUMBER DEFAULT NULL,
78 p_emp_bill_rate_schedule_id IN VARCHAR2 DEFAULT NULL,
79 p_resource_job_id IN NUMBER,
80 p_exp_raw_cost IN NUMBER,
81 p_expenditure_org_id IN NUMBER,
82 p_projfunc_currency_code IN VARCHAR2, /* Added for MCB2 */
83 p_assignment_precedes_task IN VARCHAR2, /* Added for Asgmt overide */
84 p_forecast_item_id IN NUMBER DEFAULT NULL, /* added para for bug 2212852 */
85 p_forecasting_type IN VARCHAR2 DEFAULT 'PROJECT_FORECASTING', /* added para for bug 2212852 */
86 p_sys_linkage_function IN VARCHAR2 , /* Added for Org Forecasting */
87 x_bill_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
88 x_raw_revenue OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
89 x_rev_currency_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
90 x_markup_percentage OUT NOCOPY NUMBER,/* Added for Asgmt overide */ --File.Sql.39 bug 4440895
91 x_txn_currency_code OUT NOCOPY VARCHAR2,/*Added for Org Forecasting */ --File.Sql.39 bug 4440895
92 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
93 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
94 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
95 /*Bill rate Discount */
96 p_mcb_flag IN VARCHAR2 DEFAULT NULL,
97 p_denom_raw_cost IN NUMBER DEFAULT NULL,
98 p_denom_curr_code IN VARCHAR2 DEFAULT NULL,
99 p_called_process IN VARCHAR2 DEFAULT NULL,
100 p_job_bill_rate_schedule_id IN NUMBER DEFAULT NULL,
101 /* Added for bug 2668753 */
102 p_project_raw_cost IN NUMBER DEFAULT NULL,
103 p_project_currency_code IN VARCHAR2 DEFAULT NULL,
104 x_adjusted_bill_rate OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
105
106
107
108 --
109 -- Procedure : Assignment_Rev_Amt
110 -- Purpose :This procedure will calculate the raw revenue and bill amount from one of the 12
111 -- criterias on the basis of passed parameters
112 -- Parameters :
113 --
114
115 /* New proc added for Org Forecasting */
116 PROCEDURE Get_Converted_Revenue_Amounts(
117 p_item_date IN DATE,
118 px_txn_curr_code IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
119 px_txn_raw_revenue IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
120 px_txn_bill_rate IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
121 px_projfunc_curr_code IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
122 p_projfunc_bil_rate_date_code IN VARCHAR2,
123 px_projfunc_bil_rate_type IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
124 px_projfunc_bil_rate_date IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
125 px_projfunc_bil_exchange_rate IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
126 px_projfunc_raw_revenue IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
127 px_projfunc_bill_rate IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
128 px_project_curr_code IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
129 p_project_bil_rate_date_code IN VARCHAR2,
130 px_project_bil_rate_type IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
131 px_project_bil_rate_date IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
132 px_project_bil_exchange_rate IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
133 px_project_raw_revenue IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
134 px_project_bill_rate IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
135 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
136 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
137 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
138 );
139
140
141 --
142 -- Procedure : Get_Converted_Revenue_Amounts
143 -- Purpose :This procedure will convert the transaction amounts in Project,and Project Functional
144 -- Parameters :
145 --
146
147 /*Bill rate discount */
148 PROCEDURE Non_Labor_Rev_amount(
149 p_project_id IN NUMBER ,
150 p_task_id IN NUMBER ,
151 p_bill_rate_multiplier IN NUMBER ,
152 p_quantity IN NUMBER ,
153 p_raw_cost IN NUMBER ,
154 p_burden_cost IN NUMBER ,
155 p_denom_raw_cost IN NUMBER ,
156 p_denom_burdened_cost IN NUMBER ,
157 p_expenditure_item_date IN DATE ,
158 p_task_bill_rate_org_id IN NUMBER ,
159 p_project_bill_rate_org_id IN NUMBER ,
160 p_task_std_bill_rate_sch IN VARCHAR2 DEFAULT NULL ,
161 p_project_std_bill_rate_sch IN VARCHAR2 DEFAULT NULL ,
162 p_project_org_id IN NUMBER ,
163 p_sl_function IN NUMBER,
164 p_denom_currency_code IN VARCHAR2 ,
165 p_proj_func_currency IN VARCHAR2 ,
166 p_expenditure_type IN VARCHAR2 ,
167 p_non_labor_resource IN VARCHAR2 ,
168 p_task_sch_date IN DATE ,
169 p_project_sch_date IN DATE ,
170 p_project_sch_discount IN NUMBER ,
171 p_task_sch_discount IN NUMBER ,
172 p_mcb_flag IN VARCHAR2 ,
173 p_non_labor_sch_type IN VARCHAR2 ,
174 p_project_type IN VARCHAR2 ,
175 p_exp_raw_cost IN NUMBER,
176 p_raw_cost_rate IN NUMBER ,
177 p_Incurred_by_organz_id IN NUMBER ,
178 p_override_to_organz_id IN VARCHAR2 ,
179 px_exp_func_curr_code IN OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
180 x_raw_revenue OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
181 x_rev_Curr_code OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
182 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
183 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
184 x_msg_data OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
185 /* Added for bug 2668753 */
186 p_project_raw_cost IN NUMBER DEFAULT NULL,
187 p_project_currency_code IN VARCHAR2 DEFAULT NULL,
188 p_project_burdened_cost IN NUMBER DEFAULT NULL,
189 p_proj_func_burdened_cost IN NUMBER DEFAULT NULL,
190 p_exp_func_burdened_cost IN NUMBER DEFAULT NULL,
191 /*Added for Doosan rate api changes */
192 p_task_nl_std_bill_rate_sch_id IN NUMBER DEFAULT NULL,
193 p_proj_nl_std_bill_rate_sch_id IN NUMBER DEFAULT NULL,
194 p_called_process IN VARCHAR2 DEFAULT NULL,
195 x_bill_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
196 x_markup_percentage OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
197 x_adjusted_bill_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
198 p_uom_flag IN NUMBER DEFAULT 1
199
200 );
201
202
203
204 END PA_REVENUE;
205