eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

PACKAGE: APPS.PA_ROLE_PROFILES_PUB

Source


1 PACKAGE PA_ROLE_PROFILES_PUB AS
2 -- $Header: PARPRPPS.pls 120.1 2005/08/19 16:59:22 mwasowic noship $
3 
4 PROCEDURE Add_Default_Profile
5 ( p_business_group_id      IN  NUMBER DEFAULT NULL,
6   p_business_group_name    IN  VARCHAR2 DEFAULT NULL,
7   p_organization_id        IN  NUMBER DEFAULT NULL,
8   p_organization_name      IN  VARCHAR2 DEFAULT NULL,
9   p_job_id                 IN  NUMBER DEFAULT NULL,
10   p_job_name               IN  VARCHAR2 DEFAULT NULL,
11   p_position_id            IN  NUMBER DEFAULT NULL,
12   p_position_name          IN  VARCHAR2 DEFAULT NULL,
13   p_profile_name           IN  VARCHAR2,
14   p_description            IN  VARCHAR2,
15   p_effective_start_date   IN  DATE,
16   p_effective_end_date     IN  DATE DEFAULT NULL,
17   p_role_id_tbl            IN  SYSTEM.PA_NUM_TBL_TYPE,
18   p_role_name_tbl          IN  SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
19   p_weighting_tbl          IN  SYSTEM.PA_NUM_TBL_TYPE,
20   x_return_status          OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
21   x_msg_count              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
22   x_msg_data               OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
23 
24 PROCEDURE Update_Default_Profile
25 ( p_profile_id             IN  NUMBER,
26   p_business_group_id      IN  NUMBER DEFAULT NULL,
27   p_business_group_name    IN  VARCHAR2 DEFAULT NULL,
28   p_organization_id        IN  NUMBER DEFAULT NULL,
29   p_organization_name      IN  VARCHAR2 DEFAULT NULL,
30   p_job_id                 IN  NUMBER DEFAULT NULL,
31   p_job_name               IN  VARCHAR2 DEFAULT NULL,
32   p_position_id            IN  NUMBER DEFAULT NULL,
33   p_position_name          IN  VARCHAR2 DEFAULT NULL,
34   p_profile_name           IN  VARCHAR2,
35   p_description            IN  VARCHAR2,
36   p_effective_start_date   IN  DATE,
37   p_effective_end_date     IN  DATE DEFAULT NULL,
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_return_status          OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
42   x_msg_count              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
43   x_msg_data               OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
44 
45 PROCEDURE Delete_Profile
46 ( p_profile_id             IN  NUMBER,
47   x_return_status          OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48   x_msg_count              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
49   x_msg_data               OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
50 
51 PROCEDURE Create_Profile_for_Resource
52 ( p_resource_id            IN  NUMBER,
53   p_resource_start_date    IN  DATE,
54   p_resource_end_date      IN  DATE,
55   p_business_group_id      IN  NUMBER,
56   p_organization_id        IN  NUMBER,
57   p_job_id                 IN  NUMBER,
58   p_position_id            IN  NUMBER,
59   x_return_status          OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
60   x_msg_count              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
61   x_msg_data               OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
62 
63 END PA_ROLE_PROFILES_PUB;