[Home] [Help]
PACKAGE: APPS.AMS_PS_RULE_PUB
Source
1 PACKAGE AMS_Ps_Rule_PUB AS
2 /* $Header: amspruls.pls 120.0 2005/05/31 22:34:19 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Ps_Rule_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 --===================================================================
20 -- Start of Comments
21 -- -------------------------------------------------------
22 -- Record name
23 -- ps_rules_tuple_rec_type
24 -- -------------------------------------------------------
25 -- Parameters:
26 -- name
27 -- value
28 --
29 -- End of Comments
30 /*
31 TYPE ps_rules_tuple_rec_type IS RECORD
32 (
33 name VARCHAR2(30) := FND_API.G_MISS_CHAR,
34 value VARCHAR2(30) := FND_API.G_MISS_CHAR
35 );
36
37 g_miss_ps_rules_tuple_rec ps_rules_tuple_rec_type;
38 TYPE ps_rules_tuple_tbl_type IS TABLE OF ps_rules_tuple_rec_type INDEX BY BINARY_INTEGER;
39 g_miss_ps_rules_tuple_tbl ps_rules_tuple_tbl_type;
40 */
41
42 --===================================================================
43 -- Start of Comments
44 -- -------------------------------------------------------
45 -- Record name
46 -- ps_rules_rec_type
47 -- -------------------------------------------------------
48 -- Parameters:
49 -- created_by
50 -- creation_date
51 -- last_updated_by
52 -- last_update_date
53 -- last_update_login
54 -- security_group_id
55 -- object_version_number
56 -- rule_id
57 -- rulegroup_id
58 -- posting_id
59 -- strategy_id
60 -- bus_priority_code
61 -- bus_priority_disp_order
62 -- clausevalue1
63 -- clausevalue2
64 -- clausevalue3
65 -- clausevalue4
66 -- clausevalue5
67 -- clausevalue6
68 -- clausevalue7
69 -- clausevalue8
70 -- clausevalue9
71 -- clausevalue10
72 --
73 -- Required
74 --
75 -- Defaults
76 --
77 -- Note: This is automatic generated record definition, it includes all columns
78 -- defined in the table, developer must manually add or delete some of the attributes.
79 --
80 -- End of Comments
81
82 --===================================================================
83 /*
84 TYPE ps_rules_rec_type IS RECORD
85 (
86 created_by NUMBER := FND_API.G_MISS_NUM,
87 creation_date DATE := FND_API.G_MISS_DATE,
88 last_updated_by NUMBER := FND_API.G_MISS_NUM,
89 last_update_date DATE := FND_API.G_MISS_DATE,
90 last_update_login NUMBER := FND_API.G_MISS_NUM,
91 security_group_id NUMBER := FND_API.G_MISS_NUM,
92 object_version_number NUMBER := FND_API.G_MISS_NUM,
93 rule_id NUMBER := FND_API.G_MISS_NUM,
94 rulegroup_id NUMBER := FND_API.G_MISS_NUM,
95 posting_id NUMBER := FND_API.G_MISS_NUM,
96 strategy_id NUMBER := FND_API.G_MISS_NUM,
97 bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98 bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
99 clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
100 clausevalue2 NUMBER := FND_API.G_MISS_NUM,
101 clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
102 clausevalue4 NUMBER := FND_API.G_MISS_NUM,
103 clausevalue5 VARCHAR2(15) := FND_API.G_MISS_CHAR,
104 clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
105 clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106 clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107 clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
108 clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR
109 );
110
111 g_miss_ps_rules_rec ps_rules_rec_type;
112 TYPE ps_rules_tbl_type IS TABLE OF ps_rules_rec_type INDEX BY BINARY_INTEGER;
113 g_miss_ps_rules_tbl ps_rules_tbl_type;
114
115 TYPE ps_rules_sort_rec_type IS RECORD
116 (
117 -- Please define your own sort by record here.
118 creation_date NUMBER := NULL
119 );
120
121 */
122 -- ==============================================================================
123 -- Start of Comments
124 -- ==============================================================================
125 -- API Name
126 -- Create_Ps_Rule
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_rules_rec IN ps_rules_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 Create_Ps_Rule(
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_rules_rec IN ps_rules_rec_type := g_miss_ps_rules_rec,
161 x_rule_id OUT NOCOPY NUMBER
162 );
163 */
164 -- ==============================================================================
165 -- Start of Comments
166 -- ==============================================================================
167 -- API Name
168 -- Update_Ps_Rule
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_ps_rules_rec IN ps_rules_rec_type Required
180 --
181 -- OUT
182 -- x_return_status OUT VARCHAR2
183 -- x_msg_count OUT NUMBER
184 -- x_msg_data OUT VARCHAR2
185 -- Version : Current version 1.0
186 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
187 -- and basic operation, developer must manually add parameters and business logic as necessary.
188 --
189 -- End of Comments
190 -- ==============================================================================
191 --
192 /*
193 PROCEDURE Update_Ps_Rule(
194 p_api_version_number IN NUMBER,
195 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196 p_commit IN VARCHAR2 := FND_API.G_FALSE,
197
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201
202 p_ps_rules_rec IN ps_rules_rec_type,
203 p_ps_filter_tbl IN ps_rules_tuple_tbl_type,
204 p_ps_strategy_tbl IN ps_rules_tuple_tbl_type,
205 x_object_version_number OUT NOCOPY NUMBER
206 );
207 */
208 -- ==============================================================================
209 -- Start of Comments
210 -- ==============================================================================
211 -- API Name
212 -- Delete_Ps_Rule
213 -- Type
214 -- Public
215 -- Pre-Req
216 --
217 -- Parameters
218 --
219 -- IN
220 -- p_api_version_number IN NUMBER Required
221 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
222 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
223 -- p_RULE_ID IN NUMBER
224 -- p_object_version_number IN NUMBER Optional Default = NULL
225 --
226 -- OUT
227 -- x_return_status OUT VARCHAR2
228 -- x_msg_count OUT NUMBER
229 -- x_msg_data OUT VARCHAR2
230 -- Version : Current version 1.0
231 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
232 -- and basic operation, developer must manually add parameters and business logic as necessary.
233 --
234 -- End of Comments
235 -- ==============================================================================
236 --
237 /*
238
239 PROCEDURE Delete_Ps_Rule(
240 p_api_version_number IN NUMBER,
241 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
242 p_commit IN VARCHAR2 := FND_API.G_FALSE,
243 x_return_status OUT NOCOPY VARCHAR2,
244 x_msg_count OUT NOCOPY NUMBER,
245 x_msg_data OUT NOCOPY VARCHAR2,
246 p_rule_id IN NUMBER,
247 p_object_version_number IN NUMBER
248 );
249 */
250 -- ==============================================================================
251 -- Start of Comments
252 -- ==============================================================================
253 -- API Name
254 -- Lock_Ps_Rule
255 -- Type
256 -- Public
257 -- Pre-Req
258 --
259 -- Parameters
260 --
261 -- IN
262 -- p_api_version_number IN NUMBER Required
263 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
264 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
265 -- p_ps_rules_rec IN ps_rules_rec_type Required
266 --
267 -- OUT
268 -- x_return_status OUT VARCHAR2
269 -- x_msg_count OUT NUMBER
270 -- x_msg_data OUT VARCHAR2
271 -- Version : Current version 1.0
272 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
273 -- and basic operation, developer must manually add parameters and business logic as necessary.
274 --
275 -- End of Comments
276 -- ==============================================================================
277 --
278 /*
279 PROCEDURE Lock_Ps_Rule(
280 p_api_version_number IN NUMBER,
281 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282 x_return_status OUT NOCOPY VARCHAR2,
283 x_msg_count OUT NOCOPY NUMBER,
284 x_msg_data OUT NOCOPY VARCHAR2,
285
286 p_rule_id IN NUMBER,
287 p_object_version IN NUMBER
288 );
289
290 */
291 END AMS_Ps_Rule_PUB;
292