eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DM_SCORE_RESULTS_PKG dependencies on FND_API

Line 86: DECODE( px_score_result_id, FND_API.g_miss_num, NULL, px_score_result_id),

82: num_records,
83: score,
84: confidence
85: ) VALUES (
86: DECODE( px_score_result_id, FND_API.g_miss_num, NULL, px_score_result_id),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
89: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
90: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

83: score,
84: confidence
85: ) VALUES (
86: DECODE( px_score_result_id, FND_API.g_miss_num, NULL, px_score_result_id),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
89: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
90: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
91: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 88: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

84: confidence
85: ) VALUES (
86: DECODE( px_score_result_id, FND_API.g_miss_num, NULL, px_score_result_id),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
89: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
90: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
91: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 89: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

85: ) VALUES (
86: DECODE( px_score_result_id, FND_API.g_miss_num, NULL, px_score_result_id),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
89: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
90: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
91: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
93: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),

Line 90: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

86: DECODE( px_score_result_id, FND_API.g_miss_num, NULL, px_score_result_id),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
89: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
90: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
91: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
93: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
94: DECODE( p_decile, FND_API.g_miss_char, NULL, p_decile),

Line 91: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
89: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
90: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
91: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
93: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
94: DECODE( p_decile, FND_API.g_miss_char, NULL, p_decile),
95: DECODE( p_num_records, FND_API.g_miss_num, NULL, p_num_records),

Line 92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

88: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
89: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
90: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
91: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
93: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
94: DECODE( p_decile, FND_API.g_miss_char, NULL, p_decile),
95: DECODE( p_num_records, FND_API.g_miss_num, NULL, p_num_records),
96: DECODE( p_score, FND_API.g_miss_char, NULL, p_score),

Line 93: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),

89: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
90: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
91: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
93: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
94: DECODE( p_decile, FND_API.g_miss_char, NULL, p_decile),
95: DECODE( p_num_records, FND_API.g_miss_num, NULL, p_num_records),
96: DECODE( p_score, FND_API.g_miss_char, NULL, p_score),
97: DECODE( p_confidence, FND_API.g_miss_num, NULL, p_confidence));

Line 94: DECODE( p_decile, FND_API.g_miss_char, NULL, p_decile),

90: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
91: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
93: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
94: DECODE( p_decile, FND_API.g_miss_char, NULL, p_decile),
95: DECODE( p_num_records, FND_API.g_miss_num, NULL, p_num_records),
96: DECODE( p_score, FND_API.g_miss_char, NULL, p_score),
97: DECODE( p_confidence, FND_API.g_miss_num, NULL, p_confidence));
98: END Insert_Row;

Line 95: DECODE( p_num_records, FND_API.g_miss_num, NULL, p_num_records),

91: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
93: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
94: DECODE( p_decile, FND_API.g_miss_char, NULL, p_decile),
95: DECODE( p_num_records, FND_API.g_miss_num, NULL, p_num_records),
96: DECODE( p_score, FND_API.g_miss_char, NULL, p_score),
97: DECODE( p_confidence, FND_API.g_miss_num, NULL, p_confidence));
98: END Insert_Row;
99:

Line 96: DECODE( p_score, FND_API.g_miss_char, NULL, p_score),

92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
93: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
94: DECODE( p_decile, FND_API.g_miss_char, NULL, p_decile),
95: DECODE( p_num_records, FND_API.g_miss_num, NULL, p_num_records),
96: DECODE( p_score, FND_API.g_miss_char, NULL, p_score),
97: DECODE( p_confidence, FND_API.g_miss_num, NULL, p_confidence));
98: END Insert_Row;
99:
100:

Line 97: DECODE( p_confidence, FND_API.g_miss_num, NULL, p_confidence));

93: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
94: DECODE( p_decile, FND_API.g_miss_char, NULL, p_decile),
95: DECODE( p_num_records, FND_API.g_miss_num, NULL, p_num_records),
96: DECODE( p_score, FND_API.g_miss_char, NULL, p_score),
97: DECODE( p_confidence, FND_API.g_miss_num, NULL, p_confidence));
98: END Insert_Row;
99:
100:
101: ----------------------------------------------------------

Line 135: score_result_id = DECODE( p_score_result_id, FND_API.g_miss_num, score_result_id, p_score_result_id),

131: IS
132: BEGIN
133: Update AMS_DM_SCORE_RESULTS
134: SET
135: score_result_id = DECODE( p_score_result_id, FND_API.g_miss_num, score_result_id, p_score_result_id),
136: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
137: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 136: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

132: BEGIN
133: Update AMS_DM_SCORE_RESULTS
134: SET
135: score_result_id = DECODE( p_score_result_id, FND_API.g_miss_num, score_result_id, p_score_result_id),
136: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
137: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: score_id = DECODE( p_score_id, FND_API.g_miss_num, score_id, p_score_id),

Line 137: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

133: Update AMS_DM_SCORE_RESULTS
134: SET
135: score_result_id = DECODE( p_score_result_id, FND_API.g_miss_num, score_result_id, p_score_result_id),
136: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
137: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: score_id = DECODE( p_score_id, FND_API.g_miss_num, score_id, p_score_id),
141: decile = DECODE( p_decile, FND_API.g_miss_char, decile, p_decile),

Line 138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

134: SET
135: score_result_id = DECODE( p_score_result_id, FND_API.g_miss_num, score_result_id, p_score_result_id),
136: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
137: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: score_id = DECODE( p_score_id, FND_API.g_miss_num, score_id, p_score_id),
141: decile = DECODE( p_decile, FND_API.g_miss_char, decile, p_decile),
142: num_records = DECODE( p_num_records, FND_API.g_miss_num, num_records, p_num_records),

Line 139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

135: score_result_id = DECODE( p_score_result_id, FND_API.g_miss_num, score_result_id, p_score_result_id),
136: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
137: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: score_id = DECODE( p_score_id, FND_API.g_miss_num, score_id, p_score_id),
141: decile = DECODE( p_decile, FND_API.g_miss_char, decile, p_decile),
142: num_records = DECODE( p_num_records, FND_API.g_miss_num, num_records, p_num_records),
143: score = DECODE( p_score, FND_API.g_miss_char, score, p_score),

Line 140: score_id = DECODE( p_score_id, FND_API.g_miss_num, score_id, p_score_id),

136: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
137: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: score_id = DECODE( p_score_id, FND_API.g_miss_num, score_id, p_score_id),
141: decile = DECODE( p_decile, FND_API.g_miss_char, decile, p_decile),
142: num_records = DECODE( p_num_records, FND_API.g_miss_num, num_records, p_num_records),
143: score = DECODE( p_score, FND_API.g_miss_char, score, p_score),
144: confidence = DECODE( p_confidence, FND_API.g_miss_num, confidence, p_confidence)

Line 141: decile = DECODE( p_decile, FND_API.g_miss_char, decile, p_decile),

137: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: score_id = DECODE( p_score_id, FND_API.g_miss_num, score_id, p_score_id),
141: decile = DECODE( p_decile, FND_API.g_miss_char, decile, p_decile),
142: num_records = DECODE( p_num_records, FND_API.g_miss_num, num_records, p_num_records),
143: score = DECODE( p_score, FND_API.g_miss_char, score, p_score),
144: confidence = DECODE( p_confidence, FND_API.g_miss_num, confidence, p_confidence)
145: WHERE SCORE_RESULT_ID = p_SCORE_RESULT_ID;

Line 142: num_records = DECODE( p_num_records, FND_API.g_miss_num, num_records, p_num_records),

138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: score_id = DECODE( p_score_id, FND_API.g_miss_num, score_id, p_score_id),
141: decile = DECODE( p_decile, FND_API.g_miss_char, decile, p_decile),
142: num_records = DECODE( p_num_records, FND_API.g_miss_num, num_records, p_num_records),
143: score = DECODE( p_score, FND_API.g_miss_char, score, p_score),
144: confidence = DECODE( p_confidence, FND_API.g_miss_num, confidence, p_confidence)
145: WHERE SCORE_RESULT_ID = p_SCORE_RESULT_ID;
146:

Line 143: score = DECODE( p_score, FND_API.g_miss_char, score, p_score),

139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: score_id = DECODE( p_score_id, FND_API.g_miss_num, score_id, p_score_id),
141: decile = DECODE( p_decile, FND_API.g_miss_char, decile, p_decile),
142: num_records = DECODE( p_num_records, FND_API.g_miss_num, num_records, p_num_records),
143: score = DECODE( p_score, FND_API.g_miss_char, score, p_score),
144: confidence = DECODE( p_confidence, FND_API.g_miss_num, confidence, p_confidence)
145: WHERE SCORE_RESULT_ID = p_SCORE_RESULT_ID;
146:
147: IF (SQL%NOTFOUND) THEN

Line 144: confidence = DECODE( p_confidence, FND_API.g_miss_num, confidence, p_confidence)

140: score_id = DECODE( p_score_id, FND_API.g_miss_num, score_id, p_score_id),
141: decile = DECODE( p_decile, FND_API.g_miss_char, decile, p_decile),
142: num_records = DECODE( p_num_records, FND_API.g_miss_num, num_records, p_num_records),
143: score = DECODE( p_score, FND_API.g_miss_char, score, p_score),
144: confidence = DECODE( p_confidence, FND_API.g_miss_num, confidence, p_confidence)
145: WHERE SCORE_RESULT_ID = p_SCORE_RESULT_ID;
146:
147: IF (SQL%NOTFOUND) THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

144: confidence = DECODE( p_confidence, FND_API.g_miss_num, confidence, p_confidence)
145: WHERE SCORE_RESULT_ID = p_SCORE_RESULT_ID;
146:
147: IF (SQL%NOTFOUND) THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;
150: END Update_Row;
151:
152:

Line 176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

172: BEGIN
173: DELETE FROM AMS_DM_SCORE_RESULTS
174: WHERE SCORE_RESULT_ID = p_SCORE_RESULT_ID;
175: If (SQL%NOTFOUND) then
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: End If;
178: END Delete_Row ;
179:
180: