[Home] [Help]
4670: /* key on OBJECT_ID = adj_element_id of the original version */
4671: IF P_PA_DEBUG_MODE = 'Y' THEN
4672: pa_debug.write_file('Create_Org_Fcst_Elements: ' || 'inserting into pa_project_periods_denorm');
4673: END IF;
4674: insert into pa_proj_periods_denorm (
4675: creation_date,
4676: created_by,
4677: last_update_login,
4678: last_updated_by,
4819: ppd.period_amount52,
4820: p_project_id, --passed value
4821: NULL --Org_Forecast doesn't have rollup
4822: from
4823: pa_proj_periods_denorm ppd
4824: where
4825: ppd.budget_version_id = p_source_version_id and
4826: ppd.object_id = l_ae_rec.adj_element_id;
4827:
4953: /* key on OBJECT_ID = forecast_element_id of the original version */
4954: IF P_PA_DEBUG_MODE = 'Y' THEN
4955: pa_debug.write_file('Create_Org_Fcst_Elements: ' || 'inserting into pa_project_periods_denorm');
4956: END IF;
4957: insert into pa_proj_periods_denorm (
4958: creation_date,
4959: created_by,
4960: last_update_login,
4961: last_updated_by,
5102: ppd.period_amount52,
5103: p_project_id, /* project_id */
5104: NULL --as Org_Fcst doen't have rollup
5105: from
5106: pa_proj_periods_denorm ppd
5107: where
5108: ppd.budget_version_id = p_source_version_id and
5109: ppd.object_id = l_fe_rec.forecast_element_id;
5110:
7513: (p_res_assignment_tbl IN p_res_assignment_tbl_typ
7514: ,p_period_name_tbl IN p_period_name_tbl_typ
7515: ,p_start_date_tbl IN p_start_date_tbl_typ
7516: ,p_end_date_tbl IN p_end_date_tbl_typ
7517: ,p_currency_type IN pa_proj_periods_denorm.currency_type%TYPE
7518: ,p_currency_code_tbl IN p_currency_code_tbl_typ
7519: ,p_quantity_tbl IN p_quantity_tbl_typ
7520: ,p_raw_cost_tbl IN p_cost_tbl_typ
7521: ,p_burdened_cost_tbl IN p_cost_tbl_typ
7650:
7651: /*---------------------------------------------------------------------------------------------
7652: This procedure will populate the Lines Temp table pa_fin_plan_lines_tmp, with records from
7653: Budget Lines with appropriate values and call Maintain Matrix API to update the
7654: USER_ENTERED level records into pa_proj_periods_denorm table.
7655: ---------------------------------------------------------------------------------------------*/
7656: PROCEDURE Call_Maintain_Plan_Matrix (
7657: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7658: ,p_data_source IN VARCHAR2
8177: END IF; /* End IF of check for the Data Source. */
8178:
8179:
8180: /* Call PA_PLAN_MATRIX.MAINTAIN_PLAN_MATRIX to populate the Denorm table
8181: 'PA_PROJ_PERIODS_DENORM' in order to report in a matrix format if the
8182: Plan version is tim phased by PA or GL periods. */
8183:
8184: /* First populate the amt_rec PL/SQL table with the Amount Type and the
8185: Amount Sub Type codes based on the Budget Version Type