140: ,p_selection_criteria IN VARCHAR2
141: := NULL
142: ,p_is_org IN VARCHAR2
143: := NULL
144: ,p_organization_id IN hr_organization_units.organization_id%TYPE
145: := NULL
146: ,p_is_start_org IN VARCHAR2
147: := NULL
148: ,p_starting_organization_id IN hr_organization_units.organization_id%TYPE
144: ,p_organization_id IN hr_organization_units.organization_id%TYPE
145: := NULL
146: ,p_is_start_org IN VARCHAR2
147: := NULL
148: ,p_starting_organization_id IN hr_organization_units.organization_id%TYPE
149: := NULL
150: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
151: := NULL)
152: IS
208: l_pfi_exp_org_id pa_implementations_all.org_id%TYPE;
209: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
210: l_period_set_name pa_implementations_all.period_set_name%TYPE;
211: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
212: l_task_organization_id hr_organization_units.organization_id%TYPE;
213: l_organization_id hr_organization_units.organization_id%TYPE;
214: l_business_group_id hr_organization_units.business_group_id%TYPE;
215: l_org_name hr_organization_units.name%TYPE;
216: l_org_location_id hr_organization_units.location_id%TYPE;
209: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
210: l_period_set_name pa_implementations_all.period_set_name%TYPE;
211: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
212: l_task_organization_id hr_organization_units.organization_id%TYPE;
213: l_organization_id hr_organization_units.organization_id%TYPE;
214: l_business_group_id hr_organization_units.business_group_id%TYPE;
215: l_org_name hr_organization_units.name%TYPE;
216: l_org_location_id hr_organization_units.location_id%TYPE;
217: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
210: l_period_set_name pa_implementations_all.period_set_name%TYPE;
211: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
212: l_task_organization_id hr_organization_units.organization_id%TYPE;
213: l_organization_id hr_organization_units.organization_id%TYPE;
214: l_business_group_id hr_organization_units.business_group_id%TYPE;
215: l_org_name hr_organization_units.name%TYPE;
216: l_org_location_id hr_organization_units.location_id%TYPE;
217: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
211: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
212: l_task_organization_id hr_organization_units.organization_id%TYPE;
213: l_organization_id hr_organization_units.organization_id%TYPE;
214: l_business_group_id hr_organization_units.business_group_id%TYPE;
215: l_org_name hr_organization_units.name%TYPE;
216: l_org_location_id hr_organization_units.location_id%TYPE;
217: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
219: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
212: l_task_organization_id hr_organization_units.organization_id%TYPE;
213: l_organization_id hr_organization_units.organization_id%TYPE;
214: l_business_group_id hr_organization_units.business_group_id%TYPE;
215: l_org_name hr_organization_units.name%TYPE;
216: l_org_location_id hr_organization_units.location_id%TYPE;
217: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
219: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
220: l_project_id pa_projects_all.project_id%TYPE;
213: l_organization_id hr_organization_units.organization_id%TYPE;
214: l_business_group_id hr_organization_units.business_group_id%TYPE;
215: l_org_name hr_organization_units.name%TYPE;
216: l_org_location_id hr_organization_units.location_id%TYPE;
217: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
219: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
220: l_project_id pa_projects_all.project_id%TYPE;
221: l_project_name pa_projects_all.name%TYPE;
214: l_business_group_id hr_organization_units.business_group_id%TYPE;
215: l_org_name hr_organization_units.name%TYPE;
216: l_org_location_id hr_organization_units.location_id%TYPE;
217: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
219: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
220: l_project_id pa_projects_all.project_id%TYPE;
221: l_project_name pa_projects_all.name%TYPE;
222: l_project_number pa_projects_all.segment1%TYPE;
215: l_org_name hr_organization_units.name%TYPE;
216: l_org_location_id hr_organization_units.location_id%TYPE;
217: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
219: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
220: l_project_id pa_projects_all.project_id%TYPE;
221: l_project_name pa_projects_all.name%TYPE;
222: l_project_number pa_projects_all.segment1%TYPE;
223: l_new_project_number pa_projects_all.segment1%TYPE;