PACKAGE: APPS.PA_ROLE_PROFILES_UTILS

Source

1 PACKAGE PA_ROLE_PROFILES_UTILS AUTHID CURRENT_USER AS
2 -- $Header: PARPRPUS.pls 120.1 2005/08/19 16:59:31 mwasowic noship $
3 
4 PROCEDURE Check_BusGroup_Name_Or_Id
5 ( p_business_group_id       IN  NUMBER,
6   p_business_group_name     IN  VARCHAR2,
7   p_check_id_flag           IN  VARCHAR2 DEFAULT NULL,
8   x_business_group_id       OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9   x_return_status           OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
10   x_error_msg_code          OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
11 
12 PROCEDURE Check_Position_Name_Or_Id
13 ( p_position_id             IN  NUMBER,
14   p_position_name           IN  VARCHAR2,
15   p_check_id_flag           IN  VARCHAR2 DEFAULT NULL,
16   x_position_id             OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17   x_return_status           OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
18   x_error_msg_code          OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
19 
20 PROCEDURE Check_Business_Level_Attrs
21 ( p_business_group_id      IN  NUMBER,
22   p_business_group_name    IN  VARCHAR2,
23   p_organization_id        IN  NUMBER,
24   p_organization_name      IN  VARCHAR2,
25   p_job_id                 IN  NUMBER,
26   p_job_name               IN  VARCHAR2,
27   p_position_id            IN  NUMBER,
28   p_position_name          IN  VARCHAR2,
29   x_business_group_id      OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
30   x_organization_id        OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
31   x_job_id                 OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
32   x_position_id            OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
33   x_return_status          OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34   x_msg_count              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
35   x_msg_data               OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
36 
37 PROCEDURE Validate_Profile_Lines
38 ( p_role_id_tbl            IN  SYSTEM.PA_NUM_TBL_TYPE,
39   p_role_name_tbl          IN  SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
40   p_weighting_tbl          IN  SYSTEM.PA_NUM_TBL_TYPE,
41   x_role_id_tbl            OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
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 END PA_ROLE_PROFILES_UTILS;