APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1493: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

1489: P_TASK_ID IN NUMBER,
1490: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
1491: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1492: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1493: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1494: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1495: X_MSG_COUNT OUT NOCOPY NUMBER,
1496: X_MSG_DATA OUT NOCOPY VARCHAR2)
1497: IS

Line 1917: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

1913: P_TASK_ID IN NUMBER,
1914: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
1915: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1916: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1917: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1918: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1919: X_MSG_COUNT OUT NOCOPY NUMBER,
1920: X_MSG_DATA OUT NOCOPY VARCHAR2 )
1921: IS

Line 2185: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

2181: P_TASK_ID IN NUMBER,
2182: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
2183: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2184: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2185: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2186: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2187: X_MSG_COUNT OUT NOCOPY NUMBER,
2188: X_MSG_DATA OUT NOCOPY VARCHAR2
2189: )

Line 2656: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

2652: P_TASK_ID IN NUMBER,
2653: P_TARGET_RES_LIST_ID IN NUMBER,
2654: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2655: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2656: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2657: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2658: X_MSG_COUNT OUT NOCOPY NUMBER,
2659: X_MSG_DATA OUT NOCOPY VARCHAR2)
2660: IS

Line 3950: l_etc_wp_ver_name PA_PROJ_ELEM_VER_STRUCTURE.name%type;

3946: l_etc_wp_bdgt_ver_id number;
3947: l_versioning_enabled varchar2(30);
3948: l_etc_wp_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VER_CODE%type;
3949: l_etc_wp_ver_id VARCHAR2(100);
3950: l_etc_wp_ver_name PA_PROJ_ELEM_VER_STRUCTURE.name%type;
3951: l_dummy VARCHAR2(100):=null;
3952: BEGIN
3953: SELECT DECODE(BV.VERSION_TYPE,
3954: 'COST', OPT.GEN_SRC_COST_WP_VERSION_ID,

Line 3983: FROM pa_budget_versions bv, pa_proj_elem_ver_structure el

3979: RETURN l_etc_wp_ver_id;
3980: END IF;
3981: IF l_etc_wp_bdgt_ver_id is not null AND P_CONTEXT = 'VER_NAME' THEN
3982: SELECT el.name INTO l_etc_wp_ver_name
3983: FROM pa_budget_versions bv, pa_proj_elem_ver_structure el
3984: WHERE bv.budget_version_id = l_etc_wp_bdgt_ver_id
3985: AND bv.project_structure_version_id = el.element_version_id
3986: AND bv.project_id = el.project_id;
3987: RETURN l_etc_wp_ver_name;

Line 4023: FROM pa_proj_elem_ver_structure

4019: END IF;
4020:
4021: IF P_CONTEXT = 'VER_NAME' AND l_etc_wp_ver_id is not null THEN
4022: SELECT name INTO l_etc_wp_ver_name
4023: FROM pa_proj_elem_ver_structure
4024: WHERE element_version_id = l_etc_wp_ver_id
4025: AND project_id = l_project_id;
4026: RETURN l_etc_wp_ver_name;
4027: END IF;