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