1 PACKAGE IGW_PROP_USERS_PVT AUTHID CURRENT_USER as
2 /* $Header: igwvprus.pls 115.5 2002/11/15 00:46:26 ashkumar ship $*/
3 PROCEDURE create_prop_user (
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_full_name IN VARCHAR2
13 ,p_start_date_active IN DATE
14 ,p_end_date_active IN DATE
15 ,p_logged_user_id IN NUMBER
16 ,x_return_status OUT NOCOPY VARCHAR2
17 ,x_msg_count OUT NOCOPY NUMBER
18 ,x_msg_data OUT NOCOPY VARCHAR2);
19 --------------------------------------------------------------------------------------------------------------
20
21 Procedure update_prop_user (
22 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
24 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
25 ,x_rowid IN VARCHAR2
26 ,p_proposal_id IN NUMBER
27 ,p_proposal_number IN VARCHAR2
28 ,p_user_id IN NUMBER
29 ,p_user_name IN VARCHAR2
30 ,p_full_name IN VARCHAR2
31 ,p_start_date_active IN DATE
32 ,p_end_date_active IN DATE
33 ,p_logged_user_id IN NUMBER
34 ,p_record_version_number IN NUMBER
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2);
38 --------------------------------------------------------------------------------------------------------
39
40 Procedure delete_prop_user (
41 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
42 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
43 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
44 ,x_rowid IN VARCHAR2
45 ,p_logged_user_id IN NUMBER
46 ,p_record_version_number IN NUMBER
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ,x_msg_count OUT NOCOPY NUMBER
49 ,x_msg_data OUT NOCOPY VARCHAR2);
50 ------------------------------------------------------------------------------------------------
51
52 PROCEDURE CHECK_IF_USER_HAS_SEEDED_ROLE
53 (p_proposal_id IN NUMBER
54 ,p_user_id IN NUMBER
55 ,x_return_status OUT NOCOPY VARCHAR2);
56 ---------------------------------------------------------------------------------------------
57
58 PROCEDURE CHECK_LOCK_GET_COLS
59 (x_rowid IN VARCHAR2
60 ,p_record_version_number IN NUMBER
61 ,x_proposal_id OUT NOCOPY NUMBER
62 ,x_user_id OUT NOCOPY NUMBER
63 ,x_start_date_active OUT NOCOPY DATE
64 ,x_end_date_active OUT NOCOPY DATE
65 ,x_return_status OUT NOCOPY VARCHAR2);
66 ------------------------------------------------------------------------------------------------
67
68 PROCEDURE CHECK_ERRORS;
69
70 END IGW_PROP_USERS_PVT;