PACKAGE: APPS.PA_PJI_UTIL_PKG

Source

1 PACKAGE pa_pji_util_pkg AUTHID CURRENT_USER AS
2 /* $Header: PAPJIUTS.pls 120.1 2005/08/19 16:41:05 mwasowic noship $ */
3 /* This package is created to get the utilization numbers from
4    PJI data model if PJI is installed. Otherwise the utilization numbers
5    will be derived from Utilization data model. */
6 PROCEDURE get_utilization_dtls
7   ( p_org_id               IN pa_implementations_all.org_id%TYPE
8                               := NULL
9    ,p_organization_id      IN hr_organization_units.organization_id%TYPE
10                               := NULL
11    ,p_period_type          IN pa_forecasting_options_all.org_fcst_period_type%TYPE
12                               := NULL
13    ,p_period_set_name      IN gl_periods.period_set_name%TYPE
14                               := NULL
15    ,p_period_name          IN gl_periods.period_name%TYPE
16                               := NULL
17    ,x_utl_hours           OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
18    ,x_utl_capacity        OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
19    ,x_utl_percent         OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
20    ,x_return_status       OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21    ,x_err_code            OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
22 END pa_pji_util_pkg;