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

Line 79: DECODE( p_metric_tpl_assoc_id, FND_API.g_miss_num, NULL, p_metric_tpl_assoc_id),

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

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

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

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

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

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

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

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

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

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

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

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

81: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
82: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
84: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
85: 1, -- DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
86: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
87: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
88: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
89: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code),

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

82: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
84: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
85: 1, -- DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
86: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
87: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
88: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
89: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag));

Line 87: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),

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

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

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

Line 89: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code),

85: 1, -- DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
86: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
87: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
88: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
89: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag));
91: END Insert_Row;
92:
93:

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

86: DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, NULL, p_metric_tpl_header_id),
87: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
88: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
89: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag));
91: END Insert_Row;
92:
93:
94: ----------------------------------------------------------

Line 126: metric_tpl_assoc_id = DECODE( p_metric_tpl_assoc_id, FND_API.g_miss_num, metric_tpl_assoc_id, p_metric_tpl_assoc_id),

122: IS
123: BEGIN
124: UPDATE AMS_MET_TPL_ASSOCS
125: SET
126: metric_tpl_assoc_id = DECODE( p_metric_tpl_assoc_id, FND_API.g_miss_num, metric_tpl_assoc_id, p_metric_tpl_assoc_id),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

123: BEGIN
124: UPDATE AMS_MET_TPL_ASSOCS
125: SET
126: metric_tpl_assoc_id = DECODE( p_metric_tpl_assoc_id, FND_API.g_miss_num, metric_tpl_assoc_id, p_metric_tpl_assoc_id),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: 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 128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

124: UPDATE AMS_MET_TPL_ASSOCS
125: SET
126: metric_tpl_assoc_id = DECODE( p_metric_tpl_assoc_id, FND_API.g_miss_num, metric_tpl_assoc_id, p_metric_tpl_assoc_id),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
132: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),

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

125: SET
126: metric_tpl_assoc_id = DECODE( p_metric_tpl_assoc_id, FND_API.g_miss_num, metric_tpl_assoc_id, p_metric_tpl_assoc_id),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
132: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
133: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),

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

126: metric_tpl_assoc_id = DECODE( p_metric_tpl_assoc_id, FND_API.g_miss_num, metric_tpl_assoc_id, p_metric_tpl_assoc_id),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
132: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
133: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
134: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code),

Line 131: 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: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
132: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
133: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
134: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code),
135: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

Line 132: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),

128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
132: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
133: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
134: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code),
135: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
136: WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID;

Line 133: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),

129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
132: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
133: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
134: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code),
135: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
136: WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID;
137: --AND object_version_number = p_object_version_number;

Line 134: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code),

130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
132: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
133: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
134: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code),
135: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
136: WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID;
137: --AND object_version_number = p_object_version_number;
138:

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

131: metric_tpl_header_id = DECODE( p_metric_tpl_header_id, FND_API.g_miss_num, metric_tpl_header_id, p_metric_tpl_header_id),
132: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
133: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
134: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code),
135: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
136: WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID;
137: --AND object_version_number = p_object_version_number;
138:
139: IF (SQL%NOTFOUND) THEN

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

136: WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID;
137: --AND object_version_number = p_object_version_number;
138:
139: IF (SQL%NOTFOUND) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142: END Update_Row;
143:
144:

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164: BEGIN
165: DELETE FROM AMS_MET_TPL_ASSOCS
166: WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID;
167: IF (SQL%NOTFOUND) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170: END Delete_Row ;
171:
172: