1 PACKAGE AMS_List_Src_Field_PUB AUTHID CURRENT_USER AS
2 /* $Header: amsplsfs.pls 115.5 2002/11/22 08:54:14 jieli ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_List_Src_Field_PUB
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 -- list_src_field_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- list_source_field_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- last_update_login
31 -- object_version_number
32 -- de_list_source_type_code
33 -- list_source_type_id
34 -- field_table_name
35 -- field_column_name
36 -- source_column_name
37 -- source_column_meaning
38 -- enabled_flag
39 -- start_position
40 -- end_position
41 -- security_group_id
42 --
43 -- Required
44 --
45 -- Defaults
46 --
47 -- Note: This is automatic generated record definition, it includes all columns
48 -- defined in the table, developer must manually add or delete some of the attributes.
49 --
50 -- End of Comments
51
52 --===================================================================
53 TYPE list_src_field_rec_type IS RECORD
54 (
55 list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56 last_update_date DATE := FND_API.G_MISS_DATE,
57 last_updated_by NUMBER := FND_API.G_MISS_NUM,
58 creation_date DATE := FND_API.G_MISS_DATE,
59 created_by NUMBER := FND_API.G_MISS_NUM,
60 last_update_login NUMBER := FND_API.G_MISS_NUM,
61 object_version_number NUMBER := FND_API.G_MISS_NUM,
62 de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64 field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65 field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66 source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67 source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68 enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69 start_position NUMBER := FND_API.G_MISS_NUM,
70 end_position NUMBER := FND_API.G_MISS_NUM,
71 security_group_id NUMBER := FND_API.G_MISS_NUM,
72 analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73 auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74 no_of_buckets NUMBER := FND_API.G_MISS_NUM
75
76 );
77
78 g_miss_list_src_field_rec list_src_field_rec_type;
79 TYPE list_src_field_tbl_type IS TABLE OF list_src_field_rec_type INDEX BY BINARY_INTEGER;
80 g_miss_list_src_field_tbl list_src_field_tbl_type;
81
82 TYPE list_src_field_sort_rec_type IS RECORD
83 (
84 -- Please define your own sort by record here.
85 last_update_date NUMBER := NULL
86 );
87
88 -- ==============================================================================
89 -- Start of Comments
90 -- ==============================================================================
91 -- API Name
92 -- Create_List_Src_Field
93 -- Type
94 -- Public
95 -- Pre-Req
96 --
97 -- Parameters
98 --
99 -- IN
100 -- p_api_version_number IN NUMBER Required
101 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
102 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
103 -- p_list_src_field_rec IN list_src_field_rec_type Required
104 --
105 -- OUT
106 -- x_return_status OUT VARCHAR2
107 -- x_msg_count OUT NUMBER
108 -- x_msg_data OUT VARCHAR2
109 -- Version : Current version 1.0
110 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
111 -- and basic operation, developer must manually add parameters and business logic as necessary.
112 --
113 -- End of Comments
114 -- ==============================================================================
115 --
116
117 PROCEDURE Create_List_Src_Field(
118 p_api_version_number IN NUMBER,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE,
121
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125
126 p_list_src_field_rec IN list_src_field_rec_type := g_miss_list_src_field_rec,
127 x_list_source_field_id OUT NOCOPY NUMBER
128 );
129
130 -- ==============================================================================
131 -- Start of Comments
132 -- ==============================================================================
133 -- API Name
134 -- Update_List_Src_Field
135 -- Type
136 -- Public
137 -- Pre-Req
138 --
139 -- Parameters
140 --
141 -- IN
142 -- p_api_version_number IN NUMBER Required
143 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145 -- p_list_src_field_rec IN list_src_field_rec_type Required
146 --
147 -- OUT
148 -- x_return_status OUT VARCHAR2
149 -- x_msg_count OUT NUMBER
150 -- x_msg_data OUT VARCHAR2
151 -- Version : Current version 1.0
152 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
153 -- and basic operation, developer must manually add parameters and business logic as necessary.
154 --
155 -- End of Comments
156 -- ==============================================================================
157 --
158
159 PROCEDURE Update_List_Src_Field(
160 p_api_version_number IN NUMBER,
161 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162 p_commit IN VARCHAR2 := FND_API.G_FALSE,
163
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167
168 p_list_src_field_rec IN list_src_field_rec_type,
169 x_object_version_number OUT NOCOPY NUMBER
170 );
171
172 -- ==============================================================================
173 -- Start of Comments
174 -- ==============================================================================
175 -- API Name
176 -- Delete_List_Src_Field
177 -- Type
178 -- Public
179 -- Pre-Req
180 --
181 -- Parameters
182 --
183 -- IN
184 -- p_api_version_number IN NUMBER Required
185 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187 -- p_LIST_SOURCE_FIELD_ID IN NUMBER
188 -- p_object_version_number IN NUMBER Optional Default = NULL
189 --
190 -- OUT
191 -- x_return_status OUT VARCHAR2
192 -- x_msg_count OUT NUMBER
193 -- x_msg_data OUT VARCHAR2
194 -- Version : Current version 1.0
195 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
196 -- and basic operation, developer must manually add parameters and business logic as necessary.
197 --
198 -- End of Comments
199 -- ==============================================================================
200 --
201
202 PROCEDURE Delete_List_Src_Field(
203 p_api_version_number IN NUMBER,
204 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205 p_commit IN VARCHAR2 := FND_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_list_source_field_id IN NUMBER,
210 p_object_version_number IN NUMBER
211 );
212
213 -- ==============================================================================
214 -- Start of Comments
215 -- ==============================================================================
216 -- API Name
217 -- Lock_List_Src_Field
218 -- Type
219 -- Public
220 -- Pre-Req
221 --
222 -- Parameters
223 --
224 -- IN
225 -- p_api_version_number IN NUMBER Required
226 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228 -- p_list_src_field_rec IN list_src_field_rec_type Required
229 --
230 -- OUT
231 -- x_return_status OUT VARCHAR2
232 -- x_msg_count OUT NUMBER
233 -- x_msg_data OUT VARCHAR2
234 -- Version : Current version 1.0
235 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
236 -- and basic operation, developer must manually add parameters and business logic as necessary.
237 --
238 -- End of Comments
239 -- ==============================================================================
240 --
241
242 PROCEDURE Lock_List_Src_Field(
243 p_api_version_number IN NUMBER,
244 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248
249 p_list_source_field_id IN NUMBER,
250 p_object_version IN NUMBER
251 );
252
253 END AMS_List_Src_Field_PUB;