APPS.PVX_ATTACHMENT_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

  SELECT file_name
  FROM FND_lobs
  WHERE fnd_lobs.file_id =l_file_id;

Line: 165

PROCEDURE Delete_Attachments(
   p_api_version_number     IN  NUMBER
   ,p_init_msg_list         IN  VARCHAR2 := FND_API.g_false
   ,p_commit                IN  VARCHAR2 := FND_API.g_false
   ,p_quote_header_id       IN  NUMBER
   ,p_quote_attachment_ids  IN  JTF_VARCHAR2_TABLE_100
   ,x_return_status         OUT  NOCOPY VARCHAR2
   ,x_msg_count             OUT  NOCOPY NUMBER
   ,x_msg_data              OUT  NOCOPY VARCHAR2
)
IS
  l_api_name               CONSTANT VARCHAR2(30) := 'Delete_Attachments';

Line: 185

  SELECT a.media_id, b.document_id
  FROM FND_ATTACHED_DOCUMENTS b
       ,FND_DOCUMENTS_TL a
  WHERE a.document_id = b.document_id
  AND b.attached_document_id = l_attachment_id
  AND b.pk1_value = p_quote_header_id
  AND b.entity_name = 'PVATTACH';

Line: 194

  SELECT a.document_id
  FROM FND_ATTACHED_DOCUMENTS a
  WHERE a.document_id = p_document_id
  AND a.pk1_value <> p_quote_header_id;

Line: 203

  SAVEPOINT  DELETE_ATTACHMENTS_PVT;

Line: 222

      'DELETE_ATTACHMENTS: quote_header_id ' || p_quote_header_id,
      1,
      'Y'
    );

Line: 236

      aso_debug_pub.add ('DELETE_ATTACHMENTS: quote_attachment_id ' || p_quote_attachment_ids(i),1,'Y');

Line: 268

           aso_debug_pub.add ('DELETE_ATTACHMENTS: l_document_id : ' || l_document_id,1,'Y');

Line: 275

    FND_ATTACHED_DOCUMENTS3_PKG.delete_row ( p_quote_attachment_ids(i),
                                           '6', 'N' );

Line: 279

       aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Check to see if the attachment was from an Opportunity...', 1, 'Y');

Line: 289

         aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is not from an Opportunity...', 1, 'Y');

Line: 291

      DELETE FROM fnd_lobs WHERE file_id = l_media_id;

Line: 294

         aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is from an Opportunity...', 1, 'Y');

Line: 356

END Delete_Attachments;