The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT start_date_time
FROM ams_triggers
WHERE trigger_id = p_trigger_id;
AMS_Utility_PVT.debug_message(l_full_name ||': Update Trigger');
UPDATE ams_triggers
SET process_id = to_number(l_new_item_key)
WHERE trigger_id = x_trigger_id;
PROCEDURE Update_Trigger
( p_api_version 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_trig_rec IN Ams_Trig_pvt.trig_rec_type,
p_thldchk_rec IN Ams_Thldchk_pvt.thldchk_rec_type DEFAULT NULL,
p_thldact_rec IN Ams_Thldact_pvt.thldact_rec_type
-- p_updt_type IN VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Trigger';
SELECT process_id
FROM ams_triggers
WHERE trigger_id = l_my_trig_id;
SELECT notify_flag, EXECUTE_SCHEDULE_FLAG
FROM ams_triggers
WHERE trigger_id = l_my_trig_id;
SELECT trigger_action_id, object_version_number
FROM ams_trigger_Actions
WHERE trigger_id = p_my_trig_id
AND execute_Action_type = p_action_type;
SAVEPOINT Update_Trig_PVT;
AMS_Utility_PVT.debug_message(l_full_name||': Update Trigger');
AMS_TRIG_PVT.Update_Trigger
( p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trig_rec => p_trig_rec
) ;
AMS_THLDCHK_PVT.Update_Thldchk
( p_api_version => l_api_version,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_thldchk_rec => l_thldchk_rec
) ;
AMS_THLDACT_PVT.Update_ThldAct
( p_api_version => l_api_version,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_thldact_rec => l_thldact_rec
) ;
AMS_THLDACT_PVT.Delete_ThldAct
( p_api_version => l_api_version,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trigger_action_id => l_trig_action_id,
p_object_version_number => l_object_version_number
) ;
AMS_THLDACT_PVT.Update_ThldAct
( p_api_version => l_api_version,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_thldact_rec => l_thldact_rec
) ;
AMS_THLDACT_PVT.Delete_ThldAct
( p_api_version => l_api_version,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trigger_action_id => l_trig_action_id,
p_object_version_number => l_object_version_number
) ;
/* ------------------- update trigger now ---------------------- */
-- moved to later by soagrawa 30-apr-2003
IF (AMS_DEBUG_HIGH_ON) THEN
AMS_Utility_PVT.debug_message(l_full_name||': Update Trigger');
AMS_TRIG_PVT.Update_Trigger
( p_api_version => l_api_version,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trig_rec => p_trig_rec
) ;
ROLLBACK TO Update_Trig_PVT;
ROLLBACK TO Update_Trig_PVT;
ROLLBACK TO Update_Trig_PVT;
END Update_Trigger;
SELECT start_date_time,
timezone_id,
user_start_date_time
FROM ams_triggers
WHERE trigger_id = p_trig_id;
UPDATE ams_triggers
SET process_id = to_number(l_new_item_key)
, start_date_time = l_st_dt
, user_start_date_time = l_user_st_dt
WHERE trigger_id = p_trigger_id;