The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ams_act_delivery_methods_s.NEXTVAL
FROM dual;
INSERT INTO AMS_ACT_DELIVERY_METHODS
(activity_delivery_method_id,
-- standard who columns
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
-- other columns
object_version_number,
act_delivery_method_used_by_id,
arc_act_delivery_used_by,
delivery_media_type_code,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
)
VALUES
(
l_act_DelvMethod_rec.activity_delivery_method_id,
-- standard who columns
sysdate,
FND_GLOBAL.User_Id,
sysdate,
FND_GLOBAL.User_Id,
FND_GLOBAL.Conc_Login_Id,
1, -- object_version_number
l_act_DelvMethod_rec.act_delivery_method_used_by_id,
l_act_DelvMethod_rec.arc_act_delivery_used_by,
l_act_DelvMethod_rec.delivery_media_type_code,
l_act_DelvMethod_rec.attribute_category,
l_act_DelvMethod_rec.attribute1,
l_act_DelvMethod_rec.attribute2,
l_act_DelvMethod_rec.attribute3,
l_act_DelvMethod_rec.attribute4,
l_act_DelvMethod_rec.attribute5,
l_act_DelvMethod_rec.attribute6,
l_act_DelvMethod_rec.attribute7,
l_act_DelvMethod_rec.attribute8,
l_act_DelvMethod_rec.attribute9,
l_act_DelvMethod_rec.attribute10,
l_act_DelvMethod_rec.attribute11,
l_act_DelvMethod_rec.attribute12,
l_act_DelvMethod_rec.attribute13,
l_act_DelvMethod_rec.attribute14,
l_act_DelvMethod_rec.attribute15
);
PROCEDURE Update_Act_DelvMethod
( 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_act_DelvMethod_rec IN act_DelvMethod_rec_type
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Act_DelvMethod';
SAVEPOINT Update_Act_DelvMethod_PVT;
p_validation_mode => JTF_PLSQL_API.g_update,
x_return_status => l_return_status
);
update AMS_ACT_DELIVERY_METHODS
set
last_update_date = sysdate
,last_updated_by = FND_GLOBAL.User_Id
,last_update_login = FND_GLOBAL.Conc_Login_Id
,object_version_number = l_act_DelvMethod_rec.object_version_number+1
,act_delivery_method_used_by_id = l_act_DelvMethod_rec.act_delivery_method_used_by_id
,arc_act_delivery_used_by = l_act_DelvMethod_rec.arc_act_delivery_used_by
,delivery_media_type_code = l_act_DelvMethod_rec.delivery_media_type_code
,attribute_category = l_act_DelvMethod_rec.attribute_category
,attribute1 = l_act_DelvMethod_rec.attribute1
,attribute2 = l_act_DelvMethod_rec.attribute2
,attribute3 = l_act_DelvMethod_rec.attribute3
,attribute4 = l_act_DelvMethod_rec.attribute4
,attribute5 = l_act_DelvMethod_rec.attribute5
,attribute6 = l_act_DelvMethod_rec.attribute6
,attribute7 = l_act_DelvMethod_rec.attribute7
,attribute8 = l_act_DelvMethod_rec.attribute8
,attribute9 = l_act_DelvMethod_rec.attribute9
,attribute10 = l_act_DelvMethod_rec.attribute10
,attribute11 = l_act_DelvMethod_rec.attribute11
,attribute12 = l_act_DelvMethod_rec.attribute12
,attribute13 = l_act_DelvMethod_rec.attribute13
,attribute14 = l_act_DelvMethod_rec.attribute14
,attribute15 = l_act_DelvMethod_rec.attribute15
where activity_delivery_method_id = l_act_DelvMethod_rec.activity_delivery_method_id
and object_version_number = l_act_DelvMethod_rec.object_version_number;
ROLLBACK TO Update_Act_DelvMethod_PVT;
ROLLBACK TO Update_Act_DelvMethod_PVT;
ROLLBACK TO Update_Act_DelvMethod_PVT;
END Update_Act_DelvMethod;
PROCEDURE Delete_Act_DelvMethod
( 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_act_DelvMethod_id IN NUMBER,
p_object_version IN NUMBER
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Act_DelvMethod';
SAVEPOINT Delete_Act_DelvMethod_PVT;
-- Delete header data
DELETE FROM AMS_ACT_DELIVERY_METHODS
WHERE activity_delivery_method_id = l_act_delivery_method_id
and object_version_number = p_object_version;
ROLLBACK TO Delete_Act_DelvMethod_PVT;
ROLLBACK TO Delete_Act_DelvMethod_PVT;
ROLLBACK TO Delete_Act_DelvMethod_PVT;
END Delete_Act_DelvMethod;
SELECT activity_delivery_method_id
FROM AMS_ACT_DELIVERY_METHODS
WHERE activity_delivery_method_id = p_act_delvmethod_id
and object_version_number = p_object_version
FOR UPDATE of activity_delivery_method_id NOWAIT;
AMS_Utility_PVT.debug_message(l_pk_value ||': insert B');
x_act_DelvMethod_rec.last_update_date := FND_API.g_miss_date;
x_act_DelvMethod_rec.last_updated_by := FND_API.g_miss_num;
x_act_DelvMethod_rec.last_update_login := FND_API.g_miss_num;
SELECT *
FROM ams_act_delivery_methods
WHERE activity_delivery_method_id = p_act_DelvMethod_rec.activity_delivery_method_id;