APPS.PA_FIN_PLAN_PUB dependencies on PA_ORG_FCST_ELEMENTS

Line 1653: pa_org_fcst_elements

1649: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1650: /* PA_ORG_FORECAST_ELEMENTS: delete row (keyed on budget_version_id) */
1651: delete
1652: from
1653: pa_org_fcst_elements
1654: where
1655: budget_version_id=l_budget_Version_id_tbl(i);
1656: END IF;
1657:

Line 3128: --pa_fp_adj_elements,pa_fin_plan_adj_lines,pa_org_fcst_elements,pa_org_forecast_lines.

3124: -- End, Bug 3362316, 08-JAN-2003: Populate Reporting Lines Entity ----------------------
3125: END IF;-- p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN)
3126:
3127: --IF p_calling_module is PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST then call create_org_fcst_elements to insert into
3128: --pa_fp_adj_elements,pa_fin_plan_adj_lines,pa_org_fcst_elements,pa_org_forecast_lines.
3129:
3130: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST THEN
3131:
3132: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4499: pa_org_fcst_elements

4495: cursor l_fe_csr is
4496: select
4497: forecast_element_id
4498: from
4499: pa_org_fcst_elements
4500: where
4501: budget_version_id=p_source_version_id;
4502:
4503: l_fe_rec l_fe_csr%ROWTYPE;

Line 4836: /* PA_ORG_FCST_ELEMENTS: Insert a new row for each row that contained the old budget version */

4832: close l_ra_csr;
4833:
4834:
4835:
4836: /* PA_ORG_FCST_ELEMENTS: Insert a new row for each row that contained the old budget version */
4837: IF P_PA_DEBUG_MODE = 'Y' THEN
4838: pa_debug.write_file('Create_Org_Fcst_Elements: ' || 'insert into pa_org_forecast_elements');
4839: END IF;
4840: open l_fe_csr;

Line 4843: select pa_org_fcst_elements_s.nextVal into l_forecast_element_id from dual;

4839: END IF;
4840: open l_fe_csr;
4841: loop
4842: /* generate next forecast_element_id into local variable */
4843: select pa_org_fcst_elements_s.nextVal into l_forecast_element_id from dual;
4844: fetch l_fe_csr into l_fe_rec;
4845: exit when l_fe_csr%NOTFOUND;
4846: insert into pa_org_fcst_elements (
4847: creation_date,

Line 4846: insert into pa_org_fcst_elements (

4842: /* generate next forecast_element_id into local variable */
4843: select pa_org_fcst_elements_s.nextVal into l_forecast_element_id from dual;
4844: fetch l_fe_csr into l_fe_rec;
4845: exit when l_fe_csr%NOTFOUND;
4846: insert into pa_org_fcst_elements (
4847: creation_date,
4848: created_by,
4849: last_update_login,
4850: last_updated_by,

Line 4885: pa_org_fcst_elements fe

4881: fe.assignment_id,
4882: fe.resource_id,
4883: 1 /* record_version_number = 1 */
4884: from
4885: pa_org_fcst_elements fe
4886: where
4887: forecast_element_id=l_fe_rec.forecast_element_id;
4888: /* PA_ORG_FORECAST_LINES: create a new row for every row whose forecast_element_id matches
4889: the one we're using */