eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_RATE_PVT_PKG dependencies on PA_PROJECTS_ALL

Line 169: l_project_org_id pa_projects_all.org_id%TYPE;

165:
166: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;
167: l_project_type pa_project_types_all.project_type%TYPE;
168: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
169: l_project_org_id pa_projects_all.org_id%TYPE;
170: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
171: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
172: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
173: l_distribution_rule pa_projects_all.distribution_rule%TYPE;

Line 170: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

166: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;
167: l_project_type pa_project_types_all.project_type%TYPE;
168: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
169: l_project_org_id pa_projects_all.org_id%TYPE;
170: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
171: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
172: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
173: l_distribution_rule pa_projects_all.distribution_rule%TYPE;
174:

Line 171: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

167: l_project_type pa_project_types_all.project_type%TYPE;
168: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
169: l_project_org_id pa_projects_all.org_id%TYPE;
170: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
171: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
172: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
173: l_distribution_rule pa_projects_all.distribution_rule%TYPE;
174:
175: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_id%TYPE;

Line 172: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

168: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
169: l_project_org_id pa_projects_all.org_id%TYPE;
170: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
171: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
172: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
173: l_distribution_rule pa_projects_all.distribution_rule%TYPE;
174:
175: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_id%TYPE;
176:

Line 173: l_distribution_rule pa_projects_all.distribution_rule%TYPE;

169: l_project_org_id pa_projects_all.org_id%TYPE;
170: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
171: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
172: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
173: l_distribution_rule pa_projects_all.distribution_rule%TYPE;
174:
175: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_id%TYPE;
176:
177: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;

Line 177: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;

173: l_distribution_rule pa_projects_all.distribution_rule%TYPE;
174:
175: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_id%TYPE;
176:
177: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
178: l_labor_schedule_discount NUMBER;
179: l_labor_bill_rate_org_id NUMBER;
180: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;
181: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;

Line 180: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;

176:
177: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
178: l_labor_schedule_discount NUMBER;
179: l_labor_bill_rate_org_id NUMBER;
180: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;
181: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;
182:
183: l_x_return_status VARCHAR2(50);
184: l_x_process_return_status VARCHAR2(50);

Line 181: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;

177: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
178: l_labor_schedule_discount NUMBER;
179: l_labor_bill_rate_org_id NUMBER;
180: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;
181: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;
182:
183: l_x_return_status VARCHAR2(50);
184: l_x_process_return_status VARCHAR2(50);
185: l_schedule_type VARCHAR2(50);

Line 215: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

211: l_exp_func_burdened_cost_rate NUMBER;
212: l_exp_func_burdened_cost NUMBER;
213:
214: /* Added for MCB2 */
215: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
216: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
217: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
218: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
219: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 216: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

212: l_exp_func_burdened_cost NUMBER;
213:
214: /* Added for MCB2 */
215: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
216: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
217: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
218: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
219: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
220: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

Line 217: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

213:
214: /* Added for MCB2 */
215: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
216: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
217: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
218: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
219: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
220: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
221: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;

Line 218: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

214: /* Added for MCB2 */
215: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
216: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
217: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
218: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
219: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
220: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
221: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
222: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 219: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

215: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
216: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
217: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
218: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
219: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
220: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
221: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
222: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
223: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */

Line 220: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

216: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
217: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
218: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
219: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
220: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
221: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
222: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
223: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
224: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */

Line 221: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;

217: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
218: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
219: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
220: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
221: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
222: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
223: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
224: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
225: /* Till here for mcb 2 */

Line 222: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

218: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
219: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
220: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
221: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
222: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
223: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
224: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
225: /* Till here for mcb 2 */
226:

Line 224: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */

220: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
221: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
222: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
223: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
224: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
225: /* Till here for mcb 2 */
226:
227: /* Added for Org Foreasting */
228: l_projfunc_bill_rate NUMBER;

Line 237: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

