APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_FIN_PLAN_LINES_TMP

Line 20: -- pa_fin_plan_lines_tmp was not populated.

16: -- patchset K.
17: -- 10-JAN-03 ssarma FPB7: Fix for 2744924. Look for seeded
18: -- row for amount sets.
19: -- 12-FEB-03 vejayara Bug 2796261-Source_Txn_currency_code in
20: -- pa_fin_plan_lines_tmp was not populated.
21: -- Now it is populated.
22: -- 02-JUN-03 msoundra replaced the call to
23: -- API pa_fp_org_fcst_utils.get_utilization_details
24: -- with pa_pji_util_pkg.get_utilization_dtls to get the numbers from

Line 2618: DELETE FROM pa_fin_plan_lines_tmp;

2614:
2615: l_stage := 7600;
2616: -- hr_utility.trace(to_char(l_stage));
2617:
2618: DELETE FROM pa_fin_plan_lines_tmp;
2619:
2620: l_stage := 7700;
2621: -- hr_utility.trace(to_char(l_stage));
2622:

Line 2631: INSERT INTO pa_fin_plan_lines_tmp

2627: END IF;
2628:
2629: IF l_fl_forecast_line_id_tab.count > 0 THEN
2630: FORALL j in l_fl_forecast_line_id_tab.first..l_fl_forecast_line_id_tab.last
2631: INSERT INTO pa_fin_plan_lines_tmp
2632: ( resource_assignment_id
2633: ,object_id
2634: ,object_type_code
2635: ,period_name

Line 3315: DELETE FROM pa_fin_plan_lines_tmp;

3311: l_stage := 9500;
3312: -- hr_utility.trace(to_char(l_stage));
3313:
3314: budget_lines_rec.DELETE;
3315: DELETE FROM pa_fin_plan_lines_tmp;
3316:
3317: l_stage := 9600;
3318: -- hr_utility.trace(to_char(l_stage));
3319:

Line 3321: INSERT INTO pa_fin_plan_lines_tmp

3317: l_stage := 9600;
3318: -- hr_utility.trace(to_char(l_stage));
3319:
3320: FORALL i in l_bl_res_asg_id_tab.first..l_bl_res_asg_id_tab.last
3321: INSERT INTO pa_fin_plan_lines_tmp
3322: ( resource_assignment_id
3323: ,object_id
3324: ,object_type_code
3325: ,period_name

Line 3800: DELETE FROM pa_fin_plan_lines_tmp;

3796: l_stage := 11000;
3797: -- hr_utility.trace(to_char(l_stage));
3798: budget_lines_rec.DELETE;
3799:
3800: DELETE FROM pa_fin_plan_lines_tmp;
3801:
3802: l_stage := 11100;
3803: -- hr_utility.trace(to_char(l_stage));
3804:

Line 3806: INSERT INTO pa_fin_plan_lines_tmp

3802: l_stage := 11100;
3803: -- hr_utility.trace(to_char(l_stage));
3804:
3805: FORALL i in l_bl_res_asg_id_tab.first..l_bl_res_asg_id_tab.last
3806: INSERT INTO pa_fin_plan_lines_tmp
3807: ( resource_assignment_id
3808: ,object_id
3809: ,object_type_code
3810: ,period_name