[Home] [Help]
PACKAGE: APPS.PA_FORECAST_GRC_PVT
Source
1 PACKAGE PA_FORECAST_GRC_PVT AUTHID CURRENT_USER AS
2 /* $Header: PARFGRCS.pls 120.1 2005/08/19 16:51:44 mwasowic noship $ */
3 PROCEDURE Get_Resource_Capacity (p_org_id IN NUMBER,
4 p_person_id IN NUMBER,
5 p_start_date IN DATE,
6 p_end_date IN DATE,
7 x_resource_capacity OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
8 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11 );
12
13 --
14 -- Procedure Get_Resource_Capacity
15 -- Purpose This procedure will calculate the total possible
16 -- working hours of a person between the input start
17 -- date and end date.
18 -- Parameters
19 --
20
21
22
23
24 PROCEDURE Get_Capacity_Vector(p_OU_id IN NUMBER,
25 p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
26 p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
27 p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
28 p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
29 p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
30 p_balance_type_code IN VARCHAR2,
31 p_run_start_date IN DATE,
32 p_run_end_date IN DATE,
33 x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
34 x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
35 x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
36 x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
37 x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
38 x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
39 x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
40 x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
41 x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
42 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
43 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
44 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
45 );
46
47 END PA_FORECAST_GRC_PVT;