[Home] [Help]
8207: --Category CUSTOM5340 corresponds to Modification Specific Exception. The user can use delete option
8208: -- to undo the changes for these attachments. Hence skipping this category in revert
8209: cursor get_to_be_deleted_attachments(p_header_id NUMBER,p_draft_id NUMBER, p_entity_name VARCHAR2) is
8210: select fad.attached_document_id , fd.datatype_id
8211: from fnd_attached_documents fad, fnd_documents fd
8212: where fad.entity_name = p_entity_name
8213: and fad.pk1_value = to_char(p_header_id) || '-' || to_char(p_draft_id)
8214: AND fd.document_id = fad.document_id
8215: AND fad.category_id <> (SELECT category_id
8390: --Category CUSTOM5340 corresponds to Modification Specific Exception. The user can use delete option
8391: -- to undo the changes for these attachments. Hence skipping this category in revert
8392: cursor get_to_be_deleted_attachments(p_line_location_id NUMBER,p_draft_id NUMBER, p_entity_name VARCHAR2) is
8393: select fad.attached_document_id , fd.datatype_id
8394: from fnd_attached_documents fad, fnd_documents fd
8395: where fad.entity_name = p_entity_name
8396: and fad.pk1_value = to_char(p_line_location_id) || '-' || to_char(p_draft_id)
8397: AND fd.document_id = fad.document_id
8398: AND fad.category_id <> (SELECT category_id
8492: --Category CUSTOM5340 corresponds to Modification Specific Exception. The user can use delete option
8493: -- to undo the changes for these attachments. Hence skipping this category in revert
8494: cursor get_to_be_deleted_attachments(p_line_id NUMBER,p_draft_id NUMBER,p_entity_name VARCHAR2) is
8495: select fad.attached_document_id , fd.datatype_id
8496: from fnd_attached_documents fad, fnd_documents fd
8497: where fad.entity_name = p_entity_name
8498: and fad.pk1_value = to_char(p_line_id) || '-' || to_char(p_draft_id)
8499: AND fd.document_id = fad.document_id
8500: AND fad.category_id <> (SELECT category_id