[Home] [Help]
PACKAGE: APPS.AMS_SETUP_ATTR_PVT
Source
1 PACKAGE AMS_Setup_Attr_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvatts.pls 115.19 2002/12/30 05:29:13 vmodur ship $ */
3
4 TYPE setup_attr_rec_type IS RECORD
5 (
6 SETUP_ATTRIBUTE_ID NUMBER,
7 CUSTOM_SETUP_ID NUMBER,
8 LAST_UPDATE_DATE DATE,
9 LAST_UPDATED_BY NUMBER,
10 CREATION_DATE DATE,
11 CREATED_BY NUMBER,
12 LAST_UPDATE_LOGIN NUMBER,
13 OBJECT_VERSION_NUMBER NUMBER,
14 DISPLAY_SEQUENCE_NO NUMBER,
15 OBJECT_ATTRIBUTE VARCHAR2(30),
16 ATTR_MANDATORY_FLAG VARCHAR2(1),
17 ATTR_AVAILABLE_FLAG VARCHAR2(1),
18 FUNCTION_NAME VARCHAR2(30),
19 PARENT_FUNCTION_NAME VARCHAR2(30),
20 PARENT_SETUP_ATTRIBUTE VARCHAR2(30),
21 PARENT_DISPLAY_SEQUENCE NUMBER,
22 SHOW_IN_REPORT VARCHAR2(1),
23 SHOW_IN_CUE_CARD VARCHAR2(1),
24 COPY_ALLOWED_FLAG VARCHAR2(1),
25 RELATED_AK_ATTRIBUTE VARCHAR2(30),
26 ESSENTIAL_SEQ_NUM NUMBER
27 );
28
29
30 /****************************************************************************/
31 -- Procedure
32 -- create_setup_attr
33 -- Purpose
34 -- create rows in AMS_CUSTOM_SETUP_ATTR
35 -- Parameters
36 -- IN:
37 -- p_api_version IN NUMBER
38 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
39 -- p_commit IN VARCHAR2 := FND_API.g_false
40 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
41 --
42 -- p_setup_attr_rec IN setup_attr_rec_type
43 --
44 -- OUT:
45 -- x_return_status OUT VARCHAR2
46 -- x_msg_count OUT NUMBER
47 -- x_msg_data OUT VARCHAR2
48 --
49 -- x_setup_attr_id OUT NUMBER
50 ------------------------------------------------------------------------------
51 PROCEDURE create_setup_attr
52 (
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
55 p_commit IN VARCHAR2 := FND_API.g_false,
56 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
57
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61
62 p_setup_attr_rec IN setup_attr_rec_type,
63 x_setup_attr_id OUT NOCOPY NUMBER
64 );
65
66
67 /****************************************************************************/
68 -- Procedure
69 -- update_setup_attr
70 -- Purpose
71 -- update rows in AMS_CUSTOM_SETUP_ATTR
72 -- Parameters
73 -- IN:
74 -- p_api_version IN NUMBER
75 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
76 -- p_commit IN VARCHAR2 := FND_API.g_false
77 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
78 --
79 -- p_setup_attr_rec IN setup_attr_rec_type
80 --
81 -- OUT:
82 -- x_return_status OUT VARCHAR2
83 -- x_msg_count OUT NUMBER
84 -- x_msg_data OUT VARCHAR2
85 ------------------------------------------------------------------------------
86 PROCEDURE update_setup_attr
87 (
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
90 p_commit IN VARCHAR2 := FND_API.g_false,
91 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
92
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96
97 p_setup_attr_rec IN setup_attr_rec_type
98 );
99
100
101 /***************************************************************************/
102 -- Procedure
103 -- validate_setup_attr
104 -- Purpose
105 -- validate the record
106 -- Parameters
107 -- IN:
108 -- p_api_version IN NUMBER
109 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
110 -- p_validation_mode IN VARCHAR2
111 --
112 -- p_setup_attr_rec IN setup_attr_rec_type
113 --
114 -- OUT:
115 -- x_return_status OUT VARCHAR2
116 -- x_msg_count OUT NUMBER
117 -- x_msg_data OUT VARCHAR2
118 ------------------------------------------------------------------------------
119 PROCEDURE validate_setup_attr
120 (
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
124
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128
129 p_setup_attr_rec IN setup_attr_rec_type
130 );
131
132
133 /****************************************************************************/
134 -- Procedure
135 -- check_items
136 -- Purpose
137 -- item_level validate
138 -- Parameters
139 -- IN:
140 -- p_validation_mode IN VARCHAR2
141 -- p_setup_attr_rec IN setup_attr_rec_type
142 -- OUT:
143 -- x_return_status OUT VARCHAR2
144 ------------------------------------------------------------------------------
145 PROCEDURE check_items
146 (
147 p_validation_mode IN VARCHAR2,
148 x_return_status OUT NOCOPY VARCHAR2,
149 p_setup_attr_rec IN setup_attr_rec_type
150 );
151
152
153 /****************************************************************************/
154 -- Procedure
155 -- check_setup_attr_req_items
156 -- Purpose
157 -- check if required items are miss
158 -- Parameters
159 -- IN:
160 -- p_validation_mode IN VARCHAR2
161 -- p_setup_attr_rec IN setup_attr_rec_type
162 -- OUT:
163 -- x_return_status OUT VARCHAR2
164 ------------------------------------------------------------------------------
165 PROCEDURE check_setup_attr_req_items
166 (
167 p_validation_mode IN VARCHAR2,
168 p_setup_attr_rec IN setup_attr_rec_type,
169 x_return_status OUT NOCOPY VARCHAR2
170 );
171
172
173 /****************************************************************************/
174 -- Procedure
175 -- check_setup_attr_uk_items
176 -- Purpose
177 -- check unique keys
178 -- Parameters
179 -- IN:
180 -- p_setup_attr_rec IN setup_attr_rec_type
181 -- OUT:
182 -- x_return_status OUT VARCHAR2
183 ------------------------------------------------------------------------------
184 PROCEDURE check_setup_attr_uk_items
185 (
186 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
187 p_setup_attr_rec IN setup_attr_rec_type,
188 x_return_status OUT NOCOPY VARCHAR2
189 );
190
191
192 /****************************************************************************/
193 -- Procedure
194 -- check_setup_attr_fk_items
195 -- Purpose
196 -- check foreign key items
197 -- Parameters
198 -- IN:
199 -- p_setup_attr_rec IN setup_attr_rec_type
200 -- OUT:
201 -- x_return_status OUT VARCHAR2
202 ------------------------------------------------------------------------------
203 PROCEDURE check_setup_attr_fk_items
204 (
205 p_setup_attr_rec IN setup_attr_rec_type,
206 x_return_status OUT NOCOPY VARCHAR2
207 );
208
209
210 /****************************************************************************/
211 -- Procedure
212 -- check_setup_attr_flag_items
213 -- Purpose
214 -- check for flag items
215 -- Parameters
216 -- IN:
217 -- p_setup_attr_rec IN setup_attr_rec_type
218 -- OUT:
219 -- x_return_status OUT VARCHAR2
220 ------------------------------------------------------------------------------
221 PROCEDURE check_setup_attr_flag_items
222 (
223 p_setup_attr_rec IN setup_attr_rec_type,
224 x_return_status OUT NOCOPY VARCHAR2
225 );
226
227
228 /****************************************************************************/
229 -- Procedure
230 -- complete_setup_attr_rec
231 -- Purpose
232 -- replace "g_miss" or NULL values with current database values
233 -- Parameters
234 -- IN:
235 -- p_setup_attr_rec IN setup_attr_rec_type
236 -- OUT:
237 -- x_complete_rec OUT setup_attr_rec_type
238 ------------------------------------------------------------------------------
239 PROCEDURE complete_setup_attr_rec
240 (
241 p_setup_attr_rec IN setup_attr_rec_type,
242 x_complete_rec OUT NOCOPY setup_attr_rec_type
243 );
244
245 /****************************************************************************/
246 -- Procedure
247 -- init_rec
248 --
249 -- HISTORY
250 -- 12/19/1999 julou Created.
251 ------------------------------------------------------------------------------
252 PROCEDURE init_rec
253 (
254 x_setup_attr_rec OUT NOCOPY setup_attr_rec_type
255 );
256
257 END AMS_Setup_Attr_PVT;