APPS.ASO_ATTACHMENT_INT SQL Statements

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

Line: 160

    SELECT quote_line_id
      FROM aso_shipments
     WHERE shipment_id = l_shipment_id;

Line: 297

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 /* file.sql.39 change */  VARCHAR2
   ,x_msg_count             OUT NOCOPY /* file.sql.39 change */  NUMBER
   ,x_msg_data              OUT NOCOPY /* file.sql.39 change */  VARCHAR2
)
IS
  l_api_name               CONSTANT VARCHAR2(30) := 'Delete_Attachments';

Line: 317

  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 = 'ASO_QUOTE_HEADERS_ALL';

Line: 326

  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: 335

  SAVEPOINT  DELETE_ATTACHMENTS_PVT;

Line: 354

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

Line: 368

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

Line: 400

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

Line: 407

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

Line: 411

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

Line: 421

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

Line: 423

      DELETE FROM fnd_lobs WHERE file_id = l_media_id;

Line: 426

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

Line: 435

    FND_WEBATTCH.DeleteAttachment(
        attached_document_id    => p_quote_attachment_ids(i),
        function_name           => NULL,
        entity_name             => 'ASO_QUOTE_HEADERS_ALL',
        pk1_value               => p_quote_header_id,
        pk2_value               => NULL,
        pk3_value               => NULL,
        pk4_value               => NULL,
        pk5_value               => NULL,
        from_url                => NULL,
        query_only              => 'N'
    );

Line: 502

END Delete_Attachments;