eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FIN_PLAN_PUB dependencies on PA_FP_ADJ_ELEMENTS

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

1606: IF p_context=PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET THEN
1607:
1608: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1609:
1610: /* PA_FP_ADJ_ELEMENTS: delete row (keyed on budget_version_id) */
1611: delete
1612: from
1613: pa_fp_adj_elements
1614: where

Line 1613: pa_fp_adj_elements

1609:
1610: /* PA_FP_ADJ_ELEMENTS: delete row (keyed on budget_version_id) */
1611: delete
1612: from
1613: pa_fp_adj_elements
1614: where
1615: budget_version_id=l_budget_Version_id_tbl(i);
1616:
1617: 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 4467: l_adj_element_id pa_fp_adj_elements.adj_element_id%TYPE;

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
4471: resource_assignment_id

Line 4503: pa_fp_adj_elements

4499: cursor l_ae_csr is
4500: select
4501: adj_element_id
4502: from
4503: pa_fp_adj_elements
4504: where
4505: budget_version_id = p_source_version_id and
4506: resource_assignment_id = l_ra_rec.resource_assignment_id;
4507:

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

4564: into l_resource_assignment_id
4565: from pa_fp_ra_map_tmp
4566: where source_res_assignment_id = l_ra_rec.resource_assignment_id;
4567:
4568: /* PA_FP_ADJ_ELEMENTS: Insert new row for all existing rows with the same budget_version_id */
4569: open l_ae_csr;
4570: loop
4571: fetch l_ae_csr into l_ae_rec;
4572: exit when l_ae_csr%NOTFOUND;

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

4569: open l_ae_csr;
4570: loop
4571: fetch l_ae_csr into l_ae_rec;
4572: exit when l_ae_csr%NOTFOUND;
4573: select pa_fp_adj_elements_s.nextVal into l_adj_element_id from dual;
4574: insert into pa_fp_adj_elements(
4575: adj_element_id,
4576: project_id,
4577: budget_version_id,

Line 4574: insert into pa_fp_adj_elements(

4570: loop
4571: fetch l_ae_csr into l_ae_rec;
4572: exit when l_ae_csr%NOTFOUND;
4573: select pa_fp_adj_elements_s.nextVal into l_adj_element_id from dual;
4574: insert into pa_fp_adj_elements(
4575: adj_element_id,
4576: project_id,
4577: budget_version_id,
4578: resource_assignment_id,

Line 4601: pa_fp_adj_elements ae

4597: FND_GLOBAL.login_id, /* last_update_login */
4598: FND_GLOBAL.user_id, /* last_updated_by */
4599: SYSDATE /* last_update_date */
4600: from
4601: pa_fp_adj_elements ae
4602: where
4603: ae.adj_element_id = l_ae_rec.adj_element_id;
4604: /* PA_FIN_PLAN_ADJ_LINES: Insert new row for all rows with the old adj_element_id*/
4605: insert into pa_fin_plan_adj_lines (