DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_UTILS dependencies on HR_ORGANIZATION_UNITS

Line 28: ( p_organization_id IN hr_organization_units.organization_id%TYPE

24: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
26:
27: PROCEDURE get_org_project_info
28: ( p_organization_id IN hr_organization_units.organization_id%TYPE
29: := NULL
30: ,x_org_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 38: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895

34: PROCEDURE get_org_task_info
35: ( p_project_id IN pa_projects_all.project_id%TYPE
36: := NULL
37: ,x_org_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
38: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
39: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
41:
42: PROCEDURE get_utilization_details

Line 45: ,p_organization_id IN hr_organization_units.organization_id%TYPE

41:
42: PROCEDURE get_utilization_details
43: ( p_org_id IN pa_implementations_all.org_id%TYPE
44: := NULL
45: ,p_organization_id IN hr_organization_units.organization_id%TYPE
46: := NULL
47: ,p_period_type IN pa_forecasting_options_all.org_fcst_period_type%TYPE
48: := NULL
49: ,p_period_set_name IN gl_periods.period_set_name%TYPE

Line 60: ( p_organization_id IN hr_organization_units.organization_id%TYPE

56: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
58:
59: PROCEDURE get_headcount
60: ( p_organization_id IN hr_organization_units.organization_id%TYPE
61: := NULL
62: ,p_effective_date IN DATE
63: := NULL
64: ,x_headcount OUT NOCOPY NUMBER --File.Sql.39 bug 4440895