DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on HR_ORGANIZATION_UNITS

Line 143: ,p_organization_id IN hr_organization_units.organization_id%TYPE

139: ,p_selection_criteria IN VARCHAR2
140: := NULL
141: ,p_is_org IN VARCHAR2
142: := NULL
143: ,p_organization_id IN hr_organization_units.organization_id%TYPE
144: := NULL
145: ,p_is_start_org IN VARCHAR2
146: := NULL
147: ,p_starting_organization_id IN hr_organization_units.organization_id%TYPE

Line 147: ,p_starting_organization_id IN hr_organization_units.organization_id%TYPE

143: ,p_organization_id IN hr_organization_units.organization_id%TYPE
144: := NULL
145: ,p_is_start_org IN VARCHAR2
146: := NULL
147: ,p_starting_organization_id IN hr_organization_units.organization_id%TYPE
148: := NULL
149: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
150: := NULL)
151: IS

Line 211: l_task_organization_id hr_organization_units.organization_id%TYPE;

207: l_pfi_exp_org_id pa_implementations_all.org_id%TYPE;
208: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
209: l_period_set_name pa_implementations_all.period_set_name%TYPE;
210: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
211: l_task_organization_id hr_organization_units.organization_id%TYPE;
212: l_organization_id hr_organization_units.organization_id%TYPE;
213: l_business_group_id hr_organization_units.business_group_id%TYPE;
214: l_org_name hr_organization_units.name%TYPE;
215: l_org_location_id hr_organization_units.location_id%TYPE;

Line 212: l_organization_id hr_organization_units.organization_id%TYPE;

208: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
209: l_period_set_name pa_implementations_all.period_set_name%TYPE;
210: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
211: l_task_organization_id hr_organization_units.organization_id%TYPE;
212: l_organization_id hr_organization_units.organization_id%TYPE;
213: l_business_group_id hr_organization_units.business_group_id%TYPE;
214: l_org_name hr_organization_units.name%TYPE;
215: l_org_location_id hr_organization_units.location_id%TYPE;
216: l_pfi_organization_id hr_organization_units.organization_id%TYPE;

Line 213: l_business_group_id hr_organization_units.business_group_id%TYPE;

209: l_period_set_name pa_implementations_all.period_set_name%TYPE;
210: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
211: l_task_organization_id hr_organization_units.organization_id%TYPE;
212: l_organization_id hr_organization_units.organization_id%TYPE;
213: l_business_group_id hr_organization_units.business_group_id%TYPE;
214: l_org_name hr_organization_units.name%TYPE;
215: l_org_location_id hr_organization_units.location_id%TYPE;
216: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
217: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;

Line 214: l_org_name hr_organization_units.name%TYPE;

210: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
211: l_task_organization_id hr_organization_units.organization_id%TYPE;
212: l_organization_id hr_organization_units.organization_id%TYPE;
213: l_business_group_id hr_organization_units.business_group_id%TYPE;
214: l_org_name hr_organization_units.name%TYPE;
215: l_org_location_id hr_organization_units.location_id%TYPE;
216: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
217: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;

Line 215: l_org_location_id hr_organization_units.location_id%TYPE;

211: l_task_organization_id hr_organization_units.organization_id%TYPE;
212: l_organization_id hr_organization_units.organization_id%TYPE;
213: l_business_group_id hr_organization_units.business_group_id%TYPE;
214: l_org_name hr_organization_units.name%TYPE;
215: l_org_location_id hr_organization_units.location_id%TYPE;
216: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
217: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
219: l_project_id pa_projects_all.project_id%TYPE;

Line 216: l_pfi_organization_id hr_organization_units.organization_id%TYPE;

212: l_organization_id hr_organization_units.organization_id%TYPE;
213: l_business_group_id hr_organization_units.business_group_id%TYPE;
214: l_org_name hr_organization_units.name%TYPE;
215: l_org_location_id hr_organization_units.location_id%TYPE;
216: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
217: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
219: l_project_id pa_projects_all.project_id%TYPE;
220: l_project_name pa_projects_all.name%TYPE;

Line 217: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;

213: l_business_group_id hr_organization_units.business_group_id%TYPE;
214: l_org_name hr_organization_units.name%TYPE;
215: l_org_location_id hr_organization_units.location_id%TYPE;
216: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
217: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
219: l_project_id pa_projects_all.project_id%TYPE;
220: l_project_name pa_projects_all.name%TYPE;
221: l_project_number pa_projects_all.segment1%TYPE;

Line 218: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;

214: l_org_name hr_organization_units.name%TYPE;
215: l_org_location_id hr_organization_units.location_id%TYPE;
216: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
217: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
219: l_project_id pa_projects_all.project_id%TYPE;
220: l_project_name pa_projects_all.name%TYPE;
221: l_project_number pa_projects_all.segment1%TYPE;
222: l_new_project_number pa_projects_all.segment1%TYPE;