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 912: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

908:
909: /* Procedure to generate budget amount when
910: planning level is Resource Schedule */
911: PROCEDURE GENERATE_BUDGET_AMT_RES_SCH
912: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
913: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
914: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
915: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
916: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

Line 974: FROM PA_PROJECTS_ALL P

970: NVL(P.LABOR_BILL_RATE_ORG_ID,-99),
971: P.LABOR_STD_BILL_RATE_SCHDL,
972: P.LABOR_SCHEDULE_FIXED_DATE,
973: P.LABOR_SCH_TYPE
974: FROM PA_PROJECTS_ALL P
975: WHERE PROJECT_ID = P_PROJECT_ID;
976:
977: CURSOR PROJ_ASSIGNMENTS IS
978: SELECT DISTINCT PA.ASSIGNMENT_ID,

Line 1005: PA_PROJECTS_ALL P,

1001: DECODE(PA.EXPENDITURE_TYPE,null,NULL,'EXPENDITURE_TYPE')
1002: FROM PA_PROJECT_ASSIGNMENTS PA,
1003: PA_WORK_TYPES_B WB,
1004: PA_PROJECT_ROLE_TYPES PR,
1005: PA_PROJECTS_ALL P,
1006: PA_RESOURCE_TXN_ATTRIBUTES RTA,
1007: PA_FORECAST_ITEMS FI
1008: WHERE PA.PROJECT_ID = p_project_id
1009: AND PA.PROJECT_ROLE_ID = PR.PROJECT_ROLE_ID

Line 1405: ,pa_projects_all pp

1401: ,pp.non_labor_sch_type
1402: ,pp.name project_name
1403: FROM pa_proj_fp_options pfo
1404: ,pa_budget_versions bv
1405: ,pa_projects_all pp
1406: WHERE pfo.fin_plan_version_id = bv.budget_version_id
1407: AND bv.budget_version_id = p_budget_version_id
1408: AND pp.project_id = bv.project_id
1409: AND pfo.project_id = pp.project_id;

Line 1580: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;

1576: AND tmp1.txn_currency_code = tmp2.txn_currency_code
1577: AND tmp1.start_date = tmp2.start_date;
1578: -- END of M-closeout: Bill Rate Override ER ------------------------------------------
1579:
1580: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1581: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1582: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1583: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1584: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;

Line 1581: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1577: AND tmp1.start_date = tmp2.start_date;
1578: -- END of M-closeout: Bill Rate Override ER ------------------------------------------
1579:
1580: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1581: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1582: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1583: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1584: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1585: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;

Line 1582: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

1578: -- END of M-closeout: Bill Rate Override ER ------------------------------------------
1579:
1580: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1581: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1582: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1583: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1584: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1585: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1586: l_rev_gen_method VARCHAR2(3);

Line 1583: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;

1579:
1580: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1581: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1582: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1583: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1584: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1585: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1586: l_rev_gen_method VARCHAR2(3);
1587: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;

Line 1584: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;

1580: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1581: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1582: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1583: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1584: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1585: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1586: l_rev_gen_method VARCHAR2(3);
1587: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1588: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;

Line 1585: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;

1581: l_project_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1582: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1583: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1584: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1585: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1586: l_rev_gen_method VARCHAR2(3);
1587: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1588: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1589: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;

Line 1587: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;

1583: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
1584: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1585: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1586: l_rev_gen_method VARCHAR2(3);
1587: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1588: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1589: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1590: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1591: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;

Line 1588: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;

1584: l_job_bill_rate_schedule_id PA_PROJECTS_ALL.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
1585: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1586: l_rev_gen_method VARCHAR2(3);
1587: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1588: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1589: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1590: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1591: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1592: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;

Line 1589: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;

1585: l_emp_bill_rate_schedule_id PA_PROJECTS_ALL.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
1586: l_rev_gen_method VARCHAR2(3);
1587: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1588: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1589: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1590: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1591: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1592: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1593: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;

Line 1590: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;

1586: l_rev_gen_method VARCHAR2(3);
1587: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1588: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1589: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1590: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1591: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1592: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1593: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1594: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;

Line 1591: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;

1587: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
1588: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1589: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1590: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1591: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1592: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1593: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1594: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1595: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;

Line 1592: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;

1588: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1589: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1590: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1591: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1592: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1593: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1594: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1595: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1596: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;

Line 1593: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;

1589: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1590: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1591: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1592: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1593: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1594: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1595: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1596: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1597:

Line 1594: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;

1590: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
1591: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1592: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1593: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1594: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1595: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1596: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1597:
1598: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;

Line 1595: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;

1591: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1592: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1593: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1594: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1595: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1596: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1597:
1598: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
1599: /* Added for Org Forecasting */

Line 1596: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;

1592: l_template_flag PA_PROJECTS_ALL.TEMPLATE_FLAG%TYPE;
1593: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1594: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1595: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1596: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1597:
1598: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
1599: /* Added for Org Forecasting */
1600:

Line 1601: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;

1597:
1598: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
1599: /* Added for Org Forecasting */
1600:
1601: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1602: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1603: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1604: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1605: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;

Line 1602: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;

1598: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
1599: /* Added for Org Forecasting */
1600:
1601: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1602: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1603: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1604: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1605: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1606: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;

Line 1603: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;

1599: /* Added for Org Forecasting */
1600:
1601: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1602: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1603: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1604: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1605: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1606: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1607: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;

Line 1604: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;

1600:
1601: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1602: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1603: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1604: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1605: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1606: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1607: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1608: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;

Line 1605: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;

1601: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1602: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1603: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1604: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1605: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1606: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1607: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1608: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1609: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;

Line 1606: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;

1602: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
1603: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1604: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1605: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1606: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1607: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1608: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1609: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1610: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;

Line 1607: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;

1603: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
1604: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1605: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1606: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1607: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1608: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1609: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1610: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1611: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;

Line 1608: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;

1604: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
1605: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1606: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1607: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1608: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1609: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1610: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1611: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1612:

Line 1609: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;

1605: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
1606: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1607: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1608: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1609: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1610: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1611: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1612:
1613: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

Line 1610: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;

1606: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
1607: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1608: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1609: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1610: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1611: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1612:
1613: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1614: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

Line 1611: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;

1607: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1608: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
1609: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1610: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1611: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1612:
1613: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1614: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1615: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

Line 1613: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

1609: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
1610: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1611: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1612:
1613: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1614: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1615: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1616: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1617: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

Line 1614: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

1610: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
1611: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1612:
1613: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1614: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1615: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1616: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1617: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1618: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

Line 1615: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

1611: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
1612:
1613: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1614: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1615: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1616: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1617: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1618: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1619:

Line 1616: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;

1612:
1613: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1614: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1615: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1616: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1617: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1618: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1619:
1620:

Line 1617: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

1613: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
1614: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1615: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1616: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1617: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1618: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1619:
1620:
1621: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

Line 1618: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

1614: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
1615: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
1616: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
1617: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1618: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1619:
1620:
1621: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1622: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;

Line 1667: l_rev_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1663: l_projfunc_burdened_cost_rate NUMBER;
1664: l_error_msg VARCHAR2(30);
1665:
1666: l_std_raw_revenue NUMBER;
1667: l_rev_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1668: l_billable_flag VARCHAR2(2);
1669:
1670: l_rev_reject_reason VARCHAR2(1000);
1671: l_cost_reject_reason VARCHAR2(1000);

Line 1943: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

1939: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1940: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1941: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1942:
1943: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1944: l_count NUMBER;
1945: l_count1 NUMBER;
1946: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1947: l_chk_duplicate_flag VARCHAR2(1) := 'N';

Line 4410: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,

4406:
4407: PROCEDURE CREATE_RES_ASG
4408: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
4409: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4410: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
4411: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
4412: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4413: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
4414: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 4744: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

4740: SELECT CBS_ELEMENT_ID
4741: FROM PA_RESOURCE_ASSIGNMENTS T
4742: WHERE T.RESOURCE_ASSIGNMENT_ID = c_res_asgn_id;
4743:
4744: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
4745: l_unique_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
4746: l_res_list_member_id PA_PLSQL_DATATYPES.IdTabTyp;
4747: l_task_id PA_PLSQL_DATATYPES.IdTabTyp;
4748: l_res_asgn_id PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605

Line 5802: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,

5798: in the resource assignment table*/
5799: PROCEDURE UPDATE_RES_ASG
5800: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5801: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5802: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
5803: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
5804: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5805: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
5806: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 5812: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

5808: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5809:
5810: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG';
5811:
5812: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
5813:
5814: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5815: l_res_assgn_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
5816: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

6804:
6805: END RESET_COST_AMOUNTS;
6806:
6807: PROCEDURE GEN_REV_BDGT_AMT_RES_SCH_WRP
6808: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
6809: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6810: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6811: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6812: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

Line 7089: pa_projects_all proj, pa_tasks t,

7085: l_cost_res_class_rt_sch_id_tab,
7086:
7087: l_res_format_id_tab
7088: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
7089: pa_projects_all proj, pa_tasks t,
7090: pa_proj_fp_options fp,
7091: pa_resource_list_members rlm
7092: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
7093: AND ra.project_id = proj.project_id

Line 7633: pa_projects_all proj, pa_tasks t,

7629: l_cost_res_class_rt_sch_id_tab,
7630:
7631: l_res_format_id_tab
7632: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
7633: pa_projects_all proj, pa_tasks t,
7634: pa_proj_fp_options fp,
7635: pa_resource_list_members rlm
7636: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
7637: AND ra.project_id = proj.project_id