DBA Data[Home] [Help]

APPS.AMS_SCORERESULT_PVT dependencies on FND_API

Line 57: score_result_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 58: last_update_date DATE := FND_API.G_MISS_DATE,

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,

Line 59: last_updated_by 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,

Line 60: creation_date DATE := FND_API.G_MISS_DATE,

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,

Line 61: created_by 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,

Line 62: last_update_login 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,
66: num_records NUMBER := FND_API.G_MISS_NUM,

Line 63: object_version_number 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,

Line 64: score_id 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,
68: confidence NUMBER := FND_API.G_MISS_NUM

Line 65: decile VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

Line 66: num_records 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: );
70:

Line 67: score VARCHAR2(30) := FND_API.G_MISS_CHAR,

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;

Line 68: confidence 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;
72: TYPE scoreresult_tbl_type IS TABLE OF scoreresult_rec_type INDEX BY BINARY_INTEGER;

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

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

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

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

Line 90: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

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,

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

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,

Line 109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

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

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

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

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

Line 134: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

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,

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

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,

Line 153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

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

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

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

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

Line 178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

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,

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

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,

Line 198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

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

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

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

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

Line 221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

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,

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

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,

Line 263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

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

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

Line 322: -- p_init_msg_list VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 323: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 324: -- p_validation_level NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

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,

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

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