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 130: l_resource_list_id PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE;

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

Line 203: FROM pa_budget_versions

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

Line 218: FROM pa_budget_versions

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

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

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

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

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

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

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