DBA Data[Home] [Help]

APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_PROJECT_STRUCTURE_UTILS

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

154: FP.BILL_RATE_FLAG,
155: FP.COST_RATE_FLAG,
156: FP.BURDEN_RATE_FLAG,
157: DECODE(BV.WP_VERSION_FLAG,'Y',BV.PROJECT_STRUCTURE_VERSION_ID,
158: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(opt.project_id )),
159: FB.PLAN_CLASS_CODE,
160: BV.VERSION_TYPE,
161: P.PROJECT_VALUE,
162: OPT.TRACK_WORKPLAN_COSTS_FLAG,

Line 1532: PA_PROJECT_STRUCTURE_UTILS.GET_STRUCTURE_SHARING_CODE

1528: -- Added for ER 4391254
1529: IF l_plan_class_code = 'BUDGET' THEN
1530:
1531: l_stru_sharing_code :=
1532: PA_PROJECT_STRUCTURE_UTILS.GET_STRUCTURE_SHARING_CODE
1533: ( p_project_id => l_fp_cols_rec_tgt.X_PROJECT_ID );
1534:
1535: -- For the special case when the Target is a Cost-only Budget
1536: -- and the structure is Fully Shared, try to default the source

Line 2341: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION

2337: IF l_versioning_enabled = 'Y' THEN
2338: l_wp_status := P_FP_COLS_REC_TGT.x_gen_src_wp_ver_code;
2339: --dbms_output.put_line('ver code val :'||l_wp_status );
2340: IF (l_wp_status = 'LAST_PUBLISHED') THEN
2341: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION
2342: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID );
2343: IF l_wp_id is null THEN
2344: PA_UTILS.ADD_MESSAGE
2345: ( p_app_short_name => 'PA',

Line 2351: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_CURRENT_WORKING_VER_ID

2347: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2348: END IF;
2349: ELSIF (l_wp_status = 'CURRENT_WORKING') THEN
2350: --dbms_output.put_line('inside cw chk :');
2351: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_CURRENT_WORKING_VER_ID
2352: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID);
2353: IF l_wp_id is null THEN
2354: --dbms_output.put_line('cw id is null calling latest pub :');
2355: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION

Line 2355: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION

2351: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_CURRENT_WORKING_VER_ID
2352: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID);
2353: IF l_wp_id is null THEN
2354: --dbms_output.put_line('cw id is null calling latest pub :');
2355: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION
2356: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID );
2357: END IF;
2358: --dbms_output.put_line('wp id value : '||l_wp_id);
2359: IF l_wp_id is null THEN

Line 2367: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_BASELINE_STRUCT_VER

2363: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2364: END IF;
2365: -- Changed 'BASELINE', which was INCORRECT, to 'BASELINED' (dkuo)
2366: ELSIF (l_wp_status = 'BASELINED') THEN
2367: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_BASELINE_STRUCT_VER
2368: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID );
2369: IF l_wp_id is null THEN
2370: PA_UTILS.ADD_MESSAGE
2371: ( p_app_short_name => 'PA',

Line 2377: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION

2373: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2374: END IF;
2375: END IF;
2376: ELSE
2377: l_wp_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION
2378: ( P_PROJECT_ID => P_FP_COLS_REC_TGT.X_PROJECT_ID );
2379: IF l_wp_id is null THEN
2380: PA_UTILS.ADD_MESSAGE
2381: ( p_app_short_name => 'PA',