DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on HR_ORGANIZATION_UNITS

Line 144: ,p_organization_id IN hr_organization_units.organization_id%TYPE

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

Line 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

Line 212: l_task_organization_id hr_organization_units.organization_id%TYPE;

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;

Line 213: l_organization_id hr_organization_units.organization_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;

Line 214: l_business_group_id hr_organization_units.business_group_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;

Line 215: l_org_name hr_organization_units.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;
219: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;

Line 216: l_org_location_id hr_organization_units.location_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;

Line 217: l_pfi_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;
221: l_project_name pa_projects_all.name%TYPE;

Line 218: l_pfi_project_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;
222: l_project_number pa_projects_all.segment1%TYPE;

Line 219: l_pfi_exp_organization_id hr_organization_units.organization_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;
223: l_new_project_number pa_projects_all.segment1%TYPE;