DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_FIN_PLAN_ADJ_LINES

Line 1613: /* PA_FIN_PLAN_ADJ_LINES: delete row (keyed on budget_version_id) */

1609: IF p_context=PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET THEN
1610:
1611: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1612:
1613: /* PA_FIN_PLAN_ADJ_LINES: delete row (keyed on budget_version_id) */
1614: delete
1615: from
1616: pa_fin_plan_adj_lines
1617: where

Line 1616: pa_fin_plan_adj_lines

1612:
1613: /* PA_FIN_PLAN_ADJ_LINES: delete row (keyed on budget_version_id) */
1614: delete
1615: from
1616: pa_fin_plan_adj_lines
1617: where
1618: budget_version_id=l_budget_Version_id_tbl(i);
1619:
1620: 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 4620: /* PA_FIN_PLAN_ADJ_LINES: Insert new row for all rows with the old adj_element_id*/

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 (
4622: adj_element_id,
4623: creation_date,
4624: created_by,

Line 4621: insert into pa_fin_plan_adj_lines (

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 (
4622: adj_element_id,
4623: creation_date,
4624: created_by,
4625: last_update_login,

Line 4648: pa_fin_plan_adj_lines_s.nextVal, /* use nextVal for fin_plan_adj_line_id */

4644: FND_GLOBAL.user_id, /* created_by */
4645: FND_GLOBAL.login_id, /* last_update_login */
4646: FND_GLOBAL.user_id, /* last_updated_by */
4647: SYSDATE, /* last_update_date */
4648: pa_fin_plan_adj_lines_s.nextVal, /* use nextVal for fin_plan_adj_line_id */
4649: al.project_id,
4650: al.task_id,
4651: p_target_version_id, /* use newly-created budget_version_id */
4652: l_resource_assignment_id, /* use newly-created resource assignment id */

Line 4662: pa_fin_plan_adj_lines al

4658: al.revenue_adjustment,
4659: al.utilization_adjustment,
4660: al.head_count_adjustment
4661: from
4662: pa_fin_plan_adj_lines al
4663: where
4664: al.adj_element_id=l_ae_rec.adj_element_id;
4665:
4666: