APPS.PA_FP_GEN_FCST_RMAP_PKG dependencies on PA_BUDGET_VERSIONS

Line 10: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6: /** This method is used to map the ETC source txns to the target
7: * plan version resource list. */
8: PROCEDURE FCST_SRC_TXNS_RMAP
9: ( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
10: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
11: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
12: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
13: X_MSG_COUNT OUT NOCOPY NUMBER,
14: X_MSG_DATA OUT NOCOPY VARCHAR2 )

Line 128: l_resource_list_id PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE;

124: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE;
125:
126: /* Local copy of target version details for getting source version ids. */
127: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
128: l_resource_list_id PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE;
129:
130: /* Date update variables */
131: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
132: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 201: FROM pa_budget_versions

197: * match, then copy source rlm_id to target_rlm_id for WP records in tmp1. */
198: IF l_fp_cols_rec.x_gen_src_wp_version_id IS NOT NULL THEN
199: SELECT resource_list_id
200: INTO l_resource_list_id
201: FROM pa_budget_versions
202: WHERE budget_version_id = l_fp_cols_rec.x_gen_src_wp_version_id;
203:
204: IF l_fp_cols_rec.x_resource_list_id = l_resource_list_id THEN
205: UPDATE PA_FP_CALC_AMT_TMP1

Line 216: FROM pa_budget_versions

212: * match, then copy source rlm_id to target_rlm_id for FP records in tmp1. */
213: IF l_fp_cols_rec.x_gen_src_plan_version_id IS NOT NULL THEN
214: SELECT resource_list_id
215: INTO l_resource_list_id
216: FROM pa_budget_versions
217: WHERE budget_version_id = l_fp_cols_rec.x_gen_src_plan_version_id;
218:
219: IF l_fp_cols_rec.x_resource_list_id = l_resource_list_id THEN
220: UPDATE PA_FP_CALC_AMT_TMP1

Line 343: /**Previously, we populate latest published fwbs back to pa_budget_versions,

339: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
340: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
341: END IF;
342:
343: /**Previously, we populate latest published fwbs back to pa_budget_versions,
344: but, if planning at task level, project_structure_version_id is already
345: in pa_budget_versions, if planning at project level,project_structure
346: version_id not needed in pa_budget_versions. So update deleted **/
347:

Line 345: in pa_budget_versions, if planning at project level,project_structure

341: END IF;
342:
343: /**Previously, we populate latest published fwbs back to pa_budget_versions,
344: but, if planning at task level, project_structure_version_id is already
345: in pa_budget_versions, if planning at project level,project_structure
346: version_id not needed in pa_budget_versions. So update deleted **/
347:
348: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
349:

Line 346: version_id not needed in pa_budget_versions. So update deleted **/

342:
343: /**Previously, we populate latest published fwbs back to pa_budget_versions,
344: but, if planning at task level, project_structure_version_id is already
345: in pa_budget_versions, if planning at project level,project_structure
346: version_id not needed in pa_budget_versions. So update deleted **/
347:
348: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
349:
350: /*IF p_pa_debug_mode = 'Y' THEN