[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM fnd_documents_vl
WHERE document_id = l_document_id;
SELECT rowid, attached_document_id, seq_num
FROM fnd_attached_documents
WHERE entity_name = l_entity_name AND
NVL(pk1_value,'NULL') = NVL(l_pk1_value,'NULL') AND
NVL(pk2_value,'NULL') = NVL(l_pk2_value,'NULL') AND
NVL(pk3_value,'NULL') = NVL(l_pk3_value,'NULL') AND
NVL(pk4_value,'NULL') = NVL(l_pk4_value,'NULL') AND
NVL(pk5_value,'NULL') = NVL(l_pk5_value,'NULL') AND
attribute_category = l_doc.doc_attribute_category AND
attribute1 = l_doc.doc_attribute1 AND
attribute2 = l_doc.doc_attribute2 AND
attribute3 = l_doc.doc_attribute3 AND
attribute4 = l_doc.doc_attribute4 AND
attribute5 = l_doc.doc_attribute5;
SELECT fnd_attached_documents_s.nextval
FROM dual;
SELECT NVL(max(seq_num),0) + 10
FROM fnd_attached_documents
WHERE entity_name = l_entity_name AND
NVL(pk1_value,'NULL') = NVL(l_pk1_value,'NULL') AND
NVL(pk2_value,'NULL') = NVL(l_pk2_value,'NULL') AND
NVL(pk3_value,'NULL') = NVL(l_pk3_value,'NULL') AND
NVL(pk4_value,'NULL') = NVL(l_pk4_value,'NULL') AND
NVL(pk5_value,'NULL') = NVL(l_pk5_value,'NULL');
SELECT category_id
FROM fnd_document_categories
WHERE name = 'MSDS_REJECTED';
SELECT FUNCTION_NAME
FROM FND_DOC_CATEGORY_USAGES_VL
WHERE name in ('MSDS_REG_ITEM', 'MSDS_INV_ITEM', 'MSDS_SALES_ORDER');
SELECT delivery_detail_id
FROM WSH_DELIVERABLES_V
WHERE container_flag = 'N'
and source_code = 'OE'
and released_status in ('N', 'R', 'S', 'Y', 'B', 'X')
and inventory_item_id = (select distinct inventory_item_id from mtl_system_items where segment1 = l_doc.doc_attribute1)
and organization_id = (SELECT organization_id FROM mtl_parameters WHERE organization_code = l_doc.doc_attribute5)
and source_header_number = l_doc.doc_attribute8
and source_line_number = to_number(l_doc.doc_attribute9)
Order by delivery_detail_id;
/* M. Thomas Bug 3211481 14-May-2004 Added the following to update the key fields for the attached document for a Shipment */
IF (l_category_name = 'MSDS_SALES_ORDER') THEN
/* M.Thomas 3756011 07/09/2004 the following code has been added in order to insert/update
the primary key delivery detail line id instead of sales order number for the entity WSH_DELIVERY_DETAILS */
/* Get the Primary Key delivery Detail Id for the entity WSH_DELIVERY_DETAILS */
OPEN c_get_delivery_detail_id;
FND_ATTACHED_DOCUMENTS_PKG.Insert_Row(X_Rowid => l_Rowid,
X_attached_document_id => l_attached_document_id,
X_document_id => l_doc.document_id,
X_creation_date => SYSDATE,
X_created_by => l_doc.created_by,
X_last_update_date => SYSDATE,
X_last_updated_by => l_doc.last_updated_by,
X_last_update_login => NULL,
X_seq_num => l_seq,
X_entity_name => l_entity_name,
X_column1 => NULL,
X_pk1_value => l_pk1_value,
X_pk2_value => l_pk2_value,
X_pk3_value => l_pk3_value,
X_pk4_value => l_pk4_value,
X_pk5_value => l_pk5_value,
X_automatically_added_flag => 'Y',
X_datatype_id => l_doc.datatype_id,
X_category_id => l_doc.category_id,
X_security_type => l_doc.security_type,
X_security_id => l_doc.security_id,
X_publish_flag => l_doc.publish_flag,
X_storage_type => l_doc.storage_type,
X_usage_type => l_doc.usage_type,
X_language => l_doc.doc_attribute3,
X_description => l_doc.description,
X_file_name => l_doc.file_name,
X_media_id => l_doc.media_id,
X_attribute_category => l_doc.doc_attribute_category,
X_attribute1 => l_doc.doc_attribute1,
X_attribute2 => l_doc.doc_attribute2,
X_attribute3 => l_doc.doc_attribute3,
X_attribute4 => l_doc.doc_attribute4,
X_attribute5 => l_doc.doc_attribute5,
X_attribute6 => l_doc.doc_attribute6,
X_attribute7 => l_doc.doc_attribute7,
X_attribute8 => l_doc.doc_attribute8,
X_attribute9 => l_doc.doc_attribute9,
X_attribute10 => l_doc.doc_attribute10,
X_attribute11 => l_doc.doc_attribute11,
X_attribute12 => l_doc.doc_attribute12,
X_attribute13 => l_doc.doc_attribute13,
X_attribute14 => l_doc.doc_attribute14,
X_attribute15 => l_doc.doc_attribute15,
X_create_doc => 'N');
/* The attachment already exists so we will just update it with the new file */
fnd_attached_documents_pkg.update_row(
X_rowid => l_Rowid,
X_attached_document_id => l_attached_document_id,
X_document_id => l_document_id,
X_last_update_date => SYSDATE,
X_last_updated_by => l_doc.last_updated_by,
X_last_update_login => NULL,
X_seq_num => l_seq,
X_column1 => NULL,
X_entity_name => l_entity_name,
X_pk1_value => l_pk1_value,
X_pk2_value => l_pk2_value,
X_pk3_value => l_pk3_value,
X_pk4_value => l_pk4_value,
X_pk5_value => l_pk5_value,
X_automatically_added_flag => 'Y',
X_request_id => NULL,
X_program_application_id => NULL,
X_program_id => NULL,
X_program_update_date => NULL,
X_attribute_category => l_doc.doc_attribute_category,
X_attribute1 => l_doc.doc_attribute1,
X_attribute2 => l_doc.doc_attribute2,
X_attribute3 => l_doc.doc_attribute3,
X_attribute4 => l_doc.doc_attribute4,
X_attribute5 => l_doc.doc_attribute5,
X_attribute6 => l_doc.doc_attribute6,
X_attribute7 => l_doc.doc_attribute7,
X_attribute8 => l_doc.doc_attribute8,
X_attribute9 => l_doc.doc_attribute9,
X_attribute10 => l_doc.doc_attribute10,
X_attribute11 => l_doc.doc_attribute11,
X_attribute12 => l_doc.doc_attribute12,
X_attribute13 => l_doc.doc_attribute13,
X_attribute14 => l_doc.doc_attribute14,
X_attribute15 => l_doc.doc_attribute15,
X_datatype_id => l_doc.datatype_id,
X_category_id => l_doc.category_id,
X_security_type => l_doc.security_type,
X_security_id => l_doc.security_id,
X_publish_flag => l_doc.publish_flag,
X_image_type => l_doc.image_type,
X_storage_type => l_doc.storage_type,
X_usage_type => l_doc.usage_type,
X_start_date_active => SYSDATE,
X_end_date_active => NULL ,
X_language => l_doc.doc_attribute3,
X_description => l_doc.description,
X_file_name => l_doc.file_name,
X_media_id => l_doc.media_id);
UPDATE fnd_documents
SET category_id = l_category_id
WHERE document_id = l_document_id;