452: l_prev_asg_id NUMBER;
453: l_prev_proj_orgid NUMBER;
454: l_prev_exp_type Pa_Expenditure_Types.EXPENDITURE_TYPE%TYPE;
455: /* Project Info */
456: l_prj_type Pa_Projects_All.Project_Type%TYPE;
457: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
458: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
459: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
460: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
453: l_prev_proj_orgid NUMBER;
454: l_prev_exp_type Pa_Expenditure_Types.EXPENDITURE_TYPE%TYPE;
455: /* Project Info */
456: l_prj_type Pa_Projects_All.Project_Type%TYPE;
457: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
458: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
459: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
460: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
461: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
454: l_prev_exp_type Pa_Expenditure_Types.EXPENDITURE_TYPE%TYPE;
455: /* Project Info */
456: l_prj_type Pa_Projects_All.Project_Type%TYPE;
457: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
458: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
459: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
460: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
461: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
462: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
455: /* Project Info */
456: l_prj_type Pa_Projects_All.Project_Type%TYPE;
457: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
458: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
459: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
460: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
461: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
462: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
463: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
456: l_prj_type Pa_Projects_All.Project_Type%TYPE;
457: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
458: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
459: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
460: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
461: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
462: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
463: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
464: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
457: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
458: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
459: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
460: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
461: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
462: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
463: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
464: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
465: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
458: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
459: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
460: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
461: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
462: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
463: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
464: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
465: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
466: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
459: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
460: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
461: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
462: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
463: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
464: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
465: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
466: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
467: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
460: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
461: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
462: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
463: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
464: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
465: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
466: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
467: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
468: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
461: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
462: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
463: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
464: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
465: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
466: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
467: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
468: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
469: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
462: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
463: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
464: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
465: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
466: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
467: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
468: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
469: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
470: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
463: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
464: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
465: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
466: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
467: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
468: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
469: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
470: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
471: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
464: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
465: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
466: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
467: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
468: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
469: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
470: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
471: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
472: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
465: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
466: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
467: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
468: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
469: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
470: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
471: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
472: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
473: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
466: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
467: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
468: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
469: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
470: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
471: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
472: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
473: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
474: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
467: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
468: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
469: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
470: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
471: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
472: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
473: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
474: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
475: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
468: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
469: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
470: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
471: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
472: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
473: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
474: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
475: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
476: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
469: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
470: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
471: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
472: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
473: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
474: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
475: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
476: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
477: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
470: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
471: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
472: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
473: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
474: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
475: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
476: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
477: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
478: l_fcst_cost_rate_schid pa_forecasting_options_All.JOB_COST_RATE_SCHEDULE_ID%TYPE;
471: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
472: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
473: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
474: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
475: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
476: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
477: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
478: l_fcst_cost_rate_schid pa_forecasting_options_All.JOB_COST_RATE_SCHEDULE_ID%TYPE;
479:
472: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
473: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
474: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
475: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
476: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
477: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
478: l_fcst_cost_rate_schid pa_forecasting_options_All.JOB_COST_RATE_SCHEDULE_ID%TYPE;
479:
480: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
473: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
474: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
475: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
476: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
477: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
478: l_fcst_cost_rate_schid pa_forecasting_options_All.JOB_COST_RATE_SCHEDULE_ID%TYPE;
479:
480: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
481: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
476: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
477: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
478: l_fcst_cost_rate_schid pa_forecasting_options_All.JOB_COST_RATE_SCHEDULE_ID%TYPE;
479:
480: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
481: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
482: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
483: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
484: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
477: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
478: l_fcst_cost_rate_schid pa_forecasting_options_All.JOB_COST_RATE_SCHEDULE_ID%TYPE;
479:
480: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
481: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
482: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
483: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
484: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
485: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
478: l_fcst_cost_rate_schid pa_forecasting_options_All.JOB_COST_RATE_SCHEDULE_ID%TYPE;
479:
480: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
481: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
482: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
483: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
484: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
485: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
486:
479:
480: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
481: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
482: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
483: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
484: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
485: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
486:
487: l_chk number := 0;
480: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
481: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
482: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
483: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
484: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
485: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
486:
487: l_chk number := 0;
488:
481: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
482: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
483: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
484: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
485: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
486:
487: l_chk number := 0;
488:
489: /* Project PL SQL table for Rate API */
822: l_prev_rt_fcst_jobid Pa_Project_Assignments.Fcst_Job_Id%TYPE;
823: l_prev_rt_fcst_jobgroupid Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
824: l_prev_rt_exp_type Pa_Forecast_Items.Expenditure_Type%TYPE;
825: l_prev_rt_org_id Pa_Forecast_Items.Expenditure_Org_Id%TYPE;
826: l_prev_rt_prj_type Pa_Projects_All.Project_Type%TYPE;
827: l_prev_rt_projfunc_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
828: l_prev_rt_proj_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
829: l_prev_rt_bill_jobgroup_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
830: l_prev_rt_emp_bilrate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
823: l_prev_rt_fcst_jobgroupid Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
824: l_prev_rt_exp_type Pa_Forecast_Items.Expenditure_Type%TYPE;
825: l_prev_rt_org_id Pa_Forecast_Items.Expenditure_Org_Id%TYPE;
826: l_prev_rt_prj_type Pa_Projects_All.Project_Type%TYPE;
827: l_prev_rt_projfunc_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
828: l_prev_rt_proj_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
829: l_prev_rt_bill_jobgroup_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
830: l_prev_rt_emp_bilrate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
831: l_prev_rt_job_bilrate_schid Pa_Projects_All.Job_Bill_Rate_Schedule_Id%TYPE;
824: l_prev_rt_exp_type Pa_Forecast_Items.Expenditure_Type%TYPE;
825: l_prev_rt_org_id Pa_Forecast_Items.Expenditure_Org_Id%TYPE;
826: l_prev_rt_prj_type Pa_Projects_All.Project_Type%TYPE;
827: l_prev_rt_projfunc_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
828: l_prev_rt_proj_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
829: l_prev_rt_bill_jobgroup_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
830: l_prev_rt_emp_bilrate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
831: l_prev_rt_job_bilrate_schid Pa_Projects_All.Job_Bill_Rate_Schedule_Id%TYPE;
832: l_prev_rt_dist_rule Pa_Projects_All.Distribution_Rule%TYPE;
825: l_prev_rt_org_id Pa_Forecast_Items.Expenditure_Org_Id%TYPE;
826: l_prev_rt_prj_type Pa_Projects_All.Project_Type%TYPE;
827: l_prev_rt_projfunc_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
828: l_prev_rt_proj_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
829: l_prev_rt_bill_jobgroup_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
830: l_prev_rt_emp_bilrate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
831: l_prev_rt_job_bilrate_schid Pa_Projects_All.Job_Bill_Rate_Schedule_Id%TYPE;
832: l_prev_rt_dist_rule Pa_Projects_All.Distribution_Rule%TYPE;
833: l_prev_rt_cost_rate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
826: l_prev_rt_prj_type Pa_Projects_All.Project_Type%TYPE;
827: l_prev_rt_projfunc_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
828: l_prev_rt_proj_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
829: l_prev_rt_bill_jobgroup_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
830: l_prev_rt_emp_bilrate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
831: l_prev_rt_job_bilrate_schid Pa_Projects_All.Job_Bill_Rate_Schedule_Id%TYPE;
832: l_prev_rt_dist_rule Pa_Projects_All.Distribution_Rule%TYPE;
833: l_prev_rt_cost_rate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
834:
827: l_prev_rt_projfunc_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
828: l_prev_rt_proj_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
829: l_prev_rt_bill_jobgroup_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
830: l_prev_rt_emp_bilrate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
831: l_prev_rt_job_bilrate_schid Pa_Projects_All.Job_Bill_Rate_Schedule_Id%TYPE;
832: l_prev_rt_dist_rule Pa_Projects_All.Distribution_Rule%TYPE;
833: l_prev_rt_cost_rate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
834:
835: l_prev_rt_labor_sch_discount NUMBER;
828: l_prev_rt_proj_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
829: l_prev_rt_bill_jobgroup_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
830: l_prev_rt_emp_bilrate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
831: l_prev_rt_job_bilrate_schid Pa_Projects_All.Job_Bill_Rate_Schedule_Id%TYPE;
832: l_prev_rt_dist_rule Pa_Projects_All.Distribution_Rule%TYPE;
833: l_prev_rt_cost_rate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
834:
835: l_prev_rt_labor_sch_discount NUMBER;
836: l_prev_rt_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
829: l_prev_rt_bill_jobgroup_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
830: l_prev_rt_emp_bilrate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
831: l_prev_rt_job_bilrate_schid Pa_Projects_All.Job_Bill_Rate_Schedule_Id%TYPE;
832: l_prev_rt_dist_rule Pa_Projects_All.Distribution_Rule%TYPE;
833: l_prev_rt_cost_rate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
834:
835: l_prev_rt_labor_sch_discount NUMBER;
836: l_prev_rt_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
837: l_prev_rt_labor_bill_rt_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
832: l_prev_rt_dist_rule Pa_Projects_All.Distribution_Rule%TYPE;
833: l_prev_rt_cost_rate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
834:
835: l_prev_rt_labor_sch_discount NUMBER;
836: l_prev_rt_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
837: l_prev_rt_labor_bill_rt_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
838: l_prev_rt_labor_std_bl_rt_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
839: l_prev_rt_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
840: l_prev_rt_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
833: l_prev_rt_cost_rate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%TYPE;
834:
835: l_prev_rt_labor_sch_discount NUMBER;
836: l_prev_rt_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
837: l_prev_rt_labor_bill_rt_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
838: l_prev_rt_labor_std_bl_rt_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
839: l_prev_rt_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
840: l_prev_rt_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
841:
834:
835: l_prev_rt_labor_sch_discount NUMBER;
836: l_prev_rt_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
837: l_prev_rt_labor_bill_rt_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
838: l_prev_rt_labor_std_bl_rt_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
839: l_prev_rt_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
840: l_prev_rt_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
841:
842: /* local variables */
835: l_prev_rt_labor_sch_discount NUMBER;
836: l_prev_rt_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
837: l_prev_rt_labor_bill_rt_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
838: l_prev_rt_labor_std_bl_rt_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
839: l_prev_rt_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
840: l_prev_rt_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
841:
842: /* local variables */
843: l_fi_process_flag varchar2(1);
836: l_prev_rt_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
837: l_prev_rt_labor_bill_rt_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
838: l_prev_rt_labor_std_bl_rt_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
839: l_prev_rt_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
840: l_prev_rt_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
841:
842: /* local variables */
843: l_fi_process_flag varchar2(1);
844: l_call_rate_api_flag varchar2(1) := 'N';
1566: l_labor_bill_rate_orgid,
1567: l_labor_std_bill_rate_sch,
1568: l_labor_sch_fixed_dt,
1569: l_labor_sch_type
1570: FROM Pa_Projects_All P
1571: WHERE P.Project_Id = l_prev_project_id;
1572: EXCEPTION
1573: WHEN NO_DATA_FOUND THEN
1574: l_fi_others_rejct_reason_tab(i) := 'PA_INVALID_PROJECT_ID';