DBA Data[Home] [Help]

PACKAGE: APPS.IGW_PROP_USER_ROLES_PVT

Source


1 PACKAGE IGW_PROP_USER_ROLES_PVT AUTHID CURRENT_USER as
2  /* $Header: igwvpurs.pls 115.5 2002/11/15 00:47:03 ashkumar ship $*/
3 PROCEDURE create_prop_user_role (
4   p_init_msg_list                IN 	VARCHAR2   := FND_API.G_FALSE
5  ,p_commit                       IN 	VARCHAR2   := FND_API.G_FALSE
6  ,p_validate_only                IN 	VARCHAR2   := FND_API.G_FALSE
7  ,x_rowid 		         OUT NOCOPY  	VARCHAR2
8  ,p_proposal_id			 IN 	NUMBER
9  ,p_proposal_number		 IN	VARCHAR2
10  ,p_user_id               	 IN 	NUMBER
11  ,p_user_name			 IN	VARCHAR2
12  ,p_role_id               	 IN 	NUMBER
13  ,p_role_name			 IN	VARCHAR2
14  ,p_logged_user_id		 IN     NUMBER
15  ,x_return_status                OUT NOCOPY 	VARCHAR2
16  ,x_msg_count                    OUT NOCOPY 	NUMBER
17  ,x_msg_data                     OUT NOCOPY 	VARCHAR2);
18 --------------------------------------------------------------------------------------------------------------
19 
20 Procedure update_prop_user_role (
21   p_init_msg_list                IN 	VARCHAR2   := FND_API.G_FALSE
22  ,p_commit                       IN 	VARCHAR2   := FND_API.G_FALSE
23  ,p_validate_only                IN 	VARCHAR2   := FND_API.G_FALSE
24  ,x_rowid 		         IN 	VARCHAR2
25  ,p_proposal_id			 IN 	NUMBER
26  ,p_proposal_number		 IN	VARCHAR2
27  ,p_user_id               	 IN 	NUMBER
28  ,p_user_name			 IN	VARCHAR2
29  ,p_role_id               	 IN 	NUMBER
30  ,p_role_name 			 IN	VARCHAR2
31  ,p_logged_user_id		 IN     NUMBER
32  ,p_record_version_number        IN 	NUMBER
33  ,x_return_status                OUT NOCOPY 	VARCHAR2
34  ,x_msg_count                    OUT NOCOPY 	NUMBER
35  ,x_msg_data                     OUT NOCOPY 	VARCHAR2);
36 --------------------------------------------------------------------------------------------------------
37 
38 Procedure delete_prop_user_role (
39   p_init_msg_list                IN   		VARCHAR2   := FND_API.G_FALSE
40  ,p_commit                       IN   		VARCHAR2   := FND_API.G_FALSE
41  ,p_validate_only                IN   		VARCHAR2   := FND_API.G_FALSE
42  ,x_rowid 			 IN 		VARCHAR2
43  ,p_logged_user_id	     	 IN		NUMBER
44  ,p_record_version_number        IN   		NUMBER
45  ,x_return_status                OUT NOCOPY  		VARCHAR2
46  ,x_msg_count                    OUT NOCOPY  		NUMBER
47  ,x_msg_data                     OUT NOCOPY  		VARCHAR2);
48 -----------------------------------------------------------------------------------
49 
50 PROCEDURE VALIDATE_LOGGED_USER_RIGHTS
51 (p_proposal_id		  IN  NUMBER
52 ,p_logged_user_id         IN  NUMBER
53 ,x_return_status          OUT NOCOPY VARCHAR2);
54 ------------------------------------------------------------------------------------------
55 
56 PROCEDURE CHECK_LOCK_GET_PK
57 		(x_rowid			IN 	VARCHAR2
58 		,p_record_version_number	IN	NUMBER
59                 ,x_proposal_id			OUT NOCOPY	NUMBER
60 		,x_user_id			OUT NOCOPY	NUMBER
61 		,x_role_id			OUT NOCOPY      NUMBER
62 		,x_return_status          	OUT NOCOPY 	VARCHAR2);
63 
64 ---------------------------------------------------------------------------------------------------------
65 
66 PROCEDURE GET_ROLE_ID
67 (p_role_name		  IN  VARCHAR2
68 ,x_role_id                OUT NOCOPY NUMBER
69 ,x_return_status          OUT NOCOPY VARCHAR2);
70 ------------------------------------------------------------------------------------
71 
72 PROCEDURE CHECK_IF_SEEDED_ROLE
73 (p_role_id	          IN  VARCHAR2
74 ,x_return_status          OUT NOCOPY VARCHAR2);
75 
76 -------------------------------------------------------------------------------------------------------
77 PROCEDURE CHECK_ERRORS;
78 
79 END IGW_PROP_USER_ROLES_PVT;