APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_ORG_FCST_ELEMENTS

Line 232: l_prv_forecast_element_id pa_org_fcst_elements.forecast_element_id%TYPE;

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

Line 2245: SELECT pa_org_fcst_elements_s.NEXTVAL

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

Line 2474: INSERT INTO pa_org_fcst_elements

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