1 PACKAGE AMS_DMLift_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvdlfs.pls 115.7 2002/12/09 11:52:15 choang ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_DMLift_PVT
7 -- Purpose
8 --
9 -- History
10 -- 12-Feb-2001 choang Added p_validation_mode to validate_lift.
11 -- 07-Jan-2002 choang Removed security group id
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17
18 -- Default number of records fetch per call
19 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
20 --===================================================================
21 -- Start of Comments
22 -- -------------------------------------------------------
23 -- Record name
24 -- Lift_rec_type
25 -- -------------------------------------------------------
26 -- Parameters:
27 -- LIFT_ID
28 -- LAST_UPDATE_DATE
29 -- LAST_UPDATED_BY
30 -- CREATION_DATE
31 -- CREATED_BY
32 -- LAST_UPDATE_LOGIN
33 -- OBJECT_VERSION_NUMBER
34 -- MODEL_ID
35 -- QUANTILE
36 -- LIFT
37 -- TARGETS
38 -- NON_TARGETS
39 -- TARGETS_CUMM
40 -- TARGET_DENSITY_CUMM
41 -- TARGET_DENSITY
42 -- MARGIN
43 -- ROI
44 -- TARGET_CONFIDENCE
45 -- NON_TARGET_CONFIDENCE
46 --
47 -- Required
48 --
49 -- Defaults
50 --
51 -- Note: This is automatic generated record definition, it includes all columns
52 -- defined in the table, developer must manually add or delete some of the attributes.
53 --
54 -- End of Comments
55
56 --===================================================================
57 TYPE Lift_rec_type IS RECORD
58 (
59 LIFT_ID NUMBER := FND_API.G_MISS_NUM,
60 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62 CREATION_DATE DATE := FND_API.G_MISS_DATE,
63 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
65 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
66 MODEL_ID NUMBER := FND_API.G_MISS_NUM,
67 QUANTILE NUMBER := FND_API.G_MISS_NUM,
68 LIFT NUMBER := FND_API.G_MISS_NUM,
69 TARGETS NUMBER := FND_API.G_MISS_NUM,
70 NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
71 TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
72 TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
73 TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
74 MARGIN NUMBER := FND_API.G_MISS_NUM,
75 ROI NUMBER := FND_API.G_MISS_NUM,
76 TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM,
77 NON_TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM
78 );
79
80 g_miss_Lift_rec Lift_rec_type;
81 TYPE Lift_tbl_type IS TABLE OF Lift_rec_type INDEX BY BINARY_INTEGER;
82 g_miss_Lift_tbl Lift_tbl_type;
83
84
85 -- Start of Comments
86 --
87 -- validation procedures
88 --
89 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
90 -- For create: G_CREATE, for update: G_UPDATE
91 -- Note: 1. This is automated generated item level validation procedure.
92 -- The actual validation detail is needed to be added.
93 -- 2. Validate the unique keys, lookups here
94 -- End of Comments
95
96 PROCEDURE Check_Lift_Items (
97 P_Lift_rec IN Lift_rec_type,
98 p_validation_mode IN VARCHAR2,
99 x_return_status OUT NOCOPY VARCHAR2
100 );
101 -- ==============================================================================
102 -- Start of Comments
103 -- ==============================================================================
104 -- API Name
105 -- Lock_Dmlift
106 -- Type
107 -- Private
108 -- Pre-Req
109 --
110 -- Parameters
111 --
112 -- IN
113 -- p_api_version IN NUMBER Required
114 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
115 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
116 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
117 -- p_lift_rec IN lift_rec_type Required
118 --
119 -- OUT
120 -- x_return_status OUT VARCHAR2
121 -- x_msg_count OUT NUMBER
122 -- x_msg_data OUT VARCHAR2
123 -- Version : Current version 1.0
124 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
125 -- and basic operation, developer must manually add parameters and business logic as necessary.
126 --
127 -- End of Comments
128 -- ==============================================================================
129 --
130
131 PROCEDURE Lock_Dmlift(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138
139 p_lift_id IN NUMBER,
140 p_object_version IN NUMBER
141 );
142
143 -- ==============================================================================
144 -- Start of Comments
145 -- ==============================================================================
146 -- API Name
147 -- Create_Lift
148 -- Type
149 -- Private
150 -- Pre-Req
151 --
152 -- Parameters
153 --
154 -- IN
155 -- p_api_version IN NUMBER Required
156 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
157 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
158 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
159 -- p_lift_rec IN lift_rec_type Required
160 --
161 -- OUT
162 -- x_return_status OUT VARCHAR2
163 -- x_msg_count OUT NUMBER
164 -- x_msg_data OUT VARCHAR2
165 -- Version : Current version 1.0
166 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
167 -- and basic operation, developer must manually add parameters and business logic as necessary.
168 --
169 -- End of Comments
170 -- ==============================================================================
171 --
172
173 PROCEDURE Create_Lift(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
176 p_commit IN VARCHAR2 := FND_API.G_FALSE,
177 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182
183 p_lift_rec IN Lift_rec_type := g_miss_Lift_rec,
184 x_lift_id OUT NOCOPY NUMBER
185 );
186
187 -- ==============================================================================
188 -- Start of Comments
189 -- ==============================================================================
190 -- API Name
191 -- Update_Lift
192 -- Type
193 -- Private
194 -- Pre-Req
195 --
196 -- Parameters
197 --
198 -- IN
199 -- p_api_version IN NUMBER Required
200 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203 -- p_lift_rec IN lift_rec_type Required
204 --
205 -- OUT
206 -- x_return_status OUT VARCHAR2
207 -- x_msg_count OUT NUMBER
208 -- x_msg_data OUT VARCHAR2
209 -- Version : Current version 1.0
210 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
211 -- and basic operation, developer must manually add parameters and business logic as necessary.
212 --
213 -- End of Comments
214 -- ==============================================================================
215 --
216
217 PROCEDURE Update_Lift(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220 p_commit IN VARCHAR2 := FND_API.G_FALSE,
221 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226
227 p_lift_rec IN lift_rec_type,
228 x_object_version_number OUT NOCOPY NUMBER
229 );
230
231 -- ==============================================================================
232 -- Start of Comments
233 -- ==============================================================================
234 -- API Name
235 -- Delete_Lift
236 -- Type
237 -- Private
238 -- Pre-Req
239 --
240 -- Parameters
241 --
242 -- IN
243 -- p_api_version IN NUMBER Required
244 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247 -- p_LIFT_ID IN NUMBER
248 -- p_object_version_number IN NUMBER Optional Default = NULL
249 --
250 -- OUT
251 -- x_return_status OUT VARCHAR2
252 -- x_msg_count OUT NUMBER
253 -- x_msg_data OUT VARCHAR2
254 -- Version : Current version 1.0
255 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
256 -- and basic operation, developer must manually add parameters and business logic as necessary.
257 --
258 -- End of Comments
259 -- ==============================================================================
260 --
261
262 PROCEDURE Delete_Lift(
263 p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
265 p_commit IN VARCHAR2 := FND_API.G_FALSE,
266 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2,
270 p_lift_id IN NUMBER,
271 p_object_version_number IN NUMBER
272 );
273
274
275 -- Start of Comments
276 --
277 -- Record level validation procedures
278 --
279 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
280 -- For create: G_CREATE, for update: G_UPDATE
281 -- Note: 1. This is automated generated item level validation procedure.
282 -- The actual validation detail is needed to be added.
283 -- 2. Developer can manually added inter-field level validation.
284 -- End of Comments
285
286 PROCEDURE Validate_Lift_rec(
287 p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2,
292 p_lift_rec IN lift_rec_type
293 );
294
295 -- Start of Comments
296 --
297 -- validation procedures
298 --
299 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
300 -- For create: G_CREATE, for update: G_UPDATE
301 -- Note: 1. This is automated generated item level validation procedure.
302 -- The actual validation detail is needed to be added.
303 -- 2. We can also validate table instead of record. There will be an option for user to choose.
304 -- End of Comments
305
306 PROCEDURE Validate_Lift(
307 p_api_version IN NUMBER,
308 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
310 p_validation_mode IN VARCHAR2,
311 p_lift_rec IN Lift_rec_type,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2
315 );
316 END AMS_DMLift_PVT;