APPS.OE_FND_ATTACHMENTS_PUB SQL Statements

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

Line: 38

   l_program_update_date 	date  :=null;

Line: 45

      SELECT 'Y'
      FROM FND_ATTACHED_DOCUMENTS
      WHERE document_id = p_document_id
      AND   entity_name = p_entity_name
      AND    pk1_value   = p_pk1_value
      AND    (pk2_value IS NULL
           OR  pk2_value = p_pk2_value)
      AND    (pk3_value IS NULL
           OR  pk3_value = p_pk3_value)
      AND    (pk2_value IS NULL
           OR  pk4_value = p_pk4_value)
      AND    (pk2_value IS NULL
           OR  pk5_value = p_pk5_value);

Line: 156

      SELECT 'Y'
      FROM FND_DOCUMENTS
      WHERE document_id = cp_document_id;

Line: 408

   l_program_update_date 	date  :=null;

Line: 412

      SELECT 'Yes'
      FROM FND_DOCUMENT_CATEGORIES
      WHERE category_id = p_document_category;

Line: 450

      l_program_update_date := l_curr_date;

Line: 482

       oe_debug_pub.add(  'OFA:CREATE_SHORT_TEXT_DOCUMENT:INSERING A ROW-> FND_DOCUMENTS_PKG.INSERT_ROW' ) ;

Line: 485

   fnd_documents_pkg.insert_row (
                        x_rowid		=> l_rowid
				,x_document_id	=> l_document_id
				,x_creation_date	=> l_curr_date
				,x_created_by	=> l_user_id
				,x_last_update_date  => l_curr_date
                        ,x_last_updated_by   => l_user_id
				,x_last_update_login => l_login_id
				,x_request_id   	   => l_request_id
				,x_program_application_id => l_program_application_id
				,x_program_id		=> l_program_id
				,x_program_update_date	=> l_program_update_date
				,x_datatype_id	=> G_DATATYPE_SHORT_TEXT
				,x_category_id	=> p_document_category
                        ,x_security_type	=> p_security_type
				,x_security_id	=> p_security_id
				,x_publish_flag	=> p_publish_flag
				,x_image_type     => null
				,x_storage_type	=> null
				,x_usage_type	=> p_usage_type
				,x_start_date_active => p_start_date_active
				,x_end_date_active  => p_end_date_active
				,x_language		=> p_language
				,x_description	=> p_document_description
				,x_file_name	=> null
				,x_media_id		=> l_media_id
				,x_attribute_category => null
				,x_attribute1	=> null
				,x_attribute2	=> null
				,x_attribute3	=> null
				,x_attribute4	=> null
				,x_attribute5	=> null
				,x_attribute6	=> null
				,x_attribute7	=> null
				,x_attribute8	=> null
				,x_attribute9	=> null
				,x_attribute10	=> null
				,x_attribute11	=> null
				,x_attribute12	=> null
				,x_attribute13	=> null
				,x_attribute14	=> null
				,x_attribute15	=> null
			);

Line: 536

   INSERT INTO fnd_documents_short_text
   (
     media_id
     ,short_text
   )
   VALUES
   (
     l_media_id
     ,p_document_text
   );

Line: 616

			   ,x_last_update_login	=>  l_login_id
			   ,x_program_application_id => l_program_application_id
		         ,x_program_id  	=>  l_program_id
			   ,x_request_id		=>  l_request_id
                     );