DBA Data[Home] [Help]

APPS.AMS_DMLIFT_PUB dependencies on FND_API

Line 60: LIFT_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 61: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 62: LAST_UPDATED_BY 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,

Line 63: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 64: CREATED_BY 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,

Line 65: LAST_UPDATE_LOGIN 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,

Line 66: OBJECT_VERSION_NUMBER 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,

Line 67: MODEL_ID 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,

Line 68: QUANTILE 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,

Line 69: LIFT 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,

Line 70: TARGETS 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,

Line 71: NON_TARGETS 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,

Line 72: TARGETS_CUMM 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,

Line 73: TARGET_DENSITY_CUMM 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,

Line 74: TARGET_DENSITY 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

Line 75: MARGIN 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: );

Line 76: ROI 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: );
80:

Line 77: TARGET_CONFIDENCE 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:
81: g_miss_Lift_rec Lift_rec_type;

Line 78: NON_TARGET_CONFIDENCE 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;
82: TYPE Lift_tbl_type IS TABLE OF Lift_rec_type INDEX BY BINARY_INTEGER;

Line 104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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:

Line 144: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 163: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 186: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 187: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 205: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 228: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 229: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 248: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,