APPS.PA_FIN_PLAN_PUB dependencies on PA_ORG_FORECAST_LINES

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

1619: IF p_context=PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET THEN
1620:
1621: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1622:
1623: /* PA_ORG_FORECAST_LINES: delete row (keyed on budget_version_id as of 2/20/2002) */
1624: delete
1625: from
1626: pa_org_forecast_lines
1627: where

Line 1626: pa_org_forecast_lines

1622:
1623: /* PA_ORG_FORECAST_LINES: delete row (keyed on budget_version_id as of 2/20/2002) */
1624: delete
1625: from
1626: pa_org_forecast_lines
1627: where
1628: budget_version_id = l_budget_Version_id_tbl(i);
1629:
1630: END IF;

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 4466: l_forecast_element_id pa_org_forecast_lines.forecast_element_id%TYPE;

4462: l_msg_index_out NUMBER;
4463:
4464:
4465: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
4466: l_forecast_element_id pa_org_forecast_lines.forecast_element_id%TYPE;
4467: l_adj_element_id pa_fp_adj_elements.adj_element_id%TYPE;
4468:
4469: cursor l_ra_csr is
4470: select

Line 4493: pa_org_forecast_lines

4489: cursor l_fl_csr is
4490: select
4491: forecast_line_id
4492: from
4493: pa_org_forecast_lines
4494: where
4495: forecast_element_id=l_fe_rec.forecast_element_id;
4496:
4497: l_fl1_rec l_fl_csr%ROWTYPE;

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

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 */
4874: open l_fl_csr;
4875: loop
4876: fetch l_fl_csr into l_fl1_rec;

Line 4878: insert into pa_org_forecast_lines (

4874: open l_fl_csr;
4875: loop
4876: fetch l_fl_csr into l_fl1_rec;
4877: exit when l_fl_csr%NOTFOUND;
4878: insert into pa_org_forecast_lines (
4879: creation_date,
4880: created_by,
4881: last_update_login,
4882: last_updated_by,

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

4906: FND_GLOBAL.user_id, /* created_by */
4907: FND_GLOBAL.login_id, /* last_update_login */
4908: FND_GLOBAL.user_id, /* last_updated_by */
4909: SYSDATE, /* last_update_date */
4910: pa_org_forecast_lines_s.nextVal, /* use nextVal to generate next forecast_line_id */
4911: l_forecast_element_id, /* use newly-created forecast_element_id */
4912: fl.project_id,
4913: fl.task_id,
4914: fl.period_name,

Line 4931: pa_org_forecast_lines fl

4927: fl.lent_resource_cost,
4928: fl.unassigned_time_cost,
4929: p_target_version_id
4930: from
4931: pa_org_forecast_lines fl
4932: where
4933: fl.forecast_line_id=l_fl1_rec.forecast_line_id;
4934: end loop; /* PA_ORG_FORECAST_LINES */
4935: close l_fl_csr;

Line 4934: end loop; /* PA_ORG_FORECAST_LINES */

4930: from
4931: pa_org_forecast_lines fl
4932: where
4933: fl.forecast_line_id=l_fl1_rec.forecast_line_id;
4934: end loop; /* PA_ORG_FORECAST_LINES */
4935: close l_fl_csr;
4936: /* PA_PROJECT_PERIODS_DENORM: Insert a new row for every record whose budget_version_id and resource_assignment_id match our old ones */
4937: /* key on OBJECT_ID = forecast_element_id of the original version */
4938: IF P_PA_DEBUG_MODE = 'Y' THEN