47:
48: --===================================================================
49: TYPE performance_rec_type IS RECORD
50: (
51: performance_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
48: --===================================================================
49: TYPE performance_rec_type IS RECORD
50: (
51: performance_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
49: TYPE performance_rec_type IS RECORD
50: (
51: performance_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
50: (
51: performance_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: predicted_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: performance_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: predicted_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
59: actual_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: predicted_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
59: actual_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
60: evaluated_records NUMBER := FND_API.G_MISS_NUM,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: predicted_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
59: actual_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
60: evaluated_records NUMBER := FND_API.G_MISS_NUM,
61: total_records_predicted NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: predicted_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
59: actual_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
60: evaluated_records NUMBER := FND_API.G_MISS_NUM,
61: total_records_predicted NUMBER := FND_API.G_MISS_NUM,
62: model_id NUMBER := FND_API.G_MISS_NUM
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: predicted_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
59: actual_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
60: evaluated_records NUMBER := FND_API.G_MISS_NUM,
61: total_records_predicted NUMBER := FND_API.G_MISS_NUM,
62: model_id NUMBER := FND_API.G_MISS_NUM
63: );
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: predicted_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
59: actual_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
60: evaluated_records NUMBER := FND_API.G_MISS_NUM,
61: total_records_predicted NUMBER := FND_API.G_MISS_NUM,
62: model_id NUMBER := FND_API.G_MISS_NUM
63: );
64:
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: predicted_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
59: actual_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
60: evaluated_records NUMBER := FND_API.G_MISS_NUM,
61: total_records_predicted NUMBER := FND_API.G_MISS_NUM,
62: model_id NUMBER := FND_API.G_MISS_NUM
63: );
64:
65: g_miss_performance_rec performance_rec_type;
58: predicted_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
59: actual_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
60: evaluated_records NUMBER := FND_API.G_MISS_NUM,
61: total_records_predicted NUMBER := FND_API.G_MISS_NUM,
62: model_id NUMBER := FND_API.G_MISS_NUM
63: );
64:
65: g_miss_performance_rec performance_rec_type;
66: TYPE performance_tbl_type IS TABLE OF performance_rec_type INDEX BY BINARY_INTEGER;
78: -- Parameters
79: --
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_performance_rec IN performance_rec_type Required
86: --
79: --
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_performance_rec IN performance_rec_type Required
86: --
87: -- OUT
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_performance_rec IN performance_rec_type Required
86: --
87: -- OUT
88: -- x_return_status OUT VARCHAR2
97: --
98:
99: PROCEDURE Create_Performance(
100: p_api_version_number IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104:
105: x_return_status OUT NOCOPY VARCHAR2,
98:
99: PROCEDURE Create_Performance(
100: p_api_version_number IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104:
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
99: PROCEDURE Create_Performance(
100: p_api_version_number IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104:
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
122: -- Parameters
123: --
124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129: -- p_performance_rec IN performance_rec_type Required
130: --
123: --
124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129: -- p_performance_rec IN performance_rec_type Required
130: --
131: -- OUT
124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129: -- p_performance_rec IN performance_rec_type Required
130: --
131: -- OUT
132: -- x_return_status OUT VARCHAR2
141: --
142:
143: PROCEDURE Update_Performance(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,
142:
143: PROCEDURE Update_Performance(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
143: PROCEDURE Update_Performance(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
166: -- Parameters
167: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_PERFORMANCE_ID IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL
167: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_PERFORMANCE_ID IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL
175: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_PERFORMANCE_ID IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL
175: --
176: -- OUT
186: --
187:
188: PROCEDURE Delete_Performance(
189: p_api_version_number IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
187:
188: PROCEDURE Delete_Performance(
189: p_api_version_number IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
188: PROCEDURE Delete_Performance(
189: p_api_version_number IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_performance_id IN NUMBER,
209: -- Parameters
210: --
211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_performance_rec IN performance_rec_type Required
217: --
210: --
211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_performance_rec IN performance_rec_type Required
217: --
218: -- OUT
211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_performance_rec IN performance_rec_type Required
217: --
218: -- OUT
219: -- x_return_status OUT VARCHAR2
228: --
229:
230: PROCEDURE Lock_Performance(
231: p_api_version_number IN NUMBER,
232: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
233:
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
252: -- End of Comments
253:
254: PROCEDURE Validate_Performance(
255: p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_validation_mode IN VARCHAR2,
259: p_performance_rec IN performance_rec_type,
260: x_return_status OUT NOCOPY VARCHAR2,
253:
254: PROCEDURE Validate_Performance(
255: p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_validation_mode IN VARCHAR2,
259: p_performance_rec IN performance_rec_type,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
291: -- End of Comments
292:
293: PROCEDURE Validate_performance_rec(
294: p_api_version_number IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_performance_rec IN performance_rec_type