DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_FIN_PLAN_ADJ_LINES

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

1593: IF p_context=PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET THEN
1594:
1595: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1596:
1597: /* PA_FIN_PLAN_ADJ_LINES: delete row (keyed on budget_version_id) */
1598: delete
1599: from
1600: pa_fin_plan_adj_lines
1601: where

Line 1600: pa_fin_plan_adj_lines

1596:
1597: /* PA_FIN_PLAN_ADJ_LINES: delete row (keyed on budget_version_id) */
1598: delete
1599: from
1600: pa_fin_plan_adj_lines
1601: where
1602: budget_version_id=l_budget_Version_id_tbl(i);
1603:
1604: 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 4604: /* PA_FIN_PLAN_ADJ_LINES: Insert new row for all rows with the old adj_element_id*/

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 (
4606: adj_element_id,
4607: creation_date,
4608: created_by,

Line 4605: insert into pa_fin_plan_adj_lines (

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 (
4606: adj_element_id,
4607: creation_date,
4608: created_by,
4609: last_update_login,

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

4628: FND_GLOBAL.user_id, /* created_by */
4629: FND_GLOBAL.login_id, /* last_update_login */
4630: FND_GLOBAL.user_id, /* last_updated_by */
4631: SYSDATE, /* last_update_date */
4632: pa_fin_plan_adj_lines_s.nextVal, /* use nextVal for fin_plan_adj_line_id */
4633: al.project_id,
4634: al.task_id,
4635: p_target_version_id, /* use newly-created budget_version_id */
4636: l_resource_assignment_id, /* use newly-created resource assignment id */

Line 4646: pa_fin_plan_adj_lines al

4642: al.revenue_adjustment,
4643: al.utilization_adjustment,
4644: al.head_count_adjustment
4645: from
4646: pa_fin_plan_adj_lines al
4647: where
4648: al.adj_element_id=l_ae_rec.adj_element_id;
4649:
4650: