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