DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_FP_GEN_FCST_PG_PKG

Line 25: /**GENERATE_FCST_AMT_WRP is called from PA_FP_GEN_FCST_PG_PKG.UPD_VER_DTLS_AND_GEN_AMT,

21: ------------------------------------------------------------------------------
22: --------- END OF Forward declarations for local/private procedures -----------
23: ------------------------------------------------------------------------------
24:
25: /**GENERATE_FCST_AMT_WRP is called from PA_FP_GEN_FCST_PG_PKG.UPD_VER_DTLS_AND_GEN_AMT,
26: *which was called directly from forecast generation page.
27: **/
28: PROCEDURE GENERATE_FCST_AMT_WRP
29: ( P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

Line 174: l_rev_gen_method := nvl(P_FP_COLS_REC.X_REVENUE_DERIVATION_METHOD,PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id)); --Bug 5462471

170:
171: -- Bug 4130319: Moved initialization of l_rev_gen_method from below.
172: -- Before, it was being set after the call to COPY_ACTUALS for the
173: -- Event-based Revenue and Resource Schedule cases.
174: l_rev_gen_method := nvl(P_FP_COLS_REC.X_REVENUE_DERIVATION_METHOD,PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id)); --Bug 5462471
175: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);
176:
177: -- Bug 4114589: We call the Copy Actuals API for these two cases here,
178: -- and postpone calling it until after CREATE_RES_ASG and UPDATE_RES_ASG

Line 175: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);

171: -- Bug 4130319: Moved initialization of l_rev_gen_method from below.
172: -- Before, it was being set after the call to COPY_ACTUALS for the
173: -- Event-based Revenue and Resource Schedule cases.
174: l_rev_gen_method := nvl(P_FP_COLS_REC.X_REVENUE_DERIVATION_METHOD,PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id)); --Bug 5462471
175: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);
176:
177: -- Bug 4114589: We call the Copy Actuals API for these two cases here,
178: -- and postpone calling it until after CREATE_RES_ASG and UPDATE_RES_ASG
179: -- have been called in the remaining two cases (see conditional logic below).

Line 2946: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);

2942: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP2;
2943: --hr_utility.trace('**PA_FP_CALC_AMT_TMP2.count'||l_count_tmp);
2944: --hr_utility.trace('**P_FP_COLS_REC.X_TIME_PHASED_CODE:'||P_FP_COLS_REC.X_TIME_PHASED_CODE);
2945:
2946: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);
2947: l_rev_gen_method := nvl(P_FP_COLS_REC.X_REVENUE_DERIVATION_METHOD,PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id)); --Bug 5462471
2948: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' and l_rev_gen_method = 'C' THEN
2949: IF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'N' THEN
2950: SELECT DISTINCT target_res_asg_id

Line 2947: l_rev_gen_method := nvl(P_FP_COLS_REC.X_REVENUE_DERIVATION_METHOD,PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id)); --Bug 5462471

2943: --hr_utility.trace('**PA_FP_CALC_AMT_TMP2.count'||l_count_tmp);
2944: --hr_utility.trace('**P_FP_COLS_REC.X_TIME_PHASED_CODE:'||P_FP_COLS_REC.X_TIME_PHASED_CODE);
2945:
2946: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);
2947: l_rev_gen_method := nvl(P_FP_COLS_REC.X_REVENUE_DERIVATION_METHOD,PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id)); --Bug 5462471
2948: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' and l_rev_gen_method = 'C' THEN
2949: IF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'N' THEN
2950: SELECT DISTINCT target_res_asg_id
2951: BULK COLLECT INTO l_res_asg_uom_update_tab