53:
54: --===================================================================
55: TYPE scoreresult_rec_type IS RECORD
56: (
57: score_result_id NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_updated_by NUMBER := FND_API.G_MISS_NUM,
60: creation_date DATE := FND_API.G_MISS_DATE,
61: created_by NUMBER := FND_API.G_MISS_NUM,
54: --===================================================================
55: TYPE scoreresult_rec_type IS RECORD
56: (
57: score_result_id NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_updated_by NUMBER := FND_API.G_MISS_NUM,
60: creation_date DATE := FND_API.G_MISS_DATE,
61: created_by NUMBER := FND_API.G_MISS_NUM,
62: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: TYPE scoreresult_rec_type IS RECORD
56: (
57: score_result_id NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_updated_by NUMBER := FND_API.G_MISS_NUM,
60: creation_date DATE := FND_API.G_MISS_DATE,
61: created_by NUMBER := FND_API.G_MISS_NUM,
62: last_update_login NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: (
57: score_result_id NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_updated_by NUMBER := FND_API.G_MISS_NUM,
60: creation_date DATE := FND_API.G_MISS_DATE,
61: created_by NUMBER := FND_API.G_MISS_NUM,
62: last_update_login NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: score_id NUMBER := FND_API.G_MISS_NUM,
57: score_result_id NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_updated_by NUMBER := FND_API.G_MISS_NUM,
60: creation_date DATE := FND_API.G_MISS_DATE,
61: created_by NUMBER := FND_API.G_MISS_NUM,
62: last_update_login NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: score_id NUMBER := FND_API.G_MISS_NUM,
65: decile VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_updated_by NUMBER := FND_API.G_MISS_NUM,
60: creation_date DATE := FND_API.G_MISS_DATE,
61: created_by NUMBER := FND_API.G_MISS_NUM,
62: last_update_login NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: score_id NUMBER := FND_API.G_MISS_NUM,
65: decile VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: num_records NUMBER := FND_API.G_MISS_NUM,
59: last_updated_by NUMBER := FND_API.G_MISS_NUM,
60: creation_date DATE := FND_API.G_MISS_DATE,
61: created_by NUMBER := FND_API.G_MISS_NUM,
62: last_update_login NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: score_id NUMBER := FND_API.G_MISS_NUM,
65: decile VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: num_records NUMBER := FND_API.G_MISS_NUM,
67: score VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: creation_date DATE := FND_API.G_MISS_DATE,
61: created_by NUMBER := FND_API.G_MISS_NUM,
62: last_update_login NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: score_id NUMBER := FND_API.G_MISS_NUM,
65: decile VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: num_records NUMBER := FND_API.G_MISS_NUM,
67: score VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: confidence NUMBER := FND_API.G_MISS_NUM
61: created_by NUMBER := FND_API.G_MISS_NUM,
62: last_update_login NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: score_id NUMBER := FND_API.G_MISS_NUM,
65: decile VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: num_records NUMBER := FND_API.G_MISS_NUM,
67: score VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: confidence NUMBER := FND_API.G_MISS_NUM
69: );
62: last_update_login NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: score_id NUMBER := FND_API.G_MISS_NUM,
65: decile VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: num_records NUMBER := FND_API.G_MISS_NUM,
67: score VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: confidence NUMBER := FND_API.G_MISS_NUM
69: );
70:
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: score_id NUMBER := FND_API.G_MISS_NUM,
65: decile VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: num_records NUMBER := FND_API.G_MISS_NUM,
67: score VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: confidence NUMBER := FND_API.G_MISS_NUM
69: );
70:
71: g_miss_scoreresult_rec scoreresult_rec_type;
64: score_id NUMBER := FND_API.G_MISS_NUM,
65: decile VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: num_records NUMBER := FND_API.G_MISS_NUM,
67: score VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: confidence NUMBER := FND_API.G_MISS_NUM
69: );
70:
71: g_miss_scoreresult_rec scoreresult_rec_type;
72: TYPE scoreresult_tbl_type IS TABLE OF scoreresult_rec_type INDEX BY BINARY_INTEGER;
84: -- Parameters
85: --
86: -- IN
87: -- p_api_version IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
91: -- p_scoreresult_rec IN scoreresult_rec_type Required
92: --
85: --
86: -- IN
87: -- p_api_version IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
91: -- p_scoreresult_rec IN scoreresult_rec_type Required
92: --
93: -- OUT
86: -- IN
87: -- p_api_version IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
91: -- p_scoreresult_rec IN scoreresult_rec_type Required
92: --
93: -- OUT
94: -- x_return_status OUT VARCHAR2
103: --
104:
105: PROCEDURE Create_Scoreresult(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110:
111: x_return_status OUT NOCOPY VARCHAR2,
104:
105: PROCEDURE Create_Scoreresult(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110:
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
105: PROCEDURE Create_Scoreresult(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110:
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
128: -- Parameters
129: --
130: -- IN
131: -- p_api_version IN NUMBER Required
132: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_scoreresult_rec IN scoreresult_rec_type Required
136: --
129: --
130: -- IN
131: -- p_api_version IN NUMBER Required
132: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_scoreresult_rec IN scoreresult_rec_type Required
136: --
137: -- OUT
130: -- IN
131: -- p_api_version IN NUMBER Required
132: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_scoreresult_rec IN scoreresult_rec_type Required
136: --
137: -- OUT
138: -- x_return_status OUT VARCHAR2
147: --
148:
149: PROCEDURE Update_Scoreresult(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154:
155: x_return_status OUT NOCOPY VARCHAR2,
148:
149: PROCEDURE Update_Scoreresult(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154:
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
149: PROCEDURE Update_Scoreresult(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154:
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
172: -- Parameters
173: --
174: -- IN
175: -- p_api_version IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_SCORE_RESULT_ID IN NUMBER
180: -- p_object_version_number IN NUMBER Optional Default = NULL
173: --
174: -- IN
175: -- p_api_version IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_SCORE_RESULT_ID IN NUMBER
180: -- p_object_version_number IN NUMBER Optional Default = NULL
181: --
174: -- IN
175: -- p_api_version IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_SCORE_RESULT_ID IN NUMBER
180: -- p_object_version_number IN NUMBER Optional Default = NULL
181: --
182: -- OUT
192: --
193:
194: PROCEDURE Delete_Scoreresult(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
193:
194: PROCEDURE Delete_Scoreresult(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
194: PROCEDURE Delete_Scoreresult(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_score_result_id IN NUMBER,
215: -- Parameters
216: --
217: -- IN
218: -- p_api_version IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_scoreresult_rec IN scoreresult_rec_type Required
223: --
216: --
217: -- IN
218: -- p_api_version IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_scoreresult_rec IN scoreresult_rec_type Required
223: --
224: -- OUT
217: -- IN
218: -- p_api_version IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_scoreresult_rec IN scoreresult_rec_type Required
223: --
224: -- OUT
225: -- x_return_status OUT VARCHAR2
234: --
235:
236: PROCEDURE Lock_Scoreresult(
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239:
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
258: -- End of Comments
259:
260: PROCEDURE Validate_scoreresult(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: p_validation_mode IN VARCHAR2,
265: p_scoreresult_rec IN scoreresult_rec_type,
266: x_return_status OUT NOCOPY VARCHAR2,
259:
260: PROCEDURE Validate_scoreresult(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: p_validation_mode IN VARCHAR2,
265: p_scoreresult_rec IN scoreresult_rec_type,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
297: -- End of Comments
298:
299: PROCEDURE Validate_scoreresult_rec(
300: p_api_version IN NUMBER,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: p_scoreresult_rec IN scoreresult_rec_type
318: -- Parameters
319: --
320: -- IN
321: -- p_api_version NUMBER Required
322: -- p_init_msg_list VARCHAR2 Optional Default = FND_API_G_FALSE
323: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
324: -- p_validation_level NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
325: -- p_score_id NUMBER
326: --
319: --
320: -- IN
321: -- p_api_version NUMBER Required
322: -- p_init_msg_list VARCHAR2 Optional Default = FND_API_G_FALSE
323: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
324: -- p_validation_level NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
325: -- p_score_id NUMBER
326: --
327: -- OUT
320: -- IN
321: -- p_api_version NUMBER Required
322: -- p_init_msg_list VARCHAR2 Optional Default = FND_API_G_FALSE
323: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
324: -- p_validation_level NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
325: -- p_score_id NUMBER
326: --
327: -- OUT
328: -- x_return_status VARCHAR2
333: -- End of Comments
334: -- ==============================================================================
335: PROCEDURE summarize_results (
336: p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2,
334: -- ==============================================================================
335: PROCEDURE summarize_results (
336: p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2,
342: p_score_id IN NUMBER