56:
57: --===================================================================
58: TYPE Lift_rec_type IS RECORD
59: (
60: LIFT_ID NUMBER := FND_API.G_MISS_NUM,
61: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
62: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
63: CREATION_DATE DATE := FND_API.G_MISS_DATE,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
57: --===================================================================
58: TYPE Lift_rec_type IS RECORD
59: (
60: LIFT_ID NUMBER := FND_API.G_MISS_NUM,
61: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
62: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
63: CREATION_DATE DATE := FND_API.G_MISS_DATE,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
58: TYPE Lift_rec_type IS RECORD
59: (
60: LIFT_ID NUMBER := FND_API.G_MISS_NUM,
61: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
62: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
63: CREATION_DATE DATE := FND_API.G_MISS_DATE,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
66: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
59: (
60: LIFT_ID NUMBER := FND_API.G_MISS_NUM,
61: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
62: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
63: CREATION_DATE DATE := FND_API.G_MISS_DATE,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
66: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
67: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
60: LIFT_ID NUMBER := FND_API.G_MISS_NUM,
61: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
62: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
63: CREATION_DATE DATE := FND_API.G_MISS_DATE,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
66: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
67: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
68: QUANTILE NUMBER := FND_API.G_MISS_NUM,
61: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
62: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
63: CREATION_DATE DATE := FND_API.G_MISS_DATE,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
66: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
67: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
68: QUANTILE NUMBER := FND_API.G_MISS_NUM,
69: LIFT NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
63: CREATION_DATE DATE := FND_API.G_MISS_DATE,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
66: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
67: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
68: QUANTILE NUMBER := FND_API.G_MISS_NUM,
69: LIFT NUMBER := FND_API.G_MISS_NUM,
70: TARGETS NUMBER := FND_API.G_MISS_NUM,
63: CREATION_DATE DATE := FND_API.G_MISS_DATE,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
66: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
67: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
68: QUANTILE NUMBER := FND_API.G_MISS_NUM,
69: LIFT NUMBER := FND_API.G_MISS_NUM,
70: TARGETS NUMBER := FND_API.G_MISS_NUM,
71: NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
66: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
67: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
68: QUANTILE NUMBER := FND_API.G_MISS_NUM,
69: LIFT NUMBER := FND_API.G_MISS_NUM,
70: TARGETS NUMBER := FND_API.G_MISS_NUM,
71: NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
72: TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
65: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
66: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
67: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
68: QUANTILE NUMBER := FND_API.G_MISS_NUM,
69: LIFT NUMBER := FND_API.G_MISS_NUM,
70: TARGETS NUMBER := FND_API.G_MISS_NUM,
71: NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
72: TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
73: TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
66: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
67: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
68: QUANTILE NUMBER := FND_API.G_MISS_NUM,
69: LIFT NUMBER := FND_API.G_MISS_NUM,
70: TARGETS NUMBER := FND_API.G_MISS_NUM,
71: NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
72: TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
73: TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
74: TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
67: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
68: QUANTILE NUMBER := FND_API.G_MISS_NUM,
69: LIFT NUMBER := FND_API.G_MISS_NUM,
70: TARGETS NUMBER := FND_API.G_MISS_NUM,
71: NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
72: TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
73: TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
74: TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
75: MARGIN NUMBER := FND_API.G_MISS_NUM,
68: QUANTILE NUMBER := FND_API.G_MISS_NUM,
69: LIFT NUMBER := FND_API.G_MISS_NUM,
70: TARGETS NUMBER := FND_API.G_MISS_NUM,
71: NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
72: TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
73: TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
74: TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
75: MARGIN NUMBER := FND_API.G_MISS_NUM,
76: ROI NUMBER := FND_API.G_MISS_NUM,
69: LIFT NUMBER := FND_API.G_MISS_NUM,
70: TARGETS NUMBER := FND_API.G_MISS_NUM,
71: NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
72: TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
73: TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
74: TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
75: MARGIN NUMBER := FND_API.G_MISS_NUM,
76: ROI NUMBER := FND_API.G_MISS_NUM,
77: TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM,
70: TARGETS NUMBER := FND_API.G_MISS_NUM,
71: NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
72: TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
73: TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
74: TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
75: MARGIN NUMBER := FND_API.G_MISS_NUM,
76: ROI NUMBER := FND_API.G_MISS_NUM,
77: TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM,
78: NON_TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM
71: NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
72: TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
73: TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
74: TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
75: MARGIN NUMBER := FND_API.G_MISS_NUM,
76: ROI NUMBER := FND_API.G_MISS_NUM,
77: TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM,
78: NON_TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM
79: );
72: TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
73: TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
74: TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
75: MARGIN NUMBER := FND_API.G_MISS_NUM,
76: ROI NUMBER := FND_API.G_MISS_NUM,
77: TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM,
78: NON_TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM
79: );
80:
73: TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
74: TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
75: MARGIN NUMBER := FND_API.G_MISS_NUM,
76: ROI NUMBER := FND_API.G_MISS_NUM,
77: TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM,
78: NON_TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM
79: );
80:
81: g_miss_Lift_rec Lift_rec_type;
74: TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
75: MARGIN NUMBER := FND_API.G_MISS_NUM,
76: ROI NUMBER := FND_API.G_MISS_NUM,
77: TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM,
78: NON_TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM
79: );
80:
81: g_miss_Lift_rec Lift_rec_type;
82: TYPE Lift_tbl_type IS TABLE OF Lift_rec_type INDEX BY BINARY_INTEGER;
100: -- Parameters
101: --
102: -- IN
103: -- p_api_version IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_lift_rec IN lift_rec_type Required
107: --
108: -- OUT
101: --
102: -- IN
103: -- p_api_version IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_lift_rec IN lift_rec_type Required
107: --
108: -- OUT
109: -- x_return_status OUT VARCHAR2
118: --
119:
120: PROCEDURE Lock_Dmlift(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: x_return_status OUT VARCHAR2,
124: x_msg_count OUT NUMBER,
125: x_msg_data OUT VARCHAR2,
126:
140: -- Parameters
141: --
142: -- IN
143: -- p_api_version IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_lift_rec IN lift_rec_type Required
147: --
148: -- OUT
141: --
142: -- IN
143: -- p_api_version IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_lift_rec IN lift_rec_type Required
147: --
148: -- OUT
149: -- x_return_status OUT VARCHAR2
158: --
159:
160: PROCEDURE Create_Lift(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164:
165: x_return_status OUT VARCHAR2,
166: x_msg_count OUT NUMBER,
159:
160: PROCEDURE Create_Lift(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164:
165: x_return_status OUT VARCHAR2,
166: x_msg_count OUT NUMBER,
167: x_msg_data OUT VARCHAR2,
182: -- Parameters
183: --
184: -- IN
185: -- p_api_version IN NUMBER Required
186: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
187: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
188: -- p_lift_rec IN lift_rec_type Required
189: --
190: -- OUT
183: --
184: -- IN
185: -- p_api_version IN NUMBER Required
186: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
187: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
188: -- p_lift_rec IN lift_rec_type Required
189: --
190: -- OUT
191: -- x_return_status OUT VARCHAR2
200: --
201:
202: PROCEDURE Update_Lift(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206:
207: x_return_status OUT VARCHAR2,
208: x_msg_count OUT NUMBER,
201:
202: PROCEDURE Update_Lift(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206:
207: x_return_status OUT VARCHAR2,
208: x_msg_count OUT NUMBER,
209: x_msg_data OUT VARCHAR2,
224: -- Parameters
225: --
226: -- IN
227: -- p_api_version IN NUMBER Required
228: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_LIFT_ID IN NUMBER
231: -- p_object_version_number IN NUMBER Optional Default = NULL
232: --
225: --
226: -- IN
227: -- p_api_version IN NUMBER Required
228: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_LIFT_ID IN NUMBER
231: -- p_object_version_number IN NUMBER Optional Default = NULL
232: --
233: -- OUT
243: --
244:
245: PROCEDURE Delete_Lift(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248: p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: x_return_status OUT VARCHAR2,
250: x_msg_count OUT NUMBER,
251: x_msg_data OUT VARCHAR2,
244:
245: PROCEDURE Delete_Lift(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248: p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: x_return_status OUT VARCHAR2,
250: x_msg_count OUT NUMBER,
251: x_msg_data OUT VARCHAR2,
252: p_lift_id IN NUMBER,