APPS.RCV_ASN_ATTACHMENT_PKG SQL Statements

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

Line: 33

  l_last_update_login		NUMBER;

Line: 38

    select rti.asn_attach_id,rti.created_by,rti.last_update_login
    from   fnd_attached_documents fad,
           rcv_transactions_interface rti
    where  rti.interface_transaction_id = p_interface_txn_id
    and    rti.asn_attach_id is not null
    and    to_char(rti.asn_attach_id) = fad.PK1_value
    and    fad.entity_name = 'ASN_ATTACH';

Line: 63

	  l_asn_attach_id,l_created_by,l_last_update_login;

Line: 87

	x_last_update_login		=> l_last_update_login);

Line: 137

PROCEDURE delete_asn_intf_attachments (
		p_api_version		IN 	NUMBER,
		p_init_msg_list		IN  	VARCHAR2,
		x_return_status		OUT 	NOCOPY VARCHAR2,
		x_msg_count         	OUT 	NOCOPY NUMBER,
		x_msg_data          	OUT 	NOCOPY VARCHAR2 )

IS

  l_counter		NUMBER;

Line: 148

  l_api_name	CONSTANT VARCHAR2(30) := 'DELETE_ASN_INTF_ATTACHMENTS';

Line: 175

          delete_line_attachment (
		p_api_version	=> p_api_version,
		p_init_msg_list	=> p_init_msg_list,
                x_return_status => x_return_status,
		x_msg_count	=> x_msg_count,
		x_msg_data	=> x_msg_data,
		p_asn_attach_id => l_asn_attach_id );

Line: 209

END delete_asn_intf_attachments;

Line: 213

PROCEDURE delete_line_attachment (
		p_api_version		IN 	NUMBER,
		p_init_msg_list		IN  	VARCHAR2,
		x_return_status		OUT 	NOCOPY VARCHAR2,
		x_msg_count		OUT 	NOCOPY NUMBER,
		x_msg_data          	OUT 	NOCOPY VARCHAR2,
		p_asn_attach_id 	IN  	NUMBER )

IS

  l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_LINE_ATTACHMENT';

Line: 227

  l_delete_doc_flag	VARCHAR2(1) := 'Y';

Line: 230

      SELECT FD.datatype_id
      FROM   FND_DOCUMENTS FD,
             FND_ATTACHED_DOCUMENTS FAD
      WHERE  FAD.entity_name = 'ASN_ATTACH'
      AND    FAD.pk1_value = to_char(p_asn_attach_id)
      AND    FD.document_id = FAD.document_id;

Line: 274

    /* Do not delete URL document since it was not copied. */
    IF (l_datatype_id = 5) THEN
       l_delete_doc_flag := 'N';

Line: 280

      fnd_attached_documents2_pkg.delete_attachments(
		X_entity_name 		=> 'ASN_ATTACH',
		X_pk1_value 		=> to_char(p_asn_attach_id),
		X_delete_document_flag 	=> l_delete_doc_flag);

Line: 306

END delete_line_attachment;