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