[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT decode(count(1), 0, 'N', 'Y')
INTO l_has_attachments
FROM fnd_attached_documents
WHERE entity_name = p_entity_name AND
decode(p_pk1_value, null, -1, pk1_value) = decode(p_pk1_value, null, -1, p_pk1_value) AND
decode(p_pk2_value, null, -1, pk2_value) = decode(p_pk2_value, null, -1, p_pk2_value) AND
decode(p_pk3_value, null, -1, pk3_value) = decode(p_pk3_value, null, -1, p_pk3_value) AND
decode(p_pk4_value, null, -1, pk4_value) = decode(p_pk4_value, null, -1, p_pk4_value) AND
decode(p_pk5_value, null, -1, pk5_value) = decode(p_pk5_value, null, -1, p_pk5_value) AND
rownum = 1;
INSERT INTO fnd_lobs (
file_id,
file_content_type,
file_name,
file_format,
file_data) VALUES (
fnd_lobs_s.nextval,
p_file_content_type,
p_file_name,
p_file_format,
empty_blob())
RETURNING file_id INTO l_file_id;
l_last_update_date date := SYSDATE;
l_last_updated_by number;
l_last_updated_by := l_created_by;
SELECT fnd_attached_documents_s.nextval
INTO l_attached_document_id
FROM sys.dual;
SELECT USERENV('LANG')
INTO l_lang
FROM dual;
fnd_attached_documents_pkg.insert_row (
x_rowid => l_rowid ,
x_attached_document_id => l_attached_document_id ,
x_document_id => l_document_id ,
x_creation_date => l_creation_date ,
x_created_by => l_created_by ,
x_last_update_date => l_last_update_date ,
x_last_updated_by => l_last_updated_by ,
x_last_update_login => NULL ,
x_seq_num => p_seq_num ,
x_entity_name => p_entity_name ,
x_column1 => p_column1 ,
x_pk1_value => p_pk1_value ,
x_pk2_value => p_pk2_value ,
x_pk3_value => p_pk3_value ,
x_pk4_value => p_pk4_value ,
x_pk5_value => p_pk5_value ,
x_automatically_added_flag => 'N' ,
x_request_id => NULL ,
x_program_application_id =>NULL ,
x_program_id => NULL ,
x_program_update_date => NULL ,
x_attribute_category => NULL ,
x_attribute1 => NULL ,
x_attribute2 => NULL ,
x_attribute3 => NULL ,
x_attribute4 => NULL ,
x_attribute5 => NULL ,
x_attribute6 => NULL ,
x_attribute7 => NULL ,
x_attribute8 => NULL ,
x_attribute9 => NULL ,
x_attribute10 => NULL ,
x_attribute11 => NULL ,
x_attribute12 => NULL ,
x_attribute13 => NULL ,
x_attribute14 => NULL ,
x_attribute15 => NULL ,
x_datatype_id => p_datatype_id ,
x_category_id => p_category_id ,
x_security_type => 4 ,
x_security_id => NULL ,
x_publish_flag => 'Y' ,
x_image_type => NULL ,
x_storage_type => NULL ,
x_usage_type => 'O' ,
x_language => l_lang ,
x_description => p_document_description ,
x_file_name => l_file_name ,
x_media_id => l_media_id ,
x_doc_attribute_category => NULL ,
x_doc_attribute1 => NULL ,
x_doc_attribute2 => NULL ,
x_doc_attribute3 => NULL ,
x_doc_attribute4 => NULL ,
x_doc_attribute5 => NULL ,
x_doc_attribute6 => NULL ,
x_doc_attribute7 => NULL ,
x_doc_attribute8 => NULL ,
x_doc_attribute9 => NULL ,
x_doc_attribute10 => NULL ,
x_doc_attribute11 => NULL ,
x_doc_attribute12 => NULL ,
x_doc_attribute13 => NULL ,
x_doc_attribute14 => NULL ,
x_doc_attribute15 => NULL
);
INSERT INTO fnd_documents_short_text(
media_id,
short_text)
VALUES (
l_media_id,
p_short_text);
l_last_update_date date := SYSDATE;
l_last_updated_by number;
l_last_updated_by := l_created_by;
SELECT fnd_attached_documents_s.nextval
INTO l_attached_document_id
FROM sys.dual;
SELECT USERENV('LANG')
INTO l_lang
FROM dual;
fnd_attached_documents_pkg.insert_row (
x_rowid => l_rowid ,
x_attached_document_id => l_attached_document_id ,
x_document_id => l_document_id ,
x_creation_date => l_creation_date ,
x_created_by => l_created_by ,
x_last_update_date => l_last_update_date ,
x_last_updated_by => l_last_updated_by ,
x_last_update_login => NULL ,
x_seq_num => p_seq_num ,
x_entity_name => p_entity_name ,
x_column1 => p_column1 ,
x_pk1_value => p_pk1_value ,
x_pk2_value => p_pk2_value ,
x_pk3_value => p_pk3_value ,
x_pk4_value => p_pk4_value ,
x_pk5_value => p_pk5_value ,
x_automatically_added_flag => 'N' ,
x_request_id => NULL ,
x_program_application_id =>NULL ,
x_program_id => NULL ,
x_program_update_date => NULL ,
x_attribute_category => NULL ,
x_attribute1 => NULL ,
x_attribute2 => NULL ,
x_attribute3 => NULL ,
x_attribute4 => NULL ,
x_attribute5 => NULL ,
x_attribute6 => NULL ,
x_attribute7 => NULL ,
x_attribute8 => NULL ,
x_attribute9 => NULL ,
x_attribute10 => NULL ,
x_attribute11 => NULL ,
x_attribute12 => NULL ,
x_attribute13 => NULL ,
x_attribute14 => NULL ,
x_attribute15 => NULL ,
x_datatype_id => PON_ATTACHMENTS.LONG_TEXT ,
x_category_id => p_category_id ,
x_security_type => 4 ,
x_security_id => NULL ,
x_publish_flag => 'Y' ,
x_image_type => NULL ,
x_storage_type => NULL ,
x_usage_type => 'O' ,
x_language => l_lang ,
x_description => p_document_description ,
x_file_name => l_file_name ,
x_media_id => l_media_id ,
x_doc_attribute_category => NULL ,
x_doc_attribute1 => NULL ,
x_doc_attribute2 => NULL ,
x_doc_attribute3 => NULL ,
x_doc_attribute4 => NULL ,
x_doc_attribute5 => NULL ,
x_doc_attribute6 => NULL ,
x_doc_attribute7 => NULL ,
x_doc_attribute8 => NULL ,
x_doc_attribute9 => NULL ,
x_doc_attribute10 => NULL ,
x_doc_attribute11 => NULL ,
x_doc_attribute12 => NULL ,
x_doc_attribute13 => NULL ,
x_doc_attribute14 => NULL ,
x_doc_attribute15 => NULL
);
INSERT INTO fnd_documents_long_text
(
media_id,
long_text
) VALUES (
l_media_id,
p_long_text
);
l_last_update_date date := SYSDATE;
l_last_updated_by number;
Select USERENV('LANG') into l_lang
From Dual;
Select FND_ATTACHED_DOCUMENTS_S.nextval
Into l_attached_document_id
From Dual
;
Select DTL.FILE_NAME, D.MEDIA_ID, DTL.DESCRIPTION,
D.DATATYPE_ID, D.CATEGORY_ID, D.USAGE_TYPE,
DTL.DOC_ATTRIBUTE_CATEGORY, DTL.DOC_ATTRIBUTE1,
DTL.DOC_ATTRIBUTE2, DTL.DOC_ATTRIBUTE3,
DTL.DOC_ATTRIBUTE4, DTL.DOC_ATTRIBUTE5,
DTL.DOC_ATTRIBUTE6, DTL.DOC_ATTRIBUTE7,
DTL.DOC_ATTRIBUTE8, DTL.DOC_ATTRIBUTE9,
DTL.DOC_ATTRIBUTE10, DTL.DOC_ATTRIBUTE11,
DTL.DOC_ATTRIBUTE12, DTL.DOC_ATTRIBUTE13,
DTL.DOC_ATTRIBUTE14, DTL.DOC_ATTRIBUTE15
Into l_file_name, l_media_id, l_description,
l_datatype_id, l_category_id, l_usage_type,
l_doc_attribute_category, l_doc_attribute1,
l_doc_attribute2, l_doc_attribute3,
l_doc_attribute4, l_doc_attribute5,
l_doc_attribute6, l_doc_attribute7,
l_doc_attribute8, l_doc_attribute9,
l_doc_attribute10, l_doc_attribute11,
l_doc_attribute12, l_doc_attribute13,
l_doc_attribute14, l_doc_attribute15
From FND_DOCUMENTS D, FND_DOCUMENTS_TL DTL
Where DTL.DOCUMENT_ID = D.DOCUMENT_ID
And DTL.DOCUMENT_ID = l_document_id
And DTL.LANGUAGE = l_lang
;
l_last_updated_by := l_created_by;
fnd_attached_documents_pkg.insert_row (
x_rowid => l_rowid ,
x_attached_document_id => l_attached_document_id ,
x_document_id => l_document_id ,
x_creation_date => l_creation_date ,
x_created_by => l_created_by ,
x_last_update_date => l_last_update_date ,
x_last_updated_by => l_last_updated_by ,
x_last_update_login => NULL ,
x_seq_num => p_seq_num ,
x_entity_name => p_entity_name ,
x_column1 => p_column1 ,
x_pk1_value => p_pk1_value ,
x_pk2_value => p_pk2_value ,
x_pk3_value => p_pk3_value ,
x_pk4_value => p_pk4_value ,
x_pk5_value => p_pk5_value ,
x_automatically_added_flag => 'N' ,
x_request_id => NULL ,
x_program_application_id =>NULL ,
x_program_id => NULL ,
x_program_update_date => NULL ,
x_attribute_category => NULL ,
x_attribute1 => NULL ,
x_attribute2 => NULL ,
x_attribute3 => NULL ,
x_attribute4 => NULL ,
x_attribute5 => NULL ,
x_attribute6 => NULL ,
x_attribute7 => NULL ,
x_attribute8 => NULL ,
x_attribute9 => NULL ,
x_attribute10 => NULL ,
x_attribute11 => NULL ,
x_attribute12 => NULL ,
x_attribute13 => NULL ,
x_attribute14 => NULL ,
x_attribute15 => NULL ,
x_datatype_id => l_datatype_id ,
x_category_id => l_category_id ,
x_security_type => 4 ,
x_security_id => NULL ,
x_publish_flag => 'Y' ,
x_image_type => NULL ,
x_storage_type => NULL ,
x_usage_type => l_usage_type ,
x_language => l_lang ,
x_description => l_description ,
x_file_name => l_file_name ,
x_media_id => l_media_id ,
x_doc_attribute_category => l_doc_attribute_category ,
x_doc_attribute1 => l_doc_attribute1 ,
x_doc_attribute2 => l_doc_attribute2 ,
x_doc_attribute3 => l_doc_attribute3 ,
x_doc_attribute4 => l_doc_attribute4 ,
x_doc_attribute5 => l_doc_attribute5 ,
x_doc_attribute6 => l_doc_attribute6 ,
x_doc_attribute7 => l_doc_attribute7 ,
x_doc_attribute8 => l_doc_attribute8 ,
x_doc_attribute9 => l_doc_attribute9 ,
x_doc_attribute10 => l_doc_attribute10 ,
x_doc_attribute11 => l_doc_attribute11 ,
x_doc_attribute12 => l_doc_attribute12 ,
x_doc_attribute13 => l_doc_attribute13 ,
x_doc_attribute14 => l_doc_attribute14 ,
x_doc_attribute15 => l_doc_attribute15 ,
x_create_doc => l_create_doc
);
PROCEDURE delete_attachment(
p_attached_document_id in NUMBER,
p_datatype_id in NUMBER
) IS
l_attached_document_id Number := delete_attachment.p_attached_document_id;
Select doc.Usage_Type Into l_usage_type
From Fnd_Documents doc
Where doc.Document_Id =
(
Select att.Document_Id
From Fnd_Attached_Documents att
Where att.Attached_Document_Id = l_attached_document_id
);
Select Count(*) Into l_attached_count
From Fnd_Attached_Documents
Where Document_Id =
(
Select a.Document_Id
From Fnd_Attached_Documents a
Where a.Attached_Document_Id = l_attached_document_id
);
fnd_attached_documents3_pkg.delete_row (
l_attached_document_id,
p_datatype_id,
'Y'
);
fnd_attached_documents3_pkg.delete_row (
l_attached_document_id,
p_datatype_id,
'N'
);
END delete_attachment;