233: l_projfunc_burdened_cost_rate NUMBER;
234:
235: l_amount_calc_mode VARCHAR2(50);
236:
237: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
238: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
239: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
240: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
241: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 238: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

234:
235: l_amount_calc_mode VARCHAR2(50);
236:
237: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
238: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
239: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
240: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
241: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
242: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

Line 239: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

235: l_amount_calc_mode VARCHAR2(50);
236:
237: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
238: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
239: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
240: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
241: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
242: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
243: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;

Line 240: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

236:
237: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
238: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
239: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
240: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
241: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
242: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
243: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
244: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 241: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

237: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
238: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
239: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
240: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
241: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
242: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
243: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
244: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
245: l_project_bill_rate NUMBER;

Line 242: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

238: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
239: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
240: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
241: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
242: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
243: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
244: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
245: l_project_bill_rate NUMBER;
246: l_project_raw_revenue NUMBER;

Line 243: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;

239: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
240: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
241: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
242: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
243: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
244: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
245: l_project_bill_rate NUMBER;
246: l_project_raw_revenue NUMBER;
247: l_project_raw_cost NUMBER;

Line 244: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

240: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
241: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
242: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
243: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
244: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
245: l_project_bill_rate NUMBER;
246: l_project_raw_revenue NUMBER;
247: l_project_raw_cost NUMBER;
248: l_project_raw_cost_rate NUMBER;

Line 306: FROM pa_project_types_all typ, pa_projects_all proj

302: */
303: BEGIN
304: SELECT proj.distribution_rule,typ.project_type_class_code
305: INTO l_distribution_rule,l_class_code
306: FROM pa_project_types_all typ, pa_projects_all proj
307: WHERE proj.project_id = p_project_id
308: AND proj.project_type = typ.project_type
309: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul : removed NVL function
310:

Line 534: FROM pa_project_types_all typ, pa_projects_all proj

530: IF ( p_project_type IS NULL) THEN
531:
532: SELECT typ.project_type
533: INTO l_project_type
534: FROM pa_project_types_all typ, pa_projects_all proj
535: WHERE proj.project_id = p_project_id
536: AND proj.project_type = typ.project_type
537: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul: removed NVL function
538:

Line 601: FROM pa_projects_all

597: l_labor_bill_rate_org_id,
598: l_labor_std_bill_rate_schedule,
599: l_labor_schedule_fixed_date,
600: l_labor_schedule_type
601: FROM pa_projects_all
602: WHERE project_id = p_project_id;
603:
604: IF g1_debug_mode = 'Y' THEN
605: -- dbms_output.put_line('projfunc currency '||l_projfunc_currency_code);

Line 745: FROM pa_projects_all

741: l_projfunc_currency_code,l_projfunc_bil_rate_date_code, -- Added the following columns for MCB2
742: l_projfunc_bil_rate_type,l_projfunc_bil_rate_date,l_projfunc_bil_exchange_rate,
743: l_projfunc_cost_rate_date,l_projfunc_cost_rate_type,
744: l_assignment_precedes_task
745: FROM pa_projects_all
746: WHERE project_id = p_project_id;
747:
748: END IF;
749:

Line 1559: l_completion_date pa_projects_all.completion_date%TYPE;

1555: x_error_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1556: x_projfunc_revenue_tab OUT NOCOPY PA_RATE_PVT_PKG.ProjAmt_TabTyp /* This tabwill store aount in project functional currency */) --File.Sql.39 bug 4440895
1557: IS
1558:
1559: l_completion_date pa_projects_all.completion_date%TYPE;
1560: l_period_type pa_rep_period_dates_v.period_type%TYPE;
1561: l_period_name pa_rep_period_dates_v.period_name%TYPE;
1562: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1563: l_end_date pa_rep_period_dates_v.end_date%TYPE;

Line 1566: l_converted_rev_amount pa_projects_all.project_value%TYPE;

