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_GENERATE_FORECAST_PUB dependencies on PA_PROJECTS_ALL

Line 276: PA_PROJECTS_ALL P WHERE PROJECT_ID = P_PROJECT_ID;

272: P.LABOR_STD_BILL_RATE_SCHDL,
273: P.LABOR_SCHEDULE_FIXED_DATE,
274: P.LABOR_SCH_TYPE
275: FROM
276: PA_PROJECTS_ALL P WHERE PROJECT_ID = P_PROJECT_ID;
277:
278: CURSOR PROJ_ASSIGNMENTS IS
279: SELECT PA.ASSIGNMENT_ID, PA.START_DATE,PA.RESOURCE_ID,PA.PROJECT_ROLE_ID,
280: PA.FCST_JOB_ID,PA.FCST_JOB_GROUP_ID,PR.MEANING,

Line 359: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;

355: RA.PROJECT_ID = c_project_id AND
356: RA.RESOURCE_LIST_MEMBER_ID = 103
357: ORDER BY BL.START_DATE;
358:
359: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
360: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
361: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
362: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
363: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;

Line 360: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

356: RA.RESOURCE_LIST_MEMBER_ID = 103
357: ORDER BY BL.START_DATE;
358:
359: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
360: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
361: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
362: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
363: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
364: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;

Line 361: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

357: ORDER BY BL.START_DATE;
358:
359: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
360: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
361: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
362: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
363: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
364: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
365: l_rev_gen_method VARCHAR2(3);

Line 362: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;

358:
359: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
360: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
361: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
362: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
363: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
364: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
365: l_rev_gen_method VARCHAR2(3);
366: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;

Line 363: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;

359: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
360: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
361: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
362: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
363: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
364: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
365: l_rev_gen_method VARCHAR2(3);
366: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
367: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;

Line 364: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;

360: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
361: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
362: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
363: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
364: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
365: l_rev_gen_method VARCHAR2(3);
366: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
367: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
368: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;

Line 366: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;

362: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
363: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
364: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
365: l_rev_gen_method VARCHAR2(3);
366: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
367: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
368: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
369: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
370: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;

Line 367: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;

363: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
364: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
365: l_rev_gen_method VARCHAR2(3);
366: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
367: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
368: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
369: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
370: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
371: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;

Line 368: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;

364: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
365: l_rev_gen_method VARCHAR2(3);
366: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
367: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
368: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
369: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
370: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
371: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
372: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;

Line 369: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;

365: l_rev_gen_method VARCHAR2(3);
366: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
367: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
368: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
369: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
370: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
371: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
372: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
373: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;

Line 370: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;

366: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
367: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
368: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
369: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
370: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
371: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
372: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
373: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
374: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;

Line 371: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;

367: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
368: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
369: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
370: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
371: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
372: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
373: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
374: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
375: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;

Line 372: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;

368: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
369: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
370: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
371: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
372: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
373: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
374: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
375: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
376:

Line 373: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;

369: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
370: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
371: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
372: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
373: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
374: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
375: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
376:
377: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;

Line 374: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;

370: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
371: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
372: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
373: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
374: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
375: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
376:
377: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
378: /* Added for Org Forecasting */

Line 375: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;

371: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
372: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
373: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
374: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
375: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
376:
377: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
378: /* Added for Org Forecasting */
379:

Line 380: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;

376:
377: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
378: /* Added for Org Forecasting */
379:
380: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
381: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
382: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
383: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
384: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;

Line 381: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;

377: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
378: /* Added for Org Forecasting */
379:
380: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
381: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
382: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
383: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
384: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
385: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;

Line 382: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;

378: /* Added for Org Forecasting */
379:
380: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
381: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
382: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
383: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
384: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
385: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
386: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;

Line 383: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;

379:
380: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
381: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
382: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
383: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
384: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
385: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
386: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
387: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;

Line 384: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;

380: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
381: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
382: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
383: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
384: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
385: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
386: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
387: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
388: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;

Line 385: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;

381: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
382: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
383: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
384: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
385: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
386: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
387: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
388: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
389: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;

Line 386: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;

382: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
383: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
384: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
385: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
386: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
387: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
388: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
389: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
390: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;

Line 387: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;

383: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
384: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
385: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
386: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
387: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
388: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
389: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
390: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
391:

Line 388: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;

384: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
385: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
386: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
387: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
388: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
389: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
390: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
391:
392: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

Line 389: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;

385: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
386: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
387: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
388: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
389: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
390: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
391:
392: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
393: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

Line 390: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;

386: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
387: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
388: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
389: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
390: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
391:
392: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
393: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
394: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

Line 392: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

388: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
389: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
390: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
391:
392: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
393: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
394: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
395: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
396: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

Line 393: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

389: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
390: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
391:
392: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
393: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
394: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
395: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
396: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
397: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

Line 394: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

390: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
391:
392: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
393: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
394: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
395: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
396: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
397: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
398:

Line 395: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;

391:
392: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
393: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
394: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
395: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
396: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
397: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
398:
399: l_rt_pfunc_rev_rt_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;

Line 396: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

392: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
393: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
394: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
395: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
396: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
397: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
398:
399: l_rt_pfunc_rev_rt_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
400: l_rt_pfunc_rev_rt_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 397: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

393: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
394: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
395: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
396: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
397: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
398:
399: l_rt_pfunc_rev_rt_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
400: l_rt_pfunc_rev_rt_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
401: l_rt_pfunc_rev_ex_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 510: l_rev_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

506: l_projfunc_burdened_cost_rate NUMBER;
507: l_error_msg VARCHAR2(30);
508:
509: l_std_raw_revenue NUMBER;
510: l_rev_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
511: l_billable_flag VARCHAR2(2);--Added for the bug 2420564
512:
513: l_rev_reject_reason VARCHAR2(1000);
514: l_cost_reject_reason VARCHAR2(1000);

Line 2155: FUNCTION get_forecast_gen_date(p_project_id IN pa_projects_all.project_id%TYPE)

2151: UPDATE_BUDG_VERSION( p_budget_version_id => l_budget_version_id );
2152: RAISE;
2153: END Generate_Forecast;
2154:
2155: FUNCTION get_forecast_gen_date(p_project_id IN pa_projects_all.project_id%TYPE)
2156: RETURN DATE IS
2157: l_run_date DATE:= NULL;
2158: BEGIN
2159: SELECT plan_run_date INTO l_run_date