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

Line 456: l_prj_type Pa_Projects_All.Project_Type%TYPE;

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;

Line 457: l_distribution_rule Pa_Projects_All.Distribution_Rule%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;

Line 458: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_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;

Line 459: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%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;

Line 460: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%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;

Line 461: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%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;

Line 462: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_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;

Line 463: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%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;

Line 464: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%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;

Line 465: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%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;

Line 466: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%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;

Line 467: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%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;

Line 468: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%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;

Line 469: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_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;

Line 470: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_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;

Line 471: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_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;

Line 472: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%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;

Line 473: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%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;

Line 474: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_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;

Line 475: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%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:

Line 476: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%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:
480: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

Line 477: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%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;

Line 480: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%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;

Line 481: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%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;

Line 482: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%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:

Line 483: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%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:
487: l_chk number := 0;

Line 484: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

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:

Line 485: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%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:
489: /* Project PL SQL table for Rate API */

Line 826: l_prev_rt_prj_type Pa_Projects_All.Project_Type%TYPE;

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;

Line 827: l_prev_rt_projfunc_currcode Pa_Projects_All.Project_Currency_Code%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;

Line 828: l_prev_rt_proj_currcode Pa_Projects_All.Project_Currency_Code%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;

Line 829: l_prev_rt_bill_jobgroup_id Pa_Projects_All.Bill_Job_Group_Id%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;

Line 830: l_prev_rt_emp_bilrate_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:

Line 831: l_prev_rt_job_bilrate_schid Pa_Projects_All.Job_Bill_Rate_Schedule_Id%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:
835: l_prev_rt_labor_sch_discount NUMBER;

Line 832: l_prev_rt_dist_rule Pa_Projects_All.Distribution_Rule%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;
836: l_prev_rt_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

Line 833: l_prev_rt_cost_rate_schid Pa_Projects_All.Emp_Bill_Rate_Schedule_Id%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;

Line 836: l_prev_rt_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%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;

Line 837: l_prev_rt_labor_bill_rt_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%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:

Line 838: l_prev_rt_labor_std_bl_rt_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%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:
842: /* local variables */

Line 839: l_prev_rt_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

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);

Line 840: l_prev_rt_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

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';

Line 1564: FROM Pa_Projects_All P

1560: l_labor_bill_rate_orgid,
1561: l_labor_std_bill_rate_sch,
1562: l_labor_sch_fixed_dt,
1563: l_labor_sch_type
1564: FROM Pa_Projects_All P
1565: WHERE P.Project_Id = l_prev_project_id;
1566: EXCEPTION
1567: WHEN NO_DATA_FOUND THEN
1568: l_fi_others_rejct_reason_tab(i) := 'PA_INVALID_PROJECT_ID';