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

Line 78: DECODE( px_metric_template_detail_id, FND_API.g_miss_num, NULL, px_metric_template_detail_id),

74: metric_tpl_header_id,
75: metric_id,
76: enabled_flag
77: ) VALUES (
78: DECODE( px_metric_template_detail_id, FND_API.g_miss_num, NULL, px_metric_template_detail_id),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

75: metric_id,
76: enabled_flag
77: ) VALUES (
78: DECODE( px_metric_template_detail_id, FND_API.g_miss_num, NULL, px_metric_template_detail_id),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

76: enabled_flag
77: ) VALUES (
78: DECODE( px_metric_template_detail_id, FND_API.g_miss_num, NULL, px_metric_template_detail_id),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
84: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

77: ) VALUES (
78: DECODE( px_metric_template_detail_id, FND_API.g_miss_num, NULL, px_metric_template_detail_id),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
84: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
85: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),

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

78: DECODE( px_metric_template_detail_id, FND_API.g_miss_num, NULL, px_metric_template_detail_id),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
84: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
85: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
86: DECODE( p_metric_id, FND_API.g_miss_num, NULL, p_metric_id),

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

79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
84: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
85: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
86: DECODE( p_metric_id, FND_API.g_miss_num, NULL, p_metric_id),
87: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag));

Line 84: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

80: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
84: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
85: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
86: DECODE( p_metric_id, FND_API.g_miss_num, NULL, p_metric_id),
87: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag));
88: END Insert_Row;

Line 85: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),

81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
84: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
85: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
86: DECODE( p_metric_id, FND_API.g_miss_num, NULL, p_metric_id),
87: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag));
88: END Insert_Row;
89:

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

82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
84: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
85: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
86: DECODE( p_metric_id, FND_API.g_miss_num, NULL, p_metric_id),
87: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag));
88: END Insert_Row;
89:
90:

Line 87: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag));

83: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
84: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
85: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
86: DECODE( p_metric_id, FND_API.g_miss_num, NULL, p_metric_id),
87: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag));
88: END Insert_Row;
89:
90:
91: ----------------------------------------------------------

Line 121: metric_template_detail_id = DECODE( p_metric_template_detail_id, FND_API.g_miss_num, metric_template_detail_id, p_metric_template_detail_id),

117: IS
118: BEGIN
119: UPDATE AMS_MET_TPL_DETAILS
120: SET
121: metric_template_detail_id = DECODE( p_metric_template_detail_id, FND_API.g_miss_num, metric_template_detail_id, p_metric_template_detail_id),
122: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
125: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

118: BEGIN
119: UPDATE AMS_MET_TPL_DETAILS
120: SET
121: metric_template_detail_id = DECODE( p_metric_template_detail_id, FND_API.g_miss_num, metric_template_detail_id, p_metric_template_detail_id),
122: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
125: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
126: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),

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

119: UPDATE AMS_MET_TPL_DETAILS
120: SET
121: metric_template_detail_id = DECODE( p_metric_template_detail_id, FND_API.g_miss_num, metric_template_detail_id, p_metric_template_detail_id),
122: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
125: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
126: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
127: metric_id = DECODE( p_metric_id, FND_API.g_miss_num, metric_id, p_metric_id),

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

120: SET
121: metric_template_detail_id = DECODE( p_metric_template_detail_id, FND_API.g_miss_num, metric_template_detail_id, p_metric_template_detail_id),
122: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
125: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
126: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
127: metric_id = DECODE( p_metric_id, FND_API.g_miss_num, metric_id, p_metric_id),
128: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

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

121: metric_template_detail_id = DECODE( p_metric_template_detail_id, FND_API.g_miss_num, metric_template_detail_id, p_metric_template_detail_id),
122: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
125: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
126: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
127: metric_id = DECODE( p_metric_id, FND_API.g_miss_num, metric_id, p_metric_id),
128: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
129: WHERE METRIC_TEMPLATE_DETAIL_ID = p_METRIC_TEMPLATE_DETAIL_ID;

Line 126: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),

122: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
125: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
126: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
127: metric_id = DECODE( p_metric_id, FND_API.g_miss_num, metric_id, p_metric_id),
128: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
129: WHERE METRIC_TEMPLATE_DETAIL_ID = p_METRIC_TEMPLATE_DETAIL_ID;
130: -- AND object_version_number = p_object_version_number;

Line 127: metric_id = DECODE( p_metric_id, FND_API.g_miss_num, metric_id, p_metric_id),

123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
125: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
126: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
127: metric_id = DECODE( p_metric_id, FND_API.g_miss_num, metric_id, p_metric_id),
128: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
129: WHERE METRIC_TEMPLATE_DETAIL_ID = p_METRIC_TEMPLATE_DETAIL_ID;
130: -- AND object_version_number = p_object_version_number;
131:

Line 128: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

124: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
125: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
126: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
127: metric_id = DECODE( p_metric_id, FND_API.g_miss_num, metric_id, p_metric_id),
128: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
129: WHERE METRIC_TEMPLATE_DETAIL_ID = p_METRIC_TEMPLATE_DETAIL_ID;
130: -- AND object_version_number = p_object_version_number;
131:
132: IF (SQL%NOTFOUND) THEN

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

129: WHERE METRIC_TEMPLATE_DETAIL_ID = p_METRIC_TEMPLATE_DETAIL_ID;
130: -- AND object_version_number = p_object_version_number;
131:
132: IF (SQL%NOTFOUND) THEN
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: END IF;
135: END Update_Row;
136:
137:

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: BEGIN
158: DELETE FROM AMS_MET_TPL_DETAILS
159: WHERE METRIC_TEMPLATE_DETAIL_ID = p_METRIC_TEMPLATE_DETAIL_ID;
160: IF (SQL%NOTFOUND) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163: END Delete_Row ;
164:
165: