APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1470: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

1466: P_TASK_ID IN NUMBER,
1467: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
1468: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1469: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1470: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1471: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1472: X_MSG_COUNT OUT NOCOPY NUMBER,
1473: X_MSG_DATA OUT NOCOPY VARCHAR2)
1474: IS

Line 1894: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

1890: P_TASK_ID IN NUMBER,
1891: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
1892: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1893: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1894: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1895: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1896: X_MSG_COUNT OUT NOCOPY NUMBER,
1897: X_MSG_DATA OUT NOCOPY VARCHAR2 )
1898: IS

Line 2162: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

2158: P_TASK_ID IN NUMBER,
2159: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
2160: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2161: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2162: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2163: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2164: X_MSG_COUNT OUT NOCOPY NUMBER,
2165: X_MSG_DATA OUT NOCOPY VARCHAR2
2166: )

Line 2633: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

2629: P_TASK_ID IN NUMBER,
2630: P_TARGET_RES_LIST_ID IN NUMBER,
2631: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2632: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2633: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2634: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2635: X_MSG_COUNT OUT NOCOPY NUMBER,
2636: X_MSG_DATA OUT NOCOPY VARCHAR2)
2637: IS

Line 3926: l_etc_wp_ver_name PA_PROJ_ELEM_VER_STRUCTURE.name%type;

3922: l_etc_wp_bdgt_ver_id number;
3923: l_versioning_enabled varchar2(30);
3924: l_etc_wp_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VER_CODE%type;
3925: l_etc_wp_ver_id VARCHAR2(100);
3926: l_etc_wp_ver_name PA_PROJ_ELEM_VER_STRUCTURE.name%type;
3927: l_dummy VARCHAR2(100):=null;
3928: BEGIN
3929: SELECT DECODE(BV.VERSION_TYPE,
3930: 'COST', OPT.GEN_SRC_COST_WP_VERSION_ID,

Line 3959: FROM pa_budget_versions bv, pa_proj_elem_ver_structure el

3955: RETURN l_etc_wp_ver_id;
3956: END IF;
3957: IF l_etc_wp_bdgt_ver_id is not null AND P_CONTEXT = 'VER_NAME' THEN
3958: SELECT el.name INTO l_etc_wp_ver_name
3959: FROM pa_budget_versions bv, pa_proj_elem_ver_structure el
3960: WHERE bv.budget_version_id = l_etc_wp_bdgt_ver_id
3961: AND bv.project_structure_version_id = el.element_version_id
3962: AND bv.project_id = el.project_id;
3963: RETURN l_etc_wp_ver_name;

Line 3999: FROM pa_proj_elem_ver_structure

3995: END IF;
3996:
3997: IF P_CONTEXT = 'VER_NAME' AND l_etc_wp_ver_id is not null THEN
3998: SELECT name INTO l_etc_wp_ver_name
3999: FROM pa_proj_elem_ver_structure
4000: WHERE element_version_id = l_etc_wp_ver_id
4001: AND project_id = l_project_id;
4002: RETURN l_etc_wp_ver_name;
4003: END IF;