The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT AMS_ACT_MARKET_SEGMENTS_S.NEXTVAL
FROM DUAL;
SELECT COUNT(*)
FROM AMS_ACT_MARKET_SEGMENTS
WHERE activity_market_segment_id = mks_id;
AMS_Utility_PVT.debug_message(l_full_name || ': insert');
INSERT INTO AMS_ACT_MARKET_SEGMENTS
(
activity_market_segment_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
market_segment_id,
act_market_segment_used_by_id,
arc_act_market_segment_used_by,
segment_type,
last_update_login,
object_version_number,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
group_code,
exclude_flag
)
VALUES
(
l_mks_rec.activity_market_segment_id,
SYSDATE,
FND_GLOBAL.user_id,
SYSDATE,
FND_GLOBAL.user_id,
l_mks_rec.market_segment_id,
l_mks_rec.act_market_segment_used_by_id,
l_mks_rec.arc_act_market_segment_used_by,
l_mks_rec.segment_type,
FND_GLOBAL.conc_login_id,
1,
l_mks_rec.attribute_category,
l_mks_rec.attribute1,
l_mks_rec.attribute2,
l_mks_rec.attribute3,
l_mks_rec.attribute4,
l_mks_rec.attribute5,
l_mks_rec.attribute6,
l_mks_rec.attribute7,
l_mks_rec.attribute8,
l_mks_rec.attribute9,
l_mks_rec.attribute10,
l_mks_rec.attribute11,
l_mks_rec.attribute12,
l_mks_rec.attribute13,
l_mks_rec.attribute14,
l_mks_rec.attribute15,
l_mks_rec.group_code,
l_mks_rec.exclude_flag
);
PROCEDURE update_market_segments
(
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_mks_rec IN mks_rec_type
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'update_market_segments';
SAVEPOINT update_market_segments;
p_validation_mode => JTF_PLSQL_API.g_update,
x_return_status => l_return_status
);
p_validation_mode => JTF_PLSQL_API.g_update,
x_return_status => l_return_status
);
AMS_Utility_PVT.debug_message(l_full_name||': update');
UPDATE AMS_ACT_MARKET_SEGMENTS SET
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.user_id,
market_segment_id = l_mks_rec.market_segment_id,
act_market_segment_used_by_id = l_mks_rec.act_market_segment_used_by_id,
arc_act_market_segment_used_by = l_mks_rec.arc_act_market_segment_used_by,
segment_type = l_mks_rec.segment_type,
last_update_login = FND_GLOBAL.conc_login_id,
object_version_number = l_mks_rec.object_version_number + 1,
attribute_category = l_mks_rec.attribute_category,
attribute1 = l_mks_rec.attribute1,
attribute2 = l_mks_rec.attribute2,
attribute3 = l_mks_rec.attribute3,
attribute4 = l_mks_rec.attribute4,
attribute5 = l_mks_rec.attribute5,
attribute6 = l_mks_rec.attribute6,
attribute7 = l_mks_rec.attribute7,
attribute8 = l_mks_rec.attribute8,
attribute9 = l_mks_rec.attribute9,
attribute10 = l_mks_rec.attribute10,
attribute11 = l_mks_rec.attribute11,
attribute12 = l_mks_rec.attribute12,
attribute13 = l_mks_rec.attribute13,
attribute14 = l_mks_rec.attribute14,
attribute15 = l_mks_rec.attribute15,
group_code = l_mks_rec.group_code,
exclude_flag = l_mks_rec.exclude_flag
WHERE activity_market_segment_id = l_mks_rec.activity_market_segment_id
AND object_version_number = l_mks_rec.object_version_number;
ROLLBACK TO update_market_segments;
ROLLBACK TO update_market_segments;
ROLLBACK TO update_market_segments;
END update_market_segments;
PROCEDURE delete_market_segments
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.g_false,
p_commit IN VARCHAR2 := FND_API.g_false,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_act_mks_id IN NUMBER,
p_object_version IN NUMBER
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'delete_market_segments';
SELECT act_market_segment_used_by_id ,
arc_act_market_segment_used_by
FROM ams_act_market_segments
WHERE activity_market_segment_id = p_act_mks_id;
SELECT 1
FROM ams_act_market_segments
WHERE act_market_segment_used_by_id = l_act_id
AND arc_act_market_segment_used_by = l_arc_act ;
SAVEPOINT delete_market_segments;
AMS_Utility_PVT.debug_message(l_full_name || ': delete');
DELETE FROM AMS_ACT_MARKET_SEGMENTS
WHERE activity_market_segment_id = p_act_mks_id
AND object_version_number = p_object_version;
ROLLBACK TO delete_market_segments;
ROLLBACK TO delete_market_segments;
ROLLBACK TO delete_market_segments;
END delete_market_segments;
l_api_name CONSTANT VARCHAR2(30) := 'delete_market_segments';
SELECT activity_market_segment_id
FROM AMS_ACT_MARKET_SEGMENTS
WHERE activity_market_segment_id = p_act_mks_id
AND object_version_number = p_object_version
FOR UPDATE NOWAIT;
SELECT COUNT(1)
FROM qp_qualifiers
WHERE qualifier_id = l_id;
SELECT * FROM AMS_ACT_MARKET_SEGMENTS
WHERE activity_market_segment_id = p_mks_rec.activity_market_segment_id;
x_mks_rec.last_update_date := FND_API.G_MISS_DATE ;
x_mks_rec.last_updated_by := FND_API.G_MISS_NUM ;
x_mks_rec.last_update_login := FND_API.G_MISS_NUM ;