1 PACKAGE ICX_User_Profile_PVT AS
2 -- $Header: ICXVUPFS.pls 120.1 2005/10/07 14:34:21 gjimenez noship $
3
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ICX_User_Profile_PVT';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ICXVUPFB.pls';
9
10 -- Start of Comments
11 -- API name : Create_Profile
12 -- Type : Private.
13 -- Function : Create Web User information in ICX_USER_PROFILES
14 -- Pre-reqs : None.
15 -- Paramaeters :
16 -- IN : p_api_version_number IN NUMBER Required
17 -- p_init_msg_list IN VARCHAR2 Optional
18 -- Default = FND_API.G_FALSE
19 -- p_simulate IN VARCHAR2 Optional
20 -- Default = FND_API.G_FALSE
21 -- p_commit IN VARCHAR2 Optional
22 -- Default = FND_API.G_FALSE
23 -- p_validation_level IN NUMBER Optional
24 -- Default = FND_API.G_VALID_LEVEL_FULL
25 -- p_user_id IN NUMBER Required
26 -- p_days_needed_by IN NUMBER Optional
27 -- Default = NULL
28 -- p_req_default_template IN VARCHAR2 Optional
29 -- Default = NULL
30 -- p_req_override_loc_flag IN VARCHAR2 Optional
31 -- Default = NULL
32 -- p_req_override_req_code IN VARCHAR2 Optional
33 -- Default = NULL
34 -- p_created_by IN NUMBER Required
35 -- p_creation_date IN DATE Required
36 -- p_last_updated_by IN NUMBER Required
37 -- p_last_update_date IN DATE Required
38 -- p_last_update_login IN NUMBER Required
39 --
40 -- OUT : p_return_status OUT VARCHAR2(1)
41 -- p_msg_count OUT NUMBER
42 -- p_msg_data OUT VARCHAR2(2000)
43
44 -- .
45 -- Version : Current version 1.0
46 -- Initial version 1.0
47 --
48 -- Notes : Note text
49 --
50 --
51 -- API name : Update_Profile
52 -- Type : Private.
53 -- Function : Update Web User information in ICX_USER_PROFILES
54 -- Pre-reqs : None.
55 -- Paramaeters :
56 -- IN : p_api_version_number IN NUMBER Required
57 -- p_init_msg_list IN VARCHAR2 Optional
58 -- Default = FND_API.G_FALSE
59 -- p_simulate IN VARCHAR2 Optional
60 -- Default = FND_API.G_FALSE
61 -- p_commit IN VARCHAR2 Optional
62 -- Default = FND_API.G_FALSE
63 -- p_validation_level IN NUMBER Optional
64 -- Default = FND_API.G_VALID_LEVEL_FULL
65 -- p_user_id IN NUMBER Required
66 -- p_days_needed_by IN NUMBER Optional
67 -- Default = FND_API.G_MISS_NUM
68 -- p_req_default_template IN VARCHAR2 Optional
69 -- Default = FND_API.G_MISS_CHAR
70 -- p_req_override_loc_flag IN VARCHAR2 Optional
71 -- Default = FND_API.G_MISS_CHAR
72 -- p_req_override_req_code IN VARCHAR2 Optional
73 -- Default = FND_API.G_MISS_CHAR
74 -- p_last_updated_by IN NUMBER Required
75 -- Default = FND_API.G_MISS_NUM
76 -- p_last_update_date IN DATE Required
77 -- Default = FND_API.G_MISS_DATE
78 -- p_last_update_login IN NUMBER Optional
79 -- Default = FND_API.G_MISS_NUM
80 --
81 -- OUT : p_return_status OUT VARCHAR2
82 -- p_msg_count OUT NUMBER
83 -- p_msg_data OUT VARCHAR2
84 -- .
85 -- Version : Current version 1.0
86 -- Initial version 1.0
87 --
88 -- Notes : Note text
89 --
90 --
91 -- API name : Delete_Profile
92 -- Type : Private.
93 -- Function : Delete Web User information from ICX_USER_PROFILES
94 -- Pre-reqs : None.
95 -- Paramaeters :
96 -- IN : p_api_version_number IN NUMBER Required
97 -- p_init_msg_list IN VARCHAR2 Optional
98 -- Default = FND_API.G_FALSE
99 -- p_simulate IN VARCHAR2 Optional
100 -- Default = FND_API.G_FALSE
101 -- p_commit IN VARCHAR2 Optional
102 -- Default = FND_API.G_FALSE
103 -- p_validation_level IN NUMBER Optional
104 -- Default = FND_API.G_VALID_LEVEL_FULL
105 -- p_user_id IN NUMBER Required
106 -- OUT : p_return_status OUT VARCHAR2
107 -- p_msg_count OUT NUMBER
108 -- p_msg_data OUT VARCHAR2
109 -- .
110 -- Version : Current version 1.0
111 -- Initial version 1.0
112 --
113 -- Notes : Note text
114 --
115 -- End Of Comments
116
117 PROCEDURE Create_Profile
118 ( p_api_version_number IN NUMBER,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
121 p_commit IN VARCHAR2 := FND_API.G_FALSE,
122 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123 p_return_status OUT nocopy VARCHAR2,
124 p_msg_count OUT nocopy NUMBER,
125 p_msg_data OUT nocopy VARCHAR2,
126 p_user_id IN NUMBER,
127 p_days_needed_by IN NUMBER := NULL,
128 p_req_default_template IN VARCHAR2 := NULL,
129 p_req_override_loc_flag IN VARCHAR2 := NULL,
130 p_req_override_req_code IN VARCHAR2 := NULL,
131 p_created_by IN NUMBER,
132 p_creation_date IN DATE,
133 p_last_updated_by IN NUMBER,
134 p_last_update_date IN DATE,
135 p_last_update_login IN NUMBER
136 );
137
138
139 PROCEDURE Update_Profile
140 ( p_api_version_number IN NUMBER,
141 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
143 p_commit IN VARCHAR2 := FND_API.G_FALSE,
144 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145 p_return_status OUT nocopy VARCHAR2,
146 p_msg_count OUT nocopy NUMBER,
147 p_msg_data OUT nocopy VARCHAR2,
148 p_user_id IN NUMBER,
149 p_days_needed_by IN NUMBER := FND_API.G_MISS_NUM,
150 p_req_default_template IN VARCHAR2 := FND_API.G_MISS_CHAR,
151 p_req_override_loc_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
152 p_req_override_req_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
153 p_last_updated_by IN NUMBER,
154 p_last_update_date IN DATE,
155 p_last_update_login IN NUMBER
156 );
157
158
159 PROCEDURE Delete_Profile
160 ( p_api_version_number IN NUMBER,
161 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
163 p_commit IN VARCHAR2 := FND_API.G_FALSE,
164 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165 p_return_status OUT nocopy VARCHAR2,
166 p_msg_count OUT nocopy NUMBER,
167 p_msg_data OUT nocopy VARCHAR2,
168 p_user_id IN NUMBER
169 );
170
171
172 END ICX_User_Profile_PVT;