[Home] [Help]
299: FI.RCVR_PA_PERIOD_NAME,
300: P.START_DATE,P.END_DATE,SUM(FI.ITEM_QUANTITY),
301: MIN(FI.FORECAST_ITEM_ID)
302: FROM
303: PA_FORECAST_ITEMS FI,
304: PA_FORECAST_ITEM_DETAILS FID,
305: PA_PERIODS_ALL P
306: WHERE
307: FI.PROJECT_ORG_ID = NVL(P.ORG_ID,-99) AND
322: FI.RCVR_GL_PERIOD_NAME,
323: GLP.START_DATE, GLP.END_DATE,SUM(FI.ITEM_QUANTITY),
324: MIN(FI.FORECAST_ITEM_ID)
325: FROM
326: PA_FORECAST_ITEMS FI,
327: PA_FORECAST_ITEM_DETAILS FID,
328: GL_PERIODS GLP, /* Added the ending comma for Bug 3512491 */
329: PA_IMPLEMENTATIONS IMP, /* Added the table for Bug 3512491 */
330: GL_SETS_OF_BOOKS SOB /* Added the table for Bug 3512491 */
373: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
374: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
375: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
376:
377: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
378: /* Added for Org Forecasting */
379:
380: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
381: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
481: l_fcst_def_bem PA_BUDGET_VERSIONS.BUDGET_ENTRY_METHOD_CODE%TYPE;
482: l_fcst_res_list PA_RESOURCE_LISTS_ALL_BG.RESOURCE_LIST_ID%TYPE;
483: l_fcst_period_type VARCHAR2(30);
484:
485: l_fcst_exp_org_id PA_FORECAST_ITEMS.EXPENDITURE_ORGANIZATION_ID%TYPE;
486: l_fcst_period_name PA_PERIODS.PERIOD_NAME%TYPE;
487: l_fcst_start_date PA_PERIODS.START_DATE%TYPE;
488: l_fcst_end_date PA_PERIODS.END_DATE%TYPE;
489: l_fcst_item_quantity PA_FORECAST_ITEMS.ITEM_QUANTITY%TYPE;
485: l_fcst_exp_org_id PA_FORECAST_ITEMS.EXPENDITURE_ORGANIZATION_ID%TYPE;
486: l_fcst_period_name PA_PERIODS.PERIOD_NAME%TYPE;
487: l_fcst_start_date PA_PERIODS.START_DATE%TYPE;
488: l_fcst_end_date PA_PERIODS.END_DATE%TYPE;
489: l_fcst_item_quantity PA_FORECAST_ITEMS.ITEM_QUANTITY%TYPE;
490: l_role_error_code PA_RESOURCE_ASSIGNMENTS.PLAN_ERROR_CODE%TYPE;
491:
492: l_err_code VARCHAR2(30);
493: l_err_stack VARCHAR2(2000);
1079: l_prj_revenue_bill_rate := NULL;
1080: /* Added for Org Forecasting changes */
1081: BEGIN
1082: SELECT EXPENDITURE_TYPE_CLASS INTO l_system_linkage FROM
1083: Pa_Forecast_Items WHERE
1084: Forecast_Item_Id = l_rt_forecast_item_id_tab(1);
1085: EXCEPTION
1086: WHEN NO_DATA_FOUND THEN
1087: PA_DEBUG.g_err_stage := 'no data found in FI while getting exp type class';
1171: BEGIN
1172: /* Added for Org Forecasting changes */
1173: BEGIN
1174: SELECT EXPENDITURE_TYPE_CLASS INTO l_system_linkage FROM
1175: Pa_Forecast_Items WHERE
1176: Forecast_Item_Id = l_rt_forecast_item_id_tab(1);
1177: EXCEPTION
1178: WHEN NO_DATA_FOUND THEN
1179: PA_DEBUG.g_err_stage := 'no data found in FI while getting exp type class';