APPS.PA_FP_GEN_PUB dependencies on PA_BUDGET_VERSIONS

Line 7: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: PROCEDURE UPDATE_RES_DEFAULTS
6: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
7: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: P_CALLED_MODE IN VARCHAR2,
9: P_COMMIT_FLAG IN VARCHAR2,
10: P_INIT_MSG_FLAG IN VARCHAR2,
11: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 723: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

719:
720: END INCLUDE_CHANGE_DOCUMENT_WRP;
721:
722: PROCEDURE UNSPENT_AMOUNT
723: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
724: P_APP_COST_BDGT_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
725: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
726: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
727: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 724: P_APP_COST_BDGT_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

720: END INCLUDE_CHANGE_DOCUMENT_WRP;
721:
722: PROCEDURE UNSPENT_AMOUNT
723: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
724: P_APP_COST_BDGT_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
725: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
726: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
727: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
728: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 742: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;

738: l_res_list_mem_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
739: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
740: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
741:
742: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
743: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
744: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
745: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
746: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1487: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1483:
1484: --Please note that wbs_element_version id will be NULL for budgets and forecasts. If this API is called
1485: --for a B/F version then nothing will happen. The API just return without doing any processing
1486: PROCEDURE UPD_WBS_ELEMENT_VERSION_ID
1487: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1488: P_STRUCTURE_VERSION_ID IN NUMBER,
1489: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1490: X_MSG_COUNT OUT NOCOPY NUMBER,
1491: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 1496: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;

1492:
1493: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1494: l_wbs_element_ver_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1495: l_structure_version_id NUMBER;
1496: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
1497:
1498: BEGIN
1499:
1500: /* Setting initial values */

Line 1515: FROM pa_budget_versions

1511: SELECT NVL(P_STRUCTURE_VERSION_ID,project_structure_version_id),
1512: NVL(wp_version_flag,'N')
1513: INTO l_structure_version_id,
1514: l_wp_version_flag
1515: FROM pa_budget_versions
1516: WHERE budget_version_id = p_budget_version_id;
1517:
1518: IF l_wp_version_flag = 'N' THEN
1519: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1798: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1794: *
1795: * Note that the p_fp_col_rec parameter is currently not used.
1796: */
1797: PROCEDURE MAINTAIN_FIXED_DATE_SP
1798: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1799: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1800: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1801: X_MSG_COUNT OUT NOCOPY NUMBER,
1802: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 2019: l_src_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

2015: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
2016:
2017: l_src_version_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2018: l_gen_etc_src_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2019: l_src_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2020: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
2021: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2022:
2023: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;