APPS.PA_FIN_PLAN_PUB dependencies on PA_ORG_FCST_ELEMENTS

Line 1637: pa_org_fcst_elements

1633: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1634: /* PA_ORG_FORECAST_ELEMENTS: delete row (keyed on budget_version_id) */
1635: delete
1636: from
1637: pa_org_fcst_elements
1638: where
1639: budget_version_id=l_budget_Version_id_tbl(i);
1640: END IF;
1641:

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

3108: -- End, Bug 3362316, 08-JAN-2003: Populate Reporting Lines Entity ----------------------
3109: END IF;-- p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN)
3110:
3111: --IF p_calling_module is PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST then call create_org_fcst_elements to insert into
3112: --pa_fp_adj_elements,pa_fin_plan_adj_lines,pa_org_fcst_elements,pa_org_forecast_lines.
3113:
3114: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST THEN
3115:
3116: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4483: pa_org_fcst_elements

4479: cursor l_fe_csr is
4480: select
4481: forecast_element_id
4482: from
4483: pa_org_fcst_elements
4484: where
4485: budget_version_id=p_source_version_id;
4486:
4487: l_fe_rec l_fe_csr%ROWTYPE;

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

4816: close l_ra_csr;
4817:
4818:
4819:
4820: /* PA_ORG_FCST_ELEMENTS: Insert a new row for each row that contained the old budget version */
4821: IF P_PA_DEBUG_MODE = 'Y' THEN
4822: pa_debug.write_file('Create_Org_Fcst_Elements: ' || 'insert into pa_org_forecast_elements');
4823: END IF;
4824: open l_fe_csr;

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

4823: END IF;
4824: open l_fe_csr;
4825: loop
4826: /* generate next forecast_element_id into local variable */
4827: select pa_org_fcst_elements_s.nextVal into l_forecast_element_id from dual;
4828: fetch l_fe_csr into l_fe_rec;
4829: exit when l_fe_csr%NOTFOUND;
4830: insert into pa_org_fcst_elements (
4831: creation_date,

Line 4830: insert into pa_org_fcst_elements (

4826: /* generate next forecast_element_id into local variable */
4827: select pa_org_fcst_elements_s.nextVal into l_forecast_element_id from dual;
4828: fetch l_fe_csr into l_fe_rec;
4829: exit when l_fe_csr%NOTFOUND;
4830: insert into pa_org_fcst_elements (
4831: creation_date,
4832: created_by,
4833: last_update_login,
4834: last_updated_by,

Line 4869: pa_org_fcst_elements fe

4865: fe.assignment_id,
4866: fe.resource_id,
4867: 1 /* record_version_number = 1 */
4868: from
4869: pa_org_fcst_elements fe
4870: where
4871: forecast_element_id=l_fe_rec.forecast_element_id;
4872: /* PA_ORG_FORECAST_LINES: create a new row for every row whose forecast_element_id matches
4873: the one we're using */