[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_attached_document_id IN OUT NOCOPY NUMBER,
X_document_id IN OUT NOCOPY NUMBER,
X_creation_date DATE,
X_created_by NUMBER,
X_last_update_date DATE,
X_last_updated_by NUMBER,
X_last_update_login NUMBER DEFAULT NULL,
X_seq_num NUMBER,
X_entity_name VARCHAR2,
X_column1 VARCHAR2,
X_pk1_value VARCHAR2,
X_pk2_value VARCHAR2,
X_pk3_value VARCHAR2,
X_pk4_value VARCHAR2,
X_pk5_value VARCHAR2,
X_automatically_added_flag VARCHAR2,
X_request_id NUMBER DEFAULT NULL,
X_program_application_id NUMBER DEFAULT NULL,
X_program_id NUMBER DEFAULT NULL,
X_program_update_date DATE DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
/* columns necessary for creating a document on the fly */
X_datatype_id NUMBER,
X_category_id NUMBER,
X_security_type NUMBER,
X_security_id NUMBER DEFAULT NULL,
X_publish_flag VARCHAR2,
X_image_type VARCHAR2 DEFAULT NULL,
X_storage_type NUMBER DEFAULT NULL,
X_usage_type VARCHAR2,
X_language VARCHAR2,
X_description VARCHAR2 DEFAULT NULL,
X_file_name VARCHAR2 DEFAULT NULL,
X_media_id IN OUT NOCOPY NUMBER,
X_doc_attribute_Category VARCHAR2,
X_doc_attribute1 VARCHAR2,
X_doc_attribute2 VARCHAR2,
X_doc_attribute3 VARCHAR2,
X_doc_attribute4 VARCHAR2,
X_doc_attribute5 VARCHAR2,
X_doc_attribute6 VARCHAR2,
X_doc_attribute7 VARCHAR2,
X_doc_attribute8 VARCHAR2,
X_doc_attribute9 VARCHAR2,
X_doc_attribute10 VARCHAR2,
X_doc_attribute11 VARCHAR2,
X_doc_attribute12 VARCHAR2,
X_doc_attribute13 VARCHAR2,
X_doc_attribute14 VARCHAR2,
X_doc_attribute15 VARCHAR2,
X_create_doc VARCHAR2 DEFAULT 'N',
X_url VARCHAR2 DEFAULT NULL,
X_title VARCHAR2 DEFAULT NULL) IS
tmp_rowid VARCHAR2(30);
CURSOR C IS SELECT rowid
FROM fnd_attached_documents
WHERE attached_document_id = X_attached_document_id;
fnd_documents_pkg.insert_row(
X_rowid => tmp_rowid,
X_document_id => X_document_id,
X_creation_date => X_creation_date,
X_created_by => X_created_by,
X_last_update_date => X_last_update_date,
X_last_updated_by => X_last_updated_by,
X_last_update_login => X_last_update_login,
X_datatype_id => X_datatype_id,
X_category_id => X_category_id,
X_security_type => X_security_type,
X_security_id => X_security_id,
X_publish_flag => X_publish_flag,
X_image_type => X_image_type,
X_storage_type => X_storage_type,
X_usage_type => NVL(l_usage_type,'O'),
X_start_date_active => null,
X_end_date_active => null,
X_request_id => X_request_id,
X_program_application_id => X_program_application_id,
X_program_id => X_program_id,
X_program_update_date => X_program_update_date,
X_language => X_language,
X_description => X_description,
X_file_name => X_file_name,
X_media_id => X_media_id,
X_attribute_category => X_doc_attribute_category,
X_attribute1 => X_doc_attribute1,
X_attribute2 => X_doc_attribute2,
X_attribute3 => X_doc_attribute3,
X_attribute4 => X_doc_attribute4,
X_attribute5 => X_doc_attribute5,
X_attribute6 => X_doc_attribute6,
X_attribute7 => X_doc_attribute7,
X_attribute8 => X_doc_attribute8,
X_attribute9 => X_doc_attribute9,
X_attribute10 => X_doc_attribute10,
X_attribute11 => X_doc_attribute11,
X_attribute12 => X_doc_attribute12,
X_attribute13 => X_doc_attribute13,
X_attribute14 => X_doc_attribute14,
X_attribute15 => X_doc_attribute15,
X_create_doc => l_create_doc,
X_url => X_url,
X_title => X_title);
INSERT INTO fnd_attached_documents (
attached_document_id,
document_id,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
seq_num,
entity_name,
column1,
pk1_value,
pk2_value,
pk3_value,
pk4_value,
pk5_value,
automatically_added_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
category_id) VALUES (
X_attached_document_id,
X_document_id,
X_creation_date,
X_created_by,
X_last_update_date,
X_last_updated_by,
X_last_update_login,
X_seq_num,
X_entity_name,
X_column1,
X_pk1_value,
X_pk2_value,
X_pk3_value,
X_pk4_value,
X_pk5_value,
X_automatically_added_flag,
X_attribute_category,
X_attribute1,
X_attribute2,
X_attribute3,
X_attribute4,
X_attribute5,
X_attribute6,
X_attribute7,
X_attribute8,
X_attribute9,
X_attribute10,
X_attribute11,
X_attribute12,
X_attribute13,
X_attribute14,
X_attribute15,
X_category_id);
END insert_row;
SELECT *
FROM fnd_attached_documents
WHERE rowid = X_Rowid
FOR UPDATE of attached_document_id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_attached_document_id NUMBER,
X_document_id NUMBER,
X_last_update_date DATE,
X_last_updated_by NUMBER,
X_last_update_login NUMBER DEFAULT NULL,
X_seq_num NUMBER,
X_entity_name VARCHAR2,
X_column1 VARCHAR2,
X_pk1_value VARCHAR2,
X_pk2_value VARCHAR2,
X_pk3_value VARCHAR2,
X_pk4_value VARCHAR2,
X_pk5_value VARCHAR2,
X_automatically_added_flag VARCHAR2,
X_request_id NUMBER DEFAULT NULL,
X_program_application_id NUMBER DEFAULT NULL,
X_program_id NUMBER DEFAULT NULL,
X_program_update_date DATE DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
/* columns necessary for creating a document on the fly */
X_datatype_id NUMBER,
X_category_id NUMBER,
X_security_type NUMBER,
X_security_id NUMBER DEFAULT NULL,
X_publish_flag VARCHAR2,
X_image_type VARCHAR2 DEFAULT NULL,
X_storage_type NUMBER DEFAULT NULL,
X_usage_type VARCHAR2,
X_start_date_active DATE,
X_end_date_active DATE,
X_language VARCHAR2,
X_description VARCHAR2 DEFAULT NULL,
X_file_name VARCHAR2 DEFAULT NULL,
X_media_id IN OUT NOCOPY NUMBER,
X_doc_attribute_category VARCHAR2 DEFAULT NULL,
X_doc_attribute1 VARCHAR2 DEFAULT NULL,
X_doc_attribute2 VARCHAR2 DEFAULT NULL,
X_doc_attribute3 VARCHAR2 DEFAULT NULL,
X_doc_attribute4 VARCHAR2 DEFAULT NULL,
X_doc_attribute5 VARCHAR2 DEFAULT NULL,
X_doc_attribute6 VARCHAR2 DEFAULT NULL,
X_doc_attribute7 VARCHAR2 DEFAULT NULL,
X_doc_attribute8 VARCHAR2 DEFAULT NULL,
X_doc_attribute9 VARCHAR2 DEFAULT NULL,
X_doc_attribute10 VARCHAR2 DEFAULT NULL,
X_doc_attribute11 VARCHAR2 DEFAULT NULL,
X_doc_attribute12 VARCHAR2 DEFAULT NULL,
X_doc_attribute13 VARCHAR2 DEFAULT NULL,
X_doc_attribute14 VARCHAR2 DEFAULT NULL,
X_doc_attribute15 VARCHAR2 DEFAULT NULL,
X_url VARCHAR2 DEFAULT NULL,
X_title VARCHAR2 DEFAULT NULL) IS
BEGIN
-- Update the attached_documents table
UPDATE fnd_attached_documents
SET attached_document_id = X_attached_document_id,
document_id = X_document_id,
last_update_date = X_last_update_date,
last_updated_by = X_last_updated_by,
last_update_login = X_last_update_login,
seq_num = X_seq_num,
entity_name = X_entity_name,
column1 = X_column1,
pk1_value = X_pk1_value,
pk2_value = X_pk2_value,
pk3_value = X_pk3_value,
pk4_value = X_pk4_value,
pk5_value = X_pk5_value,
automatically_added_flag = X_automatically_added_flag,
attribute_category = X_attribute_category,
attribute1 = X_attribute1,
attribute2 = X_attribute2,
attribute3 = X_attribute3,
attribute4 = X_attribute4,
attribute5 = X_attribute5,
attribute6 = X_attribute6,
attribute7 = X_attribute7,
attribute8 = X_attribute8,
attribute9 = X_attribute9,
attribute10 = X_attribute10,
attribute11 = X_attribute11,
attribute12 = X_attribute12,
attribute13 = X_attribute13,
attribute14 = X_attribute14,
attribute15 = X_attribute15,
category_id = X_category_id
WHERE rowid = X_rowid;
fnd_documents_pkg.Update_Row(X_document_id => X_document_id,
X_last_update_date => X_last_update_date,
X_last_updated_by => X_last_updated_by,
X_last_update_login => X_last_update_login,
X_datatype_id => X_datatype_id,
X_category_id => X_category_id,
X_security_type => X_security_type,
X_security_id => X_security_id,
X_publish_flag => X_publish_flag,
X_image_type => X_image_type,
X_storage_type => X_storage_type,
X_usage_type => X_usage_type,
X_start_date_active => X_start_date_active,
X_end_date_active => X_end_date_active,
X_language => X_language,
X_description => X_description,
X_file_name => X_file_name,
X_media_id => X_media_id,
X_Attribute_Category => X_doc_attribute_category,
X_Attribute1 => X_doc_attribute1,
X_Attribute2 => X_doc_attribute2,
X_Attribute3 => X_doc_attribute3,
X_Attribute4 => X_doc_attribute4,
X_Attribute5 => X_doc_attribute5,
X_Attribute6 => X_doc_attribute6,
X_Attribute7 => X_doc_attribute7,
X_Attribute8 => X_doc_attribute8,
X_Attribute9 => X_doc_attribute9,
X_Attribute10 => X_doc_attribute10,
X_Attribute11 => X_doc_attribute11,
X_Attribute12 => X_doc_attribute12,
X_Attribute13 => X_doc_attribute13,
X_Attribute14 => X_doc_attribute14,
X_Attribute15 => X_doc_attribute15,
X_url => X_url,
X_title => X_title);
END update_row;