APPS.PA_FIN_PLAN_PUB dependencies on PA_FP_ADJ_ELEMENTS

Line 1626: /* PA_FP_ADJ_ELEMENTS: delete row (keyed on budget_version_id) */

1622: IF p_context=PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET THEN
1623:
1624: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1625:
1626: /* PA_FP_ADJ_ELEMENTS: delete row (keyed on budget_version_id) */
1627: delete
1628: from
1629: pa_fp_adj_elements
1630: where

Line 1629: pa_fp_adj_elements

1625:
1626: /* PA_FP_ADJ_ELEMENTS: delete row (keyed on budget_version_id) */
1627: delete
1628: from
1629: pa_fp_adj_elements
1630: where
1631: budget_version_id=l_budget_Version_id_tbl(i);
1632:
1633: END IF;

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 4483: l_adj_element_id pa_fp_adj_elements.adj_element_id%TYPE;

4479:
4480:
4481: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
4482: l_forecast_element_id pa_org_forecast_lines.forecast_element_id%TYPE;
4483: l_adj_element_id pa_fp_adj_elements.adj_element_id%TYPE;
4484:
4485: cursor l_ra_csr is
4486: select
4487: resource_assignment_id

Line 4519: pa_fp_adj_elements

4515: cursor l_ae_csr is
4516: select
4517: adj_element_id
4518: from
4519: pa_fp_adj_elements
4520: where
4521: budget_version_id = p_source_version_id and
4522: resource_assignment_id = l_ra_rec.resource_assignment_id;
4523:

Line 4584: /* PA_FP_ADJ_ELEMENTS: Insert new row for all existing rows with the same budget_version_id */

4580: into l_resource_assignment_id
4581: from pa_fp_ra_map_tmp
4582: where source_res_assignment_id = l_ra_rec.resource_assignment_id;
4583:
4584: /* PA_FP_ADJ_ELEMENTS: Insert new row for all existing rows with the same budget_version_id */
4585: open l_ae_csr;
4586: loop
4587: fetch l_ae_csr into l_ae_rec;
4588: exit when l_ae_csr%NOTFOUND;

Line 4589: select pa_fp_adj_elements_s.nextVal into l_adj_element_id from dual;

4585: open l_ae_csr;
4586: loop
4587: fetch l_ae_csr into l_ae_rec;
4588: exit when l_ae_csr%NOTFOUND;
4589: select pa_fp_adj_elements_s.nextVal into l_adj_element_id from dual;
4590: insert into pa_fp_adj_elements(
4591: adj_element_id,
4592: project_id,
4593: budget_version_id,

Line 4590: insert into pa_fp_adj_elements(

4586: loop
4587: fetch l_ae_csr into l_ae_rec;
4588: exit when l_ae_csr%NOTFOUND;
4589: select pa_fp_adj_elements_s.nextVal into l_adj_element_id from dual;
4590: insert into pa_fp_adj_elements(
4591: adj_element_id,
4592: project_id,
4593: budget_version_id,
4594: resource_assignment_id,

Line 4617: pa_fp_adj_elements ae

4613: FND_GLOBAL.login_id, /* last_update_login */
4614: FND_GLOBAL.user_id, /* last_updated_by */
4615: SYSDATE /* last_update_date */
4616: from
4617: pa_fp_adj_elements ae
4618: where
4619: ae.adj_element_id = l_ae_rec.adj_element_id;
4620: /* PA_FIN_PLAN_ADJ_LINES: Insert new row for all rows with the old adj_element_id*/
4621: insert into pa_fin_plan_adj_lines (