APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_ORG_FCST_ELEMENTS

Line 233: l_prv_forecast_element_id pa_org_fcst_elements.forecast_element_id%TYPE;

229: l_pfi_resource_id pa_forecast_items.resource_id%TYPE;
230: l_own_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
231: l_proj_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
232: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
233: l_prv_forecast_element_id pa_org_fcst_elements.forecast_element_id%TYPE;
234: l_utl_hours pa_budget_lines.utilization_hours%TYPE;
235: l_utl_capacity pa_budget_lines.capacity%TYPE;
236: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
237: l_act_period_type gl_periods.period_type%TYPE;

Line 2246: SELECT pa_org_fcst_elements_s.NEXTVAL

2242: l_fe_ctr := nvl(l_fe_forecast_element_id_tab.last+1,1);
2243: l_stage := 5800;
2244: -- hr_utility.trace(to_char(l_stage));
2245:
2246: SELECT pa_org_fcst_elements_s.NEXTVAL
2247: INTO l_fe_new_seq
2248: FROM dual;
2249:
2250: l_stage := 5900;

Line 2475: INSERT INTO pa_org_fcst_elements

2471: -- hr_utility.trace(to_char(l_stage));
2472:
2473:
2474: FORALL i in l_fe_forecast_element_id_tab.first..l_fe_forecast_element_id_tab.last
2475: INSERT INTO pa_org_fcst_elements
2476: ( forecast_element_id
2477: ,organization_id
2478: ,org_id
2479: ,budget_version_id