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

Line 14: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,

10: * Please check body of VALIDATE_SUPPORT_CASES in PAFPGAUB.pls
11: * for list of valid parameter values.
12: **/
13: PROCEDURE GENERATE_BUDGET_AMT_WRP
14: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
15: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
16: P_CALLED_MODE IN VARCHAR2,
17: P_COMMIT_FLAG IN VARCHAR2,
18: P_INIT_MSG_FLAG IN VARCHAR2,

Line 900: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

896:
897: /* Procedure to generate budget amount when
898: planning level is Resource Schedule */
899: PROCEDURE GENERATE_BUDGET_AMT_RES_SCH
900: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
901: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
902: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
903: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
904: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

Line 962: FROM PA_PROJECTS_ALL P

958: NVL(P.LABOR_BILL_RATE_ORG_ID,-99),
959: P.LABOR_STD_BILL_RATE_SCHDL,
960: P.LABOR_SCHEDULE_FIXED_DATE,
961: P.LABOR_SCH_TYPE
962: FROM PA_PROJECTS_ALL P
963: WHERE PROJECT_ID = P_PROJECT_ID;
964:
965: CURSOR PROJ_ASSIGNMENTS IS
966: SELECT DISTINCT PA.ASSIGNMENT_ID,

Line 993: PA_PROJECTS_ALL P,

989: DECODE(PA.EXPENDITURE_TYPE,null,NULL,'EXPENDITURE_TYPE')
990: FROM PA_PROJECT_ASSIGNMENTS PA,
991: PA_WORK_TYPES_B WB,
992: PA_PROJECT_ROLE_TYPES PR,
993: PA_PROJECTS_ALL P,
994: PA_RESOURCE_TXN_ATTRIBUTES RTA,
995: PA_FORECAST_ITEMS FI
996: WHERE PA.PROJECT_ID = p_project_id
997: AND PA.PROJECT_ROLE_ID = PR.PROJECT_ROLE_ID

Line 1393: ,pa_projects_all pp

1389: ,pp.non_labor_sch_type
1390: ,pp.name project_name
1391: FROM pa_proj_fp_options pfo
1392: ,pa_budget_versions bv
1393: ,pa_projects_all pp
1394: WHERE pfo.fin_plan_version_id = bv.budget_version_id
1395: AND bv.budget_version_id = p_budget_version_id
1396: AND pp.project_id = bv.project_id
1397: AND pfo.project_id = pp.project_id;

Line 1568: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;

1564: AND tmp1.txn_currency_code = tmp2.txn_currency_code
1565: AND tmp1.start_date = tmp2.start_date;
1566: -- END of M-closeout: Bill Rate Override ER ------------------------------------------
1567:
1568: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1569: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1570: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1571: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1572: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;

Line 1569: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1565: AND tmp1.start_date = tmp2.start_date;
1566: -- END of M-closeout: Bill Rate Override ER ------------------------------------------
1567:
1568: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1569: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1570: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1571: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1572: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1573: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;

Line 1570: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

1566: -- END of M-closeout: Bill Rate Override ER ------------------------------------------
1567:
1568: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1569: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1570: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1571: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1572: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1573: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1574: l_rev_gen_method VARCHAR2(3);

Line 1571: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;

1567:
1568: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1569: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1570: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1571: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1572: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1573: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1574: l_rev_gen_method VARCHAR2(3);
1575: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;

Line 1572: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;

1568: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1569: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1570: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1571: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1572: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1573: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1574: l_rev_gen_method VARCHAR2(3);
1575: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1576: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;

Line 1573: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;

1569: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1570: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1571: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1572: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1573: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1574: l_rev_gen_method VARCHAR2(3);
1575: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1576: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1577: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;

Line 1575: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;

1571: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1572: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1573: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1574: l_rev_gen_method VARCHAR2(3);
1575: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1576: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1577: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1578: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1579: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;

Line 1576: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;

1572: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1573: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1574: l_rev_gen_method VARCHAR2(3);
1575: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1576: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1577: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1578: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1579: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1580: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;

Line 1577: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;

1573: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1574: l_rev_gen_method VARCHAR2(3);
1575: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1576: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1577: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1578: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1579: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1580: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1581: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;

Line 1578: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;

1574: l_rev_gen_method VARCHAR2(3);
1575: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1576: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1577: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1578: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1579: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1580: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1581: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1582: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;

Line 1579: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;

1575: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1576: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1577: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1578: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1579: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1580: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1581: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1582: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1583: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;

Line 1580: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;

1576: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1577: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1578: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1579: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1580: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1581: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1582: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1583: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1584: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;

Line 1581: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;

1577: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1578: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1579: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1580: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1581: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1582: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1583: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1584: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1585:

Line 1582: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;

1578: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1579: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1580: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1581: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1582: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1583: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1584: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1585:
1586: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;

