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_PERFORMANCE_PKG dependencies on FND_API

Line 59: DECODE( px_performance_id, FND_API.g_miss_num, NULL, px_performance_id),

55: evaluated_records,
56: total_records_predicted,
57: model_id
58: ) VALUES (
59: DECODE( px_performance_id, FND_API.g_miss_num, NULL, px_performance_id),
60: DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date),
61: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_last_updated_by),
62: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
63: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_created_by),

Line 60: DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date),

56: total_records_predicted,
57: model_id
58: ) VALUES (
59: DECODE( px_performance_id, FND_API.g_miss_num, NULL, px_performance_id),
60: DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date),
61: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_last_updated_by),
62: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
63: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_created_by),
64: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.conc_login_id, p_last_update_login),

Line 61: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_last_updated_by),

57: model_id
58: ) VALUES (
59: DECODE( px_performance_id, FND_API.g_miss_num, NULL, px_performance_id),
60: DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date),
61: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_last_updated_by),
62: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
63: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_created_by),
64: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.conc_login_id, p_last_update_login),
65: DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number),

Line 62: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),

58: ) VALUES (
59: DECODE( px_performance_id, FND_API.g_miss_num, NULL, px_performance_id),
60: DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date),
61: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_last_updated_by),
62: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
63: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_created_by),
64: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.conc_login_id, p_last_update_login),
65: DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number),
66: DECODE( p_predicted_value, FND_API.g_miss_char, NULL, p_predicted_value),

Line 63: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_created_by),

59: DECODE( px_performance_id, FND_API.g_miss_num, NULL, px_performance_id),
60: DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date),
61: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_last_updated_by),
62: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
63: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_created_by),
64: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.conc_login_id, p_last_update_login),
65: DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number),
66: DECODE( p_predicted_value, FND_API.g_miss_char, NULL, p_predicted_value),
67: DECODE( p_actual_value, FND_API.g_miss_char, NULL, p_actual_value),

Line 64: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.conc_login_id, p_last_update_login),

60: DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date),
61: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_last_updated_by),
62: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
63: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_created_by),
64: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.conc_login_id, p_last_update_login),
65: DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number),
66: DECODE( p_predicted_value, FND_API.g_miss_char, NULL, p_predicted_value),
67: DECODE( p_actual_value, FND_API.g_miss_char, NULL, p_actual_value),
68: DECODE( p_evaluated_records, FND_API.g_miss_num, NULL, p_evaluated_records),

Line 65: DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number),

61: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_last_updated_by),
62: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
63: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_created_by),
64: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.conc_login_id, p_last_update_login),
65: DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number),
66: DECODE( p_predicted_value, FND_API.g_miss_char, NULL, p_predicted_value),
67: DECODE( p_actual_value, FND_API.g_miss_char, NULL, p_actual_value),
68: DECODE( p_evaluated_records, FND_API.g_miss_num, NULL, p_evaluated_records),
69: DECODE( p_total_records_predicted, FND_API.g_miss_num, NULL, p_total_records_predicted),

Line 66: DECODE( p_predicted_value, FND_API.g_miss_char, NULL, p_predicted_value),

62: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
63: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_created_by),
64: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.conc_login_id, p_last_update_login),
65: DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number),
66: DECODE( p_predicted_value, FND_API.g_miss_char, NULL, p_predicted_value),
67: DECODE( p_actual_value, FND_API.g_miss_char, NULL, p_actual_value),
68: DECODE( p_evaluated_records, FND_API.g_miss_num, NULL, p_evaluated_records),
69: DECODE( p_total_records_predicted, FND_API.g_miss_num, NULL, p_total_records_predicted),
70: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id));

Line 67: DECODE( p_actual_value, FND_API.g_miss_char, NULL, p_actual_value),

63: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.user_id, p_created_by),
64: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.conc_login_id, p_last_update_login),
65: DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number),
66: DECODE( p_predicted_value, FND_API.g_miss_char, NULL, p_predicted_value),
67: DECODE( p_actual_value, FND_API.g_miss_char, NULL, p_actual_value),
68: DECODE( p_evaluated_records, FND_API.g_miss_num, NULL, p_evaluated_records),
69: DECODE( p_total_records_predicted, FND_API.g_miss_num, NULL, p_total_records_predicted),
70: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id));
71: END Insert_Row;

Line 68: DECODE( p_evaluated_records, FND_API.g_miss_num, NULL, p_evaluated_records),

