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 710: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

706:
707: END INCLUDE_CHANGE_DOCUMENT_WRP;
708:
709: PROCEDURE UNSPENT_AMOUNT
710: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
711: P_APP_COST_BDGT_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
712: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
713: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
714: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 711: P_APP_COST_BDGT_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

707: END INCLUDE_CHANGE_DOCUMENT_WRP;
708:
709: PROCEDURE UNSPENT_AMOUNT
710: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
711: P_APP_COST_BDGT_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
712: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
713: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
714: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
715: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 729: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;

725: l_res_list_mem_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
726: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
727: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
728:
729: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
730: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
731: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
732: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
733: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;

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

1470:
1471: --Please note that wbs_element_version id will be NULL for budgets and forecasts. If this API is called
1472: --for a B/F version then nothing will happen. The API just return without doing any processing
1473: PROCEDURE UPD_WBS_ELEMENT_VERSION_ID
1474: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1475: P_STRUCTURE_VERSION_ID IN NUMBER,
1476: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1477: X_MSG_COUNT OUT NOCOPY NUMBER,
1478: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 1483: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;

1479:
1480: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1481: l_wbs_element_ver_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1482: l_structure_version_id NUMBER;
1483: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
1484:
1485: BEGIN
1486:
1487: /* Setting initial values */

Line 1502: FROM pa_budget_versions

1498: SELECT NVL(P_STRUCTURE_VERSION_ID,project_structure_version_id),
1499: NVL(wp_version_flag,'N')
1500: INTO l_structure_version_id,
1501: l_wp_version_flag
1502: FROM pa_budget_versions
1503: WHERE budget_version_id = p_budget_version_id;
1504:
1505: IF l_wp_version_flag = 'N' THEN
1506: IF P_PA_DEBUG_MODE = 'Y' THEN

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

1781: *
1782: * Note that the p_fp_col_rec parameter is currently not used.
1783: */
1784: PROCEDURE MAINTAIN_FIXED_DATE_SP
1785: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1786: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1787: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1788: X_MSG_COUNT OUT NOCOPY NUMBER,
1789: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 2006: l_src_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

2002: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
2003:
2004: l_src_version_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2005: l_gen_etc_src_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2006: l_src_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2007: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
2008: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2009:
2010: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;