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_PROJ_FP_OPTIONS

Line 575: FROM pa_proj_fp_options opt, pa_budget_versions bv

571: 'COST', opt.gen_src_cost_plan_version_id,
572: 'REVENUE',opt.gen_src_rev_plan_version_id,
573: 'ALL',opt.gen_src_all_plan_version_id)
574: INTO l_source_bv_id
575: FROM pa_proj_fp_options opt, pa_budget_versions bv
576: WHERE bv.budget_version_id = opt.fin_plan_version_id
577: AND bv.budget_version_id = p_budget_version_id ;
578: END IF;
579:

Line 904: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

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,
905: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
906: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
907: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
908: P_CALLED_MODE IN VARCHAR2,

Line 905: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_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,
905: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
906: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
907: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
908: P_CALLED_MODE IN VARCHAR2,
909: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,

Line 907: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,

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,
905: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
906: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
907: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
908: P_CALLED_MODE IN VARCHAR2,
909: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
910: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
911: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

Line 909: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,

905: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
906: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
907: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
908: P_CALLED_MODE IN VARCHAR2,
909: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
910: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
911: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
912: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
913: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 910: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

906: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
907: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
908: P_CALLED_MODE IN VARCHAR2,
909: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
910: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
911: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
912: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
913: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
914: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 911: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

907: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
908: P_CALLED_MODE IN VARCHAR2,
909: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
910: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
911: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
912: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
913: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
914: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
915: --this pl/sql table is used to update the initial res_asg_id from the generated amounts

Line 1391: FROM pa_proj_fp_options pfo

1387: ,pp.labor_bill_rate_org_id
1388: ,pp.labor_sch_type
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

Line 1797: l_amount_set_id PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE;

1793: l_avg_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1794:
1795: l_rowcount number :=0;
1796:
1797: l_amount_set_id PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE;
1798: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
1799: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
1800: l_resource_list_id PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE;
1801: l_res_planning_level PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE;

Line 1798: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;

1794:
1795: l_rowcount number :=0;
1796:
1797: l_amount_set_id PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE;
1798: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
1799: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
1800: l_resource_list_id PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE;
1801: l_res_planning_level PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE;
1802: l_rbs_version_id PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE;

Line 1799: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;

1795: l_rowcount number :=0;
1796:
1797: l_amount_set_id PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE;
1798: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
1799: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
1800: l_resource_list_id PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE;
1801: l_res_planning_level PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE;
1802: l_rbs_version_id PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE;
1803: --l_plan_res_list_id PA_PROJ_FP_OPTIONS.COST_PLAN_RES_LIST_ID%TYPE;

Line 1800: l_resource_list_id PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE;

1796:
1797: l_amount_set_id PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE;
1798: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
1799: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
1800: l_resource_list_id PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE;
1801: l_res_planning_level PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE;
1802: l_rbs_version_id PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE;
1803: --l_plan_res_list_id PA_PROJ_FP_OPTIONS.COST_PLAN_RES_LIST_ID%TYPE;
1804: l_emp_rate_sch_id PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE;

Line 1801: l_res_planning_level PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE;

1797: l_amount_set_id PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE;
1798: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
1799: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
1800: l_resource_list_id PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE;
1801: l_res_planning_level PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE;
1802: l_rbs_version_id PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE;
1803: --l_plan_res_list_id PA_PROJ_FP_OPTIONS.COST_PLAN_RES_LIST_ID%TYPE;
1804: l_emp_rate_sch_id PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE;
1805: l_job_rate_sch_id PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE;

Line 1802: l_rbs_version_id PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE;

1798: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
1799: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
1800: l_resource_list_id PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE;
1801: l_res_planning_level PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE;
1802: l_rbs_version_id PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE;
1803: --l_plan_res_list_id PA_PROJ_FP_OPTIONS.COST_PLAN_RES_LIST_ID%TYPE;
1804: l_emp_rate_sch_id PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE;
1805: l_job_rate_sch_id PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE;
1806: l_non_labor_res_rate_sch_id PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE;

Line 1803: --l_plan_res_list_id PA_PROJ_FP_OPTIONS.COST_PLAN_RES_LIST_ID%TYPE;

1799: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
1800: l_resource_list_id PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE;
1801: l_res_planning_level PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE;
1802: l_rbs_version_id PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE;
1803: --l_plan_res_list_id PA_PROJ_FP_OPTIONS.COST_PLAN_RES_LIST_ID%TYPE;
1804: l_emp_rate_sch_id PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE;
1805: l_job_rate_sch_id PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE;
1806: l_non_labor_res_rate_sch_id PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE;
1807: l_res_class_rate_sch_id PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE;

Line 1804: l_emp_rate_sch_id PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE;

1800: l_resource_list_id PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE;
1801: l_res_planning_level PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE;
1802: l_rbs_version_id PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE;
1803: --l_plan_res_list_id PA_PROJ_FP_OPTIONS.COST_PLAN_RES_LIST_ID%TYPE;
1804: l_emp_rate_sch_id PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE;
1805: l_job_rate_sch_id PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE;
1806: l_non_labor_res_rate_sch_id PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE;
1807: l_res_class_rate_sch_id PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE;
1808: l_burden_rate_sch_id PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE;

Line 1805: l_job_rate_sch_id PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE;

1801: l_res_planning_level PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE;
1802: l_rbs_version_id PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE;
1803: --l_plan_res_list_id PA_PROJ_FP_OPTIONS.COST_PLAN_RES_LIST_ID%TYPE;
1804: l_emp_rate_sch_id PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE;
1805: l_job_rate_sch_id PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE;
1806: l_non_labor_res_rate_sch_id PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE;
1807: l_res_class_rate_sch_id PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE;
1808: l_burden_rate_sch_id PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE;
1809: l_current_planning_period PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE;

Line 1806: l_non_labor_res_rate_sch_id PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE;

1802: l_rbs_version_id PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE;
1803: --l_plan_res_list_id PA_PROJ_FP_OPTIONS.COST_PLAN_RES_LIST_ID%TYPE;
1804: l_emp_rate_sch_id PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE;
1805: l_job_rate_sch_id PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE;
1806: l_non_labor_res_rate_sch_id PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE;
1807: l_res_class_rate_sch_id PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE;
1808: l_burden_rate_sch_id PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE;
1809: l_current_planning_period PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE;
1810: l_period_mask_id PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE;

Line 1807: l_res_class_rate_sch_id PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE;

1803: --l_plan_res_list_id PA_PROJ_FP_OPTIONS.COST_PLAN_RES_LIST_ID%TYPE;
1804: l_emp_rate_sch_id PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE;
1805: l_job_rate_sch_id PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE;
1806: l_non_labor_res_rate_sch_id PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE;
1807: l_res_class_rate_sch_id PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE;
1808: l_burden_rate_sch_id PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE;
1809: l_current_planning_period PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE;
1810: l_period_mask_id PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE;
1811: l_gen_src_plan_type_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE;

Line 1808: l_burden_rate_sch_id PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE;

1804: l_emp_rate_sch_id PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE;
1805: l_job_rate_sch_id PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE;
1806: l_non_labor_res_rate_sch_id PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE;
1807: l_res_class_rate_sch_id PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE;
1808: l_burden_rate_sch_id PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE;
1809: l_current_planning_period PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE;
1810: l_period_mask_id PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE;
1811: l_gen_src_plan_type_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE;
1812: l_gen_src_plan_version_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE;

Line 1809: l_current_planning_period PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE;

1805: l_job_rate_sch_id PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE;
1806: l_non_labor_res_rate_sch_id PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE;
1807: l_res_class_rate_sch_id PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE;
1808: l_burden_rate_sch_id PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE;
1809: l_current_planning_period PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE;
1810: l_period_mask_id PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE;
1811: l_gen_src_plan_type_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE;
1812: l_gen_src_plan_version_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE;
1813: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;

Line 1810: l_period_mask_id PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE;

1806: l_non_labor_res_rate_sch_id PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE;
1807: l_res_class_rate_sch_id PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE;
1808: l_burden_rate_sch_id PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE;
1809: l_current_planning_period PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE;
1810: l_period_mask_id PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE;
1811: l_gen_src_plan_type_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE;
1812: l_gen_src_plan_version_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE;
1813: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
1814: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

Line 1811: l_gen_src_plan_type_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE;

1807: l_res_class_rate_sch_id PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE;
1808: l_burden_rate_sch_id PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE;
1809: l_current_planning_period PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE;
1810: l_period_mask_id PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE;
1811: l_gen_src_plan_type_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE;
1812: l_gen_src_plan_version_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE;
1813: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
1814: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1815: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;

Line 1812: l_gen_src_plan_version_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE;

1808: l_burden_rate_sch_id PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE;
1809: l_current_planning_period PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE;
1810: l_period_mask_id PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE;
1811: l_gen_src_plan_type_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE;
1812: l_gen_src_plan_version_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE;
1813: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
1814: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1815: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
1816: l_gen_incl_change_doc_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE;

Line 1813: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;

1809: l_current_planning_period PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE;
1810: l_period_mask_id PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE;
1811: l_gen_src_plan_type_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE;
1812: l_gen_src_plan_version_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE;
1813: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
1814: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1815: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
1816: l_gen_incl_change_doc_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE;
1817: l_gen_incl_open_comm_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE;

Line 1814: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

1810: l_period_mask_id PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE;
1811: l_gen_src_plan_type_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE;
1812: l_gen_src_plan_version_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE;
1813: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
1814: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1815: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
1816: l_gen_incl_change_doc_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE;
1817: l_gen_incl_open_comm_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE;
1818: l_gen_incl_bill_event_flag PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE;

Line 1815: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;

1811: l_gen_src_plan_type_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE;
1812: l_gen_src_plan_version_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE;
1813: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
1814: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1815: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
1816: l_gen_incl_change_doc_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE;
1817: l_gen_incl_open_comm_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE;
1818: l_gen_incl_bill_event_flag PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE;
1819: l_gen_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;

Line 1816: l_gen_incl_change_doc_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE;

1812: l_gen_src_plan_version_id PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE;
1813: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
1814: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1815: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
1816: l_gen_incl_change_doc_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE;
1817: l_gen_incl_open_comm_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE;
1818: l_gen_incl_bill_event_flag PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE;
1819: l_gen_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;
1820: l_gen_actual_amts_thru_code PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE;

Line 1817: l_gen_incl_open_comm_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE;

1813: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
1814: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1815: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
1816: l_gen_incl_change_doc_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE;
1817: l_gen_incl_open_comm_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE;
1818: l_gen_incl_bill_event_flag PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE;
1819: l_gen_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;
1820: l_gen_actual_amts_thru_code PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE;
1821: l_gen_incl_unspent_amt_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE;

Line 1818: l_gen_incl_bill_event_flag PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE;

1814: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1815: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
1816: l_gen_incl_change_doc_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE;
1817: l_gen_incl_open_comm_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE;
1818: l_gen_incl_bill_event_flag PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE;
1819: l_gen_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;
1820: l_gen_actual_amts_thru_code PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE;
1821: l_gen_incl_unspent_amt_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE;
1822:

Line 1819: l_gen_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;

1815: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
1816: l_gen_incl_change_doc_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE;
1817: l_gen_incl_open_comm_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE;
1818: l_gen_incl_bill_event_flag PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE;
1819: l_gen_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;
1820: l_gen_actual_amts_thru_code PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE;
1821: l_gen_incl_unspent_amt_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE;
1822:
1823: l_raw_cost_flag PA_FIN_PLAN_AMOUNT_SETS.RAW_COST_FLAG%TYPE;

Line 1820: l_gen_actual_amts_thru_code PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE;

1816: l_gen_incl_change_doc_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE;
1817: l_gen_incl_open_comm_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE;
1818: l_gen_incl_bill_event_flag PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE;
1819: l_gen_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;
1820: l_gen_actual_amts_thru_code PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE;
1821: l_gen_incl_unspent_amt_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE;
1822:
1823: l_raw_cost_flag PA_FIN_PLAN_AMOUNT_SETS.RAW_COST_FLAG%TYPE;
1824: l_burdened_flag PA_FIN_PLAN_AMOUNT_SETS.BURDENED_COST_FLAG%TYPE;

Line 1821: l_gen_incl_unspent_amt_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE;

1817: l_gen_incl_open_comm_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE;
1818: l_gen_incl_bill_event_flag PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE;
1819: l_gen_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;
1820: l_gen_actual_amts_thru_code PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE;
1821: l_gen_incl_unspent_amt_flag PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE;
1822:
1823: l_raw_cost_flag PA_FIN_PLAN_AMOUNT_SETS.RAW_COST_FLAG%TYPE;
1824: l_burdened_flag PA_FIN_PLAN_AMOUNT_SETS.BURDENED_COST_FLAG%TYPE;
1825: l_revenue_flag PA_FIN_PLAN_AMOUNT_SETS.REVENUE_FLAG%TYPE;

Line 4396: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

4392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4393: END GENERATE_BUDGET_AMT_RES_SCH;
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,

Line 4399: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

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,
4403: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 4638: l_gen_src_code pa_proj_fp_options.gen_all_src_code%TYPE := null;

4634:
4635: l_count NUMBER;
4636: l_count1 NUMBER;
4637: l_wp_version_flag pa_budget_Versions.wp_version_flag%TYPE;
4638: l_gen_src_code pa_proj_fp_options.gen_all_src_code%TYPE := null;
4639:
4640: --Bug 4052036. This tbl will hold the ra ids that are inserted in this API
4641: l_ins_ra_id_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4642: BEGIN

Line 5168: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

5164:
5165: /* Procedure to update the reosurce_assignment_id
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,

Line 5171: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

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,
5175: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5585: ( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

5581: we are not deleting budget lines records that was generated
5582: by the previous source in the same run.
5583: */
5584: PROCEDURE DEL_MANUAL_BDGT_LINES
5585: ( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5586: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5587: PX_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
5588: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
5589: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 5685: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

5681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5682: END DEL_MANUAL_BDGT_LINES;
5683:
5684: PROCEDURE UPDATE_INIT_AMOUNTS
5685: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5686: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5687: P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
5688: --this pl/sql table will have newly created res_asg_id from the source
5689: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 5746: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

5742:
5743: /* Procedure to update the latest amount
5744: generation date in the budget versions table*/
5745: PROCEDURE UPDATE_BV_FOR_GEN_DATE
5746: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5747: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5748: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
5749: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5750: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5802: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

5798:
5799: END UPDATE_BV_FOR_GEN_DATE;
5800:
5801: PROCEDURE GET_GENERATED_RES_ASG
5802: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5803: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5804: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
5805: P_CHK_DUPLICATE_FLAG IN VARCHAR2,
5806: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 5894: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

5890: created and later its copy as working version. Add the
5891: missing currencies to all the workplan versions
5892: ******************************************************************************/
5893: PROCEDURE INSERT_TXN_CURRENCY
5894: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5895: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5896: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5897: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5898: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5994: pa_proj_fp_options pfo

5990: l_budget_version_id_tbl,
5991: l_proj_fp_options_id_tbl
5992: FROM pa_budget_versions bv,
5993: --bug 3919127 pa_proj_elem_ver_structure ver,
5994: pa_proj_fp_options pfo
5995: WHERE bv.project_id = p_project_id
5996: AND bv.wp_version_flag = 'Y'
5997: /* bug 3919127
5998: AND bv.project_id = ver.project_id

Line 6011: FROM pa_proj_fp_options

6007: SELECT proj_fp_options_id,
6008: null
6009: INTO l_proj_fp_options_id_tbl(nvl(l_proj_fp_options_id_tbl.count,0) + 1),
6010: l_budget_version_id_tbl(nvl(l_proj_fp_options_id_tbl.count,0) + 1)
6011: FROM pa_proj_fp_options
6012: WHERE project_id = p_project_id AND
6013: fin_plan_type_id = l_fp_cols_rec.X_FIN_PLAN_TYPE_ID AND
6014: fin_plan_option_level_code = 'PLAN_TYPE';
6015: END IF;

Line 6155: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

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,
6156: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6157: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6158: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
6159: P_CALLED_MODE IN VARCHAR2,

Line 6156: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_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,
6156: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6157: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6158: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
6159: P_CALLED_MODE IN VARCHAR2,
6160: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,

Line 6158: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,

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,
6156: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6157: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6158: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
6159: P_CALLED_MODE IN VARCHAR2,
6160: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
6161: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
6162: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

Line 6160: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,

6156: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6157: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6158: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
6159: P_CALLED_MODE IN VARCHAR2,
6160: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
6161: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
6162: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
6163: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
6164: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 6161: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

6157: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6158: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
6159: P_CALLED_MODE IN VARCHAR2,
6160: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
6161: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
6162: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
6163: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
6164: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
6165: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 6162: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

6158: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
6159: P_CALLED_MODE IN VARCHAR2,
6160: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
6161: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
6162: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
6163: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
6164: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
6165: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6166: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 6433: pa_proj_fp_options fp,

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
6437: AND ra.task_id = t.task_id(+)

Line 6700: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

6696:
6697: END GEN_REV_BDGT_AMT_RES_SCH_WRP;
6698:
6699: PROCEDURE GEN_WP_REV_BDGT_AMT_WRP
6700: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6701: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6702: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6703: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6704: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

Line 6703: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

6699: PROCEDURE GEN_WP_REV_BDGT_AMT_WRP
6700: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6701: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6702: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6703: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6704: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6705: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6706: P_RETAIN_MANUAL_FLAG IN VARCHAR2,
6707: P_CALLED_MODE IN VARCHAR2,

Line 6704: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

6700: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6701: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6702: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6703: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6704: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6705: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6706: P_RETAIN_MANUAL_FLAG IN VARCHAR2,
6707: P_CALLED_MODE IN VARCHAR2,
6708: P_INC_CHG_DOC_FLAG IN VARCHAR2,

Line 6977: pa_proj_fp_options fp,

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
6981: AND ra.task_id = t.task_id(+)