1 PACKAGE AMS_Rule_Group_PUB AS
2 /* $Header: amsprgps.pls 120.0 2005/05/31 15:22:57 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Rule_Group_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 -- rule_group_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- row_id
26 -- rulegroup_id
27 -- posting_id
28 -- strategy_type
29 -- exec_priority
30 -- last_update_date
31 -- last_update_login
32 -- created_by
33 -- creation_date
34 -- last_updated_by
35 -- object_version_number
36 -- rule_name
37 -- rule_description
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 rule_group_rec_type IS RECORD
50 (
51 row_id ROWID := FND_API.G_MISS_CHAR,
52 rulegroup_id NUMBER := FND_API.G_MISS_NUM,
53 posting_id NUMBER := FND_API.G_MISS_NUM,
54 strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
55 exec_priority NUMBER := FND_API.G_MISS_NUM,
56 last_update_date DATE := FND_API.G_MISS_DATE,
57 last_update_login NUMBER := FND_API.G_MISS_NUM,
58 created_by NUMBER := FND_API.G_MISS_NUM,
59 creation_date DATE := FND_API.G_MISS_DATE,
60 last_updated_by NUMBER := FND_API.G_MISS_NUM,
61 object_version_number NUMBER := FND_API.G_MISS_NUM,
62 rule_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 rule_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
64 );
65
66 g_miss_rule_group_rec rule_group_rec_type;
67 TYPE rule_group_tbl_type IS TABLE OF rule_group_rec_type INDEX BY BINARY_INTEGER;
68 g_miss_rule_group_tbl rule_group_tbl_type;
69
70 TYPE rule_group_sort_rec_type IS RECORD
71 (
72 -- Please define your own sort by record here.
73 rulegroup_id NUMBER := NULL
74 );
75
76 -- ==============================================================================
77 -- Start of Comments
78 -- ==============================================================================
79 -- API Name
80 -- Create_Rule_Group
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_rule_group_rec IN rule_group_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_Rule_Group(
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_rule_group_rec IN rule_group_rec_type := g_miss_rule_group_rec,
115 x_rulegroup_id OUT NOCOPY NUMBER
116 );
117
118 -- ==============================================================================
119 -- Start of Comments
120 -- ==============================================================================
121 -- API Name
122 -- Update_Rule_Group
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_rule_group_rec IN rule_group_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_Rule_Group(
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_rule_group_rec IN rule_group_rec_type,
157 x_object_version_number OUT NOCOPY NUMBER
158 );
159
160 -- ==============================================================================
161 -- Start of Comments
162 -- ==============================================================================
163 -- API Name
164 -- Delete_Rule_Group
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_RULEGROUP_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_Rule_Group(
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_rulegroup_id IN NUMBER,
198 p_object_version_number IN NUMBER
199 );
200
201 -- ==============================================================================
202 -- Start of Comments
203 -- ==============================================================================
204 -- API Name
205 -- Lock_Rule_Group
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_rule_group_rec IN rule_group_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_Rule_Group(
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_rulegroup_id IN NUMBER,
238 p_object_version IN NUMBER
239 );
240
241 END AMS_Rule_Group_PUB;