1 PACKAGE PV_Attr_Principal_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvatps.pls 120.0 2007/12/20 07:12:09 abnagapp noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Attr_Principal_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 --G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- Attr_Principal_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- Attribute_Principal_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- last_update_login
31 -- object_version_number
32 -- attribute_id
33 -- jtf_auth_principal_id
34 --
35 -- Required
36 --
37 -- Defaults
38 --
39 --
40 -- End of Comments
41
42 --===================================================================
43
44 TYPE Attr_Principal_rec_type IS RECORD
45 (
46 Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47 ,last_update_date DATE := FND_API.G_MISS_DATE
48 ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49 ,creation_date DATE := FND_API.G_MISS_DATE
50 ,created_by NUMBER := FND_API.G_MISS_NUM
51 ,last_update_login NUMBER := FND_API.G_MISS_NUM
52 ,object_version_number NUMBER := FND_API.G_MISS_NUM
53 ,attribute_id NUMBER := FND_API.G_MISS_NUM
54 ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM
55 );
56
57
58 g_miss_Attr_Principal_rec Attr_Principal_rec_type;
59 TYPE Attr_Principal_tbl_type IS TABLE OF Attr_Principal_rec_type INDEX BY BINARY_INTEGER;
60 g_miss_Attr_Principal_tbl Attr_Principal_tbl_type;
61
62 -- ==============================================================================
63 -- Start of Comments
64 -- ==============================================================================
65 -- API Name
66 -- Create_Attribute_Principal
67 -- Type
68 -- Private
69 -- Pre-Req
70 --
71 -- Parameters
72 --
73 -- IN
74 -- p_api_version_number IN NUMBER Required
75 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78 -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
79 --
80 -- OUT
81 -- x_return_status OUT VARCHAR2
82 -- x_msg_count OUT NUMBER
83 -- x_msg_data OUT VARCHAR2
84 -- Version : Current version 1.0
85 --
86 -- End of Comments
87 -- ==============================================================================
88 --
89
90 PROCEDURE Create_Attr_Principal(
91 p_api_version_number IN NUMBER
92 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
95
96 ,x_return_status OUT NOCOPY VARCHAR2
97 ,x_msg_count OUT NOCOPY NUMBER
98 ,x_msg_data OUT NOCOPY VARCHAR2
99
100 ,p_Attr_Principal_rec IN Attr_Principal_rec_type := g_miss_Attr_Principal_rec
101 ,x_Attr_Principal_id OUT NOCOPY NUMBER
102 );
103
104 -- ==============================================================================
105 -- Start of Comments
106 -- ==============================================================================
107 -- API Name
108 -- Update_Attribute_Principal
109 -- Type
110 -- Private
111 -- Pre-Req
112 --
113 -- Parameters
114 --
115 -- IN
116 -- p_api_version_number IN NUMBER Required
117 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
118 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
120 -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
121 --
122 -- OUT
123 -- x_return_status OUT VARCHAR2
124 -- x_msg_count OUT NUMBER
125 -- x_msg_data OUT VARCHAR2
126 -- Version : Current version 1.0
127 -- End of Comments
128 -- ==============================================================================
129 --
130
131 PROCEDURE Update_Attr_Principal(
132 p_api_version_number IN NUMBER
133 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
134 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
135 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
136
137 ,x_return_status OUT NOCOPY VARCHAR2
138 ,x_msg_count OUT NOCOPY NUMBER
139 ,x_msg_data OUT NOCOPY VARCHAR2
140
141 ,p_Attr_Principal_rec IN Attr_Principal_rec_type
142 ,x_object_version_number OUT NOCOPY NUMBER
143 );
144
145 -- ==============================================================================
146 -- Start of Comments
147 -- ==============================================================================
148 -- API Name
149 -- Delete_Attribute_Principal
150 -- Type
151 -- Private
152 -- Pre-Req
153 --
154 -- Parameters
155 --
156 -- IN
157 -- p_api_version_number IN NUMBER Required
158 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161 -- p_Attribute_Principal_ID IN NUMBER
162 -- p_object_version_number IN NUMBER Optional Default = NULL
163 --
164 -- OUT
165 -- x_return_status OUT VARCHAR2
166 -- x_msg_count OUT NUMBER
167 -- x_msg_data OUT VARCHAR2
168 -- Version : Current version 1.0
169 -- End of Comments
170 -- ==============================================================================
171 --
172
173 PROCEDURE Delete_Attr_Principal(
174 p_api_version_number IN NUMBER
175 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
176 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
177 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178
179 ,x_return_status OUT NOCOPY VARCHAR2
180 ,x_msg_count OUT NOCOPY NUMBER
181 ,x_msg_data OUT NOCOPY VARCHAR2
182
183 ,p_Attr_Principal_id IN NUMBER
184 ,p_object_version_number IN NUMBER
185 );
186
187 -- ==============================================================================
188 -- Start of Comments
189 -- ==============================================================================
190 -- API Name
191 -- Lock_Attribute_Principal
192 -- Type
193 -- Private
194 -- Pre-Req
195 --
196 -- Parameters
197 --
198 -- IN
199 -- p_api_version_number IN NUMBER Required
200 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203 -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
204 --
205 -- OUT
206 -- x_return_status OUT VARCHAR2
207 -- x_msg_count OUT NUMBER
208 -- x_msg_data OUT VARCHAR2
209 -- Version : Current version 1.0
210 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
211 -- and basic operation, developer must manually add parameters and business logic as necessary.
212 --
213 -- End of Comments
214 -- ==============================================================================
215 --
216
217 PROCEDURE Lock_Attr_Principal(
218 p_api_version_number IN NUMBER
219 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
220
221 ,x_return_status OUT NOCOPY VARCHAR2
222 ,x_msg_count OUT NOCOPY NUMBER
223 ,x_msg_data OUT NOCOPY VARCHAR2
224
225 ,p_Attr_Principal_id IN NUMBER
226 ,p_object_version IN NUMBER
227 );
228
229
230 -- Start of Comments
231 --
232 -- validation procedures
233 --
234 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
235 -- For create: G_CREATE, for update: G_UPDATE
236 -- End of Comments
237
238 PROCEDURE Validate_Attr_Principal(
239 p_api_version_number IN NUMBER
240 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
241 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
242 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
243 ,p_Attr_Principal_rec IN Attr_Principal_rec_type
244 ,x_return_status OUT NOCOPY VARCHAR2
245 ,x_msg_count OUT NOCOPY NUMBER
246 ,x_msg_data OUT NOCOPY VARCHAR2
247 );
248
249
250
251
252 -- Start of Comments
253 --
254 -- Record level validation procedures
255 --
256 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
257 -- For create: G_CREATE, for update: G_UPDATE
258 -- End of Comments
259
260 PROCEDURE Validate_Attr_Principal_Rec(
261 p_api_version_number IN NUMBER
262 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
263 ,x_return_status OUT NOCOPY VARCHAR2
264 ,x_msg_count OUT NOCOPY NUMBER
265 ,x_msg_data OUT NOCOPY VARCHAR2
266 ,p_Attr_Principal_rec IN Attr_Principal_rec_type
267 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
268 );
269
270 PROCEDURE Check_Attr_Principal_Items (
271 p_Attr_Principal_rec IN Attr_Principal_rec_type
272 ,p_validation_mode IN VARCHAR2
273 ,x_return_status OUT NOCOPY VARCHAR2
274 );
275
276 END PV_Attr_Principal_PVT;