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;