The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT AMS_MET_TPL_HEADERS_ALL_S.NEXTVAL
FROM dual;
SELECT 1
FROM AMS_MET_TPL_HEADERS_B
WHERE METRIC_TPL_HEADER_ID = l_id;
Ams_Met_Tpl_Headers_B_Pkg.Insert_Row(
px_metric_tpl_header_id => l_metric_tpl_header_id,
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
px_object_version_number => l_object_version_number,
p_enabled_flag => l_metric_tpl_header_rec.enabled_flag,
p_application_id => l_metric_tpl_header_rec.application_id,
p_METRIC_TPL_HEADER_NAME => l_metric_tpl_header_rec.METRIC_TPL_HEADER_NAME,
p_DESCRIPTION => l_metric_tpl_header_rec.DESCRIPTION,
p_object_type => l_metric_tpl_header_rec.object_type,
p_association_type => l_metric_tpl_header_rec.association_type,
p_used_by_id => l_metric_tpl_header_rec.used_by_id,
p_used_by_code => l_metric_tpl_header_rec.used_by_code);
PROCEDURE Update_Metric_Template(
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_metric_tpl_header_rec IN metric_tpl_header_rec_type,
x_object_version_number OUT NOCOPY NUMBER
)
IS
CURSOR c_get_metric_template(l_metric_tpl_header_id NUMBER) IS
SELECT METRIC_TPL_HEADER_ID ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
OBJECT_VERSION_NUMBER ,
APPLICATION_ID ,
ENABLED_FLAG ,
METRIC_TPL_HEADER_NAME,
DESCRIPTION,
OBJECT_TYPE,
ASSOCIATION_TYPE,
USED_BY_ID,
USED_BY_CODE
FROM AMS_MET_TPL_HEADERS_VL
WHERE metric_tpl_header_id = l_metric_tpl_header_id;
L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Metric_Template';
SAVEPOINT UPDATE_Metric_Template_PVT;
p_message_name => 'API_MISSING_UPDATE_TARGET',
p_token_name => 'INFO',
p_token_value => 'Metric_Template');
p_validation_mode => JTF_PLSQL_API.g_update,
p_metric_tpl_header_rec => l_tar_metric_tpl_header_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
Ams_Utility_Pvt.debug_message('Private API: Calling Ams_Met_Tpl_Headers_B_Pkg.Update_Row');
Ams_Met_Tpl_Headers_B_Pkg.Update_Row(
p_metric_tpl_header_id => l_ref_metric_tpl_header_rec.metric_tpl_header_id,
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
p_object_version_number => l_object_version_number,
p_enabled_flag => l_tar_metric_tpl_header_rec.enabled_flag,
p_application_id => l_tar_metric_tpl_header_rec.application_id,
p_METRIC_TPL_HEADER_NAME => l_tar_metric_tpl_header_rec.METRIC_TPL_HEADER_NAME,
p_DESCRIPTION => l_tar_metric_tpl_header_rec.DESCRIPTION,
p_object_type => l_ref_metric_tpl_header_rec.object_type,
p_association_type => l_ref_metric_tpl_header_rec.association_type,
p_used_by_id => l_ref_metric_tpl_header_rec.used_by_id,
p_used_by_code => l_ref_metric_tpl_header_rec.used_by_code);
ROLLBACK TO UPDATE_Metric_Template_PVT;
ROLLBACK TO UPDATE_Metric_Template_PVT;
ROLLBACK TO UPDATE_Metric_Template_PVT;
END Update_Metric_Template;
PROCEDURE Delete_Metric_Template(
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_metric_tpl_header_id IN NUMBER,
p_object_version_number IN NUMBER
)
IS
L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Metric_Template';
SAVEPOINT DELETE_Metric_Template_PVT;
DELETE FROM ams_met_tpl_details
WHERE metric_tpl_header_id = p_metric_tpl_header_id;
DELETE FROM ams_met_tpl_assocs
WHERE metric_tpl_header_id = p_metric_tpl_header_id;
Ams_Utility_Pvt.debug_message( 'PRIVATE API: Calling DELETE TABLE handler');
Ams_Met_Tpl_Headers_B_Pkg.Delete_Row(
p_METRIC_TPL_HEADER_ID => p_METRIC_TPL_HEADER_ID);
ROLLBACK TO DELETE_Metric_Template_PVT;
ROLLBACK TO DELETE_Metric_Template_PVT;
ROLLBACK TO DELETE_Metric_Template_PVT;
END Delete_Metric_Template;
SELECT METRIC_TPL_HEADER_ID
FROM AMS_MET_TPL_HEADERS_B
WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID
AND object_version_number = p_object_version
FOR UPDATE NOWAIT;
SELECT count(1)
FROM AMS_MET_TPL_HEADERS_VL
WHERE METRIC_TPL_HEADER_NAME = p_met_tpl_header_name;
SELECT 1
FROM AMS_MET_TPL_HEADERS_VL
WHERE METRIC_TPL_HEADER_ID <> p_met_tpl_header_id
AND METRIC_TPL_HEADER_NAME = p_met_tpl_header_name;
SELECT 1
FROM ams_metrics_vl
WHERE UPPER(METRICS_NAME) = UPPER(p_metrics_name)
AND arc_metric_used_for_object = p_arc_metric_used_for_object;
ELSE -- Update
IF p_metric_tpl_header_rec.metric_tpl_header_id IS NULL OR
p_metric_tpl_header_rec.metric_tpl_header_id = FND_API.g_miss_num THEN
Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTH_NO_MET_TPL_HDR_ID');
SELECT count(1) FROM ams_lookups
WHERE lookup_type = 'AMS_METRIC_OBJECT_TYPE'
AND lookup_code = p_objectType;
SELECT count(1)
FROM ams_custom_setups_B a, ams_lookups b
WHERE custom_setup_id = p_setupId
AND b.lookup_type in ( 'AMS_METRIC_OBJECT_TYPE', 'AMS_ROLLUP_TYPE')
AND b.lookup_code = a.object_type;
IF p_validation_mode = JTF_PLSQL_API.g_update THEN
-- Debug Message
IF AMS_DEBUG_HIGH_ON THEN
Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': UPDATE MODE');