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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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;
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;
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: --
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
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
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,
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: --
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
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
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,
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,
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,
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: --
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
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
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,
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,
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,
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
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: --
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
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,
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,
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,
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
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,
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,