1562: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1563: l_end_date pa_rep_period_dates_v.end_date%TYPE;
1564:
1565: /* Added for MCB2 */
1566: l_converted_rev_amount pa_projects_all.project_value%TYPE;
1567: l_conversion_fail EXCEPTION;
1568: l_denominator Number;
1569: l_numerator Number;
1570: l_status Varchar2(30);

Line 1761: l_converted_rev_amount pa_projects_all.project_value%TYPE;

1757: l_proj_cost NUMBER;
1758: l_running_cost NUMBER:=0;
1759:
1760: /* Added for MCB2 */
1761: l_converted_rev_amount pa_projects_all.project_value%TYPE;
1762: l_conversion_fail EXCEPTION;
1763: l_denominator Number;
1764: l_numerator Number;
1765: l_status Varchar2(30);

Line 1875: l_rule pa_projects_all.distribution_rule%TYPE; -- Used to store the distribution rule for

1871: p_distribution_rule IN VARCHAR2 DEFAULT NULL,
1872: x_rev_gen_method OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
1873: x_error_msg OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1874: IS
1875: l_rule pa_projects_all.distribution_rule%TYPE; -- Used to store the distribution rule for
1876: -- further result e.g if rule starts with work
1877: -- then project is T and M else Fixed price
1878: l_proj_typ VARCHAR2(1); -- Used to store type of the project for return
1879: -- statement i.e. if 'T' - 'T and M' ,'C' - 'Cost based'

Line 1897: FROM pa_project_types_all typ, pa_projects_all proj

1893: /* Selecting distribution rule for checking wheather the project is Fixed Price or T and M */
1894: BEGIN
1895: SELECT proj.distribution_rule,typ.project_type_class_code
1896: INTO l_rule,l_class_code
1897: FROM pa_project_types_all typ, pa_projects_all proj
1898: WHERE proj.project_id = p_project_id
1899: AND proj.project_type = typ.project_type
1900: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul : removed NVL function
1901:

Line 2048: l_project_org_id pa_projects_all.org_id%TYPE;

2044:
2045: l_project_type pa_project_types_all.project_type%TYPE;
2046: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
2047:
2048: l_project_org_id pa_projects_all.org_id%TYPE;
2049: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
2050: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
2051: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
2052:

Line 2049: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

2045: l_project_type pa_project_types_all.project_type%TYPE;
2046: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
2047:
2048: l_project_org_id pa_projects_all.org_id%TYPE;
2049: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
2050: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
2051: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
2052:
2053:

Line 2050: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

2046: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
2047:
2048: l_project_org_id pa_projects_all.org_id%TYPE;
2049: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
2050: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
2051: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
2052:
2053:
2054: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;

Line 2051: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

2047:
2048: l_project_org_id pa_projects_all.org_id%TYPE;
2049: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
2050: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
2051: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
2052:
2053:
2054: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
2055: l_labor_schedule_discount NUMBER;

Line 2054: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;

2050: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
2051: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
2052:
2053:
2054: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
2055: l_labor_schedule_discount NUMBER;
2056: l_labor_bill_rate_org_id NUMBER;
2057: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;
2058: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;

Line 2057: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;

2053:
2054: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
2055: l_labor_schedule_discount NUMBER;
2056: l_labor_bill_rate_org_id NUMBER;
2057: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;
2058: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;
2059:
2060: l_raw_cost_rate NUMBER;
2061: l_raw_cost NUMBER;

Line 2058: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;

2054: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
2055: l_labor_schedule_discount NUMBER;
2056: l_labor_bill_rate_org_id NUMBER;
2057: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;
2058: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;
2059:
2060: l_raw_cost_rate NUMBER;
2061: l_raw_cost NUMBER;
2062:

Line 2067: l_distribution_rule pa_projects_all.distribution_rule%TYPE;

2063: l_x_return_status VARCHAR2(50);
2064: l_proj_bill_job_id NUMBER;
2065: l_overr_to_organization_id NUMBER;
2066: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_id%TYPE;
2067: l_distribution_rule pa_projects_all.distribution_rule%TYPE;
2068:
2069:
2070: l_proj_cost_job_id NUMBER;
2071: l_cost_rate_multiplier NUMBER;

