The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_sql := 'SELECT COUNT(*) FROM ' || p_table_name;
l_sql := 'SELECT COUNT(*) FROM ' || p_table_name;
l_sql := 'SELECT COUNT(*) FROM ' || p_lookup_table_name;
SELECT jtf_amv_attachments_s.NEXTVAL
FROM DUAL;
SELECT COUNT(*)
FROM jtf_amv_attachments
WHERE attachment_id = act_attachment_id;
SELECT deliverable_type_code
FROM jtf_amv_items_b
WHERE item_id = p_item_id;
INSERT INTO jtf_amv_attachments
(
attachment_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
object_version_number,
owner_user_id,
attachment_used_by_id,
attachment_used_by,
version,
enabled_flag,
can_fulfill_electronic_flag,
file_id,
file_name,
file_extension,
document_id,
keywords,
display_width,
display_height,
display_location,
link_to,
link_URL,
send_for_preview_flag,
attachment_type,
language_code,
application_id,
description,
default_style_sheet,
display_url,
display_rule_id,
display_program,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
display_text,
alternate_text,
secured_flag,
attachment_sub_type
)
VALUES (
l_act_attachment_rec.attachment_id,
SYSDATE,
FND_GLOBAL.user_id,
SYSDATE,
FND_GLOBAL.user_id,
FND_GLOBAL.conc_login_id,
1, -- object_version_number
l_act_attachment_rec.owner_user_id,
l_act_attachment_rec.attachment_used_by_id,
l_act_attachment_rec.attachment_used_by,
l_act_attachment_rec.version,
NVL(l_act_attachment_rec.enabled_flag, 'Y'),
NVL(l_act_attachment_rec.can_fulfill_electronic_flag, 'N'),
l_act_attachment_rec.file_id,
l_act_attachment_rec.file_name,
l_act_attachment_rec.file_extension,
l_act_attachment_rec.document_id,
l_act_attachment_rec.keywords,
l_act_attachment_rec.display_width,
l_act_attachment_rec.display_height,
l_act_attachment_rec.display_location,
l_act_attachment_rec.link_to,
l_act_attachment_rec.link_URL,
l_act_attachment_rec.send_for_preview_flag,
l_act_attachment_rec.attachment_type,
l_act_attachment_rec.language_code,
l_act_attachment_rec.application_id,
l_act_attachment_rec.description,
l_act_attachment_rec.default_style_sheet,
l_act_attachment_rec.display_url,
l_act_attachment_rec.display_rule_id,
l_act_attachment_rec.display_program,
l_act_attachment_rec.attribute_category,
l_act_attachment_rec.attribute1,
l_act_attachment_rec.attribute2,
l_act_attachment_rec.attribute3,
l_act_attachment_rec.attribute4,
l_act_attachment_rec.attribute5,
l_act_attachment_rec.attribute6,
l_act_attachment_rec.attribute7,
l_act_attachment_rec.attribute8,
l_act_attachment_rec.attribute9,
l_act_attachment_rec.attribute10,
l_act_attachment_rec.attribute11,
l_act_attachment_rec.attribute12,
l_act_attachment_rec.attribute13,
l_act_attachment_rec.attribute14,
l_act_attachment_rec.attribute15,
l_act_attachment_rec.display_text,
l_act_attachment_rec.alternate_text,
l_act_attachment_rec.secured_flag,
l_act_attachment_rec.attachment_sub_type
);
update jtf_amv_items_b
set last_update_date = sysdate,
last_updated_by = FND_GLOBAL.user_id,
last_update_login = FND_GLOBAL.conc_login_id
where item_id = l_act_attachment_rec.attachment_used_by_id ;
PROCEDURE delete_act_attachment
(
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_attachment_id IN NUMBER,
p_object_version IN NUMBER
) AS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'delete_act_attachment';
SAVEPOINT delete_act_attachment;
DELETE FROM jtf_amv_attachments
WHERE attachment_id = p_act_attachment_id
AND object_version_number = p_object_version;
ROLLBACK TO delete_act_attachment;
ROLLBACK TO delete_act_attachment;
ROLLBACK TO delete_act_attachment;
END delete_act_attachment;
PROCEDURE update_act_attachment
(
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_attachment_rec IN act_attachment_rec_type
) AS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'update_act_attachment';
SELECT deliverable_type_code
FROM jtf_amv_items_b
WHERE item_id = p_item_id;
SAVEPOINT update_act_attachment;
p_validation_mode => JTF_PLSQL_API.g_update,
x_return_status => l_return_status
);
UPDATE jtf_amv_attachments 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_attachment_rec.object_version_number + 1,
owner_user_id = l_act_attachment_rec.owner_user_id,
attachment_used_by_id = l_act_attachment_rec.attachment_used_by_id,
attachment_used_by = l_act_attachment_rec.attachment_used_by,
version = l_act_attachment_rec.version,
enabled_flag = l_act_attachment_rec.enabled_flag,
can_fulfill_electronic_flag =
l_act_attachment_rec.can_fulfill_electronic_flag,
file_id = l_act_attachment_rec.file_id,
file_name = l_act_attachment_rec.file_name,
file_extension = l_act_attachment_rec.file_extension,
document_id = l_act_attachment_rec.document_id,
keywords = l_act_attachment_rec.keywords,
display_width = l_act_attachment_rec.display_width,
display_height = l_act_attachment_rec.display_height,
display_location = l_act_attachment_rec.display_location,
link_to = l_act_attachment_rec.link_to,
link_url = l_act_attachment_rec.link_url,
send_for_preview_flag = l_act_attachment_rec.send_for_preview_flag,
attachment_type = l_act_attachment_rec.attachment_type,
language_code = l_act_attachment_rec.language_code,
application_id = l_act_attachment_rec.application_id,
description = l_act_attachment_rec.description,
default_style_sheet = l_act_attachment_rec.default_style_sheet,
display_rule_id = l_act_attachment_rec.display_rule_id,
display_url = l_act_attachment_rec.display_url,
display_program = l_act_attachment_rec.display_program,
attribute_category = l_act_attachment_rec.attribute_category,
attribute1 = l_act_attachment_rec.attribute1,
attribute2 = l_act_attachment_rec.attribute2,
attribute3 = l_act_attachment_rec.attribute3,
attribute4 = l_act_attachment_rec.attribute4,
attribute5 = l_act_attachment_rec.attribute5,
attribute6 = l_act_attachment_rec.attribute6,
attribute7 = l_act_attachment_rec.attribute7,
attribute8 = l_act_attachment_rec.attribute8,
attribute9 = l_act_attachment_rec.attribute9,
attribute10 = l_act_attachment_rec.attribute10,
attribute11 = l_act_attachment_rec.attribute11,
attribute12 = l_act_attachment_rec.attribute12,
attribute13 = l_act_attachment_rec.attribute13,
attribute14 = l_act_attachment_rec.attribute14,
attribute15 = l_act_attachment_rec.attribute15,
display_text = l_act_attachment_rec.display_text,
alternate_text = l_act_attachment_rec.alternate_text,
secured_flag = l_act_attachment_rec.secured_flag,
attachment_sub_type = l_act_attachment_rec.attachment_sub_type
WHERE attachment_id = l_act_attachment_rec.attachment_id
AND object_version_number = l_act_attachment_rec.object_version_number;
update jtf_amv_items_b
set last_update_date = sysdate,
last_updated_by = FND_GLOBAL.user_id,
last_update_login = FND_GLOBAL.conc_login_id
where item_id = l_act_attachment_rec.attachment_used_by_id;
ROLLBACK TO update_act_attachment;
ROLLBACK TO update_act_attachment;
ROLLBACK TO update_act_attachment;
END update_act_attachment;
SELECT attachment_id
FROM jtf_amv_attachments
WHERE attachment_id = p_act_attachment_id
AND object_version_number = p_object_version
FOR UPDATE OF attachment_id NOWAIT;
x_act_attachment_rec.last_update_date := FND_API.g_miss_date;
x_act_attachment_rec.last_updated_by := FND_API.g_miss_num;
x_act_attachment_rec.last_update_login := FND_API.g_miss_num;
SELECT *
FROM jtf_amv_attachments
WHERE attachment_id = p_act_attachment_rec.attachment_id;