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