APPS.PA_FIN_PLAN_PUB dependencies on PA_ORG_FORECAST_LINES

Line 1639: /* PA_ORG_FORECAST_LINES: delete row (keyed on budget_version_id as of 2/20/2002) */

1635: IF p_context=PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET THEN
1636:
1637: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1638:
1639: /* PA_ORG_FORECAST_LINES: delete row (keyed on budget_version_id as of 2/20/2002) */
1640: delete
1641: from
1642: pa_org_forecast_lines
1643: where

Line 1642: pa_org_forecast_lines

1638:
1639: /* PA_ORG_FORECAST_LINES: delete row (keyed on budget_version_id as of 2/20/2002) */
1640: delete
1641: from
1642: pa_org_forecast_lines
1643: where
1644: budget_version_id = l_budget_Version_id_tbl(i);
1645:
1646: 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 4482: l_forecast_element_id pa_org_forecast_lines.forecast_element_id%TYPE;

4478: l_msg_index_out NUMBER;
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

Line 4509: pa_org_forecast_lines

4505: cursor l_fl_csr is
4506: select
4507: forecast_line_id
4508: from
4509: pa_org_forecast_lines
4510: where
4511: forecast_element_id=l_fe_rec.forecast_element_id;
4512:
4513: l_fl1_rec l_fl_csr%ROWTYPE;

Line 4888: /* PA_ORG_FORECAST_LINES: create a new row for every row whose forecast_element_id matches

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 */
4890: open l_fl_csr;
4891: loop
4892: fetch l_fl_csr into l_fl1_rec;

Line 4894: insert into pa_org_forecast_lines (

4890: open l_fl_csr;
4891: loop
4892: fetch l_fl_csr into l_fl1_rec;
4893: exit when l_fl_csr%NOTFOUND;
4894: insert into pa_org_forecast_lines (
4895: creation_date,
4896: created_by,
4897: last_update_login,
4898: last_updated_by,

Line 4926: pa_org_forecast_lines_s.nextVal, /* use nextVal to generate next forecast_line_id */

4922: FND_GLOBAL.user_id, /* created_by */
4923: FND_GLOBAL.login_id, /* last_update_login */
4924: FND_GLOBAL.user_id, /* last_updated_by */
4925: SYSDATE, /* last_update_date */
4926: pa_org_forecast_lines_s.nextVal, /* use nextVal to generate next forecast_line_id */
4927: l_forecast_element_id, /* use newly-created forecast_element_id */
4928: fl.project_id,
4929: fl.task_id,
4930: fl.period_name,

Line 4947: pa_org_forecast_lines fl

4943: fl.lent_resource_cost,
4944: fl.unassigned_time_cost,
4945: p_target_version_id
4946: from
4947: pa_org_forecast_lines fl
4948: where
4949: fl.forecast_line_id=l_fl1_rec.forecast_line_id;
4950: end loop; /* PA_ORG_FORECAST_LINES */
4951: close l_fl_csr;

Line 4950: end loop; /* PA_ORG_FORECAST_LINES */

4946: from
4947: pa_org_forecast_lines fl
4948: where
4949: fl.forecast_line_id=l_fl1_rec.forecast_line_id;
4950: end loop; /* PA_ORG_FORECAST_LINES */
4951: close l_fl_csr;
4952: /* PA_PROJECT_PERIODS_DENORM: Insert a new row for every record whose budget_version_id and resource_assignment_id match our old ones */
4953: /* key on OBJECT_ID = forecast_element_id of the original version */
4954: IF P_PA_DEBUG_MODE = 'Y' THEN