APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 175: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(opt.project_id )),

171: FP.BILL_RATE_FLAG,
172: FP.COST_RATE_FLAG,
173: FP.BURDEN_RATE_FLAG,
174: DECODE(BV.WP_VERSION_FLAG,'Y',BV.PROJECT_STRUCTURE_VERSION_ID,
175: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(opt.project_id )),
176: FB.PLAN_CLASS_CODE,
177: BV.VERSION_TYPE,
178: P.PROJECT_VALUE,
179: OPT.TRACK_WORKPLAN_COSTS_FLAG,

Line 1556: PA_PROJECT_STRUCTURE_UTILS.GET_STRUCTURE_SHARING_CODE

1552: -- Added for ER 4391254
1553: IF l_plan_class_code = 'BUDGET' THEN
1554:
1555: l_stru_sharing_code :=
1556: PA_PROJECT_STRUCTURE_UTILS.GET_STRUCTURE_SHARING_CODE
1557: ( p_project_id => l_fp_cols_rec_tgt.X_PROJECT_ID );
1558:
1559: -- For the special case when the Target is a Cost-only Budget
1560: -- and the structure is Fully Shared, try to default the source

Line 1689: PA_PROJECT_STRUCTURE_UTILS.GET_STRUCTURE_SHARING_CODE

1685: END IF;
1686: END IF; -- Validation Case 1
1687: l_source_wp_ver_id := l_fp_cols_rec_tgt.X_GEN_SRC_WP_VERSION_ID;
1688: l_stru_sharing_code :=
1689: PA_PROJECT_STRUCTURE_UTILS.GET_STRUCTURE_SHARING_CODE
1690: ( p_project_id => l_fp_cols_rec_tgt.X_PROJECT_ID );
1691: l_source_fp_ver_id := l_fp_cols_rec_tgt.X_GEN_SRC_PLAN_VERSION_ID;
1692: --Added For CBS
1693: IF l_stru_sharing_code = 'SHARE_FULL' AND

Line 2422: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION

2418: IF l_versioning_enabled = 'Y' THEN
2419: l_wp_status := P_FP_COLS_REC_TGT.x_gen_src_wp_ver_code;
2420: --dbms_output.put_line('ver code val :'||l_wp_status );
2421: IF (l_wp_status = 'LAST_PUBLISHED') THEN
2422: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION
2423: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID );
2424: IF l_wp_id is null THEN
2425: PA_UTILS.ADD_MESSAGE
2426: ( p_app_short_name => 'PA',

Line 2432: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_CURRENT_WORKING_VER_ID

2428: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2429: END IF;
2430: ELSIF (l_wp_status = 'CURRENT_WORKING') THEN
2431: --dbms_output.put_line('inside cw chk :');
2432: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_CURRENT_WORKING_VER_ID
2433: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID);
2434: IF l_wp_id is null THEN
2435: --dbms_output.put_line('cw id is null calling latest pub :');
2436: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION

Line 2436: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION

2432: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_CURRENT_WORKING_VER_ID
2433: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID);
2434: IF l_wp_id is null THEN
2435: --dbms_output.put_line('cw id is null calling latest pub :');
2436: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION
2437: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID );
2438: END IF;
2439: --dbms_output.put_line('wp id value : '||l_wp_id);
2440: IF l_wp_id is null THEN

Line 2448: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_BASELINE_STRUCT_VER

2444: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2445: END IF;
2446: -- Changed 'BASELINE', which was INCORRECT, to 'BASELINED' (dkuo)
2447: ELSIF (l_wp_status = 'BASELINED') THEN
2448: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_BASELINE_STRUCT_VER
2449: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID );
2450: IF l_wp_id is null THEN
2451: PA_UTILS.ADD_MESSAGE
2452: ( p_app_short_name => 'PA',

Line 2458: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION

2454: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2455: END IF;
2456: END IF;
2457: ELSE
2458: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION
2459: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID );
2460: IF l_wp_id is null THEN
2461: PA_UTILS.ADD_MESSAGE
2462: ( p_app_short_name => 'PA',