APPS.PA_FIN_PLAN_PUB dependencies on PA_PROJ_PERIODS_DENORM

Line 4658: insert into pa_proj_periods_denorm (

4654: /* key on OBJECT_ID = adj_element_id of the original version */
4655: IF P_PA_DEBUG_MODE = 'Y' THEN
4656: pa_debug.write_file('Create_Org_Fcst_Elements: ' || 'inserting into pa_project_periods_denorm');
4657: END IF;
4658: insert into pa_proj_periods_denorm (
4659: creation_date,
4660: created_by,
4661: last_update_login,
4662: last_updated_by,

Line 4807: pa_proj_periods_denorm ppd

4803: ppd.period_amount52,
4804: p_project_id, --passed value
4805: NULL --Org_Forecast doesn't have rollup
4806: from
4807: pa_proj_periods_denorm ppd
4808: where
4809: ppd.budget_version_id = p_source_version_id and
4810: ppd.object_id = l_ae_rec.adj_element_id;
4811:

Line 4941: insert into pa_proj_periods_denorm (

4937: /* key on OBJECT_ID = forecast_element_id of the original version */
4938: IF P_PA_DEBUG_MODE = 'Y' THEN
4939: pa_debug.write_file('Create_Org_Fcst_Elements: ' || 'inserting into pa_project_periods_denorm');
4940: END IF;
4941: insert into pa_proj_periods_denorm (
4942: creation_date,
4943: created_by,
4944: last_update_login,
4945: last_updated_by,

Line 5090: pa_proj_periods_denorm ppd

5086: ppd.period_amount52,
5087: p_project_id, /* project_id */
5088: NULL --as Org_Fcst doen't have rollup
5089: from
5090: pa_proj_periods_denorm ppd
5091: where
5092: ppd.budget_version_id = p_source_version_id and
5093: ppd.object_id = l_fe_rec.forecast_element_id;
5094:

Line 7497: ,p_currency_type IN pa_proj_periods_denorm.currency_type%TYPE

7493: (p_res_assignment_tbl IN p_res_assignment_tbl_typ
7494: ,p_period_name_tbl IN p_period_name_tbl_typ
7495: ,p_start_date_tbl IN p_start_date_tbl_typ
7496: ,p_end_date_tbl IN p_end_date_tbl_typ
7497: ,p_currency_type IN pa_proj_periods_denorm.currency_type%TYPE
7498: ,p_currency_code_tbl IN p_currency_code_tbl_typ
7499: ,p_quantity_tbl IN p_quantity_tbl_typ
7500: ,p_raw_cost_tbl IN p_cost_tbl_typ
7501: ,p_burdened_cost_tbl IN p_cost_tbl_typ

Line 7634: USER_ENTERED level records into pa_proj_periods_denorm table.

7630:
7631: /*---------------------------------------------------------------------------------------------
7632: This procedure will populate the Lines Temp table pa_fin_plan_lines_tmp, with records from
7633: Budget Lines with appropriate values and call Maintain Matrix API to update the
7634: USER_ENTERED level records into pa_proj_periods_denorm table.
7635: ---------------------------------------------------------------------------------------------*/
7636: PROCEDURE Call_Maintain_Plan_Matrix (
7637: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7638: ,p_data_source IN VARCHAR2

Line 8161: 'PA_PROJ_PERIODS_DENORM' in order to report in a matrix format if the

8157: END IF; /* End IF of check for the Data Source. */
8158:
8159:
8160: /* Call PA_PLAN_MATRIX.MAINTAIN_PLAN_MATRIX to populate the Denorm table
8161: 'PA_PROJ_PERIODS_DENORM' in order to report in a matrix format if the
8162: Plan version is tim phased by PA or GL periods. */
8163:
8164: /* First populate the amt_rec PL/SQL table with the Amount Type and the
8165: Amount Sub Type codes based on the Budget Version Type