Line 2087: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

2083: l_exp_func_burdened_cost_rate NUMBER;
2084: l_exp_func_burdened_cost NUMBER;
2085:
2086: /* Added for MCB2 */
2087: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2088: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2089: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2090: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2091: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 2088: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

2084: l_exp_func_burdened_cost NUMBER;
2085:
2086: /* Added for MCB2 */
2087: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2088: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2089: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2090: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2091: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2092: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

Line 2089: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

2085:
2086: /* Added for MCB2 */
2087: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2088: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2089: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2090: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2091: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2092: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2093: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;

Line 2090: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

2086: /* Added for MCB2 */
2087: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2088: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2089: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2090: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2091: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2092: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2093: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2094: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 2091: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

2087: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2088: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2089: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2090: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2091: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2092: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2093: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2094: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2095: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */

Line 2092: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

2088: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2089: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2090: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2091: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2092: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2093: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2094: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2095: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
2096: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */

Line 2093: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;

2089: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2090: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2091: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2092: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2093: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2094: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2095: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
2096: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
2097: /* Till here for mcb 2 */

Line 2094: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

2090: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2091: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2092: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2093: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2094: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2095: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
2096: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
2097: /* Till here for mcb 2 */
2098:

Line 2096: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */

2092: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2093: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2094: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2095: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
2096: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
2097: /* Till here for mcb 2 */
2098:
2099: /* Added for Org Foreasting */
2100: l_projfunc_bill_rate NUMBER;

Line 2109: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

2105: l_projfunc_burdened_cost_rate NUMBER;
2106:
2107: l_amount_calc_mode VARCHAR2(50);
2108:
2109: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2110: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2111: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2112: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2113: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 2110: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

2106:
2107: l_amount_calc_mode VARCHAR2(50);
2108:
2109: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2110: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2111: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2112: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2113: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2114: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

Line 2111: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

2107: l_amount_calc_mode VARCHAR2(50);
2108:
2109: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2110: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2111: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2112: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2113: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2114: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2115: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;

Line 2112: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

2108:
2109: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2110: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2111: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2112: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2113: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2114: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2115: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
2116: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 2113: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

2109: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2110: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2111: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2112: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2113: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2114: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2115: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
2116: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2117: l_project_bill_rate NUMBER;

Line 2114: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

2110: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2111: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2112: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2113: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2114: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2115: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
2116: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2117: l_project_bill_rate NUMBER;
2118: l_project_raw_revenue NUMBER;

Line 2115: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;

2111: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2112: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2113: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2114: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2115: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
2116: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2117: l_project_bill_rate NUMBER;
2118: l_project_raw_revenue NUMBER;
2119: l_project_raw_cost NUMBER;

Line 2116: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

2112: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2113: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2114: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2115: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
2116: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2117: l_project_bill_rate NUMBER;
2118: l_project_raw_revenue NUMBER;
2119: l_project_raw_cost NUMBER;
2120: l_project_raw_cost_rate NUMBER;

Line 2189: FROM pa_project_types_all typ, pa_projects_all proj

2185: /* Selecting distribution rule for calculation rate */
2186: BEGIN
2187: SELECT proj.distribution_rule,typ.project_type_class_code,proj.labor_sch_type
2188: INTO l_distribution_rule,l_class_code,l_labor_schedule_type
2189: FROM pa_project_types_all typ, pa_projects_all proj
2190: WHERE proj.project_id = p_project_id
2191: AND proj.project_type = typ.project_type
2192: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul : removed NVL function
2193:

Line 2239: FROM pa_project_types_all typ, pa_projects_all proj