64: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.conc_login_id, p_last_update_login),
65: DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number),
66: DECODE( p_predicted_value, FND_API.g_miss_char, NULL, p_predicted_value),
67: DECODE( p_actual_value, FND_API.g_miss_char, NULL, p_actual_value),
68: DECODE( p_evaluated_records, FND_API.g_miss_num, NULL, p_evaluated_records),
69: DECODE( p_total_records_predicted, FND_API.g_miss_num, NULL, p_total_records_predicted),
70: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id));
71: END Insert_Row;
72:

Line 69: DECODE( p_total_records_predicted, FND_API.g_miss_num, NULL, p_total_records_predicted),

65: DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number),
66: DECODE( p_predicted_value, FND_API.g_miss_char, NULL, p_predicted_value),
67: DECODE( p_actual_value, FND_API.g_miss_char, NULL, p_actual_value),
68: DECODE( p_evaluated_records, FND_API.g_miss_num, NULL, p_evaluated_records),
69: DECODE( p_total_records_predicted, FND_API.g_miss_num, NULL, p_total_records_predicted),
70: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id));
71: END Insert_Row;
72:
73: PROCEDURE Update_Row(

Line 70: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id));

66: DECODE( p_predicted_value, FND_API.g_miss_char, NULL, p_predicted_value),
67: DECODE( p_actual_value, FND_API.g_miss_char, NULL, p_actual_value),
68: DECODE( p_evaluated_records, FND_API.g_miss_num, NULL, p_evaluated_records),
69: DECODE( p_total_records_predicted, FND_API.g_miss_num, NULL, p_total_records_predicted),
70: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id));
71: END Insert_Row;
72:
73: PROCEDURE Update_Row(
74: p_performance_id NUMBER,

Line 91: performance_id = DECODE( p_performance_id, FND_API.g_miss_num, performance_id, p_performance_id),

87: IS
88: BEGIN
89: Update AMS_DM_PERFORMANCE
90: SET
91: performance_id = DECODE( p_performance_id, FND_API.g_miss_num, performance_id, p_performance_id),
92: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
93: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
94: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
95: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

88: BEGIN
89: Update AMS_DM_PERFORMANCE
90: SET
91: performance_id = DECODE( p_performance_id, FND_API.g_miss_num, performance_id, p_performance_id),
92: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
93: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
94: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
95: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
96: predicted_value = DECODE( p_predicted_value, FND_API.g_miss_char, predicted_value, p_predicted_value),

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

89: Update AMS_DM_PERFORMANCE
90: SET
91: performance_id = DECODE( p_performance_id, FND_API.g_miss_num, performance_id, p_performance_id),
92: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
93: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
94: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
95: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
96: predicted_value = DECODE( p_predicted_value, FND_API.g_miss_char, predicted_value, p_predicted_value),
97: actual_value = DECODE( p_actual_value, FND_API.g_miss_char, actual_value, p_actual_value),

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

90: SET
91: performance_id = DECODE( p_performance_id, FND_API.g_miss_num, performance_id, p_performance_id),
92: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
93: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
94: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
95: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
96: predicted_value = DECODE( p_predicted_value, FND_API.g_miss_char, predicted_value, p_predicted_value),
97: actual_value = DECODE( p_actual_value, FND_API.g_miss_char, actual_value, p_actual_value),
98: evaluated_records = DECODE( p_evaluated_records, FND_API.g_miss_num, evaluated_records, p_evaluated_records),

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

91: performance_id = DECODE( p_performance_id, FND_API.g_miss_num, performance_id, p_performance_id),
92: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
93: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
94: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
95: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
96: predicted_value = DECODE( p_predicted_value, FND_API.g_miss_char, predicted_value, p_predicted_value),
97: actual_value = DECODE( p_actual_value, FND_API.g_miss_char, actual_value, p_actual_value),
98: evaluated_records = DECODE( p_evaluated_records, FND_API.g_miss_num, evaluated_records, p_evaluated_records),
99: total_records_predicted = DECODE( p_total_records_predicted, FND_API.g_miss_num, total_records_predicted, p_total_records_predicted),

Line 96: predicted_value = DECODE( p_predicted_value, FND_API.g_miss_char, predicted_value, p_predicted_value),

92: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
93: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
94: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
95: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
96: predicted_value = DECODE( p_predicted_value, FND_API.g_miss_char, predicted_value, p_predicted_value),
97: actual_value = DECODE( p_actual_value, FND_API.g_miss_char, actual_value, p_actual_value),
98: evaluated_records = DECODE( p_evaluated_records, FND_API.g_miss_num, evaluated_records, p_evaluated_records),
99: total_records_predicted = DECODE( p_total_records_predicted, FND_API.g_miss_num, total_records_predicted, p_total_records_predicted),
100: model_id = DECODE( p_model_id, FND_API.g_miss_num, model_id, p_model_id)

Line 97: actual_value = DECODE( p_actual_value, FND_API.g_miss_char, actual_value, p_actual_value),

93: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
94: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
95: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
96: predicted_value = DECODE( p_predicted_value, FND_API.g_miss_char, predicted_value, p_predicted_value),
97: actual_value = DECODE( p_actual_value, FND_API.g_miss_char, actual_value, p_actual_value),
98: evaluated_records = DECODE( p_evaluated_records, FND_API.g_miss_num, evaluated_records, p_evaluated_records),
99: total_records_predicted = DECODE( p_total_records_predicted, FND_API.g_miss_num, total_records_predicted, p_total_records_predicted),
100: model_id = DECODE( p_model_id, FND_API.g_miss_num, model_id, p_model_id)
101: WHERE PERFORMANCE_ID = p_PERFORMANCE_ID;

Line 98: evaluated_records = DECODE( p_evaluated_records, FND_API.g_miss_num, evaluated_records, p_evaluated_records),

94: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
95: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
96: predicted_value = DECODE( p_predicted_value, FND_API.g_miss_char, predicted_value, p_predicted_value),
97: actual_value = DECODE( p_actual_value, FND_API.g_miss_char, actual_value, p_actual_value),
98: evaluated_records = DECODE( p_evaluated_records, FND_API.g_miss_num, evaluated_records, p_evaluated_records),
99: total_records_predicted = DECODE( p_total_records_predicted, FND_API.g_miss_num, total_records_predicted, p_total_records_predicted),
100: model_id = DECODE( p_model_id, FND_API.g_miss_num, model_id, p_model_id)
101: WHERE PERFORMANCE_ID = p_PERFORMANCE_ID;
102:

Line 99: total_records_predicted = DECODE( p_total_records_predicted, FND_API.g_miss_num, total_records_predicted, p_total_records_predicted),

95: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
96: predicted_value = DECODE( p_predicted_value, FND_API.g_miss_char, predicted_value, p_predicted_value),
97: actual_value = DECODE( p_actual_value, FND_API.g_miss_char, actual_value, p_actual_value),
98: evaluated_records = DECODE( p_evaluated_records, FND_API.g_miss_num, evaluated_records, p_evaluated_records),
99: total_records_predicted = DECODE( p_total_records_predicted, FND_API.g_miss_num, total_records_predicted, p_total_records_predicted),
100: model_id = DECODE( p_model_id, FND_API.g_miss_num, model_id, p_model_id)
101: WHERE PERFORMANCE_ID = p_PERFORMANCE_ID;
102:
103: IF (SQL%NOTFOUND) THEN

Line 100: model_id = DECODE( p_model_id, FND_API.g_miss_num, model_id, p_model_id)

96: predicted_value = DECODE( p_predicted_value, FND_API.g_miss_char, predicted_value, p_predicted_value),
97: actual_value = DECODE( p_actual_value, FND_API.g_miss_char, actual_value, p_actual_value),
98: evaluated_records = DECODE( p_evaluated_records, FND_API.g_miss_num, evaluated_records, p_evaluated_records),
99: total_records_predicted = DECODE( p_total_records_predicted, FND_API.g_miss_num, total_records_predicted, p_total_records_predicted),
100: model_id = DECODE( p_model_id, FND_API.g_miss_num, model_id, p_model_id)
101: WHERE PERFORMANCE_ID = p_PERFORMANCE_ID;
102:
103: IF (SQL%NOTFOUND) THEN
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

100: model_id = DECODE( p_model_id, FND_API.g_miss_num, model_id, p_model_id)
101: WHERE PERFORMANCE_ID = p_PERFORMANCE_ID;
102:
103: IF (SQL%NOTFOUND) THEN
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105: END IF;
106: END Update_Row;
107:
108: PROCEDURE Delete_Row(

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: BEGIN
112: DELETE FROM AMS_DM_PERFORMANCE
113: WHERE PERFORMANCE_ID = p_PERFORMANCE_ID;
114: If (SQL%NOTFOUND) then
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: End If;
117: END Delete_Row ;
118:
119: