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.

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 1628: l_completion_date pa_projects_all.completion_date%TYPE;

1624: x_error_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1625: 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
1626: IS
1627:
1628: l_completion_date pa_projects_all.completion_date%TYPE;
1629: l_period_type pa_rep_period_dates_v.period_type%TYPE;
1630: l_period_name pa_rep_period_dates_v.period_name%TYPE;
1631: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1632: l_end_date pa_rep_period_dates_v.end_date%TYPE;

Line 1635: l_converted_rev_amount pa_projects_all.project_value%TYPE;

1631: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1632: l_end_date pa_rep_period_dates_v.end_date%TYPE;
1633:
1634: /* Added for MCB2 */
1635: l_converted_rev_amount pa_projects_all.project_value%TYPE;
1636: l_conversion_fail EXCEPTION;
1637: l_denominator Number;
1638: l_numerator Number;
1639: l_status Varchar2(30);

Line 1830: l_converted_rev_amount pa_projects_all.project_value%TYPE;

1826: l_proj_cost NUMBER;
1827: l_running_cost NUMBER:=0;
1828:
1829: /* Added for MCB2 */
1830: l_converted_rev_amount pa_projects_all.project_value%TYPE;
1831: l_conversion_fail EXCEPTION;
1832: l_denominator Number;
1833: l_numerator Number;
1834: l_status Varchar2(30);

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

1940: p_distribution_rule IN VARCHAR2 DEFAULT NULL,
1941: x_rev_gen_method OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
1942: x_error_msg OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1943: IS
1944: l_rule pa_projects_all.distribution_rule%TYPE; -- Used to store the distribution rule for
1945: -- further result e.g if rule starts with work
1946: -- then project is T and M else Fixed price
1947: l_proj_typ VARCHAR2(1); -- Used to store type of the project for return
1948: -- statement i.e. if 'T' - 'T and M' ,'C' - 'Cost based'

Line 1966: FROM pa_project_types_all typ, pa_projects_all proj

1962: /* Selecting distribution rule for checking wheather the project is Fixed Price or T and M */
1963: BEGIN
1964: SELECT proj.distribution_rule,typ.project_type_class_code
1965: INTO l_rule,l_class_code
1966: FROM pa_project_types_all typ, pa_projects_all proj
1967: WHERE proj.project_id = p_project_id
1968: AND proj.project_type = typ.project_type
1969: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul : removed NVL function
1970:

Line 2117: l_project_org_id pa_projects_all.org_id%TYPE;

2113:
2114: l_project_type pa_project_types_all.project_type%TYPE;
2115: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
2116:
2117: l_project_org_id pa_projects_all.org_id%TYPE;
2118: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
2119: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
2120: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
2121:

Line 2118: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

2114: l_project_type pa_project_types_all.project_type%TYPE;
2115: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
2116:
2117: l_project_org_id pa_projects_all.org_id%TYPE;
2118: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
2119: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
2120: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
2121:
2122:

Line 2119: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

2115: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
2116:
2117: l_project_org_id pa_projects_all.org_id%TYPE;
2118: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
2119: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
2120: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
2121:
2122:
2123: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;

Line 2120: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

2116:
2117: l_project_org_id pa_projects_all.org_id%TYPE;
2118: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
2119: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
2120: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
2121:
2122:
2123: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
2124: l_labor_schedule_discount NUMBER;

Line 2123: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;

2119: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
2120: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
2121:
2122:
2123: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
2124: l_labor_schedule_discount NUMBER;
2125: l_labor_bill_rate_org_id NUMBER;
2126: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;
2127: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;

Line 2126: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;

2122:
2123: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
2124: l_labor_schedule_discount NUMBER;
2125: l_labor_bill_rate_org_id NUMBER;
2126: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;
2127: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;
2128:
2129: l_raw_cost_rate NUMBER;
2130: l_raw_cost NUMBER;

Line 2127: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;

2123: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
2124: l_labor_schedule_discount NUMBER;
2125: l_labor_bill_rate_org_id NUMBER;
2126: l_labor_std_bill_rate_schedule pa_projects_all.labor_std_bill_rate_schdl%TYPE;
2127: l_labor_schedule_type pa_projects_all.labor_sch_type%TYPE;
2128:
2129: l_raw_cost_rate NUMBER;
2130: l_raw_cost NUMBER;
2131:

Line 2136: l_distribution_rule pa_projects_all.distribution_rule%TYPE;

2132: l_x_return_status VARCHAR2(50);
2133: l_proj_bill_job_id NUMBER;
2134: l_overr_to_organization_id NUMBER;
2135: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_id%TYPE;
2136: l_distribution_rule pa_projects_all.distribution_rule%TYPE;
2137:
2138:
2139: l_proj_cost_job_id NUMBER;
2140: l_cost_rate_multiplier NUMBER;

Line 2156: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

2152: l_exp_func_burdened_cost_rate NUMBER;
2153: l_exp_func_burdened_cost NUMBER;
2154:
2155: /* Added for MCB2 */
2156: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2157: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2158: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2159: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2160: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 2157: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

2153: l_exp_func_burdened_cost NUMBER;
2154:
2155: /* Added for MCB2 */
2156: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2157: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2158: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2159: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2160: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2161: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

Line 2158: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

2154:
2155: /* Added for MCB2 */
2156: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2157: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2158: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2159: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2160: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2161: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2162: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;

Line 2159: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

2155: /* Added for MCB2 */
2156: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2157: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2158: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2159: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2160: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2161: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2162: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2163: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 2160: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

2156: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2157: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2158: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2159: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2160: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2161: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2162: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2163: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2164: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */

Line 2161: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

2157: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
2158: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2159: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2160: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2161: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2162: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2163: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2164: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
2165: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */

Line 2162: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;

2158: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
2159: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2160: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2161: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2162: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2163: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2164: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
2165: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
2166: /* Till here for mcb 2 */

Line 2163: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

2159: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
2160: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2161: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2162: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2163: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2164: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
2165: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
2166: /* Till here for mcb 2 */
2167:

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

2161: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
2162: l_projfunc_cost_rate_date pa_projects_all.projfunc_cost_rate_DATE%TYPE;
2163: l_projfunc_cost_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
2164: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
2165: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
2166: /* Till here for mcb 2 */
2167:
2168: /* Added for Org Foreasting */
2169: l_projfunc_bill_rate NUMBER;

Line 2178: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

2174: l_projfunc_burdened_cost_rate NUMBER;
2175:
2176: l_amount_calc_mode VARCHAR2(50);
2177:
2178: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2179: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2180: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2181: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2182: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 2179: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

2175:
2176: l_amount_calc_mode VARCHAR2(50);
2177:
2178: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2179: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2180: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2181: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2182: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2183: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

Line 2180: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

2176: l_amount_calc_mode VARCHAR2(50);
2177:
2178: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2179: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2180: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2181: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2182: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2183: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2184: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;

Line 2181: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

2177:
2178: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2179: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2180: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2181: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2182: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2183: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2184: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
2185: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 2182: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

2178: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2179: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2180: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2181: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2182: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2183: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2184: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
2185: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2186: l_project_bill_rate NUMBER;

Line 2183: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

2179: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
2180: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2181: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2182: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2183: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2184: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
2185: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2186: l_project_bill_rate NUMBER;
2187: l_project_raw_revenue NUMBER;

Line 2184: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;

2180: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
2181: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2182: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2183: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2184: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
2185: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2186: l_project_bill_rate NUMBER;
2187: l_project_raw_revenue NUMBER;
2188: l_project_raw_cost NUMBER;

Line 2185: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

2181: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
2182: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2183: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
2184: l_project_cost_rate_date pa_projects_all.project_rate_DATE%TYPE;
2185: l_project_cost_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
2186: l_project_bill_rate NUMBER;
2187: l_project_raw_revenue NUMBER;
2188: l_project_raw_cost NUMBER;
2189: l_project_raw_cost_rate NUMBER;

Line 2258: FROM pa_project_types_all typ, pa_projects_all proj

2254: /* Selecting distribution rule for calculation rate */
2255: BEGIN
2256: SELECT proj.distribution_rule,typ.project_type_class_code,proj.labor_sch_type
2257: INTO l_distribution_rule,l_class_code,l_labor_schedule_type
2258: FROM pa_project_types_all typ, pa_projects_all proj
2259: WHERE proj.project_id = p_project_id
2260: AND proj.project_type = typ.project_type
2261: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul : removed NVL function
2262:

Line 2308: FROM pa_project_types_all typ, pa_projects_all proj

2304: IF ( p_project_type IS NULL) THEN
2305:
2306: SELECT typ.project_type
2307: INTO l_project_type
2308: FROM pa_project_types_all typ, pa_projects_all proj
2309: WHERE proj.project_id = p_project_id
2310: AND proj.project_type = typ.project_type
2311: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul: removed NVL function
2312:

Line 2371: FROM pa_projects_all

2367: l_labor_bill_rate_org_id,
2368: l_labor_std_bill_rate_schedule,
2369: l_labor_schedule_fixed_date,
2370: l_labor_schedule_type
2371: FROM pa_projects_all
2372: WHERE project_id = p_project_id;
2373: END;
2374: ELSE
2375: IF p_project_org_id IS NOT NULL THEN

Line 2498: FROM pa_projects_all

2494: l_projfunc_bil_rate_type,l_projfunc_bil_rate_date,l_projfunc_bil_exchange_rate,
2495: l_projfunc_cost_rate_date,l_projfunc_cost_rate_type,
2496: l_assignment_precedes_task,
2497: l_labor_schedule_type
2498: FROM pa_projects_all
2499: WHERE project_id = p_project_id;
2500: END;
2501: END IF;
2502: */

Line 3118: l_projfunc_rev_rt_dt_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;

3114: l_forecast_item_id pa_forecast_items.forecast_item_id%TYPE; /* added for bug 2212852 */
3115:
3116: /* Adding for Org Forecasting */
3117:
3118: l_projfunc_rev_rt_dt_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
3119: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
3120: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
3121: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
3122:

Line 3119: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;

3115:
3116: /* Adding for Org Forecasting */
3117:
3118: l_projfunc_rev_rt_dt_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
3119: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
3120: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
3121: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
3122:
3123: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;

Line 3120: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;

3116: /* Adding for Org Forecasting */
3117:
3118: l_projfunc_rev_rt_dt_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
3119: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
3120: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
3121: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
3122:
3123: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;
3124: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;

Line 3121: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;

3117:
3118: l_projfunc_rev_rt_dt_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
3119: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
3120: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
3121: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
3122:
3123: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;
3124: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;
3125: l_projfunc_cst_exch_rt NUMBER;

Line 3123: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;

3119: l_projfunc_rev_rt_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
3120: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
3121: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
3122:
3123: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;
3124: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;
3125: l_projfunc_cst_exch_rt NUMBER;
3126:
3127: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;

Line 3124: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;

3120: l_projfunc_rev_rt_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
3121: l_projfunc_rev_exch_rt PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
3122:
3123: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;
3124: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;
3125: l_projfunc_cst_exch_rt NUMBER;
3126:
3127: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
3128: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;

Line 3127: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;

3123: l_projfunc_cst_rt_type PA_PROJECTS_ALL.projfunc_cost_rate_type%TYPE;
3124: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;
3125: l_projfunc_cst_exch_rt NUMBER;
3126:
3127: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
3128: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
3129: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3130: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3131:

Line 3128: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;

3124: l_projfunc_cst_rt_date PA_PROJECTS_ALL.projfunc_cost_rate_date%TYPE;
3125: l_projfunc_cst_exch_rt NUMBER;
3126:
3127: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
3128: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
3129: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3130: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3131:
3132: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;

Line 3129: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;

3125: l_projfunc_cst_exch_rt NUMBER;
3126:
3127: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
3128: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
3129: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3130: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3131:
3132: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;
3133: l_project_cst_rt_date PA_PROJECTS_ALL.project_rate_date%TYPE;

Line 3130: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;

3126:
3127: l_project_rev_rt_dt_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
3128: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
3129: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3130: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3131:
3132: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;
3133: l_project_cst_rt_date PA_PROJECTS_ALL.project_rate_date%TYPE;
3134: l_project_cst_exch_rt NUMBER;

Line 3132: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;

3128: l_project_rev_rt_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
3129: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3130: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3131:
3132: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;
3133: l_project_cst_rt_date PA_PROJECTS_ALL.project_rate_date%TYPE;
3134: l_project_cst_exch_rt NUMBER;
3135:
3136: l_project_bill_rate NUMBER;

Line 3133: l_project_cst_rt_date PA_PROJECTS_ALL.project_rate_date%TYPE;

3129: l_project_rev_rt_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
3130: l_project_rev_exch_rt PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
3131:
3132: l_project_cst_rt_type PA_PROJECTS_ALL.project_rate_type%TYPE;
3133: l_project_cst_rt_date PA_PROJECTS_ALL.project_rate_date%TYPE;
3134: l_project_cst_exch_rt NUMBER;
3135:
3136: l_project_bill_rate NUMBER;
3137: l_project_raw_revenue NUMBER;