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 193: 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

189:
190: -- Bug 4130319: Moved initialization of l_rev_gen_method from below.
191: -- Before, it was being set after the call to COPY_ACTUALS for the
192: -- Event-based Revenue and Resource Schedule cases.
193: 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
194: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);
195:
196: -- Bug 4114589: We call the Copy Actuals API for these two cases here,
197: -- and postpone calling it until after CREATE_RES_ASG and UPDATE_RES_ASG

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

190: -- Bug 4130319: Moved initialization of l_rev_gen_method from below.
191: -- Before, it was being set after the call to COPY_ACTUALS for the
192: -- Event-based Revenue and Resource Schedule cases.
193: 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
194: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);
195:
196: -- Bug 4114589: We call the Copy Actuals API for these two cases here,
197: -- and postpone calling it until after CREATE_RES_ASG and UPDATE_RES_ASG
198: -- have been called in the remaining two cases (see conditional logic below).

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

3169: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP2;
3170: --hr_utility.trace('**PA_FP_CALC_AMT_TMP2.count'||l_count_tmp);
3171: --hr_utility.trace('**P_FP_COLS_REC.X_TIME_PHASED_CODE:'||P_FP_COLS_REC.X_TIME_PHASED_CODE);
3172:
3173: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);
3174: 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
3175: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' and l_rev_gen_method = 'C' THEN
3176: IF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'N' THEN
3177: SELECT DISTINCT target_res_asg_id

Line 3174: 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

3170: --hr_utility.trace('**PA_FP_CALC_AMT_TMP2.count'||l_count_tmp);
3171: --hr_utility.trace('**P_FP_COLS_REC.X_TIME_PHASED_CODE:'||P_FP_COLS_REC.X_TIME_PHASED_CODE);
3172:
3173: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);
3174: 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
3175: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' and l_rev_gen_method = 'C' THEN
3176: IF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'N' THEN
3177: SELECT DISTINCT target_res_asg_id
3178: BULK COLLECT INTO l_res_asg_uom_update_tab