Line 1583: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;

1579: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1580: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1581: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1582: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1583: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1584: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1585:
1586: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
1587: /* Added for Org Forecasting */

Line 1584: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;

1580: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1581: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1582: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1583: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1584: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1585:
1586: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
1587: /* Added for Org Forecasting */
1588:

Line 1589: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;

1585:
1586: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
1587: /* Added for Org Forecasting */
1588:
1589: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1590: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1591: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1592: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1593: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;

Line 1590: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;

1586: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
1587: /* Added for Org Forecasting */
1588:
1589: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1590: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1591: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1592: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1593: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1594: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;

Line 1591: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;

1587: /* Added for Org Forecasting */
1588:
1589: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1590: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1591: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1592: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1593: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1594: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1595: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;

Line 1592: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;

1588:
1589: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1590: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1591: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1592: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1593: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1594: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1595: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1596: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;

Line 1593: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;

1589: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1590: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1591: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1592: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1593: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1594: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1595: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1596: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1597: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;

Line 1594: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;

1590: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1591: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1592: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1593: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1594: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1595: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1596: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1597: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1598: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;

Line 1595: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;

1591: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1592: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1593: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1594: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1595: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1596: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1597: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1598: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1599: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;

Line 1596: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;

1592: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1593: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1594: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1595: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1596: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1597: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1598: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1599: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1600:

Line 1597: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;

1593: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1594: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1595: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1596: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1597: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1598: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1599: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1600:
1601: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

Line 1598: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;

1594: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1595: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1596: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1597: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1598: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1599: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1600:
1601: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1602: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

Line 1599: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;

1595: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1596: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1597: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1598: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1599: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1600:
1601: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1602: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1603: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

Line 1601: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

1597: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1598: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1599: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1600:
1601: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1602: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1603: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1604: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1605: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

Line 1602: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

1598: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1599: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1600:
1601: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1602: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1603: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1604: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1605: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1606: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

Line 1603: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

1599: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1600:
1601: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1602: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1603: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1604: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1605: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1606: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1607:

Line 1604: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;

1600:
1601: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1602: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1603: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1604: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1605: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1606: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1607:
1608:

Line 1605: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

1601: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1602: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1603: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1604: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1605: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1606: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1607:
1608:
1609: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

Line 1606: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

1602: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1603: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1604: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1605: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1606: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1607:
1608:
1609: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1610: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;

Line 1655: l_rev_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1651: l_projfunc_burdened_cost_rate NUMBER;
1652: l_error_msg VARCHAR2(30);
1653:
1654: l_std_raw_revenue NUMBER;
1655: l_rev_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1656: l_billable_flag VARCHAR2(2);
1657:
1658: l_rev_reject_reason VARCHAR2(1000);
1659: l_cost_reject_reason VARCHAR2(1000);

Line 1931: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

1927: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1928: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1929: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1930:
1931: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1932: l_count NUMBER;
1933: l_count1 NUMBER;
1934: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1935: l_chk_duplicate_flag VARCHAR2(1) := 'N';

Line 4398: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,

4394:
4395: PROCEDURE CREATE_RES_ASG
4396: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
4397: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4398: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
4399: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
4400: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4401: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
4402: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 4576: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

4572: 0;
4573:
4574:
4575:
4576: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
4577: l_unique_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
4578: l_res_list_member_id PA_PLSQL_DATATYPES.IdTabTyp;
4579: l_task_id PA_PLSQL_DATATYPES.IdTabTyp;
4580: l_mapped_fin_task_version_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 5170: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,

5166: in the resource assignment table*/
5167: PROCEDURE UPDATE_RES_ASG
5168: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5169: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5170: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
5171: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
5172: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5173: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
5174: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 5180: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

5176: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5177:
5178: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG';
5179:
5180: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
5181:
5182: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5183: l_res_assgn_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
5184: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6151: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,

6147:
6148: END RESET_COST_AMOUNTS;
6149:
6150: PROCEDURE GEN_REV_BDGT_AMT_RES_SCH_WRP
6151: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
6152: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6153: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6154: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6155: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

Line 6432: pa_projects_all proj, pa_tasks t,

6428: l_cost_res_class_rt_sch_id_tab,
6429:
6430: l_res_format_id_tab
6431: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
6432: pa_projects_all proj, pa_tasks t,
6433: pa_proj_fp_options fp,
6434: pa_resource_list_members rlm
6435: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
6436: AND ra.project_id = proj.project_id

Line 6976: pa_projects_all proj, pa_tasks t,

6972: l_cost_res_class_rt_sch_id_tab,
6973:
6974: l_res_format_id_tab
6975: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
6976: pa_projects_all proj, pa_tasks t,
6977: pa_proj_fp_options fp,
6978: pa_resource_list_members rlm
6979: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
6980: AND ra.project_id = proj.project_id