2235: IF ( p_project_type IS NULL) THEN
2236:
2237: SELECT typ.project_type
2238: INTO l_project_type
2239: FROM pa_project_types_all typ, pa_projects_all proj
2240: WHERE proj.project_id = p_project_id
2241: AND proj.project_type = typ.project_type
2242: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul: removed NVL function
2243:

Line 2302: FROM pa_projects_all

2298: l_labor_bill_rate_org_id,
2299: l_labor_std_bill_rate_schedule,
2300: l_labor_schedule_fixed_date,
2301: l_labor_schedule_type
2302: FROM pa_projects_all
2303: WHERE project_id = p_project_id;
2304: END;
2305: ELSE
2306: IF p_project_org_id IS NOT NULL THEN

Line 2429: FROM pa_projects_all

2425: l_projfunc_bil_rate_type,l_projfunc_bil_rate_date,l_projfunc_bil_exchange_rate,
2426: l_projfunc_cost_rate_date,l_projfunc_cost_rate_type,
2427: l_assignment_precedes_task,
2428: l_labor_schedule_type
2429: FROM pa_projects_all
2430: WHERE project_id = p_project_id;
2431: END;
2432: END IF;
2433: */

Line 2988: l_projfunc_rev_rt_dt_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;

2984: l_forecast_item_id pa_forecast_items.forecast_item_id%TYPE; /* added for bug 2212852 */
2985:
2986: /* Adding for Org Forecasting */
2987:
2988: l_projfunc_rev_rt_dt_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2989: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2990: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2991: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2992:

Line 2989: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;

2985:
2986: /* Adding for Org Forecasting */
2987:
2988: l_projfunc_rev_rt_dt_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2989: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2990: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2991: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2992:
2993: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;

Line 2990: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;

2986: /* Adding for Org Forecasting */
2987:
2988: l_projfunc_rev_rt_dt_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2989: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2990: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2991: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2992:
2993: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;
2994: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;

Line 2991: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;

2987:
2988: l_projfunc_rev_rt_dt_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2989: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2990: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2991: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2992:
2993: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;
2994: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;
2995: l_projfunc_cst_exch_rt NUMBER;

Line 2993: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;

2989: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2990: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2991: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2992:
2993: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;
2994: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;
2995: l_projfunc_cst_exch_rt NUMBER;
2996:
2997: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;

Line 2994: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;

2990: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2991: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2992:
2993: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;
2994: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;
2995: l_projfunc_cst_exch_rt NUMBER;
2996:
2997: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2998: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;

Line 2997: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;

2993: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;
2994: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;
2995: l_projfunc_cst_exch_rt NUMBER;
2996:
2997: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2998: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2999: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3000: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3001:

Line 2998: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;

2994: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;
2995: l_projfunc_cst_exch_rt NUMBER;
2996:
2997: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2998: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2999: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3000: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3001:
3002: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;

Line 2999: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;

2995: l_projfunc_cst_exch_rt NUMBER;
2996:
2997: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2998: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2999: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3000: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3001:
3002: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;
3003: l_project_cst_rt_date PA_PROJECTS_ALL.project_rate_date%TYPE;

Line 3000: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;

2996:
2997: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2998: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2999: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3000: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3001:
3002: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;
3003: l_project_cst_rt_date PA_PROJECTS_ALL.project_rate_date%TYPE;
3004: l_project_cst_exch_rt NUMBER;

Line 3002: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;

2998: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2999: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3000: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3001:
3002: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;
3003: l_project_cst_rt_date PA_PROJECTS_ALL.project_rate_date%TYPE;
3004: l_project_cst_exch_rt NUMBER;
3005:
3006: l_project_bill_rate NUMBER;

Line 3003: l_project_cst_rt_date PA_PROJECTS_ALL.project_rate_date%TYPE;

2999: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3000: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3001:
3002: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;
3003: l_project_cst_rt_date PA_PROJECTS_ALL.project_rate_date%TYPE;
3004: l_project_cst_exch_rt NUMBER;
3005:
3006: l_project_bill_rate NUMBER;
3007: l_project_raw_revenue NUMBER;