APPS.OE_ATCHMT_UTIL SQL Statements

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

Line: 108

               SELECT line_number
               INTO l_line_number
               FROM oe_order_lines
               WHERE line_id = p_entity_id;

Line: 167

PROCEDURE Delete_Attachments
(
 p_entity_code                     in   varchar2,
 p_entity_id                       in   number,
x_return_status out nocopy varchar2

)
------------------------------------------
IS
l_entity_name					VARCHAR2(30);

Line: 189

		FND_ATTACHED_DOCUMENTS2_PKG.Delete_Attachments
			(x_entity_name		=> l_entity_name
			,x_pk1_value		=> to_char(p_entity_id)
			,x_automatically_added_flag	=> null
                -- Bug 3280106
                -- Delete all FND one-time documents specific to this entity
                        ,x_delete_document_flag => 'Y'
			);

Line: 211

            ,   'Delete_Attachments'
			);

Line: 214

END Delete_Attachments;

Line: 337

      select (nvl(max(seq_num),0) + 10)
      into l_seq_num
      from fnd_attached_documents
      where entity_name = l_entity_name
        and pk1_value = to_char(p_entity_id);